Notes for upgrading oracle standalone 10201upgrateto10205

Zookeeper

Oracle standalone 10201 upgrate to 10205

1. Shut down the database:

For Oracle RAC:

$ Srvctl stop database-d db_name
For Single Instance:

SQL> CONNECT SYS AS SYSOPER
Enter password: SYS_password
SQL> SHUTDOWN

2.
Emctl stop dbconsole
Lsnrctl stop
Isqlplusctl stop

3. $ export DISPLAY = localhost: 0.0
./RunInstaller

4.
Start the database in the UPGRADE mode:

SQL> STARTUP UPGRADE
Set the system to spool results to a log file for later analysis:

SQL> SPOOL upgrade_info.log
Run the Pre-Upgrade Information Tool:

SQL> @/rdbms/admin/utlu102i. SQL
Turn off the spooling of script results to the log file:

SQL> SPOOL OFF

5.
Enter the following SQL * Plus commands:

SQL> STARTUP UPGRADE
SQL> SPOOL patch. log
SQL> @? /Rdbms/admin/catupgrd. SQL
SQL> SPOOL OFF

6.
Restart the database:

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

7.
SQL> @? /Rdbms/admin/utlrp. SQL

8.
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS. DBA_REGISTRY
9.