Upgrade Database From 11.2.0.2 To 11.2.0.3?

May 14, 2012

i have upgraded the Database from 11.2.0.2 to 11.2.0.3 , after that while i was accessing the D.B i am getting this error.

ORA-00020: maximum number of processes (600) exceeded

after that i have modifed number of process and made it to 1200.

but then i got the same issue

ORA-00020: maximum number of processes (1200) exceeded

is it any Bug or the upgradation went wrong. Is there any change in the primary and foreign keys before and after the upgrade...

View 6 Replies


ADVERTISEMENT

Upgrade :: Reference Note IDs For Database Upgrade From 11.2.0.2. To 11.2.0.3.2

Oct 22, 2012

find reference note IDs for DB upgrade from 11.2.0.2 to 11.2.0.3.2, as I am finding only Exadata which I don't want but I want to find for Ebiz database, on OS - Solaris 10 9/10 s10s_u9wos_14a SPARC.

View 1 Replies View Related

Upgrade :: Oracle 11.2.0.3.0 Database Upgrade Changes DATA_PUMP_DIR

Jun 6, 2012

Along with existing RMAN backups we do Exports - of our DB using and OS User and Oracle Wallet.Of the DB's we have upgraded the Data Pump Directory

Select * from dba_directories; (there are other commands to get this info as well).

I captured screens from the DBUA upgrades, but did not see an option to change this information.Is there a way to feed this information to the install moving forward. IE, ./DBUA -silent ?

Also, anyone tracked the percentage of storage increase from 10.2/11.1 to 11.2.

View 4 Replies View Related

Upgrade :: SYS Table Very Slow After 11g Database Upgrade?

Nov 7, 2012

All my sys tables are very slow after my database upgrade from 10.2.0.4 to 11.2.0.3 on AIX 6.1

For example
select * from ALL_TAB_COLUMNS; -- taking 19 seconds in 11.2.0.3 and few millisec in 10.2.0.4

I have deleted and updated fixed and dictionary table statistics , till I facing this issue

View 5 Replies View Related

Upgrade :: Oracle Database Upgrade

Mar 13, 2013

We are planning to upgrade our database from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi to Oracle Standard Edition 11g . We also have oracle apex installed on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi database with oracle apex 3.1

No our plan to upgrade the database and oracle apex to 4.2. Since Oracle Enterprise Edition is licensing is very expensive we though of buying standard edition and upgrade to this version.

can we upgrade the oracle database from enterprise edition to latest standard edition?

View 3 Replies View Related

Upgrade :: Database Upgrade From 9.2.0 To 11gr2

Aug 6, 2012

Iam doing some oracle database upgrade from 9.2.0 to 11gr2 . is it possible to upgrade directly from this 9i version to 11gr2 .

Version : 9.2.0 to 11gr2

View 4 Replies View Related

Upgrade :: Database Upgrade From 11.2.0.1 To 11.2.0.3

Jan 2, 2013

After many tries of upgrade'ing oracle I decided to make backup of my database and then remove 11.2.0.1 and install 11.2.0.3 to recover db. Unfortunately I am not sure how should I perform restoration.I backed up data by calling RMAN> backup database include current controlfile;

After that I moved files from fast_recovery_area and cleared my machine from current oracle release.I also did a copy of directories:

ORACLE_HOMEdbs
ORACLE_HOME
etworkadmin
ORACLE_HOMEowbinadmin
ORACLE_HOMEhostname_dbname
ORACLE_HOMEoc4jj2eeOC4J_DBConsole_hostname_dbname

View 8 Replies View Related

Difference Between Database Or SID Upgrade

Oct 19, 2012

i want to know is there any difference between upgradation of SID and database. while upgrading my database from oracle 11.2.0.2 to 11.2.0.3 in DBUA it shows my SID is upgrading (ORCL) but i have few other databases ex (test and prod).

is it enough if we upgrade the SID or we must perform any other actions..

and
2nd QUERY :

