Detailed steps for ORACLE Database Upgrade

Steps for upgrading the ORACLE database:

I. Back up ORACLE databases

2. Confirm the installation path of the Home directory of the ORACLE database

3. Shut down the database:

SQLPLUS/NOLOG

CONN/AS SYSDBA

SHUTDOWN IMMEDIATE

Stop all ORACLE running services

4. Unzip the installation package and change the installation package to be owned by the oracle user.

Chown-R oracle: oinstall Disk1

Chown-R oracle: oinstall Disk1

./RunInstaller

Setup.exe

5. Confirm and perform the following steps after installation

1. Check the table space size and parameter settings

2. The System tablespace has more than 10 MB of free space.

3. Set the initial parameters of SHARED_POOL_SIZE and JAVA_POOL_SIZE.

SQL> STARTUP

SQL> SHOW PARAMETER PFILE;

Determine the current value

SQL> SHOW PARAMETER pai_pool_size

SQL> SHOW PARAMETER JAVA_POOL_SIZE

Change parameter value

SQL> ALTER SYSTEM SET pai_pool_size = '150m' SCOPE = SPFILE;

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

4. Shut down the database: shutdown immediate;

VI,

SQL> START UPGRADE

SQL> SPOOL PATCH. LOG

SQL> @? /Rdbms/admin/catpatch. SQL

SQL> SPOOL OFF

View the Update LOG: PATCH. LOG

Restart the database

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP

Run

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

7. After the upgrade is completed, test the database usage status.

Follow the steps described above to upgrade the ORACLE database. I hope you will be able to gain some benefits from the content mentioned above.