Patch 11.2.0.3.4 P14275605 PSU for a single Oracle 11g instance

Patch 11.2.0.3.4 P14275605 PSU for a single Oracle 11g instance

1. Close all instances

SQL> shutdown immediate

2. Disable all listeners

$ [Oracle @ ora_11g test01] $ lsnrctl stop

3. Disable all background sqlplus

[Oracle @ ora_11g 14275605] $ ps-ef | grep sqlplus

Oracle 11823 6859 0 00:00:00 pts/2 grep sqlplus

-------------------------------------- Split line --------------------------------------

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

-------------------------------------- Split line --------------------------------------

4. Go to the 14275605 psu decompression directory and ensure that the 14275605 permission is oracle: oinstall

[Oracle @ ora_11g ~] $ Cd/oinstall/14275605/

[Oracle @ ora_11g 14275605] $ pwd

/Oinstallation/14275605

[Oracle @ ora_11g 14275605] $ ls-al

Drwxrwxr-x 6 oracle oinstall 4096 Oct 12.

Drwxr-xr-x 5 oracle oinstall 4096 Dec 17 ..

Drwxr-xr-x 4 oracle oinstall 4096 Apr 4 2012 13343438

Drwxrwxr-x 4 oracle oinstall 4096 Apr 4 2012 13696216

Drwxrwxr-x 4 oracle oinstall 4096 Jun 13 2012 13923374

Drwxrwxr-x 4 oracle oinstall 4096 Oct 4 14275605

-Rwxr-xr-x 1 oracle oinstall 2871 Oct 4 patchmd. xml

 

5. Check the OPATCH version. if the version is too low, you need to download the latest OPATCH psu to MOS. The number is 6880880.

[Oracle @ ora_11g 14275605] $ ORACLE_HOME/OPatch/opatch version

OPatch Version: 11.2.0.3.0

 

OPatch succeeded.

 

6. check whether there are PSU conflicts with 14275605.

[Oracle @ ora_11g 14275605] $ ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-ph ./

Oracle Interim Patch Installer version 11.2.0.3.0

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

 

PREREQ session

 

Oracle Home:/opt/oracle/product/db_1

Central Inventory:/opt/oraInventory

From:/opt/oracle/product/db_1/oraInst. loc

OPatch version: 11.2.0.3.0

OUI version: 11.2.0.3.0

Log file location:/opt/oracle/product/db_1/export toollogs/opatch/opatch2012-12-18_20-05-23PM_1.log

 

Invoking prereq "checkconflictagainstohwithdetail"

 

Prereq "checkConflictAgainstOHWithDetail" passed.

 

OPatch succeeded.

 

 

7. Apply 14275605 database PSU

[Oracle @ ora_11g 14275605] $/opt/oracle/product/db_1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.0

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

 

 

Oracle Home:/opt/oracle/product/db_1

Central Inventory:/opt/oraInventory

From:/opt/oracle/product/db_1/oraInst. loc

OPatch version: 11.2.0.3.0

OUI version: 11.2.0.3.0

Log file location:/opt/oracle/product/db_1/export toollogs/opatch/opatch2012-12-18_20-09-24PM_1.log

 

Verifying environment and padding Ming prerequisite checks...

OPatch continues with these patches: 13343438 13696216 13923374

 

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 = '/opt/oracle/product/db_1 ')

 

 

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

Y

User Responded with: Y

Backing up files...

Applying sub-patch '000000' to oh'/opt/oracle/product/db_1'

 

Patching component oracle. rdbms. rsf, 11.2.0.3.0...

 

Patching component oracle. rdbms, 11.2.0.3.0...

 

Patching component oracle. rdbms. dbscripts, 11.2.0.3.0...

 

Verifying the update...

Applying sub-patch '000000' to oh'/opt/oracle/product/db_1'

 

Patching component oracle. rdbms. rsf, 11.2.0.3.0...

 

Patching component oracle. rdbms, 11.2.0.3.0...

 

Patching component oracle. sdo. locator, 11.2.0.3.0...

 

Patching component oracle. sysman. console. db, 11.2.0.3.0...

 

Patching component oracle. sysman. oms. core, 10.2.0.4.4...

 

Verifying the update...

Applying sub-patch '000000' to oh'/opt/oracle/product/db_1'

ApplySession: Optional component (s) [oracle. network. cman, 11.2.0.3.0] not present in the Oracle Home or a higher version is found.

 