i have 2 oracle homes in my server with different versions like (11.2.0.2 and 11.2.0.3)and i have few databases and there tablespaces. how to determine which database is created on which version and which database is upgraded from 11.2.0.2 to 11.2.0.3.

View 3 Replies View Related

Upgrade :: Upgrading Database From 10.2.0.1.0 To 10.2.0.4.0

Sep 6, 2013

When upgrading database from 10.2.0.1.0 to 10.2.0.4.0  , i am getting following error$

/run Installer Starting Oracle Universal Installer...Checking installer requirements...Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5,  UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3 Passed All installer requirements met. Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-09-07_01-25-05AM.  Please wait ...  error:  invalid compressed data to inflate /tmp/OraInstall2013-09-07_01 -25-05AM/oui/jlib/ewt3.jarerror:  invalid compressed data to inflate /tmp/OraInstall2013-09-07_01-25-05AM/oui/gui de/htmlguide.jar

View 8 Replies View Related

Database Upgrade From 9.2.0.8 To 10gR2

Oct 26, 2012

Why is knowing the backup policy important before starting any upgrade.

View 17 Replies View Related

Rolling Upgrade Of CRS / ASM / DBHomes And Database From 10.2.0.4 To 10.2.0.5?

Nov 5, 2012

I have an upgrade question. My customer wants to minimize downtime and so wants to do a rolling upgrade of crs, asm, dbhomes and databases from 10.2.0.4 to 10.2.0.5.

Customer wants to upgrade server1 during normal business hours- CRS/ASM/DBHOMES, then move databases from server2 to server1 and upgrade during planned downtime, then upgrade server2 during normal business hours -CRS/ASM/DBHOMES.

3 steps, taking 3 days to complete. Is this possible? I know CRS can be done in a rolling upgrade, but what about ASM?Is this doable?

View 3 Replies View Related

Backend Database 10.2.0.3 - Upgrade Path?

Jun 6, 2012

we have a very critical application running and the backend database is 10.2.0.3. we are planing on upgrading to 10g to 11.2.0.2 and looking ways to look with minimal downtime off production. steps for upgrade with very minimal downtime of appliction?

View 2 Replies View Related

Server Administration :: Upgrade Database From 11.2.0.1 To 11.2.0.3?

Dec 15, 2012

I tried updating the oracle database from version 11.2.0.1 to 11.2.0.3 but I have no clear procedure. I chose the option of the installer "upgrade database" and install the software on a new home. To migrate, must be all oracle services stopped? In the migration phase, it is normal to ask me listener data, etc .... or installer now detects the same database?

View 1 Replies View Related

Upgrade :: Database From 9.2.0.7 To 10.2.0.2 And Leaving COMPATIBLE To 9.2.0?

Jan 11, 2013

I want to upgrade our database version (9.2.0.7) to 10g (10.2.0.2)

I know if I set COMPATIBLE parameter to 10.2.0.2 at first then I can't downgrade to 9.2.0.7 if any problem occurs I am not sure that our application can deal with 10g or not so I think it's better to leave the COMPATIBLE parameter to 9.2.0 several days for sure and if all things go well then change COMPATIBLE to 10.2.0.2 (I need to say that I can’t test our application in a test environment )

Now do you think leaving COMPATIBLE to 9.2.0 (after upgrade) for many days can cause any problem to Database ?

View 3 Replies View Related

Upgrade :: Database 32bit From 10.2.0.1 To 10.2.0.4 Version

Jun 24, 2012

I am trying to upgrade the database 32bit from 10.2.0.1 to 10.2.0.4 version in Linux 32 bit . I faced the version incompatibility error during patch set installation and hence ran the patchset installation with -ignoresysprereqs option.

