[oracle@]:/oracle/asmhome1/OPatch > opatch version Invoking OPatch 10.2.0.5.1 OPatch Version: 10.2.0.5.1 OPatch succeeded. [oracle@]:/oracle/asmhome1/OPatch > cd [oracle@]:/oracle > . .profile [oracle@]:/oracle > sql SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 1 09:48:52 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter system checkpoint; System altered. SQL> shutdown abort; ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@]:/oracle > [oracle@]:/oracle > . .profile_asm [YOU HAVE NEW MAIL] [oracle@]:/oracle > sql SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 1 09:54:58 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown; ASM diskgroups dismounted ASM instance shutdown SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@]:/oracle > lsnrctl stop LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 01-JUN-2011 09:49:09 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=defbora01)(PORT=1521))) The command completed successfully [oracle@]:/oracle/orahome1/OPatch > su - root's Password: [root@]:/home/root> /usr/sbin/slibclean [root@]:/home/root> [oracle@]:/oracle > cd $ORACLE_HOME/OPatch [oracle@]:/oracle/asmhome1/OPatch > ls 11725015 jlib opatch.pl README.txt ocm opatchprereqs crs opatch p11725015_10204_AIX5L-cpuapr2011.zip docs opatch.bat p6880880_102000_AIX64-5L-opatch.zip emdpatch.pl opatch.ini [oracle@]:/oracle/asmhome1/OPatch > cd 11725015 [oracle@]:/oracle/asmhome1/OPatch/11725015 > opatch napply --skip_subset --skip_duplicate ... (output truncated) ... -------------------------------------------------------------------------------- ********************************************************************** ** ATTENTION ** ** ** ** Please note that this Patch Installation is ** ** not complete until all the Post Installation instructions ** ** noted in the Readme accompanying this patch, have been ** ** successfully completed. ** ** ** ********************************************************************** -------------------------------------------------------------------------------- The local system has been patched and can be restarted. UtilSession: N-Apply done. OPatch succeeded. [oracle@]:/oracle/asmhome1/OPatch/11725015 > [oracle@]:/oracle/asmhome1/OPatch/11725015 > opatch lsinv ... (output truncated) ... [oracle@]:/oracle > . .profile [oracle@]:/oracle/orahome1/OPatch > cd 11725015 [oracle@]:/oracle/orahome1/OPatch/11725015 > opatch napply --skip_subset --skip_duplicate ... (output truncated) ... [oracle@]:/oracle/orahome1/OPatch/11725015 > sql SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 1 10:20:14 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup upgrade; ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087480 bytes Variable Size 637535688 bytes Database Buffers 2566914048 bytes Redo Buffers 14688256 bytes Database mounted. Database opened. SQL> @?/rdbms/admin/catbundle.sql cpu apply SQL> @?/rdbms/admin/utlrp.sql [oracle@]:/oracle/orahome1/cpu/view_recompile > ls -l total 24 -rwxr-xr-x 1 oracle dba 2095 Jul 10 2008 recompile_precheck_jan2008cpu.sql -rwxr-xr-x 1 oracle dba 5143 Jul 10 2008 view_recompile_jan2008cpu.sql [oracle@]:/oracle/orahome1/cpu/view_recompile > sql SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 1 10:34:16 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @recompile_precheck_jan2008cpu.sql; Running precheck.sql... Number of views to be recompiled :2226 ----------------------------------------------------------------------- Number of objects to be recompiled :4347 Please follow the README.txt instructions for running viewrecomp.sql PL/SQL procedure successfully completed. SQL> @view_recompile_jan2008cpu.sql; PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. 1 row created. Commit complete. No. of Invalid Objects is :1848 Please refer to README.html to for instructions on validating these objects PL/SQL procedure successfully completed. Logfile for the current viewrecomp.sql session is : vcomp_CORET_01Jun2011_11_47_53.log SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087480 bytes Variable Size 637535688 bytes Database Buffers 2566914048 bytes Redo Buffers 14688256 bytes Database mounted. Database opened. SQL> SQL> select bundle_series, action, version from dba_registry_history; BUNDLE_SERIES ACTION VERSION ---------------------- ---------------- -------- CPU APPLY CPU 10.2.0.4 SQL> SELECT * FROM registry$history where ID = '6452863'; SQL> select bundle_series, action, version from registry$history where ID = '6452863'; BUNDLE_SERIES ACTION VERSION ------------------------------ ---------- ------------------------------ CPU
AWR Snap ID
2 weeks ago
No comments:
Post a Comment