Oracle Upgradation 10g To 11g
- BACKUP BINARIES, DB,TNSNAMES,LISTENER,INIT,SPFILE,PWFILE THAT ARE BEING UPGRADED.
- COMPATIBLE PARAMETER MUST BE SET TO MINIMUM 10.0.0.0. THE RECOMMENDED IS 11.2.0 FOR 11gR2 PARAMETER FILE.
Install New Oracle Database Software & Apply Any Patches Necessary.
Step-2 :
Run The Pre-Upgrade Information Tools : (Mandatory)
1. Copy the Pre-Upgrade Information Tool (utlul12i.sql) from the Oracle Database 11gR2 directory: $ORACLE_HOME/rdbms/admin to a temporary directory /tmp.
2. Set your environment to the one that is being upgraded. Assuming 10g.
3. Change directory to /tmp that you copied utlu112i.sql to in Step 1.
4. Start SQL*Plus and login as ‘/ as sysdba’
5. Spool the results to a log file:
- SQL> SPOOL upgrade_info.log
- SQL> @utlul12i.sql
- SQL> SPOOL OFF
Oracle recommends gathering stats before the upgrade: EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
- Deprecated CONNECT Role
- Access Control to Network Utility Packages
- Database Links with passwords
- TIMESTAMP WITH TIME ZONE Data Type
- Optimizer Statistics
- Invalid Objects
- Save Oracle Enterprise Manager Database Control Data
- Complete Materialized View Refreshes
- Ensure No Files Need Media Recovery
- Ensure No Files Are in Backup Mode
- Resolve Outstanding Distributed Transactions
- Sync Standby Database with the Primary Database
- Purging the Database Recycle Bin
Prepare 11gR2 Home :
- Copy configuration files (init file, tnsnames, listener, pwfile) from old Oracle Home to new.
- Update init files with new COMPATIBLE parameter, fix any deprecated ones, and adjust the values to at least the minimum values indicated by the Pre-Upgrade Tool.
- Update any relative path names in parameter file to fully path names.
After all the Above Steps , you will start the upgrade Database for 10g Home :
1. Shutdown the database:
- SQL> SHUTDOWN IMMEDIATE;
- The oratab file points to Oracle Database 11g Release 2 Oracle Home
- The following environment variables point to the Oracle 11g Release 2 directories:
PATH
3.Change to the $ORACLE_HOME/rdbms/admin directory and start SQL*Plus
- sqlplus ‘/ as sysdba’
- SQL> STARTUP UPGRADE;
- SQL> SPOOL upgrade.log
- SQL> @catupgrd.sql
- SQL> SHUTDOWN IMMEDIATE;
- SQL> STARTUP;
- SQL> @utlul12s.sql
- SQL> $ORACLE_HOME/rdbms/admin/catuppst.sql
- SQL> $ORACLE_HOME/rdbms/admin/utlrp.sql
- SQL> SELECT count(*) FROM dba_invalid_objects;
- SQL> SELECT distinct object_name FROM dba_invalid_objects;
Comments
Post a Comment