oracle 10.2.0.3 installation patch 5731535
Bonjour,
je viens d'installer ce patch à l'aide d'opatch .
il y a certaines recommandations "post-installation" que je ne comprends pas :
Citation:
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';
les instructions ci-dessus doivent-elles être executées en sachant que je n'ai
qu' un seul ORACLE_HOME (celui que je viens de patcher) ?
le script catcpu.sql execute le package dbms_registry que je ne maitrise
pas .
si vous pouviez me dire comment vous procédez ?
car d'habitude je n 'installe jamais de patch hors les patch-sets .
cdlt
