Upgrade :: Compatible Parameter During Upgrade
May 21, 2013Why COMPATIBLE Parameter is important to be at a certain value before you UPGRADE(10.2.0.4 to 11.2.0.3) to 11g ?
View 2 Replies
ADVERTISEMENT
Upgrade :: Oracle Upgrade 11.1.0.7 To 11.2.0.3 - Compatible
Jul 19, 2013I am going to upgrade database from 11.1.0.7 to 11.2.0.3
1) If compatible is set to 10.2.0 in 11.2.0.3, will it work ?
2) If compatible set to maximum level, will it affect our application ?
3) Whether any code related problem occurred after upgrading like PL/SQL codes ?
Upgrade :: Database From 9.2.0.7 To 10.2.0.2 And Leaving COMPATIBLE To 9.2.0?
Jan 11, 2013I 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 ?
Upgrade :: Cross Platform Upgrade From Single Instance To RAC
Jun 26, 2013I'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 RelatedUpgrade :: ORA-00904 / OBJ$EDITION / Invalid Identifier After Upgrade To 11.2.0.3
Nov 19, 2012I recently performed an upgrade on a new server from oracle 10gr2 to oracle 11gr2 (11.2.0.3).
I take the rman backup from oracle 10g server and restore it on new server where I installed oracle 11gr2.
But on my previous oracle 10gr2 server I enabled the auditing. After doing successful upgrade now when I try to login with any user except sys I receive the following error:
SQL> conn scott/tiger
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier
I got the workaround by setting the parameter audit_trail=FALSE (Previous value was DB_EXTENDED) .But I want my auditing to be enabled as per y requirements.
Upgrade :: Upgrade Patch For Enterprise Versus Standard 11.2.0.1
Sep 22, 2012is the upgrade patch the same for standard edition and enterprise edition or there are two separate patches?
View 5 Replies View RelatedUpgrade :: Reference Note IDs For Database Upgrade From 11.2.0.2. To 11.2.0.3.2
Oct 22, 2012find 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 RelatedUpgrade :: Oracle 11.2.0.3.0 Database Upgrade Changes DATA_PUMP_DIR
Jun 6, 2012Along 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.
Upgrade :: SYS Table Very Slow After 11g Database Upgrade?
Nov 7, 2012All 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
Upgrade :: Patchset Number To Upgrade Oracle
Jun 14, 2012Know the Patch set number to upgrade a Oracle 10.2.0.1 to 10.2.0.5 on Solaris 10 Spark 64bits?
View 1 Replies View RelatedUpgrade :: Oracle Database Upgrade
Mar 13, 2013We 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?
Upgrade :: Database Upgrade From 9.2.0 To 11gr2
Aug 6, 2012Iam 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
Upgrade :: Upgrade 11.2.0.2 To 11.2.0.3 On Linux Environment?
Mar 23, 2013I try to upgrade 11.2.0.2 to 11.2.0.3 on Linux environment. I have to apply patch P1253900 before the upgrade per oracle doc.
however I got following conflict:
Verifying environment and performing prerequisite checks...
Checking skip_duplicate
Checking skip_subset
Conflicts/Supersets for each patch are:
Patch : 12539000
Conflict with 12827726
Conflict details:
/u01/app/grid/product/11.2.0/grid/lib/libserver11.a:/ksxp.o
Following patches have conflicts: [ 12827726 12539000 ] Refer to My Oracle Support Note 1299688.1 for instructions on resolving patch conflicts.
I checked above oracle note, and did not say any resolution.
Upgrade :: 10.2.0.1 To 10.2.0.4 Upgrade 32bit
Jun 24, 2012I am trying to upgrade the database 32bit from 10.2.0.1 to 10.2.0.4 version in lunux 32 bit . I faced the version incompatibilty error during patchset 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
[code]....
Need certified os and versions for oracle db 10gr2
Upgrade :: Database Upgrade From 11.2.0.1 To 11.2.0.3
Jan 2, 2013After 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
Upgrade :: Migration / Upgrade 10g / R2 To 11g / 2
Jul 6, 2012I am looking for for exact steps for migration. The important question ist:
-- If we migrate from 10g to 11g, do we need addition (more) CPU's as currently we have?
-- Do wee need more powerful HW.
Upgrade :: Oracle 10g To 11g Upgrade
Feb 21, 2013I am trying to come up with a plan for an upgrade that is needed for a server I maintain. It is a Windows 2003 32bit running Oracle 10.2.0.3 on old Hardware. It also has two obscure 3rd party applications that are running on it that directly access the database. These applications are supported by off site consultants.
My initial plan was to Create a Windows 2008 R2 Virtual Server and install the same version of Oracle 10.2.0.3. Using Rman clone the database to the new server. Have the consultants come in and get the applications working. Once everything in the new environment seems to be working fine, run RMAN again and reclone the database to have all the latest data. Then at a later time upgrade the database to 11g 32bit. Virtually no downtime and we could spend all the time we needed getting the applications working and testing the new environment.
The plan is dead right of the bat though because I realize 10.2.0.3 is not supported by Windows 2008 R2. I really did not want to add an Oracle DB upgrade into the mix at the same time. Just because their are so many changes from the old environment to the new that I want to break this down into manageable chunks. And I can maybe get by with 1 day of down time.
So now I am looking at installing 11g on my Virtual Server, Clone the database, upgrade the database, have the consultants come in and get the applications working. All the while we are down. If we run into any problems, which you always do, it just completely blows the schedule.
Upgrade :: Oracle Upgrade 10.2.0.5 Non-ASM 11.2.0.3 ASM?
Jun 29, 2012I need to upgrade our current system 10.2.0.5 (non Asm) to 11.2.0.3(ASM) on the same host.
So a few options : install ASM on current 10.2.0.5, create volumes etc and shift DB into ASM
upgrade to 11.2.0.3 GI - standalone
upgrade DB to 11.2.0.3
install 11.2.0.3 GI, configure ASM and run against 10.2.0.5
DB upgrade DB to 11.2.0.3
The DB upgrade has to come last I've been told.
11gRel2 DBCA - Using Compatible Parameter 10.2.0.3.0 Results In ORA-00201
Aug 16, 2012Following is the scenario:
1. Oracle DB Binaries: 11.2.0.2.2
2. Using dbca to create General Purpose Database and then modify initialization parameter "COMPATIBLE from 11.2.0.0.0 to 10.2.0.3.0" in the "All Initialization Parameters" window.
So, when I finally start installing database, I get following error during the install:
ORA-00201: control file version 11.2.0.0.0 incompatible with ORACLE version 10.2.0.3.0
ORA-00202: control file: '/u01/app/oracle/cfgtoollogs/dbca/infpp1/tempControl.clt'
IGNORE OR ABORT...
Now you might ask why i am doing this. Actually I want to install fresh 11grel2. database with lower compatible parameter. IMPORT DP custom schemas into this database making sure compatible is set to 10.2.0.3.0. Then run database with such settings for a week and finally change compatible parameter to 11.2.0.0.0
Any thoughts where i am going wrong? as the default template seems not accepting what i am interested to do.
Server Administration :: Differences In Versions According To Init-parameter Compatible
Dec 15, 2010How oracle deals with the setting of init.ora parameter compatible.
e.g. we have
DB Version=10.2.0.4
compatible=10.2.0
what is the possible leak for us ? Is there any description about the features changed in 10.2 up to 10.2.0.4 in all steps - so that we can check out which functions we do not have.
Upgrade :: Upgrade To 11g R2 From 10g R2
Aug 1, 2012How to Upgrade to 11g R2 from 10g?
Let me Explain my environment:
=> 2 Node RAC on Windows 2003
=> 1 voting disk and OCR [No mirroring]
=> ASM with Extenral Redundancy.
=> Seperat CRS,ASM & RDBMS Home.
Explain me following Areas:
1) How to upgrade to 11g R2 by using ""p10404530"" patch.
2) Fresh 11g R2 installation document on Win 2003.
2) How to Configure SCAN without DNS?
3) How to Configure OCR & Voting disk on ASM
Upgrade :: Upgrade 10.2.0.4 SE To 11.2.0.3 EE
Apr 17, 2013I'm planning to upgrade an existing 10.2.0.4 Standard Edition database to 11.2.0.3 Enterprise Edition and have a related question after getting a little uncertain looking at the MOS note .
"How to Convert Database from Standard to Enterprise Edition ? [ID 117048.1]"
Do I ?:
1. Install 10.2.0.4 EE Home and convert my 10g database from SE to EE, and then install 11.2.0.3 EE Home and upgrade the database.
or can I?:
2. Install 11.2.0.3 EE home and do the upgrade directly from 10.2.0.4 SE to 11.2.0.3 EE
Oracle 9i To 10g Upgrade
Jul 3, 2010I am trying to upgrade database from 9.2.0.7 to 10.2.0 in my test server. Here are the steps i am planning to do.
1. Export user data of production, Import in test db(ABC) using Destroy=Y Fromuser,touser parameter( this step just to refresh old test data)
2. Install 10g db, Use DBUA Utility of 10g to start upgrade>select 9i database which i want to upgrade
3. follow DBUA instruction ..create datafile paths, init.ora file, tnsnames,listener... same as the existing setup i have of 9i(so i can make replica of 9i in 10g)
question: I have another database(xyz) in test server its also in 9i, I don't want to upgrade that for now. so do i need to use one listener /tnasnames file of 10g and include setting of 9i in that 10g file ?
How to manage init,tnasnames,listener files setting in 2 db versions . Is there anything else i need to do to perform upgrade 9i-10g ? or its all ?
I will install just 10g database will import full export of 9i db. if i can do full import in 10g or should i just go for fromuser, tuser option to import? i believe for that i need to create datafiles, user,grant in new 10g db. I am not sure which option is best to perform 10g upgrade?
How To Upgrade Oracle 9.2.0.1 To 9.2.0.4
Feb 3, 2011I want to know the detailed steps for the Upgradation of database from Oracle 9.2.0.1 to 9.2.0.4?
View 4 Replies View RelatedUpgrade Database From 11.2.0.2 To 11.2.0.3?
May 14, 2012i 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...
Unable To Upgrade From 9i To 10g?
Oct 31, 2010I'm attempting to upgrade a 9.2.0.7 to 10.2.0.? (haven't run the patch set yet so it's at 10.2.0.1) I'm not sure if the listener is correct to proceed.
The platform is Windows x323 (server 2003)
>>I'm not an Oracle DBA, I stumble thru it in administering PTC's Windchill vault..
I am trying to run the Oracle DBUA and the documentation for the Upgrade Assistant instructs me to install in an OraHome that is separate from the existing. Done.
The Upgrading Guide then States:
"Run the Oracle Net Configuration Assistant
If you are upgrading from Oracle9i and a listener was not configured in the Oracle9i repository, run Oracle Net Configuration Assistant to configure the listening protocol address and service information for the new Oracle Database 10g database, including a listener.ora file. A version 10 listener is required for an Oracle Database 10g database. Previous versions of the listener are not supported for use with an Oracle Database 10g database. However, it is possible to use a version 10 listener with previous versions of the Oracle database."
Oracle Net Services Administration Guide, �10 states:
"Note:
A version 10 listener is required for an Oracle Database 10g database. Previous versions of the listener are not supported for use with an Oracle Database 10g database. However, it is possible to use a version 10 listener with previous versions of the Oracle database."
Here's what I've got: The Installation using the Universal installer for 10g ran w/o complaint, reported success. The installation type was Advanced>Custom per the PTC Windchill documentation. After the initial installation, the Oracle Net Configuration Assistant did not start automatically, as the documentation stated it would. (The documentation from PTC on Oracle is skimpy at best)
I launched the Network Config Assistant from the start menu in the new OraHome10g. When I tried to create the listener, TCP on port 1521, it told me this was already in use by another program. I could configure it, but until the conflict was resolved....
When I open the Net Manager, the path in the header bar of the frame is to OraHome92\network\Admin....YET, when I run HELP>About in the Net Manager it reports "Oracle Net Manager; Version 10.2.0.0.0 Production"
I had stopped all Oracle services when I ran the UI to install 10g. I have also since removed the service for the 9i TNSListener from windoze register (and restarted). Right now, there is no that shows running in Services.
??Am I actually OK to go ahead w/ the patch set, then run the Pre-Upgrade Information Tool then the Oracle DBUA?
Do I actually have a 10g listener setup?
But, the listener.ora, tnsnames.ora etc are all in the OraHom92/network/admin folder and nothing but the samples show in the OraHome10g/network/admin. Will the DBUA migrate these or should I manually transplant them into the OraHome10g directory?
Forms :: Upgrade From 10g To 11g?
Jul 18, 2012We need to upgrade ours forms for 10g to 11g. provide links to white papers that discuss forms upgrade from 10g to 11g?
View 4 Replies View RelatedUpgrade To Oracle 11.2.0.1?
Mar 9, 2011Recently we have upgraded our database from Oracle 9.2.0.8 to Oracle 11.1.0.7. But now the new requirement comes that it should be upgraded to Oracle 11.2.0.1
Our OS environment - UNIX AIX 5.3
Since its a development database, we have dataset of Oracle 9i and Oracle 11g1 cold backup. I have a query regarding this. what would be the best way to upgrade, is it from Oracle 9i to Oracle 11g1 or Oracle 11g1 to Oracle 11g2?
How To Run Start Up Upgrade In 11g-RAC Env
Jun 3, 201311.2.0.3.5
RHEL-7
2 NODE RAC
issue : XDB component is INVALID and oracle support suggested below steps. But, in RAC env, can we do this on both nodes or only on one node. If we are doing in node1 and do we need DOWN node2 ?
{
SQL> spool xdbreload.log
SQL> connect / as sysdba
SQL> set echo on;
SQL> shutdown immediate;
[code].......
How to run UPGRADE in rac env ?
Upgrade :: Migration From 10g To 11g?
Nov 2, 2012my current database version is 10.2.0.3.0 and we are going to migrate our database to 11.2.0.3 .
Can we directly migrate database to 11.2.0.3 or will i require to apply any patch before this ?