Now during the patchset installation i encountered the below error in in the install logfile.
**************************************
INFO: Start output from spawned process:
INFO:
--------------------------------------------------------------------------------
INFO:
INFO: /u01/app/oracle/product/10.2.0/bin/genclntsh
INFO: genclntsh: genclntsh: Could not locate /u01/app/oracle/product/10.2.0/network/admin/shrept.lst
INFO: make:
INFO: *** [client_sharedlib] Error 1
INFO:
INFO: End output from spawned process.
INFO:
--------------------------------------------------------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0/network/lib/ins_net_client.mk'. See '/u01/app/oracle/oraInventory/logs/installActions2012-06-24_11-45-11AM.log' for details.
Exception Severity: 1
***********************************************

Provide me the certified os and versions for oracle db 10gr2

View 2 Replies View Related

Expdp Slower After 11gR2 Database Upgrade?

Aug 6, 2012

After upgrading 11gR1 database (11.1.0.7.0) to 11gR2 (11.2.0.3.0), the datapump exports have been taking quite a bit longer. When database was 11gR1, a full expdp took approx. 40-45 minutes. After upgrade, it takes approx. 1 hour 40-50 minutes. These times were with parallel=4. I tried with parallel=8 and parallel=12, both of these took around 1 hour 5-10 minutes, better but still quite a bit slower than pre-11gR2 upgrade. I tried with exclude=statistics, index_statistics, indexes; it still took approx. 1 hour 40-45 minutes. This is a PeopleSoft database so there are many, many objects to be exported. The database was upgraded using dbua.

View 1 Replies View Related

Server Administration :: Upgrade 10g (10.2.0.1.0) 64bit Database To 11i?

May 23, 2012

i want to upgrade my 10g(10.2.0.1.0) 64bit database to 11i. how can perform it. os windows xp.

View 1 Replies View Related

RAC & Failsafe :: Upgrade Of Oracle And Standby Database In HP UX

Mar 9, 2011

we had our Oracle RAC database at primary and Standby database as DR. It was running in 10g (10.2.0.1.0) in HP UX 11i platform.

We need to upgrade both the setups from 10.2.0.1.0 to 10.2.0.4.0 . I will go through the upgrade guide, i like to know is there any special case for upgrading when we do for both primary and standby database.

And whether i need to create a new Oracle home with 10.2.0.4.0 software or i can upgrade in the same oracle home which already exists.

View 2 Replies View Related

Upgrade :: Database Is Not Available For Download In Oracle Downloads

Apr 2, 2013

I need to upgrade database from 9.2.0.6.0 to 11.1.0.7.0 . But 11.1.0.7.0 database is not available for download in oracle downloads. How do i download 11.1.0.7.0 and bring the links for upgrading process.

View 5 Replies View Related

Upgrade :: Migrate Database From Windows To Linux?

May 6, 2013

I need to migrate database from Windows to Linux. The current size is ~50GB.

Current Env:
OS = Windows 2003
DB version = 10.2.0.3

Proposed Env:
OS = Linux
DB version = 11.2.0.2

Would using datapump be a correct choice for this migration? Also do the step below seem correct?

01.     Pre-create tablespaces on target 11g database
02.     Export full database of source 10g database
03.     Copy dumpfile to Destination Server
04.     Grant IMPORT_FULL_DATABASE system privilege to user SYSTEM of target 11g database
05.     Import full database to target 11g database

View 6 Replies View Related

Upgrade :: Upgrading The 11g Database Using Dbua Utility?

Apr 22, 2013

I have installed oracle 11g R2 in windows and i ve created database of vesrion 11.2.0.1.0. I tried to upgrade the database to higher version using the dbua utility . But in this utility source & destination both is showing as 11.2.0.1.0. upgrade the database from 11.2.0.1.0 to higher version using the dbua utility

View 16 Replies View Related

Server Administration :: Upgrade 9.2.0.8 Database In Oracle 11.2.0.2

Sep 21, 2011

I am trying to upgrade the oracle 9.2.0.8 database in oracle 11.2.0.2. I have installed the new oracle home for 11g and after running the pre-upgrade script and setting the all environment variable like oracle base, oracle home, oracle sid and ora_nls