Patching component oracle. rdbms. rsf, 11.2.0.3.0...

 

Patching component oracle. rdbms, 11.2.0.3.0...

 

Patching component oracle. rdbms. dbscripts, 11.2.0.3.0...

 

Patching component oracle. network. rsf, 11.2.0.3.0...

 

Patching component oracle. network. listener, 11.2.0.3.0...

 

Patching component oracle. sysman. console. db, 11.2.0.3.0...

 

Verifying the update...

Applying sub-patch '000000' to oh'/opt/oracle/product/db_1'

ApplySession: Optional component (s) [oracle. precomp. lang, 11.2.0.3.0] not present in the Oracle Home or a higher version is found.

 

Patching component oracle. network. client, 11.2.0.3.0...

 

Patching component oracle. network. rsf, 11.2.0.3.0...

 

Patching component oracle. precomp. common, 11.2.0.3.0...

 

Patching component oracle. rdbms, 11.2.0.3.0...

 

Patching component oracle. rdbms. dbscripts, 11.2.0.3.0...

 

Patching component oracle. rdbms. rman, 11.2.0.3.0...

 

Patching component oracle. rdbms. rsf, 11.2.0.3.0...

 

Patching component oracle. rdbms. util, 11.2.0.3.0...

 

Verifying the update...

 

OPatch found the word "warning" in the stderr of the make command.

Please look at this stderr. You can re-run this make command.

Stderr output:

Ins_precomp.mk: 19: warning: overriding commands for target 'pcscfg. cfg'

/Opt/oracle/product/db_1/precomp/lib/env_precomp.mk: 2160: warning: ignoring old commands for target 'pcscfg. cfg'

/Opt/oracle/product/db_1/precomp/lib/ins_precomp.mk: 19: warning: overriding commands for target 'pcscfg. cfg'

/Opt/oracle/product/db_1/precomp/lib/env_precomp.mk: 2160: warning: ignoring old commands for target 'pcscfg. cfg'

 

 

Composite patch 14275605 successfully applied.

OPatch Session completed with warnings.

Log file location:/opt/oracle/product/db_1/export toollogs/opatch/opatch2012-12-18_20-09-24PM_1.log

 

OPatch completed with warnings.

 

 

8. Go to the admin directory and run the catbundle. SQL script to change the application.

[Oracle @ ora_11g 14275605] $ cd $ ORACLE_HOME/rdbms/admin

[Oracle @ ora_11g admin] $ sqlplus/as sysdba

 

SQL> startup

 

SQL> @ catbundle. SQL psu apply

 

Query registry $ history to view the PSU level

 

SQL> select substr (action_time, 1, 30) action_time,

Substr (id, 1, 8) id,

Substr (action, 1, 10) action,

Substr (version, 1, 8) version,

Substr (comments, 1, 20) comments

From registry $ history;

 

ACTION_TIME ID ACTION VERSION COMMENTS

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

17-DEC-12 03.14.08.703547 PM 0 APPLY 11.2.0.3 Patchset 11.2.0.2.0

18-DEC-12 08.13.16.342146 PM 4 APPLY 11.2.0.3 PSU 11.2.0.3.4

 

 

9. Check for errors in the following directories

 

$ ORACLE_HOME/logging toollogs/catbundle

$ ORACLE_BASE/logging toollogs/catbundle

The log format is as follows:

Catbundle_PSU _ <database SID> _ APPLY _ <TIMESTAMP>. log

Catbundle_PSU _ <database SID> _ GENERATE _ <TIMESTAMP>. log

 

The PSU database has been upgraded.

 

10. After the catbundle. SQL statement is executed, it is generated in the $ ORACLE_HOME/rdbms/admin directory.

Catbundle_PSU _ <database SID> _ APPLY. SQL, catbundle_PSU _ <database SID> _ ROLLBACK. SQL scripts

 

[Oracle @ ora_11g admin] $ ls-al catbundle_PSU_TEST01 _*

-Rw-r ----- 1 oracle oinstall 1130 Dec 18 20:13 catbundle_PSU_TEST01_APPLY. SQL

-Rw-r ----- 1 oracle oinstall 1139 Dec 18 20:13 catbundle_PSU_TEST01_ROLLBACK. SQL

 

Catbundle_PSU_TEST01_ROLLBACK. SQL is used for PSU rollback.