Opatch PSU Oracle Solaris on SPARC (64-bit)


bash-3.00$ cd $ORACLE_HOME 

-bash-3.00$ mv OPatch OPatch.OLD



-bash-3.00$ cp p6880880_112000_Solaris86-64.zip /u01/app/oracle/product/11.2.0/db_1/



-bash-3.00$ unzip p6880880_112000_Solaris86-64.zip



-bash-3.00$ opatch version

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch: whereis: not found

Invoking OPatch 11.2.0.1.6



OPatch Version: 11.2.0.1.6



OPatch succeeded.

-bash-3.00$

-bash-3.00$ export PATH=$PATH:/usr/ucb

-bash-3.00$ opatch version

Invoking OPatch 11.2.0.1.6



OPatch Version: 11.2.0.1.6



OPatch succeeded.

-bash-3.00$
2- Download the patch number 9952216 and unzip the file:
-bash-3.00$ cd /export/home/oracle/patch/ 

-bash-3.00$ unzip p9952216_112010_Solaris86-64.zip
3- Patch conflict detection:
Check whether any currently installed one-off patches conflict with the downloaded patch:
view plaincopy to clipboardprint?
-bash-3.00$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9952216

Invoking OPatch 11.2.0.1.6



Oracle Interim Patch Installer version 11.2.0.1.6

Copyright (c) 2011, Oracle Corporation. All rights reserved.



PREREQ session



Oracle Home : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oracle/oraInventory

from : /var/opt/oracle/oraInst.loc

OPatch version : 11.2.0.1.6

OUI version : 11.2.0.1.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-08-10_01-33-35AM.log



Invoking prereq "checkconflictagainstohwithdetail"



Prereq "checkConflictAgainstOHWithDetail" passed.



OPatch succeeded.

-bash-3.00$
4- Shutdown the services:
Shutdown the database instance(s) and all listeners running;
view plaincopy to clipboardprint?
-bash-3.00$ sqlplus / as sysdba



SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 10 01:34:28 2011



Copyright (c) 1982, 2009, Oracle. All rights reserved.





Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options



SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

-bash-3.00$ lsnrctl stop



LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 10-AUG-2011 01:34:57



Copyright (c) 1991, 2009, Oracle. All rights reserved.



Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))

The command completed successfully

-bash-3.00$



-bash-3.00$
5- Apply the patch:
view plaincopy to clipboardprint?
-bash-3.00$ cd 9952216/

-bash-3.00$ opatch apply

Invoking OPatch 11.2.0.1.6



Oracle Interim Patch Installer version 11.2.0.1.6

Copyright (c) 2011, Oracle Corporation. All rights reserved.





Oracle Home : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oracle/oraInventory

from : /var/opt/oracle/oraInst.loc

OPatch version : 11.2.0.1.6

OUI version : 11.2.0.1.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-08-10_01-36-14AM.log



Applying interim patch '9952216' to OH '/u01/app/oracle/product/11.2.0/db_1'

Verifying environment and performing prerequisite checks...



Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:



You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y



Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/11.2.0/db_1')





Is the local system ready for patching? [y|n]

y



User Responded with: Y

Backing up files...



Patching component oracle.rdbms.rsf, 11.2.0.1.0...



Patching component oracle.rdbms.dbscripts, 11.2.0.1.0...



Patching component oracle.rdbms, 11.2.0.1.0...

Copying file to "/u01/app/oracle/product/11.2.0/db_1/cpu/scripts/bug9371993.sql"

Copying file to "/u01/app/oracle/product/11.2.0/db_1/cpu/scripts/bug9016295.sql"

Copying file to "/u01/app/oracle/product/11.2.0/db_1/cpu/scripts/bug9758569.sql"

Copying file to "/u01/app/oracle/product/11.2.0/db_1/psu/scripts/bug8820324.sql"

Copying file to "/u01/app/oracle/product/11.2.0/db_1/psu/11.2.0.1.3/catpsu.sql"

Copying file to "/u01/app/oracle/product/11.2.0/db_1/psu/11.2.0.1.3/catpsu_rollback.sql"



Patching component oracle.oraolap, 11.2.0.1.0...



Patching component oracle.rdbms.deconfig, 11.2.0.1.0...



Patching component oracle.javavm.server, 11.2.0.1.0...



Patching component oracle.precomp.common, 11.2.0.1.0...



Patching component oracle.network.rsf, 11.2.0.1.0...



Patching component oracle.network.listener, 11.2.0.1.0...

Patch 9952216 successfully applied

Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-08-10_01-36-14AM.log



OPatch succeeded.

-bash-3.00$
5- Verify the patch:
view plaincopy to clipboardprint?
-bash-3.00$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9952216

Invoking OPatch 11.2.0.1.6



Oracle Interim Patch Installer version 11.2.0.1.6

Copyright (c) 2011, Oracle Corporation. All rights reserved.



PREREQ session



Oracle Home : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oracle/oraInventory

from : /var/opt/oracle/oraInst.loc

OPatch version : 11.2.0.1.6

OUI version : 11.2.0.1.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-08-10_01-40-00AM.log



Invoking prereq "checkconflictagainstohwithdetail"



ZOP-47: The patch(es) has supersets with other patches installed in the Oracle Home (or) among themselves.



Prereq "checkConflictAgainstOHWithDetail" failed.



Summary of Conflict Analysis:



Patches that can be applied now without any conflicts are :

9952216



Following patches will be rolled back from Oracle Home on application of the patches in the given list :

9952216



Conflicts/Supersets for each patch are:



Patch : 9952216



Bug Superset of 9952216

Super set bugs are:

9068088, 9363384, 8865718, 8898852, 8801119, 9054253, 8725286, 8974548, 9093300, 8909984, 8755082, 8780372, 9952216, 8664189, 8769569, 7519406, 9471411, 9302343, 8822531, 7705591, 8650719, 9637033, 8883722, 8639114, 8723477, 8729793, 8919682, 8856478, 9001453, 8733749, 8565708, 8735201, 8684517, 8870559, 8773383, 8981059, 8812705, 9488887, 8813366, 9242411, 8822832, 8897784, 8760714, 8775569, 8671349, 8898589, 9714832, 8642202, 9011088, 9369797, 9170608, 9165206, 8834636, 8891037, 8431487, 8570322, 8685253, 8872096, 8718952, 8799099, 9032717, 9399090, 9713537, 9546223, 8588519, 8783738, 8834425, 9454385, 8856497, 8890026, 8721315, 8818175, 8674263, 9145541, 8720447, 9272086, 9467635, 9010222, 9102860, 9197917, 8991997, 8661168, 8803762, 8769239, 9654983, 8546356, 8706590, 8778277, 9058865, 8815639, 9971778, 9971779, 9027691, 9454036, 9454037, 9454038, 9255542, 8761974, 9275072, 8496830, 8702892, 8818983, 8475069, 8875671, 9328668, 8891929, 8798317, 8782959, 9971780, 8774868, 8820324, 8544696, 8702535, 9406607, 9952260, 8268775, 9036013, 9363145, 8933870, 8405205, 9467727, 8822365, 9676419, 8761260, 8790767, 8795418, 8913269, 8717461, 8861700, 9531984, 8607693, 8330783, 8780281, 8784929, 8780711, 9341448, 9015983, 8828328, 9119194, 8832205, 8665189, 8717031, 9482399, 9676420, 9399991, 8821286, 8633358, 9321701, 9231605, 9655013, 8796511, 9167285, 8782971, 8756598, 9390484, 8703064, 9066116, 9007102, 9461782, 9382101, 8505803, 9352237, 8753903, 9216806, 8918433, 9057443, 8790561, 8795792, 8733225, 9067282, 8928276, 8837736, 9210925



OPatch succeeded.

-bash-3.00$
6- Load sql files into the database:
view plaincopy to clipboardprint?
-bash-3.00$ cd $ORACLE_HOME/rdbms/admin

-bash-3.00$

-bash-3.00$ sqlplus /nolog



SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 10 01:42:12 2011



Copyright (c) 1982, 2009, Oracle. All rights reserved.



SQL> connect / as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.



Total System Global Area 8551575552 bytes

Fixed Size 2228144 bytes

Variable Size 1375731792 bytes

Database Buffers 7163871232 bytes

Redo Buffers 9744384 bytes

Database mounted.

Database opened.

SQL>

SQL> @catbundle.sql psu apply

....

Check the following log file for errors:

/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/catbundle/catbundle_PSU_NBBSDB_APPLY_2011Aug10_01_43_22.log

SQL> QUIT



-bash-3.00$ cat /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/catbundle/catbundle_PSU_NBBSDB_APPLY_2011Aug10_01_43_22.log

...

....

.....



SQL> ALTER SESSION SET current_schema = SYS;



Session altered.



SQL> PROMPT Updating registry...

Updating registry...

SQL> INSERT INTO registry$history

2 (action_time, action,

3 namespace, version, id,

4 bundle_series, comments)

5 VALUES

6 (SYSTIMESTAMP, 'APPLY',

7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),

8 '11.2.0.1',

9 3,

10 'PSU',

11 'PSU 11.2.0.1.3');



1 row created.



SQL> COMMIT;



Commit complete.



SQL> SPOOL off
7- Start the listeners:
view plaincopy to clipboardprint?
-bash-3.00$ lsnrctl start



LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 10-AUG-2011 01:46:56



Copyright (c) 1991, 2009, Oracle. All rights reserved.



Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...



TNSLSNR for Solaris: Version 11.2.0.1.0 - Production

System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/ca120qadb02/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))



Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production

Start Date 10-AUG-2011 01:46:56

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/ca120qadb02/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

The listener supports no services

The command completed successfully

-bash-3.00$
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: