Database Upgrade

For 9i/10g

Shutdown database to do patch installation

Use runinstaller to upgrade the binary it to higher version

Ensure SHARED_POOL_SIZE and JAVA_POOL_SIZE are atleast 150M

SQL> SHOW PARAMETER SHARED_POOL_SIZE
SQL> SHOW PARAMETER JAVA_POOL_SIZE

If not set as below

SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;

SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;

Shut down database:

SQL> SHUTDOWN

Start upgrade: [10g]

SQL> STARTUP UPGRADE
SQL> SPOOL upgrade.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF


Start upgrade: [9i]

SQL> startup migrate
SQL> spool upgrade.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> spool off


Review the upgrade.log file for any errors

Restart the database:

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

Run the utlrp.sql script to recompile all invalid PL/SQL packages
SQL> @?/rdbms/admin/utlrp.sql

Start listener

$lsnrctl start LISTENER

Check database connectivity