i am running the dbua but after click on finish button it's do the processing of 2% but after that i get
-------------------------------------------------
ORA-12709 error while loading create
database character set
--------------------------------------------------

View 11 Replies View Related

Application Express :: Upgrade Failed In Database From 10g To 11g

Jul 30, 2012

When we upgraded the database from 10g to 11g, Apex upgrade failed. Due to the failure, I removed the old schema and did a fresh install of Apex 4.1. It is working but we lost the applications from previous Apex.

What is the best strategy when you need both database and Apex upgrades? We are a Linux workshop, setting up Apex in Oracle Fusion Middleware 11g environment.

View 0 Replies View Related

Server Administration :: Download Patchset To Upgrade Database From 10.2.0.3 To 10.2.0.5?

Apr 23, 2012

where I can download patchset to upgrade my database from 10.2.0.3 to 10.2.0.5?

View 1 Replies View Related

RAC & Failsafe :: Upgrade Database With ASM Storage From 10gR2 To 11gR2?

Mar 7, 2011

I have a database running on 10205 version. It is a RAC database with ASM storage.

I want to migrate this database to other server and upgrade this database to 11202 version .

View 1 Replies View Related

Server Administration :: Migrate And Upgrade Oracle 9i Database To 10g?

Mar 10, 2011

I am looking to migrate and upgrade an Oracle 9i database to 10g.

Would there be any fallout if the characterset were changed from US7ASCII to UTF8?

View 2 Replies View Related

Data Guard :: Upgrade Primary And Standby Database?

Apr 30, 2012

I have a primary and standby DB using data guard 10.2.0.3.I want to upgrade oracle to 11G.I know that primary and standby should have same version even if data guard will not work again.I want to know what is the steps by steps action to properly upgrade both DB : primary and Standby.

View 1 Replies View Related

Server Administration :: Upgrade 9208 Database To 102030

Sep 16, 2013

We have a 9208 Prod Database running out of 9i binaries in a HP UX Machine.We want to upgrade it to 102030.We tried upgrading it once and we failed .Oracle came back saying we need to apply a binary patch on the 10g Oracle Home as the error we faced is a bug.This is HP UX machine and there are no 10g databases running here.

.Management has asked to do a test run so that upgrade does not fail again.Unfortunately we do not have an identical test env in this case to test the binary patch.

Here is how we planned.

1)We make a copy of the existing 9208 Database in the same machine as a new SID i.e Clone to a new SID and make it up and running.
2)We apply the binary patch on the 10203.
3)Attempt the upgrade .If it goes fine we are good.
4)If the upgrade does not go fine and brings up new surprises(Say Oracle come back and says another patch is required),Will we have already done irreversible damage to our 10g binaries ?

Is there a good way to revert back the upgrade ? Will the inventory be corrupt?

Is there a way to get back to old binaries if the applied patch did not work or if Oracle says to apply new patch.? Finally will all the above create an issue to the existing 9i Database?

View 5 Replies View Related

Upgrade :: From Linux 32bit To 64bit - 10gR2 Database?

Dec 26, 2012

I need to do the following:

(1) Move my 10gR2 database from 32-bit Linux to 11gR2 64-Bit Linux (using an RMAN backup from 10gR2 restored on the 64-bit machine) then

(2) Bring up the database on 64-bit hardware and then upgrade to 11.2.0.3 (64-Bit) [Without installing the 10.2.0.3 64-Bit software]

Haven't tried restoring to 11.2.0.3 from a RMAN 10.2.0.3 backup. I was trying not to have to install the Oracle 10.2.0.3 software for 64-bit on the 64-bit machine. Was hoping to go directly to 11.2.0.3 (64-bit).

View 2 Replies View Related

Upgrade :: Cross Platform Upgrade From Single Instance To RAC

Jun 26, 2013

I'm planning to upgrade a small database (~150GB) from 10.2.0.3 on windows 2003 23bit to 11.2.0.3 RAC on Linux 5.8.The database contains oracle spatial too. A suitable method and link to document to be followed. 

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved