Upgrade oracle9204 to 9206 notes

Log On As an Oracle user.
1. Unzip the 9206 patch installation package
$ Unzip p3948480_9206_solaris64.zip

2. Set the environment variables ORACLE_HOME and ORACLE_SID.
$ ORACLE_HOME =/opt/oracle/db01/app/oracle/product/9.2.0
$ ORACLE_SID = ORCL
$ Export ORACLE_HOME ORACLE_SID

3. Stop DB and all oracle-related processes
SQL> shutdown immediate
$ Lsnrctl stop

4. Back up the oracle Installation Directory
$ Tar-cvf oracle9204_clear.tar db01 db02 db03 db04

5. If you are using a software such as XManager for remote login and installation, you need to set DISPLAY:
$ DISPLAY = 172.19.136.98: 0.0; export DISPLAY -- 172.19.136.98 is the IP address of the PC client running XManager software.

6. Enter XWindow and start the installer.
% Cd/opt/wacos/9206/Disk1
%./RunInstaller
Follow the on-screen prompts to install the SDK.

7. Set the initialization parameters SHARED_POOL_SIZE and JAVA_POOL_SIZE.
$ Sqlplus '/as sysdba'
SQL> startup;
SQL> show parameter pfile;
SQL> show parameter shared_pool_size;
SQL> ALTER SYSTEM SET SHARED_POOL_SIZE = '150m' SCOPE = spfile; -- at least 150 MB
SQL> show parameter java_pool_size;
SQL> ALTER SYSTEM SET JAVA_POOL_SIZE = '150m' SCOPE = spfile; -- at least 150 MB
SQL> shutdown;
SQL> exit

8. Upgrade DB (Non-RAC)
$ Lsnrctl start
$ Sqlplus/nolog
SQL> conn/as sysdba
SQL> startup migrate
SQL> spool./patch9206.log
SQL> @? /Rdbms/admin/catpatch. SQL -- long time
SQL> spool off;

9. Check patch. log to see if there are any errors.
$ More patch9206.log

10. compile all invalid objects
SQL> shutdown;
SQL> startup;
SQL> @? /Rdbms/admin/utlrp. SQL

11. Check the upgrade information.
SQL> select * from dba_registry;

12. Package backup
$ Lsnrctl stop
$ Sqlplus '/as sysdba'
SQL> shutdown immediate;
$ Tar-cvf oracle9206_clear.tar db01 db02 db03 db04