3.3.4 Post Installation Instructions
Follow these steps:
Start the OracleService<SID> and Oracle Listener Services.
Start all database instances running out of the ORACLE_HOME that you just patched.
Invoke the following command if the patch is installed in the RAC setup:
> %ORACLE_HOME%\bin\opmd -install
For each database instance running out of the ORACLE_HOME being patched, connect to the database using SQL*Plus as SYSDBA and run catcpu.sql as follows:
> cd %ORACLE_HOME%\Bundle\Patch1
> sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catcpu.sql
SQL> QUIT
Inspect the logfile %ORACLE_HOME%\bundle\Patch1\Apply_<ORACLE_SID>_<timestamp>.log for any errors.
If there are errors, refer to Section 4, "Known Issues".
If catcpu.sql reports any Invalid Objects, compile the invalid objects as follows.
(For large numbers of objects, this compilation step can take some time. If you are applying this patch through the Oracle Enterprise Manager console, you will be prompted to run this compilation script.)
> cd %ORACLE_HOME%\rdbms\admin
> sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlprp.sql 0
To check for invalid objects, execute the following statement:
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
Partager