Oracle10g patching (p5490848_10202_LINUX)

Oracle's patch contains readme.html, which provides detailed updates to the patch.

Oracle's patch contains readme.html, which provides detailed updates to the patch.

Oracle's patch contains readme.html, which provides detailed updates to the patch.

The following are my patch records:
1. You must use the OPatch utility release 10.2.0.2 It is available in $ ORACLE_HOME.
The OPatch tool version must be 10.2.0.2, so you must first check the OPatch version.
12 [oracle @ carefree ~] $ ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.2.0

2. if the version is correct, decompress the patch and apply the patch.
[Oracle @ carefree ~] $ Unzip p5490848_10202_LINUX.zip
Archive: p5490848_10202_LINUX.zip
Creating: 5490848/
....
....
[Oracle @ carefree ~] $ Cd 5490848
[Oracle @ carefree 5490848] $ ORACLE_HOME/OPatch/opatch apply
Invoking OPatch 10.2.0.2.0
...
...

3. Start the instance and run related scripts.
Cd $ ORACLE_HOME/cpu/CPUOct2006
Sqlplus/nolog

SQL> CONNECT/AS SYSDBA
SQL> STARTUP
SQL> @ catcpu. SQL
SQL> @? /Rdbms/adminutlrp. SQL
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'invalid ';

4. query patch information

Select * from dba_registry_history;
Note: Before patching, you can manage database instances and related information.
Emctl stop dbconsole
Isqlplusctl stop
Lsnrctl stop
Shutdwon immediate

5. rollback
Cd 1, 5490848
$ ORACLE_HOME/OPatch/opatch rollback-id 5490848
Cd $ ORACLE_HOME/cpu/CPUOct2007
Sqlplus/nolog
SQL> CONNECT/AS SYSDBA
SQL> STARTUP
SQL> @ catcpu_rollback. SQL
SQL> @? /Rdbms/adminutlrp. SQL
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'invalid ';

Recommended reading:

RedHat Linux 5 & CentOS 5

Install Oracle 10g R2 in CentOS 6.3 (x32)

Installing Oracle 12C in Linux-6-64