Oracle 11g 單一實例打11.2.0.3.4 P14275605 PSU補丁

Oracle 11g 單一實例打11.2.0.3.4 P14275605 PSU補丁

1.關閉所有instance

SQL> shutdown immediate

2.關閉所有監聽

$[Oracle@ora_11g test01]$ lsnrctl stop

3.關閉所有後台sqlplus

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

oracle  11823  6859  0 20:20 pts/2    00:00:00 grep sqlplus

--------------------------------------分割線 --------------------------------------

在CentOS 6.4下安裝Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虛擬機器中安裝步驟

Debian 下 安裝 Oracle 11g XE R2

--------------------------------------分割線 --------------------------------------

4.進入14275605 psu 解壓目錄,確保14275605許可權為oracle:oinstall

[oracle@ora_11g ~]$ cd /oinstall/14275605/

[oracle@ora_11g 14275605]$ pwd

/oinstall/14275605

[oracle@ora_11g 14275605]$ ls -al

drwxrwxr-x 6 oracle oinstall 4096 Oct 12 15:29 .

drwxr-xr-x 5 oracle oinstall 4096 Dec 17 20:00 ..

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 09:38 14275605

-rwxr-xr-x 1 oracle oinstall 2871 Oct  4 09:38 patchmd.xml

 

5.檢查OPATCH版本，如果版本過低需要到MOS下載最近的OPATCH psu號為為6880880

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

OPatch Version: 11.2.0.3.0

 

OPatch succeeded.

 

6.檢查是否有與14275605有衝突的PSU

[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/cfgtoollogs/opatch/opatch2012-12-18_20-05-23PM_1.log

 

Invoking prereq "checkconflictagainstohwithdetail"

 

Prereq "checkConflictAgainstOHWithDetail" passed.

 

OPatch succeeded.

 

 

7.應用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/cfgtoollogs/opatch/opatch2012-12-18_20-09-24PM_1.log

 

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:  13343438  13696216  13923374  14275605 

 

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 '13343438' 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 '13696216' 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 '13923374' 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 '14275605' 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/cfgtoollogs/opatch/opatch2012-12-18_20-09-24PM_1.log

 

OPatch completed with warnings.

 

 

8.進入admin目錄，執行catbundle.sql指令碼應用改變

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

[oracle@ora_11g admin]$ sqlplus  / as sysdba

 

SQL> startup

 

SQL> @catbundle.sql psu apply

 

查詢registry$history 來查看PSU層級

 

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.在以下目錄檢查是否錯誤

 

$ORACLE_HOME/cfgtoollogs/catbundle

$ORACLE_BASE/cfgtoollogs/catbundle

日誌格式如下:

catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log

catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log

 

到此 PSU資料庫升級完成

 

10.執行完catbundle.sql後，會在$ORACLE_HOME/rdbms/admin目錄下產生

catbundle_PSU_<database SID>_APPLY.sql，catbundle_PSU_<database SID>_ROLLBACK.sql兩個指令碼

 

[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用於復原PSU時使用