【简单的案例分享,停机10分钟】10204升级CRS&DB的PSU至102044
来源:互联网 发布:如何看待李贽思想知乎 编辑:程序博客网 时间:2024/05/21 16:21
发现一个现象,AIX5.3+HACMP+10.2.0.4RAC+RAW的环境,运行五六年的数据库crsd.log都会报以下错误:
-------------------------------------------
CAAMonitorHandler :: 0:Action Script /opt/oracle/product/crs/bin/racgwrap(check) timed out for ora.harac1.vip! (timeout=60)
CheckResource error for ora.harac1.vip error code = -2
CAAMonitorHandler :: 0:Could not join /opt/oracle/product/crs/bin/racgwrap(check)
category: 1234, operation: scls_process_join, loc: childcrash, OS error: 0,
other: Abnormal termination of the child
-------------------------------------------
以上错误发生时,vip1无法响应应用连接,持续时间由2-10分钟不等,影响范围很大。
以上错误其实是BUG,对于BUG的描述请看:
由此可见,只要将CRS版本升级至10.2.0.4.2或该版本以上即可。
以下粘出打补丁的测试全过程,测试环境为RedHat5.5+ASM+10204RAC
此次打补丁采用滚动升级方式进行,最后一步需要START UPGRADE独占方式启库操作,将中止数据库对外服务,将影响范围降至最低。
提醒:打补丁前一定要仔细查看README.txt,并严格按照README.txt里的步骤逐一操作,而且打丁前切记备份数据库和安装目录,做好回退方案,以免不时之需。
1.1.1 preinstall requickment
[oracle@dwdb1 ~]$ cd $ORA_CRS_HOME/OPatch
[oracle@dwdb1 OPatch]$ ./opatch lsinventory -detail
Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.1.0/db_1
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /oracle/product/11.1.0/db_1/oui
Log file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2014-11-10_10-21-55AM.log
Lsinventory Output file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-11-10_10-21-55AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.
Installed Products (191):
Agent Required Support Files 10.2.0.1.0
Agent Required Support Files Patch 10.2.0.4.0
Assistant Common Files 10.2.0.1.0
Assistant Common Files Patch 10.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 10.2.0.1.0
Character Set Migration Utility 10.2.0.1.0
Character Set Migration Utility Patch 10.2.0.4.0
Database Configuration and Upgrade Assistants 10.2.0.1.0
Database Configuration and Upgrade Assistants Patch 10.2.0.4.0
Database SQL Scripts 10.2.0.1.0
Database SQL Scripts Patch 10.2.0.4.0
Database Workspace Manager 10.2.0.1.0
Database Workspace Manager 10.2.0.4.0
DBJAVA Required Support Files 10.2.0.1.0
DBJAVA Required Support Files Patch 10.2.0.4.0
Enterprise Edition Options 10.2.0.1.0
Enterprise Manager Agent Core 10.2.0.1.0
Enterprise Manager Agent Core Patch 10.2.0.4.0a
Enterprise Manager Agent DB 10.2.0.1.0
Enterprise Manager Agent DB 10.2.0.4.0
Enterprise Manager Baseline 10.2.0.1.0
Enterprise Manager Baseline 10.2.0.4.0
Enterprise Manager Common Core Patch 10.2.0.4.0a
Enterprise Manager Common Files 10.2.0.1.0
Enterprise Manager Minimal Integration 10.2.0.1.0
Enterprise Manager plugin Common Files 10.2.0.1.0
Enterprise Manager plugin Common Files 10.2.0.1.0
Enterprise Manager plugin Common Files Patch 10.2.0.4.0
Enterprise Manager Repository Core 10.2.0.1.0
Enterprise Manager Repository Core patch 10.2.0.4.0a
Enterprise Manager Repository DB 10.2.0.1.0
Enterprise Manager Repository DB 10.2.0.4.0
Generic Connectivity Common Files 10.2.0.1.0
Generic Connectivity Common Files Patch 10.2.0.4.0
HAS Common Files 10.2.0.1.0
HAS Common Files Patch 10.2.0.4.0
HAS Files for DB 10.2.0.1.0
HAS Files for DB Patch 10.2.0.4.0
Installation Common Files 10.2.0.1.0
Installation Common Files Patch 10.2.0.4.0
Installer SDK Component 10.2.0.4.0
iSQL*Plus 10.2.0.1.0
iSQL*Plus 10.2.0.4.0
Java Runtime Environment 1.4.2.14.0
JDBC Common Files 10.2.0.1.0
JDBC Common Files 10.2.0.4.0
LDAP Required Support Files 10.2.0.1.0
LDAP Required Support Files Patch 10.2.0.4.0
OLAP SQL Scripts 10.2.0.1.0
OLAP SQL Scripts Patch 10.2.0.4.0
Oracle Advanced Security 10.2.0.1.0
Oracle Advanced Security Patch 10.2.0.4.0
Oracle Call Interface (OCI) 10.2.0.1.0
Oracle Call Interface (OCI) Patch 10.2.0.4.0
Oracle Clusterware RDBMS Files 10.2.0.1.0
Oracle Clusterware RDBMS Files Patch 10.2.0.4.0
Oracle Code Editor 1.2.1.0.0I
Oracle Configuration Manager 10.2.7.1.0
Oracle Containers for Java 10.2.0.1.0
Oracle Containers for Java 10.2.0.4.0
Oracle Core Required Support Files 10.2.0.1.0
Oracle Core Required Support Files Patch 10.2.0.4.0
Oracle Data Mining RDBMS Files 10.2.0.1.0
Oracle Data Mining RDBMS Files Patch 10.2.0.4.0
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g 10.2.0.1.0
Oracle Database 10G 32 bit 10.2.0.1.0
Oracle Database 10g interMedia Files 10.2.0.1.0
Oracle Database 10g interMedia Files Patch 10.2.0.4.0
Oracle Database 10g Patch 10.2.0.4.0
Oracle Database 10g Patch 10.2.0.4.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 10.2.0.1.0
Oracle Database Utilities Patch 10.2.0.4.0
Oracle Display Fonts 9.0.2.0.0
Oracle Enterprise Manager Console DB 10.2.0.1.0
Oracle Enterprise Manager Console DB 10.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.38.0.0
Oracle Globalization Support 10.2.0.1.0
Oracle Globalization Support Patch 10.2.0.4.0
Oracle Help For Java 4.2.6.1.0
Oracle Help for the Web 1.1.10.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle interMedia 10.2.0.1.0
Oracle interMedia Annotator 10.2.0.1.0
Oracle interMedia Client Option 10.2.0.1.0
Oracle interMedia Client Option Patch 10.2.0.4.0
Oracle interMedia Java Advanced Imaging 10.2.0.1.0
Oracle interMedia Java Advanced Imaging Patch 10.2.0.4.0
Oracle interMedia Locator 10.2.0.1.0
Oracle interMedia Locator Patch 10.2.0.4.0
Oracle interMedia Locator RDBMS Files 10.2.0.1.0
Oracle interMedia Locator RDBMS Files Patch 10.2.0.4.0
Oracle interMedia Patch 10.2.0.4.0
Oracle Internet Directory Client 10.2.0.1.0
Oracle Internet Directory Client Patch 10.2.0.4.0
Oracle Java Client 10.2.0.1.0
Oracle Java Client Patch 10.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.2 Patch 10.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.4 Patch 10.2.0.4.0
Oracle JDBC/OCI Instant Client 10.2.0.1.0
Oracle JDBC/OCI Instant Client Patch 10.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.33.0.0
Oracle JVM 10.2.0.1.0
Oracle JVM Patch 10.2.0.4.0
Oracle LDAP administration 10.2.0.1.0
Oracle LDAP administration patch 10.2.0.4.0
Oracle Locale Builder 10.2.0.1.0
Oracle Message Gateway Common Files 10.2.0.1.0
Oracle Message Gateway Common Files Patch 10.2.0.4.0
Oracle Net 10.2.0.1.0
Oracle Net Listener 10.2.0.1.0
Oracle Net Listener Patch 10.2.0.4.0
Oracle Net Patch 10.2.0.4.0
Oracle Net Required Support Files 10.2.0.1.0
Oracle Net Required Support Files Patch 10.2.0.4.0
Oracle Net Services 10.2.0.1.0
Oracle Notification Service 10.1.0.3.0
Oracle Notification Service Patch 10.2.0.4.0
Oracle ODBC Driver 10.2.0.1.0
Oracle ODBC Driver Patch 10.2.0.4.0
Oracle OLAP 10.2.0.1.0
Oracle OLAP API 10.2.0.1.0
Oracle OLAP API Patch 10.2.0.4.0
Oracle OLAP Patch 10.2.0.4.0
Oracle OLAP RDBMS Files 10.2.0.1.0
Oracle OLAP RDBMS Files Patch 10.2.0.4.0
Oracle One-Off Patch Installer 10.2.0.4.0
Oracle Partitioning 10.2.0.1.0
Oracle Partitioning Patch 10.2.0.4.0
Oracle Programmer 10.2.0.1.0
Oracle RAC Required Support Files-HAS 10.2.0.1.0
Oracle RAC Required Support Files-HAS Patch 10.2.0.4.0
Oracle Real Application Testing 10.2.0.4.0
Oracle Recovery Manager 10.2.0.1.0
Oracle Recovery Manager Patch 10.2.0.4.0
Oracle Required Support Files 32 bit 10.2.0.0.0
Oracle Required Support Files 32 bit Patch 10.2.0.4.0
Oracle Spatial 10.2.0.1.0
Oracle Starter Database 10.2.0.1.0
Oracle Starter Database Patch 10.2.0.4.0
Oracle Text 10.2.0.1.0
Oracle Text Patch 10.2.0.4.0
Oracle UIX 2.1.22.0.0
Oracle Universal Installer 10.2.0.4.0
Oracle Wallet Manager 10.2.0.1.0
Oracle Wallet Manager Patch 10.2.0.4.0
Oracle XML Development Kit 10.2.0.1.0
Oracle XML Development Kit Patch 10.2.0.4.0
Parser Generator Required Support Files 10.2.0.1.0
Perl Interpreter 5.8.3.0.2
PL/SQL 10.2.0.1.0
PL/SQL 10.2.0.4.0
PL/SQL Embedded Gateway 10.2.0.1.0
PL/SQL Embedded Gateway Patch 10.2.0.4.0
Platform Required Support Files 10.2.0.1.0
Platform Required Support Files 10.2.0.4.0
Precompiler Common Files 10.2.0.1.0
Precompiler Common Files Patch 10.2.0.4.0
Precompiler Required Support Files 10.2.0.1.0
Precompiler Required Support Files Patch 10.2.0.4.0
RDBMS Required Support Files 10.2.0.1.0
RDBMS Required Support Files for Instant Client 10.2.0.1.0
RDBMS Required Support Files for Instant Client Patch 10.2.0.4.0
RDBMS Required Support Files Patch 10.2.0.4.0
regexp 2.1.9.0.0
Required Support Files 10.2.0.1.0
Sample Schema Data 10.2.0.1.0
Sample Schema Data Patch 10.2.0.4.0
Secure Socket Layer 10.2.0.1.0
Secure Socket Layer Patch 10.2.0.4.0
SQL*Plus 10.2.0.1.0
SQL*Plus 10.2.0.4.0
SQL*Plus Required Support Files 10.2.0.1.0
SQL*Plus Required Support Files Patch 10.2.0.4.0
SQLJ Runtime 10.2.0.1.0
SQLJ Runtime Patch 10.2.0.4.0
SSL Required Support Files for InstantClient 10.2.0.1.0
SSL Required Support Files for InstantClient Patch 10.2.0.4.0
Sun JDK 1.4.2.14.0
Sun JDK extensions 10.1.2.0.0
XDK Required Support Files 10.2.0.1.0
XDK Required Support Files Patch 10.2.0.4.0
XML Parser for Java 10.2.0.1.0
XML Parser for Java Patch 10.2.0.4.0
XML Parser for Oracle JVM 10.2.0.1.0
XML Parser for Oracle JVM Patch 10.2.0.4.0
There are 191 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = dwdb1
Remote node = dwdb2
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@dwdb1 orainst]$ ls –lrt
total 2299108
drwxr-xr-x 10 oracle oinstall 4096 Oct 23 2005 clusterware
drwxr-xr-x 6 oracle oinstall 4096 Oct 23 2005 database
drwxr-xr-x 5 oracle oinstall 4096 Mar 12 2008 Disk1
-rwxr-xr-x 1 oracle oinstall 171882 Mar 17 2008 README.html
drwxr-xr-x 7 oracle oinstall 4096 Nov 3 2010 OPatch
-rw-r--r-- 1 oracle oinstall 316486815 Nov 3 22:19 10201_clusterware_linux_x86_64.cpio.gz
-rw-r--r-- 1 oracle oinstall 758433170 Nov 3 22:20 10201_database_linux_x86_64.cpio.gz
-rw-r--r-- 1 oracle oinstall 1195551830 Nov 6 22:59 p6810189_10204_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall 0 Nov 6 23:03 a
-rw-r--r-- 1 oracle oinstall 20035 Nov 10 10:45 p9294403_CRS-PSU_102044_README.txt
-rw-r--r-- 1 oracle oinstall 53853693 Nov 10 10:45 p9294403_CRS-PSU_102044_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall 27412455 Nov 10 10:59 p6880880_102000_Linux-x86-64.zip
[oracle@dwdb1 orainst]$ ./OPatch/opatch version
Invoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1
OPatch succeeded.
[oracle@dwdb1 orainst]$ mv $ORA_CRS_HOME/OPatch $ORA_CRS_HOME/OPatch_bak
[oracle@dwdb1 orainst]$ cp -rp OPatch/ /oracle/product/11.1.0/crs_1/
[oracle@dwdb1 orainst]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bak
[oracle@dwdb1 orainst]$ cp -rp OPatch/ $ORACLE_HOME/
[oracle@dwdb1 orainst]$ unzip p9294403_CRS-PSU_102044_Linux-x86-64.zip
[oracle@dwdb1 orainst]$ cd 9294403
1.1.2 stop instance and CRS (11:07 – 五分钟)
[oracle@dwdb1 orainst]$ srvctl stop instance -i odsptdb1 -d odsptdb
[root@dwdb1 crs_1]# /etc/init.d/init.crs stop
Shutting down Oracle Cluster Ready Services (CRS):
Nov 10 11:08:20.377 | INF | daemon shutting down
Stopping resources. This could take several minutes.
Successfully stopped CRS resources.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
1.1.3 unlock protected files<root>
# export ORA_CRS_HOME=/oracle/product/11.1.0/crs_1
[root@dwdb1 9294403]# /orainst/9294403/custom/scripts/prerootpatch.sh -crshome $ORA_CRS_HOME -crsuser oracle
Checking to see if Oracle CRS stack is down...
Oracle CRS stack is down now.
1.1.4 save important configuration setting<oracl>
[oracle@dwdb1 orainst]$ /orainst/9294403/custom/scripts/prepatch.sh -crshome $ORA_CRS_HOME
/orainst/9294403/custom/scripts/prepatch.sh completed successfully.
[oracle@dwdb1 orainst]$
[oracle@dwdb1 orainst]$
[oracle@dwdb1 orainst]$ /orainst/9294403/custom/server/9294403/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
Unable to determine value for ORACLE_BASE. Ignoring...
/orainst/9294403/custom/server/9294403/custom/scripts/prepatch.sh completed successfully.
1.1.5 Patch the CRS home files
1.1.5.1 to CRS_HOME
[oracle@dwdb1 orainst]$ export PATH=$ORA_CRS_HOME/OPatch:$PATH
[oracle@dwdb1 orainst]$ opatch napply -local -oh $ORA_CRS_HOME -id 9294403
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
UTIL session
Oracle Home : /oracle/product/11.1.0/crs_1
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.4.0
OUI location : /oracle/product/11.1.0/crs_1/oui
Log file location : /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch2014-11-10_11-19-41AM.log
Patch history file: /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch_history.txt
Invoking utility "napply"
Checking conflict among patches...
Checking if Oracle Home has components required by patches...
Checking conflicts against Oracle Home...
OPatch continues with these patches: 9294403
Do you want to proceed? [y|n]
y
User Responded with: Y
Running prerequisite checks...
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
You selected -local option, hence OPatch will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/product/11.1.0/crs_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch 'NApply' for restore. This might take a while...
…
Verifying the update...
Inventory check OK: Patch ID 9294403 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9294403 are present in Oracle Home.
The local system has been patched and can be restarted.
UtilSession: N-Apply done.
OPatch succeeded.
1.1.5.2 to RDBMS_HOME
[oracle@dwdb1 orainst]$ cd 9294403/
[oracle@dwdb1 9294403]$ opatch napply custom/server/ -local -oh $ORACLE_HOME -id 9294403
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
UTIL session
Oracle Home : /oracle/product/11.1.0/db_1
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.4.0
OUI location : /oracle/product/11.1.0/db_1/oui
Log file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2014-11-10_11-31-32AM.log
Patch history file: /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Invoking utility "napply"
Checking conflict among patches...
Checking if Oracle Home has components required by patches...
Checking conflicts against Oracle Home...
OPatch continues with these patches: 9294403
Do you want to proceed? [y|n]y
Running prerequisite checks...
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
You selected -local option, hence OPatch will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/product/11.1.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch 'NApply' for restore. This might take a while...
Applying patch 9294403...
ApplySession applying interim patch '9294403' to OH '/oracle/product/11.1.0/db_1'
…
Verifying the update...
Inventory check OK: Patch ID 9294403 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9294403 are present in Oracle Home.
Running make for target install
Running make for target install
The local system has been patched and can be restarted.
UtilSession: N-Apply done.
OPatch succeeded.
[oracle@dwdb1 9294403]$ which opatch
/oracle/product/11.1.0/db_1/OPatch/opatch
[oracle@dwdb1 9294403]$ opatch lsinventory
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.1.0/db_1
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.4.0
OUI location : /oracle/product/11.1.0/db_1/oui
Log file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2014-11-10_11-33-44AM.log
Patch history file: /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-11-10_11-33-44AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.
Interim patches (1) :
Patch 9294403 : applied on Mon Nov 10 11:33:01 CST 2014
Unique Patch ID: 12382183
Created on 19 Mar 2010, 18:59:24 hrs PST8PDT
Bugs fixed:
9294403
Rac system comprising of multiple nodes
Local node = dwdb1
Remote node = dwdb2
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@dwdb1 9294403]$ opatch lsinventory -oh $ORA_CRS_HOME
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.1.0/crs_1
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.4.0
OUI location : /oracle/product/11.1.0/crs_1/oui
Log file location : /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch2014-11-10_11-34-03AM.log
Patch history file: /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/lsinv/lsinventory2014-11-10_11-34-03AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Clusterware 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.
Interim patches (1) :
Patch 9294403 : applied on Mon Nov 10 11:21:48 CST 2014
Unique Patch ID: 12382183
Created on 19 Mar 2010, 18:59:31 hrs PST8PDT
Bugs fixed:
9294403
Rac system comprising of multiple nodes
Local node = dwdb1
Remote node = dwdb2
--------------------------------------------------------------------------------
OPatch succeeded.
1.1.6 Configure the HOME
1.1.6.1 TO CRS_HOME
[oracle@dwdb1 9294403]$ custom/scripts/postpatch.sh -crshome $ORA_CRS_HOME
Oracle CRS_ENV_FILE is not specified but using /oracle/product/11.1.0/crs_1/install/params.crs for parameter definitions
Oracle CRS_ENV_FILE is not specified
…
1.1.6.2 TO RDBMS_HOME
[oracle@dwdb1 9294403]$ custom/server/9294403/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
Reading /oracle/product/11.1.0/db_1/install/params.ora..
Reading /oracle/product/11.1.0/db_1/install/params.ora..
Parsing file /oracle/product/11.1.0/db_1/bin/racgwrap
Parsing file /oracle/product/11.1.0/db_1/css/admin/init.cssd
…
1.1.7 restored security on the CRS Home <root>
11:40
[root@dwdb1 9294403]# custom/scripts/postrootpatch.sh -crshome $ORA_CRS_HOME
Checking to see if Oracle CRS stack is already up...
Checking to see if Oracle CRS stack is already starting
WARNING: directory '/oracle/product/11.1.0' is not owned by root
WARNING: directory '/oracle/product' is not owned by root
WARNING: directory '/oracle' is not owned by root
Startup will be queued to init within 30 seconds.
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
1.1.8 verify pathing
1.1.8.1 TO CRS_HOME
[oracle@dwdb1 9294403]$ opatch lsinventory -detail -oh $ORA_CRS_HOME
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.1.0/crs_1
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.4.0
OUI location : /oracle/product/11.1.0/crs_1/oui
Log file location : /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch2014-11-10_11-42-01AM.log
Patch history file: /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/lsinv/lsinventory2014-11-10_11-42-01AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Clusterware 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.
Installed Products (57):
Agent Required Support Files 10.2.0.1.0
Agent Required Support Files Patch 10.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 10.2.0.1.0
Cluster Ready Services Files 10.2.0.1.0
Cluster Ready Services Files Patch 10.2.0.4.0
DBJAVA Required Support Files 10.2.0.1.0
DBJAVA Required Support Files Patch 10.2.0.4.0
Enterprise Manager Minimal Integration 10.2.0.1.0
HAS Common Files 10.2.0.1.0
HAS Common Files Patch 10.2.0.4.0
Installer SDK Component 10.2.0.4.0
Java Runtime Environment 1.4.2.14.0
LDAP Required Support Files 10.2.0.1.0
LDAP Required Support Files Patch 10.2.0.4.0
Oracle Clusterware 10.2.0.1.0
Oracle Clusterware Patch 10.2.0.4.0
Oracle Clusterware RDBMS Files 10.2.0.1.0
Oracle Clusterware RDBMS Files Patch 10.2.0.4.0
Oracle Core Required Support Files 10.2.0.1.0
Oracle Core Required Support Files Patch 10.2.0.4.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.38.0.0
Oracle Globalization Support 10.2.0.1.0
Oracle Globalization Support Patch 10.2.0.4.0
Oracle Help For Java 4.2.6.1.0
Oracle Ice Browser 5.2.3.6.0
Oracle JFC Extended Windowing Toolkit 4.2.33.0.0
Oracle Locale Builder 10.2.0.1.0
Oracle Net Required Support Files 10.2.0.1.0
Oracle Net Required Support Files Patch 10.2.0.4.0
Oracle Notification Service 10.1.0.3.0
Oracle Notification Service Patch 10.2.0.4.0
Oracle One-Off Patch Installer 10.2.0.4.0
Oracle RAC Required Support Files-HAS 10.2.0.1.0
Oracle RAC Required Support Files-HAS Patch 10.2.0.4.0
Oracle Required Support Files 32 bit 10.2.0.0.0
Oracle Required Support Files 32 bit Patch 10.2.0.4.0
Oracle Universal Installer 10.2.0.4.0
Parser Generator Required Support Files 10.2.0.1.0
Perl Interpreter 5.8.3.0.2
Platform Required Support Files 10.2.0.1.0
Platform Required Support Files 10.2.0.4.0
Precompiler Required Support Files 10.2.0.1.0
Precompiler Required Support Files Patch 10.2.0.4.0
RDBMS Required Support Files 10.2.0.1.0
RDBMS Required Support Files for Instant Client 10.2.0.1.0
RDBMS Required Support Files for Instant Client Patch 10.2.0.4.0
RDBMS Required Support Files Patch 10.2.0.4.0
Required Support Files 10.2.0.1.0
SQL*Plus Required Support Files 10.2.0.1.0
SQL*Plus Required Support Files Patch 10.2.0.4.0
SSL Required Support Files for InstantClient 10.2.0.1.0
SSL Required Support Files for InstantClient Patch 10.2.0.4.0
Sun JDK 1.4.2.14.0
XDK Required Support Files 10.2.0.1.0
XDK Required Support Files Patch 10.2.0.4.0
There are 57 products installed in this Oracle Home.
Interim patches (1) :
Patch 9294403 : applied on Mon Nov 10 11:21:48 CST 2014
Unique Patch ID: 12382183
Created on 19 Mar 2010, 18:59:31 hrs PST8PDT
Bugs fixed:
9294403
Files Touched:
cemutlo --> ORACLE_HOME/bin/cemutlo
cemutlo.bin --> ORACLE_HOME/bin/cemutlo.bin
cemutls --> ORACLE_HOME/bin/cemutls
cemutls.bin --> ORACLE_HOME/bin/cemutls.bin
clscfg --> ORACLE_HOME/bin/clscfg
clscfg.bin --> ORACLE_HOME/bin/clscfg.bin
clsfmt --> ORACLE_HOME/bin/clsfmt
clsfmt.bin --> ORACLE_HOME/bin/clsfmt.bin
clsid --> ORACLE_HOME/bin/clsid
clsid.bin --> ORACLE_HOME/bin/clsid.bin
cluutil --> ORACLE_HOME/bin/cluutil
cluvfy --> ORACLE_HOME/bin/cluvfy
crs_getperm --> ORACLE_HOME/bin/crs_getperm
crs_getperm.bin --> ORACLE_HOME/bin/crs_getperm.bin
crs_profile --> ORACLE_HOME/bin/crs_profile
crs_profile.bin --> ORACLE_HOME/bin/crs_profile.bin
crs_register --> ORACLE_HOME/bin/crs_register
crs_register.bin --> ORACLE_HOME/bin/crs_register.bin
crs_relocate --> ORACLE_HOME/bin/crs_relocate
crs_relocate.bin --> ORACLE_HOME/bin/crs_relocate.bin
crs_setperm --> ORACLE_HOME/bin/crs_setperm
crs_setperm.bin --> ORACLE_HOME/bin/crs_setperm.bin
crs_start --> ORACLE_HOME/bin/crs_start
crs_start.bin --> ORACLE_HOME/bin/crs_start.bin
crs_stat --> ORACLE_HOME/bin/crs_stat
crs_stat.bin --> ORACLE_HOME/bin/crs_stat.bin
crs_stop --> ORACLE_HOME/bin/crs_stop
crs_stop.bin --> ORACLE_HOME/bin/crs_stop.bin
crs_unregister --> ORACLE_HOME/bin/crs_unregister
crs_unregister.bin --> ORACLE_HOME/bin/crs_unregister.bin
crsctl --> ORACLE_HOME/bin/crsctl
crsctl.bin --> ORACLE_HOME/bin/crsctl.bin
crsd --> ORACLE_HOME/bin/crsd
crsd.bin --> ORACLE_HOME/bin/crsd.bin
crstmpl.scr --> ORACLE_HOME/bin/crstmpl.scr
diagcollection.pl --> ORACLE_HOME/bin/diagcollection.pl
evmd --> ORACLE_HOME/bin/evmd
evmd.bin --> ORACLE_HOME/bin/evmd.bin
evminfo --> ORACLE_HOME/bin/evminfo
evminfo.bin --> ORACLE_HOME/bin/evminfo.bin
evmlogger --> ORACLE_HOME/bin/evmlogger
evmlogger.bin --> ORACLE_HOME/bin/evmlogger.bin
evmmkbin --> ORACLE_HOME/bin/evmmkbin
evmmkbin.bin --> ORACLE_HOME/bin/evmmkbin.bin
evmmklib --> ORACLE_HOME/bin/evmmklib
evmmklib.bin --> ORACLE_HOME/bin/evmmklib.bin
evmpost --> ORACLE_HOME/bin/evmpost
evmpost.bin --> ORACLE_HOME/bin/evmpost.bin
evmshow --> ORACLE_HOME/bin/evmshow
evmshow.bin --> ORACLE_HOME/bin/evmshow.bin
evmsort --> ORACLE_HOME/bin/evmsort
evmsort.bin --> ORACLE_HOME/bin/evmsort.bin
evmwatch --> ORACLE_HOME/bin/evmwatch
evmwatch.bin --> ORACLE_HOME/bin/evmwatch.bin
gsd --> ORACLE_HOME/bin/gsd
gsd.sh --> ORACLE_HOME/bin/gsd.sh
gsdctl --> ORACLE_HOME/bin/gsdctl
lsdb --> ORACLE_HOME/bin/lsdb
lsnodes --> ORACLE_HOME/bin/lsnodes
lsnodes.bin --> ORACLE_HOME/bin/lsnodes.bin
oclsomon --> ORACLE_HOME/bin/oclsomon
oclsomon.bin --> ORACLE_HOME/bin/oclsomon.bin
oclsvmon --> ORACLE_HOME/bin/oclsvmon
oclsvmon.bin --> ORACLE_HOME/bin/oclsvmon.bin
ocrcheck --> ORACLE_HOME/bin/ocrcheck
ocrcheck.bin --> ORACLE_HOME/bin/ocrcheck.bin
ocrconfig --> ORACLE_HOME/bin/ocrconfig
ocrconfig.bin --> ORACLE_HOME/bin/ocrconfig.bin
ocrdump --> ORACLE_HOME/bin/ocrdump
ocrdump.bin --> ORACLE_HOME/bin/ocrdump.bin
ocrpatch --> ORACLE_HOME/bin/ocrpatch
ocssd --> ORACLE_HOME/bin/ocssd
ocssd.bin --> ORACLE_HOME/bin/ocssd.bin
oifcfg --> ORACLE_HOME/bin/oifcfg
oifcfg.bin --> ORACLE_HOME/bin/oifcfg.bin
olsnodes --> ORACLE_HOME/bin/olsnodes
olsnodes.bin --> ORACLE_HOME/bin/olsnodes.bin
oprocd --> ORACLE_HOME/bin/oprocd
oprocd.bin --> ORACLE_HOME/bin/oprocd.bin
racgeut --> ORACLE_HOME/bin/racgeut
racgevtf --> ORACLE_HOME/bin/racgevtf
racgmain --> ORACLE_HOME/bin/racgmain
racgons --> ORACLE_HOME/bin/racgons
racgons.bin --> ORACLE_HOME/bin/racgons.bin
racgvip --> ORACLE_HOME/bin/racgvip
racgwrap --> ORACLE_HOME/bin/racgwrap
sclsspawn --> ORACLE_HOME/bin/sclsspawn
srvctl --> ORACLE_HOME/bin/srvctl
usrvip --> ORACLE_HOME/bin/usrvip
vipca --> ORACLE_HOME/bin/vipca
init.crs --> ORACLE_HOME/crs/admin/init.crs
init.crsd --> ORACLE_HOME/crs/admin/init.crsd
inittab --> ORACLE_HOME/crs/admin/inittab
clscrsx.h --> ORACLE_HOME/crs/demo/clscrsx.h
crsapp.c --> ORACLE_HOME/crs/demo/crsapp.c
demo_crs.mk --> ORACLE_HOME/crs/demo/demo_crs.mk
env_has.mk --> ORACLE_HOME/crs/lib/env_has.mk
env_has.mk --> ORACLE_HOME/crs/lib32/env_has.mk
crsar.msb --> ORACLE_HOME/crs/mesg/crsar.msb
crscs.msb --> ORACLE_HOME/crs/mesg/crscs.msb
crsd.msb --> ORACLE_HOME/crs/mesg/crsd.msb
crsdk.msb --> ORACLE_HOME/crs/mesg/crsdk.msb
crse.msb --> ORACLE_HOME/crs/mesg/crse.msb
crsel.msb --> ORACLE_HOME/crs/mesg/crsel.msb
crsf.msb --> ORACLE_HOME/crs/mesg/crsf.msb
crshu.msb --> ORACLE_HOME/crs/mesg/crshu.msb
crsi.msb --> ORACLE_HOME/crs/mesg/crsi.msb
crsiw.msb --> ORACLE_HOME/crs/mesg/crsiw.msb
crsja.msb --> ORACLE_HOME/crs/mesg/crsja.msb
crsko.msb --> ORACLE_HOME/crs/mesg/crsko.msb
crsn.msb --> ORACLE_HOME/crs/mesg/crsn.msb
crsnl.msb --> ORACLE_HOME/crs/mesg/crsnl.msb
crspl.msb --> ORACLE_HOME/crs/mesg/crspl.msb
crspt.msb --> ORACLE_HOME/crs/mesg/crspt.msb
crsptb.msb --> ORACLE_HOME/crs/mesg/crsptb.msb
crsro.msb --> ORACLE_HOME/crs/mesg/crsro.msb
crsru.msb --> ORACLE_HOME/crs/mesg/crsru.msb
crss.msb --> ORACLE_HOME/crs/mesg/crss.msb
crssf.msb --> ORACLE_HOME/crs/mesg/crssf.msb
crssk.msb --> ORACLE_HOME/crs/mesg/crssk.msb
crsth.msb --> ORACLE_HOME/crs/mesg/crsth.msb
crstr.msb --> ORACLE_HOME/crs/mesg/crstr.msb
crsus.msb --> ORACLE_HOME/crs/mesg/crsus.msb
crsus.msg --> ORACLE_HOME/crs/mesg/crsus.msg
crszhs.msb --> ORACLE_HOME/crs/mesg/crszhs.msb
crszht.msb --> ORACLE_HOME/crs/mesg/crszht.msb
action_scr.scr --> ORACLE_HOME/crs/public/action_scr.scr
TYPE_application.cap --> ORACLE_HOME/crs/template/TYPE_application.cap
TYPE_generic.cap --> ORACLE_HOME/crs/template/TYPE_generic.cap
application.tdf --> ORACLE_HOME/crs/template/application.tdf
generic.tdf --> ORACLE_HOME/crs/template/generic.tdf
init.cssd --> ORACLE_HOME/css/admin/init.cssd
clssar.msb --> ORACLE_HOME/css/mesg/clssar.msb
clsscs.msb --> ORACLE_HOME/css/mesg/clsscs.msb
clssd.msb --> ORACLE_HOME/css/mesg/clssd.msb
clssdk.msb --> ORACLE_HOME/css/mesg/clssdk.msb
clsse.msb --> ORACLE_HOME/css/mesg/clsse.msb
clssel.msb --> ORACLE_HOME/css/mesg/clssel.msb
clssf.msb --> ORACLE_HOME/css/mesg/clssf.msb
clsshu.msb --> ORACLE_HOME/css/mesg/clsshu.msb
clssi.msb --> ORACLE_HOME/css/mesg/clssi.msb
clssiw.msb --> ORACLE_HOME/css/mesg/clssiw.msb
clssja.msb --> ORACLE_HOME/css/mesg/clssja.msb
clssko.msb --> ORACLE_HOME/css/mesg/clssko.msb
clssn.msb --> ORACLE_HOME/css/mesg/clssn.msb
clssnl.msb --> ORACLE_HOME/css/mesg/clssnl.msb
clsspl.msb --> ORACLE_HOME/css/mesg/clsspl.msb
clsspt.msb --> ORACLE_HOME/css/mesg/clsspt.msb
clssptb.msb --> ORACLE_HOME/css/mesg/clssptb.msb
clssro.msb --> ORACLE_HOME/css/mesg/clssro.msb
clssru.msb --> ORACLE_HOME/css/mesg/clssru.msb
clsss.msb --> ORACLE_HOME/css/mesg/clsss.msb
clsssf.msb --> ORACLE_HOME/css/mesg/clsssf.msb
clsssk.msb --> ORACLE_HOME/css/mesg/clsssk.msb
clssth.msb --> ORACLE_HOME/css/mesg/clssth.msb
clsstr.msb --> ORACLE_HOME/css/mesg/clsstr.msb
clssus.msb --> ORACLE_HOME/css/mesg/clssus.msb
clssus.msg --> ORACLE_HOME/css/mesg/clssus.msg
clsszhs.msb --> ORACLE_HOME/css/mesg/clsszhs.msb
clsszht.msb --> ORACLE_HOME/css/mesg/clsszht.msb
cvu_config --> ORACLE_HOME/cv/admin/cvu_config
admin.dtd --> ORACLE_HOME/cv/cvdata/admin.dtd
admin.xml --> ORACLE_HOME/cv/cvdata/admin.xml
constraints.dtd --> ORACLE_HOME/cv/cvdata/constraints.dtd
constraints.xml --> ORACLE_HOME/cv/cvdata/constraints.xml
exectask --> ORACLE_HOME/cv/remenv/exectask
exectask.sh --> ORACLE_HOME/cv/remenv/exectask.sh
cvuqdisk-1.0.1-1.rpm --> ORACLE_HOME/cv/rpm/cvuqdisk-1.0.1-1.rpm
evm.auth --> ORACLE_HOME/evm/admin/conf/evm.auth
evmdaemon.conf --> ORACLE_HOME/evm/admin/conf/evmdaemon.conf
evmlogger.conf --> ORACLE_HOME/evm/admin/conf/evmlogger.conf
clu.evf --> ORACLE_HOME/evm/admin/filters/clu.evf
crs.evf --> ORACLE_HOME/evm/admin/filters/crs.evf
evm.evf --> ORACLE_HOME/evm/admin/filters/evm.evf
sys.evf --> ORACLE_HOME/evm/admin/filters/sys.evf
init.evmd --> ORACLE_HOME/evm/admin/init.evmd
clu.evt --> ORACLE_HOME/evm/admin/templates/clu/clu.evt
crs.evt --> ORACLE_HOME/evm/admin/templates/clu/crs/crs.evt
oraha.evt --> ORACLE_HOME/evm/admin/templates/clu/oraha.evt
evm.evt --> ORACLE_HOME/evm/admin/templates/sys/evm.evt
evmar.msb --> ORACLE_HOME/evm/mesg/evmar.msb
evmcs.msb --> ORACLE_HOME/evm/mesg/evmcs.msb
evmd.msb --> ORACLE_HOME/evm/mesg/evmd.msb
evmdk.msb --> ORACLE_HOME/evm/mesg/evmdk.msb
evme.msb --> ORACLE_HOME/evm/mesg/evme.msb
evmel.msb --> ORACLE_HOME/evm/mesg/evmel.msb
evmf.msb --> ORACLE_HOME/evm/mesg/evmf.msb
evmhu.msb --> ORACLE_HOME/evm/mesg/evmhu.msb
evmi.msb --> ORACLE_HOME/evm/mesg/evmi.msb
evmiw.msb --> ORACLE_HOME/evm/mesg/evmiw.msb
evmja.msb --> ORACLE_HOME/evm/mesg/evmja.msb
evmko.msb --> ORACLE_HOME/evm/mesg/evmko.msb
evmn.msb --> ORACLE_HOME/evm/mesg/evmn.msb
evmnl.msb --> ORACLE_HOME/evm/mesg/evmnl.msb
evmpl.msb --> ORACLE_HOME/evm/mesg/evmpl.msb
evmpt.msb --> ORACLE_HOME/evm/mesg/evmpt.msb
evmptb.msb --> ORACLE_HOME/evm/mesg/evmptb.msb
evmro.msb --> ORACLE_HOME/evm/mesg/evmro.msb
evmru.msb --> ORACLE_HOME/evm/mesg/evmru.msb
evms.msb --> ORACLE_HOME/evm/mesg/evms.msb
evmsf.msb --> ORACLE_HOME/evm/mesg/evmsf.msb
evmsk.msb --> ORACLE_HOME/evm/mesg/evmsk.msb
evmth.msb --> ORACLE_HOME/evm/mesg/evmth.msb
evmtr.msb --> ORACLE_HOME/evm/mesg/evmtr.msb
evmus.msb --> ORACLE_HOME/evm/mesg/evmus.msb
evmus.msg --> ORACLE_HOME/evm/mesg/evmus.msg
evmzhs.msb --> ORACLE_HOME/evm/mesg/evmzhs.msb
evmzht.msb --> ORACLE_HOME/evm/mesg/evmzht.msb
clsdar.msb --> ORACLE_HOME/has/mesg/clsdar.msb
clsdcs.msb --> ORACLE_HOME/has/mesg/clsdcs.msb
clsdd.msb --> ORACLE_HOME/has/mesg/clsdd.msb
clsddk.msb --> ORACLE_HOME/has/mesg/clsddk.msb
clsde.msb --> ORACLE_HOME/has/mesg/clsde.msb
clsdel.msb --> ORACLE_HOME/has/mesg/clsdel.msb
clsdf.msb --> ORACLE_HOME/has/mesg/clsdf.msb
clsdhu.msb --> ORACLE_HOME/has/mesg/clsdhu.msb
clsdi.msb --> ORACLE_HOME/has/mesg/clsdi.msb
clsdiw.msb --> ORACLE_HOME/has/mesg/clsdiw.msb
clsdja.msb --> ORACLE_HOME/has/mesg/clsdja.msb
clsdko.msb --> ORACLE_HOME/has/mesg/clsdko.msb
clsdn.msb --> ORACLE_HOME/has/mesg/clsdn.msb
clsdnl.msb --> ORACLE_HOME/has/mesg/clsdnl.msb
clsdpl.msb --> ORACLE_HOME/has/mesg/clsdpl.msb
clsdpt.msb --> ORACLE_HOME/has/mesg/clsdpt.msb
clsdptb.msb --> ORACLE_HOME/has/mesg/clsdptb.msb
clsdro.msb --> ORACLE_HOME/has/mesg/clsdro.msb
clsdru.msb --> ORACLE_HOME/has/mesg/clsdru.msb
clsds.msb --> ORACLE_HOME/has/mesg/clsds.msb
clsdsf.msb --> ORACLE_HOME/has/mesg/clsdsf.msb
clsdsk.msb --> ORACLE_HOME/has/mesg/clsdsk.msb
clsdth.msb --> ORACLE_HOME/has/mesg/clsdth.msb
clsdtr.msb --> ORACLE_HOME/has/mesg/clsdtr.msb
clsdus.msb --> ORACLE_HOME/has/mesg/clsdus.msb
clsdus.msg --> ORACLE_HOME/has/mesg/clsdus.msg
clsdzhs.msb --> ORACLE_HOME/has/mesg/clsdzhs.msb
clsdzht.msb --> ORACLE_HOME/has/mesg/clsdzht.msb
clstar.msb --> ORACLE_HOME/has/mesg/clstar.msb
clstcs.msb --> ORACLE_HOME/has/mesg/clstcs.msb
clstd.msb --> ORACLE_HOME/has/mesg/clstd.msb
clstdk.msb --> ORACLE_HOME/has/mesg/clstdk.msb
clste.msb --> ORACLE_HOME/has/mesg/clste.msb
clstel.msb --> ORACLE_HOME/has/mesg/clstel.msb
clstf.msb --> ORACLE_HOME/has/mesg/clstf.msb
clsthu.msb --> ORACLE_HOME/has/mesg/clsthu.msb
clsti.msb --> ORACLE_HOME/has/mesg/clsti.msb
clstiw.msb --> ORACLE_HOME/has/mesg/clstiw.msb
clstja.msb --> ORACLE_HOME/has/mesg/clstja.msb
clstko.msb --> ORACLE_HOME/has/mesg/clstko.msb
clstn.msb --> ORACLE_HOME/has/mesg/clstn.msb
clstnl.msb --> ORACLE_HOME/has/mesg/clstnl.msb
clstpl.msb --> ORACLE_HOME/has/mesg/clstpl.msb
clstpt.msb --> ORACLE_HOME/has/mesg/clstpt.msb
clstptb.msb --> ORACLE_HOME/has/mesg/clstptb.msb
clstro.msb --> ORACLE_HOME/has/mesg/clstro.msb
clstru.msb --> ORACLE_HOME/has/mesg/clstru.msb
clsts.msb --> ORACLE_HOME/has/mesg/clsts.msb
clstsf.msb --> ORACLE_HOME/has/mesg/clstsf.msb
clstsk.msb --> ORACLE_HOME/has/mesg/clstsk.msb
clstth.msb --> ORACLE_HOME/has/mesg/clstth.msb
clsttr.msb --> ORACLE_HOME/has/mesg/clsttr.msb
clstus.msb --> ORACLE_HOME/has/mesg/clstus.msb
clstus.msg --> ORACLE_HOME/has/mesg/clstus.msg
clstzhs.msb --> ORACLE_HOME/has/mesg/clstzhs.msb
clstzht.msb --> ORACLE_HOME/has/mesg/clstzht.msb
install.excl --> ORACLE_HOME/install/install.excl
install.incl --> ORACLE_HOME/install/install.incl
localconfig --> ORACLE_HOME/install/localconfig
paramfile.crs --> ORACLE_HOME/install/paramfile.crs
root10103.sh --> ORACLE_HOME/install/root10103.sh
root102.sh --> ORACLE_HOME/install/root102.sh
rootadd.sbs --> ORACLE_HOME/install/rootadd.sbs
rootaddnode.sbs --> ORACLE_HOME/install/rootaddnode.sbs
rootconfig.sh --> ORACLE_HOME/install/rootconfig.sh
rootdeinstall.sh --> ORACLE_HOME/install/rootdeinstall.sh
rootdelete.sh --> ORACLE_HOME/install/rootdelete.sh
rootdeletenode.sh --> ORACLE_HOME/install/rootdeletenode.sh
rootinstall.sh --> ORACLE_HOME/install/rootinstall.sh
rootupgrade.sh --> ORACLE_HOME/install/rootupgrade.sh
cvu.jar --> ORACLE_HOME/jlib/cvu.jar
srvm.jar --> ORACLE_HOME/jlib/srvm.jar
srvmhas.jar --> ORACLE_HOME/jlib/srvmhas.jar
libcxaguard.so.5 --> ORACLE_HOME/lib/libcxaguard.so.5
libdbcfg10.so --> ORACLE_HOME/lib/libdbcfg10.so
libhasgen10.so --> ORACLE_HOME/lib/libhasgen10.so
libocr10.so --> ORACLE_HOME/lib/libocr10.so
libocrb10.so --> ORACLE_HOME/lib/libocrb10.so
libocrutl10.so --> ORACLE_HOME/lib/libocrutl10.so
libsrvm10.so --> ORACLE_HOME/lib/libsrvm10.so
libsrvmhas10.so --> ORACLE_HOME/lib/libsrvmhas10.so
libsrvmocr10.so --> ORACLE_HOME/lib/libsrvmocr10.so
libuini10.a --> ORACLE_HOME/lib/libuini10.a
libuini10.so --> ORACLE_HOME/lib/libuini10.so
libdbcfg10.so --> ORACLE_HOME/lib32/libdbcfg10.so
libhasgen10.so --> ORACLE_HOME/lib32/libhasgen10.so
libocr10.so --> ORACLE_HOME/lib32/libocr10.so
libocrb10.so --> ORACLE_HOME/lib32/libocrb10.so
libocrutl10.so --> ORACLE_HOME/lib32/libocrutl10.so
libsrvm10.so --> ORACLE_HOME/lib32/libsrvm10.so
libsrvmhas10.so --> ORACLE_HOME/lib32/libsrvmhas10.so
libsrvmocr10.so --> ORACLE_HOME/lib32/libsrvmocr10.so
libuini10.a --> ORACLE_HOME/lib32/libuini10.a
libuini10.so --> ORACLE_HOME/lib32/libuini10.so
README --> ORACLE_HOME/racg/README
clsrar.msb --> ORACLE_HOME/racg/mesg/clsrar.msb
clsrcs.msb --> ORACLE_HOME/racg/mesg/clsrcs.msb
clsrd.msb --> ORACLE_HOME/racg/mesg/clsrd.msb
clsrdk.msb --> ORACLE_HOME/racg/mesg/clsrdk.msb
clsre.msb --> ORACLE_HOME/racg/mesg/clsre.msb
clsrel.msb --> ORACLE_HOME/racg/mesg/clsrel.msb
clsrf.msb --> ORACLE_HOME/racg/mesg/clsrf.msb
clsrhu.msb --> ORACLE_HOME/racg/mesg/clsrhu.msb
clsri.msb --> ORACLE_HOME/racg/mesg/clsri.msb
clsriw.msb --> ORACLE_HOME/racg/mesg/clsriw.msb
clsrja.msb --> ORACLE_HOME/racg/mesg/clsrja.msb
clsrko.msb --> ORACLE_HOME/racg/mesg/clsrko.msb
clsrn.msb --> ORACLE_HOME/racg/mesg/clsrn.msb
clsrnl.msb --> ORACLE_HOME/racg/mesg/clsrnl.msb
clsrpl.msb --> ORACLE_HOME/racg/mesg/clsrpl.msb
clsrpt.msb --> ORACLE_HOME/racg/mesg/clsrpt.msb
clsrptb.msb --> ORACLE_HOME/racg/mesg/clsrptb.msb
clsrro.msb --> ORACLE_HOME/racg/mesg/clsrro.msb
clsrru.msb --> ORACLE_HOME/racg/mesg/clsrru.msb
clsrs.msb --> ORACLE_HOME/racg/mesg/clsrs.msb
clsrsf.msb --> ORACLE_HOME/racg/mesg/clsrsf.msb
clsrsk.msb --> ORACLE_HOME/racg/mesg/clsrsk.msb
clsrth.msb --> ORACLE_HOME/racg/mesg/clsrth.msb
clsrtr.msb --> ORACLE_HOME/racg/mesg/clsrtr.msb
clsrus.msb --> ORACLE_HOME/racg/mesg/clsrus.msb
clsrus.msg --> ORACLE_HOME/racg/mesg/clsrus.msg
clsrzhs.msb --> ORACLE_HOME/racg/mesg/clsrzhs.msb
clsrzht.msb --> ORACLE_HOME/racg/mesg/clsrzht.msb
ocrlog.ini --> ORACLE_HOME/srvm/admin/ocrlog.ini
paramfile.sample --> ORACLE_HOME/srvm/admin/paramfile.sample
srvctl.jar --> ORACLE_HOME/srvm/jlib/srvctl.jar
vipca.jar --> ORACLE_HOME/srvm/jlib/vipca.jar
libsrvm10.a --> ORACLE_HOME/srvm/lib/libsrvm10.a
libsrvmhas10.a --> ORACLE_HOME/srvm/lib/libsrvmhas10.a
libsrvmocr10.a --> ORACLE_HOME/srvm/lib/libsrvmocr10.a
libsrvm10.a --> ORACLE_HOME/srvm/lib32/libsrvm10.a
libsrvmhas10.a --> ORACLE_HOME/srvm/lib32/libsrvmhas10.a
libsrvmocr10.a --> ORACLE_HOME/srvm/lib32/libsrvmocr10.a
prcod.msb --> ORACLE_HOME/srvm/mesg/prcod.msb
prcoe.msb --> ORACLE_HOME/srvm/mesg/prcoe.msb
prcof.msb --> ORACLE_HOME/srvm/mesg/prcof.msb
prcoi.msb --> ORACLE_HOME/srvm/mesg/prcoi.msb
prcoja.msb --> ORACLE_HOME/srvm/mesg/prcoja.msb
prcoko.msb --> ORACLE_HOME/srvm/mesg/prcoko.msb
prcoptb.msb --> ORACLE_HOME/srvm/mesg/prcoptb.msb
prcous.msb --> ORACLE_HOME/srvm/mesg/prcous.msb
prcous.msg --> ORACLE_HOME/srvm/mesg/prcous.msg
prcozhs.msb --> ORACLE_HOME/srvm/mesg/prcozhs.msb
prcozht.msb --> ORACLE_HOME/srvm/mesg/prcozht.msb
prifd.msb --> ORACLE_HOME/srvm/mesg/prifd.msb
prife.msb --> ORACLE_HOME/srvm/mesg/prife.msb
priff.msb --> ORACLE_HOME/srvm/mesg/priff.msb
prifi.msb --> ORACLE_HOME/srvm/mesg/prifi.msb
prifja.msb --> ORACLE_HOME/srvm/mesg/prifja.msb
prifko.msb --> ORACLE_HOME/srvm/mesg/prifko.msb
prifptb.msb --> ORACLE_HOME/srvm/mesg/prifptb.msb
prifus.msb --> ORACLE_HOME/srvm/mesg/prifus.msb
prifus.msg --> ORACLE_HOME/srvm/mesg/prifus.msg
prifzhs.msb --> ORACLE_HOME/srvm/mesg/prifzhs.msb
prifzht.msb --> ORACLE_HOME/srvm/mesg/prifzht.msb
procd.msb --> ORACLE_HOME/srvm/mesg/procd.msb
proce.msb --> ORACLE_HOME/srvm/mesg/proce.msb
procf.msb --> ORACLE_HOME/srvm/mesg/procf.msb
proci.msb --> ORACLE_HOME/srvm/mesg/proci.msb
procja.msb --> ORACLE_HOME/srvm/mesg/procja.msb
procko.msb --> ORACLE_HOME/srvm/mesg/procko.msb
procptb.msb --> ORACLE_HOME/srvm/mesg/procptb.msb
procus.msb --> ORACLE_HOME/srvm/mesg/procus.msb
procus.msg --> ORACLE_HOME/srvm/mesg/procus.msg
proczhs.msb --> ORACLE_HOME/srvm/mesg/proczhs.msb
proczht.msb --> ORACLE_HOME/srvm/mesg/proczht.msb
protd.msb --> ORACLE_HOME/srvm/mesg/protd.msb
prote.msb --> ORACLE_HOME/srvm/mesg/prote.msb
protf.msb --> ORACLE_HOME/srvm/mesg/protf.msb
proti.msb --> ORACLE_HOME/srvm/mesg/proti.msb
protja.msb --> ORACLE_HOME/srvm/mesg/protja.msb
protko.msb --> ORACLE_HOME/srvm/mesg/protko.msb
protptb.msb --> ORACLE_HOME/srvm/mesg/protptb.msb
protus.msb --> ORACLE_HOME/srvm/mesg/protus.msb
protus.msg --> ORACLE_HOME/srvm/mesg/protus.msg
protzhs.msb --> ORACLE_HOME/srvm/mesg/protzhs.msb
protzht.msb --> ORACLE_HOME/srvm/mesg/protzht.msb
rootconfigadd --> ORACLE_HOME/srvm/utl/rootconfigadd
rootinstalladd --> ORACLE_HOME/srvm/utl/rootinstalladd
Patch Location in Inventory:
/oracle/product/11.1.0/crs_1/inventory/oneoffs/9294403
Patch Location in Storage area:
/oracle/product/11.1.0/crs_1/.patch_storage/9294403_Mar_19_2010_18_59_31
Rac system comprising of multiple nodes
Local node = dwdb1
Remote node = dwdb2
--------------------------------------------------------------------------------
OPatch succeeded.
1.1.8.2 TO RDBMS_HOME
[oracle@dwdb1 9294403]$ opatch lsinventory -detail -oh $ORACLE_HOME
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.1.0/db_1
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.4.0
OUI location : /oracle/product/11.1.0/db_1/oui
Log file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2014-11-10_11-42-55AM.log
Patch history file: /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-11-10_11-42-55AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.
Installed Products (191):
Agent Required Support Files 10.2.0.1.0
Agent Required Support Files Patch 10.2.0.4.0
Assistant Common Files 10.2.0.1.0
Assistant Common Files Patch 10.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 10.2.0.1.0
Character Set Migration Utility 10.2.0.1.0
Character Set Migration Utility Patch 10.2.0.4.0
Database Configuration and Upgrade Assistants 10.2.0.1.0
Database Configuration and Upgrade Assistants Patch 10.2.0.4.0
Database SQL Scripts 10.2.0.1.0
Database SQL Scripts Patch 10.2.0.4.0
Database Workspace Manager 10.2.0.1.0
Database Workspace Manager 10.2.0.4.0
DBJAVA Required Support Files 10.2.0.1.0
DBJAVA Required Support Files Patch 10.2.0.4.0
Enterprise Edition Options 10.2.0.1.0
Enterprise Manager Agent Core 10.2.0.1.0
Enterprise Manager Agent Core Patch 10.2.0.4.0a
Enterprise Manager Agent DB 10.2.0.1.0
Enterprise Manager Agent DB 10.2.0.4.0
Enterprise Manager Baseline 10.2.0.1.0
Enterprise Manager Baseline 10.2.0.4.0
Enterprise Manager Common Core Patch 10.2.0.4.0a
Enterprise Manager Common Files 10.2.0.1.0
Enterprise Manager Minimal Integration 10.2.0.1.0
Enterprise Manager plugin Common Files 10.2.0.1.0
Enterprise Manager plugin Common Files 10.2.0.1.0
Enterprise Manager plugin Common Files Patch 10.2.0.4.0
Enterprise Manager Repository Core 10.2.0.1.0
Enterprise Manager Repository Core patch 10.2.0.4.0a
Enterprise Manager Repository DB 10.2.0.1.0
Enterprise Manager Repository DB 10.2.0.4.0
Generic Connectivity Common Files 10.2.0.1.0
Generic Connectivity Common Files Patch 10.2.0.4.0
HAS Common Files 10.2.0.1.0
HAS Common Files Patch 10.2.0.4.0
HAS Files for DB 10.2.0.1.0
HAS Files for DB Patch 10.2.0.4.0
Installation Common Files 10.2.0.1.0
Installation Common Files Patch 10.2.0.4.0
Installer SDK Component 10.2.0.4.0
iSQL*Plus 10.2.0.1.0
iSQL*Plus 10.2.0.4.0
Java Runtime Environment 1.4.2.14.0
JDBC Common Files 10.2.0.1.0
JDBC Common Files 10.2.0.4.0
LDAP Required Support Files 10.2.0.1.0
LDAP Required Support Files Patch 10.2.0.4.0
OLAP SQL Scripts 10.2.0.1.0
OLAP SQL Scripts Patch 10.2.0.4.0
Oracle Advanced Security 10.2.0.1.0
Oracle Advanced Security Patch 10.2.0.4.0
Oracle Call Interface (OCI) 10.2.0.1.0
Oracle Call Interface (OCI) Patch 10.2.0.4.0
Oracle Clusterware RDBMS Files 10.2.0.1.0
Oracle Clusterware RDBMS Files Patch 10.2.0.4.0
Oracle Code Editor 1.2.1.0.0I
Oracle Configuration Manager 10.2.7.1.0
Oracle Containers for Java 10.2.0.1.0
Oracle Containers for Java 10.2.0.4.0
Oracle Core Required Support Files 10.2.0.1.0
Oracle Core Required Support Files Patch 10.2.0.4.0
Oracle Data Mining RDBMS Files 10.2.0.1.0
Oracle Data Mining RDBMS Files Patch 10.2.0.4.0
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g 10.2.0.1.0
Oracle Database 10G 32 bit 10.2.0.1.0
Oracle Database 10g interMedia Files 10.2.0.1.0
Oracle Database 10g interMedia Files Patch 10.2.0.4.0
Oracle Database 10g Patch 10.2.0.4.0
Oracle Database 10g Patch 10.2.0.4.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 10.2.0.1.0
Oracle Database Utilities Patch 10.2.0.4.0
Oracle Display Fonts 9.0.2.0.0
Oracle Enterprise Manager Console DB 10.2.0.1.0
Oracle Enterprise Manager Console DB 10.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.38.0.0
Oracle Globalization Support 10.2.0.1.0
Oracle Globalization Support Patch 10.2.0.4.0
Oracle Help For Java 4.2.6.1.0
Oracle Help for the Web 1.1.10.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle interMedia 10.2.0.1.0
Oracle interMedia Annotator 10.2.0.1.0
Oracle interMedia Client Option 10.2.0.1.0
Oracle interMedia Client Option Patch 10.2.0.4.0
Oracle interMedia Java Advanced Imaging 10.2.0.1.0
Oracle interMedia Java Advanced Imaging Patch 10.2.0.4.0
Oracle interMedia Locator 10.2.0.1.0
Oracle interMedia Locator Patch 10.2.0.4.0
Oracle interMedia Locator RDBMS Files 10.2.0.1.0
Oracle interMedia Locator RDBMS Files Patch 10.2.0.4.0
Oracle interMedia Patch 10.2.0.4.0
Oracle Internet Directory Client 10.2.0.1.0
Oracle Internet Directory Client Patch 10.2.0.4.0
Oracle Java Client 10.2.0.1.0
Oracle Java Client Patch 10.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.2 Patch 10.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.4 Patch 10.2.0.4.0
Oracle JDBC/OCI Instant Client 10.2.0.1.0
Oracle JDBC/OCI Instant Client Patch 10.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.33.0.0
Oracle JVM 10.2.0.1.0
Oracle JVM Patch 10.2.0.4.0
Oracle LDAP administration 10.2.0.1.0
Oracle LDAP administration patch 10.2.0.4.0
Oracle Locale Builder 10.2.0.1.0
Oracle Message Gateway Common Files 10.2.0.1.0
Oracle Message Gateway Common Files Patch 10.2.0.4.0
Oracle Net 10.2.0.1.0
Oracle Net Listener 10.2.0.1.0
Oracle Net Listener Patch 10.2.0.4.0
Oracle Net Patch 10.2.0.4.0
Oracle Net Required Support Files 10.2.0.1.0
Oracle Net Required Support Files Patch 10.2.0.4.0
Oracle Net Services 10.2.0.1.0
Oracle Notification Service 10.1.0.3.0
Oracle Notification Service Patch 10.2.0.4.0
Oracle ODBC Driver 10.2.0.1.0
Oracle ODBC Driver Patch 10.2.0.4.0
Oracle OLAP 10.2.0.1.0
Oracle OLAP API 10.2.0.1.0
Oracle OLAP API Patch 10.2.0.4.0
Oracle OLAP Patch 10.2.0.4.0
Oracle OLAP RDBMS Files 10.2.0.1.0
Oracle OLAP RDBMS Files Patch 10.2.0.4.0
Oracle One-Off Patch Installer 10.2.0.4.0
Oracle Partitioning 10.2.0.1.0
Oracle Partitioning Patch 10.2.0.4.0
Oracle Programmer 10.2.0.1.0
Oracle RAC Required Support Files-HAS 10.2.0.1.0
Oracle RAC Required Support Files-HAS Patch 10.2.0.4.0
Oracle Real Application Testing 10.2.0.4.0
Oracle Recovery Manager 10.2.0.1.0
Oracle Recovery Manager Patch 10.2.0.4.0
Oracle Required Support Files 32 bit 10.2.0.0.0
Oracle Required Support Files 32 bit Patch 10.2.0.4.0
Oracle Spatial 10.2.0.1.0
Oracle Starter Database 10.2.0.1.0
Oracle Starter Database Patch 10.2.0.4.0
Oracle Text 10.2.0.1.0
Oracle Text Patch 10.2.0.4.0
Oracle UIX 2.1.22.0.0
Oracle Universal Installer 10.2.0.4.0
Oracle Wallet Manager 10.2.0.1.0
Oracle Wallet Manager Patch 10.2.0.4.0
Oracle XML Development Kit 10.2.0.1.0
Oracle XML Development Kit Patch 10.2.0.4.0
Parser Generator Required Support Files 10.2.0.1.0
Perl Interpreter 5.8.3.0.2
PL/SQL 10.2.0.1.0
PL/SQL 10.2.0.4.0
PL/SQL Embedded Gateway 10.2.0.1.0
PL/SQL Embedded Gateway Patch 10.2.0.4.0
Platform Required Support Files 10.2.0.1.0
Platform Required Support Files 10.2.0.4.0
Precompiler Common Files 10.2.0.1.0
Precompiler Common Files Patch 10.2.0.4.0
Precompiler Required Support Files 10.2.0.1.0
Precompiler Required Support Files Patch 10.2.0.4.0
RDBMS Required Support Files 10.2.0.1.0
RDBMS Required Support Files for Instant Client 10.2.0.1.0
RDBMS Required Support Files for Instant Client Patch 10.2.0.4.0
RDBMS Required Support Files Patch 10.2.0.4.0
regexp 2.1.9.0.0
Required Support Files 10.2.0.1.0
Sample Schema Data 10.2.0.1.0
Sample Schema Data Patch 10.2.0.4.0
Secure Socket Layer 10.2.0.1.0
Secure Socket Layer Patch 10.2.0.4.0
SQL*Plus 10.2.0.1.0
SQL*Plus 10.2.0.4.0
SQL*Plus Required Support Files 10.2.0.1.0
SQL*Plus Required Support Files Patch 10.2.0.4.0
SQLJ Runtime 10.2.0.1.0
SQLJ Runtime Patch 10.2.0.4.0
SSL Required Support Files for InstantClient 10.2.0.1.0
SSL Required Support Files for InstantClient Patch 10.2.0.4.0
Sun JDK 1.4.2.14.0
Sun JDK extensions 10.1.2.0.0
XDK Required Support Files 10.2.0.1.0
XDK Required Support Files Patch 10.2.0.4.0
XML Parser for Java 10.2.0.1.0
XML Parser for Java Patch 10.2.0.4.0
XML Parser for Oracle JVM 10.2.0.1.0
XML Parser for Oracle JVM Patch 10.2.0.4.0
There are 191 products installed in this Oracle Home.
Interim patches (1) :
Patch 9294403 : applied on Mon Nov 10 11:33:01 CST 2014
Unique Patch ID: 12382183
Created on 19 Mar 2010, 18:59:24 hrs PST8PDT
Bugs fixed:
9294403
Files Touched:
clscfg --> ORACLE_HOME/bin/clscfg
clscfg.bin --> ORACLE_HOME/bin/clscfg.bin
clsfmt --> ORACLE_HOME/bin/clsfmt
clsfmt.bin --> ORACLE_HOME/bin/clsfmt.bin
clsid --> ORACLE_HOME/bin/clsid
clsid.bin --> ORACLE_HOME/bin/clsid.bin
cluvfy --> ORACLE_HOME/bin/cluvfy
crsctl --> ORACLE_HOME/bin/crsctl
crsctl.bin --> ORACLE_HOME/bin/crsctl.bin
gsd --> ORACLE_HOME/bin/gsd
gsd.sh --> ORACLE_HOME/bin/gsd.sh
gsdctl --> ORACLE_HOME/bin/gsdctl
localconfig --> ORACLE_HOME/bin/localconfig
lsnodes --> ORACLE_HOME/bin/lsnodes
ocssd --> ORACLE_HOME/bin/ocssd
ocssd.bin --> ORACLE_HOME/bin/ocssd.bin
racgwrap --> ORACLE_HOME/bin/racgwrap
rawutl --> ORACLE_HOME/bin/rawutl
srvconfig --> ORACLE_HOME/bin/srvconfig
srvctl --> ORACLE_HOME/bin/srvctl
srvmspawn --> ORACLE_HOME/bin/srvmspawn
vipca --> ORACLE_HOME/bin/vipca
clscrsx.h --> ORACLE_HOME/crs/demo/clscrsx.h
crsapp.c --> ORACLE_HOME/crs/demo/crsapp.c
demo_crs.mk --> ORACLE_HOME/crs/demo/demo_crs.mk
env_has.mk --> ORACLE_HOME/crs/lib/env_has.mk
env_has.mk --> ORACLE_HOME/crs/lib32/env_has.mk
crsar.msb --> ORACLE_HOME/crs/mesg/crsar.msb
crscs.msb --> ORACLE_HOME/crs/mesg/crscs.msb
crsd.msb --> ORACLE_HOME/crs/mesg/crsd.msb
crsdk.msb --> ORACLE_HOME/crs/mesg/crsdk.msb
crse.msb --> ORACLE_HOME/crs/mesg/crse.msb
crsel.msb --> ORACLE_HOME/crs/mesg/crsel.msb
crsf.msb --> ORACLE_HOME/crs/mesg/crsf.msb
crshu.msb --> ORACLE_HOME/crs/mesg/crshu.msb
crsi.msb --> ORACLE_HOME/crs/mesg/crsi.msb
crsiw.msb --> ORACLE_HOME/crs/mesg/crsiw.msb
crsja.msb --> ORACLE_HOME/crs/mesg/crsja.msb
crsko.msb --> ORACLE_HOME/crs/mesg/crsko.msb
crsn.msb --> ORACLE_HOME/crs/mesg/crsn.msb
crsnl.msb --> ORACLE_HOME/crs/mesg/crsnl.msb
crspl.msb --> ORACLE_HOME/crs/mesg/crspl.msb
crspt.msb --> ORACLE_HOME/crs/mesg/crspt.msb
crsptb.msb --> ORACLE_HOME/crs/mesg/crsptb.msb
crsro.msb --> ORACLE_HOME/crs/mesg/crsro.msb
crsru.msb --> ORACLE_HOME/crs/mesg/crsru.msb
crss.msb --> ORACLE_HOME/crs/mesg/crss.msb
crssf.msb --> ORACLE_HOME/crs/mesg/crssf.msb
crssk.msb --> ORACLE_HOME/crs/mesg/crssk.msb
crsth.msb --> ORACLE_HOME/crs/mesg/crsth.msb
crstr.msb --> ORACLE_HOME/crs/mesg/crstr.msb
crsus.msb --> ORACLE_HOME/crs/mesg/crsus.msb
crsus.msg --> ORACLE_HOME/crs/mesg/crsus.msg
crszhs.msb --> ORACLE_HOME/crs/mesg/crszhs.msb
crszht.msb --> ORACLE_HOME/crs/mesg/crszht.msb
action_scr.scr --> ORACLE_HOME/crs/public/action_scr.scr
init.cssd --> ORACLE_HOME/css/admin/init.cssd
inittab_local --> ORACLE_HOME/css/admin/inittab_local
clssar.msb --> ORACLE_HOME/css/mesg/clssar.msb
clsscs.msb --> ORACLE_HOME/css/mesg/clsscs.msb
clssd.msb --> ORACLE_HOME/css/mesg/clssd.msb
clssdk.msb --> ORACLE_HOME/css/mesg/clssdk.msb
clsse.msb --> ORACLE_HOME/css/mesg/clsse.msb
clssel.msb --> ORACLE_HOME/css/mesg/clssel.msb
clssf.msb --> ORACLE_HOME/css/mesg/clssf.msb
clsshu.msb --> ORACLE_HOME/css/mesg/clsshu.msb
clssi.msb --> ORACLE_HOME/css/mesg/clssi.msb
clssiw.msb --> ORACLE_HOME/css/mesg/clssiw.msb
clssja.msb --> ORACLE_HOME/css/mesg/clssja.msb
clssko.msb --> ORACLE_HOME/css/mesg/clssko.msb
clssn.msb --> ORACLE_HOME/css/mesg/clssn.msb
clssnl.msb --> ORACLE_HOME/css/mesg/clssnl.msb
clsspl.msb --> ORACLE_HOME/css/mesg/clsspl.msb
clsspt.msb --> ORACLE_HOME/css/mesg/clsspt.msb
clssptb.msb --> ORACLE_HOME/css/mesg/clssptb.msb
clssro.msb --> ORACLE_HOME/css/mesg/clssro.msb
clssru.msb --> ORACLE_HOME/css/mesg/clssru.msb
clsss.msb --> ORACLE_HOME/css/mesg/clsss.msb
clsssf.msb --> ORACLE_HOME/css/mesg/clsssf.msb
clsssk.msb --> ORACLE_HOME/css/mesg/clsssk.msb
clssth.msb --> ORACLE_HOME/css/mesg/clssth.msb
clsstr.msb --> ORACLE_HOME/css/mesg/clsstr.msb
clssus.msb --> ORACLE_HOME/css/mesg/clssus.msb
clssus.msg --> ORACLE_HOME/css/mesg/clssus.msg
clsszhs.msb --> ORACLE_HOME/css/mesg/clsszhs.msb
clsszht.msb --> ORACLE_HOME/css/mesg/clsszht.msb
clsdar.msb --> ORACLE_HOME/has/mesg/clsdar.msb
clsdcs.msb --> ORACLE_HOME/has/mesg/clsdcs.msb
clsdd.msb --> ORACLE_HOME/has/mesg/clsdd.msb
clsddk.msb --> ORACLE_HOME/has/mesg/clsddk.msb
clsde.msb --> ORACLE_HOME/has/mesg/clsde.msb
clsdel.msb --> ORACLE_HOME/has/mesg/clsdel.msb
clsdf.msb --> ORACLE_HOME/has/mesg/clsdf.msb
clsdhu.msb --> ORACLE_HOME/has/mesg/clsdhu.msb
clsdi.msb --> ORACLE_HOME/has/mesg/clsdi.msb
clsdiw.msb --> ORACLE_HOME/has/mesg/clsdiw.msb
clsdja.msb --> ORACLE_HOME/has/mesg/clsdja.msb
clsdko.msb --> ORACLE_HOME/has/mesg/clsdko.msb
clsdn.msb --> ORACLE_HOME/has/mesg/clsdn.msb
clsdnl.msb --> ORACLE_HOME/has/mesg/clsdnl.msb
clsdpl.msb --> ORACLE_HOME/has/mesg/clsdpl.msb
clsdpt.msb --> ORACLE_HOME/has/mesg/clsdpt.msb
clsdptb.msb --> ORACLE_HOME/has/mesg/clsdptb.msb
clsdro.msb --> ORACLE_HOME/has/mesg/clsdro.msb
clsdru.msb --> ORACLE_HOME/has/mesg/clsdru.msb
clsds.msb --> ORACLE_HOME/has/mesg/clsds.msb
clsdsf.msb --> ORACLE_HOME/has/mesg/clsdsf.msb
clsdsk.msb --> ORACLE_HOME/has/mesg/clsdsk.msb
clsdth.msb --> ORACLE_HOME/has/mesg/clsdth.msb
clsdtr.msb --> ORACLE_HOME/has/mesg/clsdtr.msb
clsdus.msb --> ORACLE_HOME/has/mesg/clsdus.msb
clsdus.msg --> ORACLE_HOME/has/mesg/clsdus.msg
clsdzhs.msb --> ORACLE_HOME/has/mesg/clsdzhs.msb
clsdzht.msb --> ORACLE_HOME/has/mesg/clsdzht.msb
clstar.msb --> ORACLE_HOME/has/mesg/clstar.msb
clstcs.msb --> ORACLE_HOME/has/mesg/clstcs.msb
clstd.msb --> ORACLE_HOME/has/mesg/clstd.msb
clstdk.msb --> ORACLE_HOME/has/mesg/clstdk.msb
clste.msb --> ORACLE_HOME/has/mesg/clste.msb
clstel.msb --> ORACLE_HOME/has/mesg/clstel.msb
clstf.msb --> ORACLE_HOME/has/mesg/clstf.msb
clsthu.msb --> ORACLE_HOME/has/mesg/clsthu.msb
clsti.msb --> ORACLE_HOME/has/mesg/clsti.msb
clstiw.msb --> ORACLE_HOME/has/mesg/clstiw.msb
clstja.msb --> ORACLE_HOME/has/mesg/clstja.msb
clstko.msb --> ORACLE_HOME/has/mesg/clstko.msb
clstn.msb --> ORACLE_HOME/has/mesg/clstn.msb
clstnl.msb --> ORACLE_HOME/has/mesg/clstnl.msb
clstpl.msb --> ORACLE_HOME/has/mesg/clstpl.msb
clstpt.msb --> ORACLE_HOME/has/mesg/clstpt.msb
clstptb.msb --> ORACLE_HOME/has/mesg/clstptb.msb
clstro.msb --> ORACLE_HOME/has/mesg/clstro.msb
clstru.msb --> ORACLE_HOME/has/mesg/clstru.msb
clsts.msb --> ORACLE_HOME/has/mesg/clsts.msb
clstsf.msb --> ORACLE_HOME/has/mesg/clstsf.msb
clstsk.msb --> ORACLE_HOME/has/mesg/clstsk.msb
clstth.msb --> ORACLE_HOME/has/mesg/clstth.msb
clsttr.msb --> ORACLE_HOME/has/mesg/clsttr.msb
clstus.msb --> ORACLE_HOME/has/mesg/clstus.msb
clstus.msg --> ORACLE_HOME/has/mesg/clstus.msg
clstzhs.msb --> ORACLE_HOME/has/mesg/clstzhs.msb
clstzht.msb --> ORACLE_HOME/has/mesg/clstzht.msb
rootlocaladd.sh --> ORACLE_HOME/install/rootlocaladd.sh
srvm.jar --> ORACLE_HOME/jlib/srvm.jar
srvmasm.jar --> ORACLE_HOME/jlib/srvmasm.jar
srvmhas.jar --> ORACLE_HOME/jlib/srvmhas.jar
libclsr10.a --> ORACLE_HOME/lib/libclsr10.a
libclsra10.so --> ORACLE_HOME/lib/libclsra10.so
libcxaguard.so.5 --> ORACLE_HOME/lib/libcxaguard.so.5
libdbcfg10.a --> ORACLE_HOME/lib/libdbcfg10.a
libdbcfg10.so --> ORACLE_HOME/lib/libdbcfg10.so
libhasgen10.so --> ORACLE_HOME/lib/libhasgen10.so
libocr10.a --> ORACLE_HOME/lib/libocr10.a
libocr10.so --> ORACLE_HOME/lib/libocr10.so
libocrb10.a --> ORACLE_HOME/lib/libocrb10.a
libocrb10.so --> ORACLE_HOME/lib/libocrb10.so
libocrutl10.a --> ORACLE_HOME/lib/libocrutl10.a
libocrutl10.so --> ORACLE_HOME/lib/libocrutl10.so
liboevm.a --> ORACLE_HOME/lib/liboevm.a
libsrvm10.so --> ORACLE_HOME/lib/libsrvm10.so
libsrvmhas10.so --> ORACLE_HOME/lib/libsrvmhas10.so
libsrvmocr10.so --> ORACLE_HOME/lib/libsrvmocr10.so
libuini10.a --> ORACLE_HOME/lib/libuini10.a
libuini10.so --> ORACLE_HOME/lib/libuini10.so
libclsr10.a --> ORACLE_HOME/lib32/libclsr10.a
libclsra10.so --> ORACLE_HOME/lib32/libclsra10.so
libdbcfg10.a --> ORACLE_HOME/lib32/libdbcfg10.a
libdbcfg10.so --> ORACLE_HOME/lib32/libdbcfg10.so
libhasgen10.so --> ORACLE_HOME/lib32/libhasgen10.so
libocr10.a --> ORACLE_HOME/lib32/libocr10.a
libocr10.so --> ORACLE_HOME/lib32/libocr10.so
libocrb10.a --> ORACLE_HOME/lib32/libocrb10.a
libocrb10.so --> ORACLE_HOME/lib32/libocrb10.so
libocrutl10.a --> ORACLE_HOME/lib32/libocrutl10.a
libocrutl10.so --> ORACLE_HOME/lib32/libocrutl10.so
liboevm.a --> ORACLE_HOME/lib32/liboevm.a
libsrvm10.so --> ORACLE_HOME/lib32/libsrvm10.so
libsrvmhas10.so --> ORACLE_HOME/lib32/libsrvmhas10.so
libsrvmocr10.so --> ORACLE_HOME/lib32/libsrvmocr10.so
libuini10.a --> ORACLE_HOME/lib32/libuini10.a
libuini10.so --> ORACLE_HOME/lib32/libuini10.so
ins_has.mk --> ORACLE_HOME/racg/lib/ins_has.mk
s0clsrdmai.o --> ORACLE_HOME/racg/lib/s0clsrdmai.o
s0clsreut.o --> ORACLE_HOME/racg/lib/s0clsreut.o
s0clsrmain.o --> ORACLE_HOME/racg/lib/s0clsrmain.o
s0clsrmdb.o --> ORACLE_HOME/racg/lib/s0clsrmdb.o
ins_has.mk --> ORACLE_HOME/racg/lib32/ins_has.mk
s0clsrdmai.o --> ORACLE_HOME/racg/lib32/s0clsrdmai.o
s0clsreut.o --> ORACLE_HOME/racg/lib32/s0clsreut.o
s0clsrmain.o --> ORACLE_HOME/racg/lib32/s0clsrmain.o
s0clsrmdb.o --> ORACLE_HOME/racg/lib32/s0clsrmdb.o
clsrar.msb --> ORACLE_HOME/racg/mesg/clsrar.msb
clsrcs.msb --> ORACLE_HOME/racg/mesg/clsrcs.msb
clsrd.msb --> ORACLE_HOME/racg/mesg/clsrd.msb
clsrdk.msb --> ORACLE_HOME/racg/mesg/clsrdk.msb
clsre.msb --> ORACLE_HOME/racg/mesg/clsre.msb
clsrel.msb --> ORACLE_HOME/racg/mesg/clsrel.msb
clsrf.msb --> ORACLE_HOME/racg/mesg/clsrf.msb
clsrhu.msb --> ORACLE_HOME/racg/mesg/clsrhu.msb
clsri.msb --> ORACLE_HOME/racg/mesg/clsri.msb
clsriw.msb --> ORACLE_HOME/racg/mesg/clsriw.msb
clsrja.msb --> ORACLE_HOME/racg/mesg/clsrja.msb
clsrko.msb --> ORACLE_HOME/racg/mesg/clsrko.msb
clsrn.msb --> ORACLE_HOME/racg/mesg/clsrn.msb
clsrnl.msb --> ORACLE_HOME/racg/mesg/clsrnl.msb
clsrpl.msb --> ORACLE_HOME/racg/mesg/clsrpl.msb
clsrpt.msb --> ORACLE_HOME/racg/mesg/clsrpt.msb
clsrptb.msb --> ORACLE_HOME/racg/mesg/clsrptb.msb
clsrro.msb --> ORACLE_HOME/racg/mesg/clsrro.msb
clsrru.msb --> ORACLE_HOME/racg/mesg/clsrru.msb
clsrs.msb --> ORACLE_HOME/racg/mesg/clsrs.msb
clsrsf.msb --> ORACLE_HOME/racg/mesg/clsrsf.msb
clsrsk.msb --> ORACLE_HOME/racg/mesg/clsrsk.msb
clsrth.msb --> ORACLE_HOME/racg/mesg/clsrth.msb
clsrtr.msb --> ORACLE_HOME/racg/mesg/clsrtr.msb
clsrus.msb --> ORACLE_HOME/racg/mesg/clsrus.msb
clsrus.msg --> ORACLE_HOME/racg/mesg/clsrus.msg
clsrzhs.msb --> ORACLE_HOME/racg/mesg/clsrzhs.msb
clsrzht.msb --> ORACLE_HOME/racg/mesg/clsrzht.msb
README_srvm.txt --> ORACLE_HOME/relnotes/README_srvm.txt
ocrlog.ini --> ORACLE_HOME/srvm/admin/ocrlog.ini
README.doc --> ORACLE_HOME/srvm/doc/README.doc
srvctl.jar --> ORACLE_HOME/srvm/jlib/srvctl.jar
vipca.jar --> ORACLE_HOME/srvm/jlib/vipca.jar
env_srvm.mk --> ORACLE_HOME/srvm/lib/env_srvm.mk
ins_srvm.mk --> ORACLE_HOME/srvm/lib/ins_srvm.mk
libsrvm10.a --> ORACLE_HOME/srvm/lib/libsrvm10.a
libsrvmhas10.a --> ORACLE_HOME/srvm/lib/libsrvmhas10.a
libsrvmocr10.a --> ORACLE_HOME/srvm/lib/libsrvmocr10.a
prifcg.o --> ORACLE_HOME/srvm/lib/prifcg.o
prifcmn.o --> ORACLE_HOME/srvm/lib/prifcmn.o
prifutl.o --> ORACLE_HOME/srvm/lib/prifutl.o
prot.o --> ORACLE_HOME/srvm/lib/prot.o
protchek.o --> ORACLE_HOME/srvm/lib/protchek.o
protconf.o --> ORACLE_HOME/srvm/lib/protconf.o
protdump.o --> ORACLE_HOME/srvm/lib/protdump.o
prraw.o --> ORACLE_HOME/srvm/lib/prraw.o
sprdbgrp.o --> ORACLE_HOME/srvm/lib/sprdbgrp.o
sprifcg.o --> ORACLE_HOME/srvm/lib/sprifcg.o
sprotc.o --> ORACLE_HOME/srvm/lib/sprotc.o
sprotch.o --> ORACLE_HOME/srvm/lib/sprotch.o
sprotd.o --> ORACLE_HOME/srvm/lib/sprotd.o
sprraw.o --> ORACLE_HOME/srvm/lib/sprraw.o
env_srvm.mk --> ORACLE_HOME/srvm/lib32/env_srvm.mk
ins_srvm.mk --> ORACLE_HOME/srvm/lib32/ins_srvm.mk
libsrvm10.a --> ORACLE_HOME/srvm/lib32/libsrvm10.a
libsrvmhas10.a --> ORACLE_HOME/srvm/lib32/libsrvmhas10.a
libsrvmocr10.a --> ORACLE_HOME/srvm/lib32/libsrvmocr10.a
prifcg.o --> ORACLE_HOME/srvm/lib32/prifcg.o
prifcmn.o --> ORACLE_HOME/srvm/lib32/prifcmn.o
prifutl.o --> ORACLE_HOME/srvm/lib32/prifutl.o
prot.o --> ORACLE_HOME/srvm/lib32/prot.o
protchek.o --> ORACLE_HOME/srvm/lib32/protchek.o
protconf.o --> ORACLE_HOME/srvm/lib32/protconf.o
protdump.o --> ORACLE_HOME/srvm/lib32/protdump.o
prraw.o --> ORACLE_HOME/srvm/lib32/prraw.o
sprdbgrp.o --> ORACLE_HOME/srvm/lib32/sprdbgrp.o
sprifcg.o --> ORACLE_HOME/srvm/lib32/sprifcg.o
sprotc.o --> ORACLE_HOME/srvm/lib32/sprotc.o
sprotch.o --> ORACLE_HOME/srvm/lib32/sprotch.o
sprotd.o --> ORACLE_HOME/srvm/lib32/sprotd.o
sprraw.o --> ORACLE_HOME/srvm/lib32/sprraw.o
prifd.msb --> ORACLE_HOME/srvm/mesg/prifd.msb
prife.msb --> ORACLE_HOME/srvm/mesg/prife.msb
priff.msb --> ORACLE_HOME/srvm/mesg/priff.msb
prifi.msb --> ORACLE_HOME/srvm/mesg/prifi.msb
prifja.msb --> ORACLE_HOME/srvm/mesg/prifja.msb
prifko.msb --> ORACLE_HOME/srvm/mesg/prifko.msb
prifptb.msb --> ORACLE_HOME/srvm/mesg/prifptb.msb
prifus.msb --> ORACLE_HOME/srvm/mesg/prifus.msb
prifus.msg --> ORACLE_HOME/srvm/mesg/prifus.msg
prifzhs.msb --> ORACLE_HOME/srvm/mesg/prifzhs.msb
prifzht.msb --> ORACLE_HOME/srvm/mesg/prifzht.msb
procd.msb --> ORACLE_HOME/srvm/mesg/procd.msb
proce.msb --> ORACLE_HOME/srvm/mesg/proce.msb
procf.msb --> ORACLE_HOME/srvm/mesg/procf.msb
proci.msb --> ORACLE_HOME/srvm/mesg/proci.msb
procja.msb --> ORACLE_HOME/srvm/mesg/procja.msb
procko.msb --> ORACLE_HOME/srvm/mesg/procko.msb
procptb.msb --> ORACLE_HOME/srvm/mesg/procptb.msb
procus.msb --> ORACLE_HOME/srvm/mesg/procus.msb
procus.msg --> ORACLE_HOME/srvm/mesg/procus.msg
proczhs.msb --> ORACLE_HOME/srvm/mesg/proczhs.msb
proczht.msb --> ORACLE_HOME/srvm/mesg/proczht.msb
protd.msb --> ORACLE_HOME/srvm/mesg/protd.msb
prote.msb --> ORACLE_HOME/srvm/mesg/prote.msb
protf.msb --> ORACLE_HOME/srvm/mesg/protf.msb
proti.msb --> ORACLE_HOME/srvm/mesg/proti.msb
protja.msb --> ORACLE_HOME/srvm/mesg/protja.msb
protko.msb --> ORACLE_HOME/srvm/mesg/protko.msb
protptb.msb --> ORACLE_HOME/srvm/mesg/protptb.msb
protus.msb --> ORACLE_HOME/srvm/mesg/protus.msb
protus.msg --> ORACLE_HOME/srvm/mesg/protus.msg
protzhs.msb --> ORACLE_HOME/srvm/mesg/protzhs.msb
protzht.msb --> ORACLE_HOME/srvm/mesg/protzht.msb
rootlocaladd --> ORACLE_HOME/srvm/utl/rootlocaladd
ins_srvm.mk --> ORACLE_HOME/srvm/lib/install
ins_has.mk --> ORACLE_HOME/racg/lib/install
Patch Location in Inventory:
/oracle/product/11.1.0/db_1/inventory/oneoffs/9294403
Patch Location in Storage area:
/oracle/product/11.1.0/db_1/.patch_storage/9294403_Mar_19_2010_18_59_24
Rac system comprising of multiple nodes
Local node = dwdb1
Remote node = dwdb2
--------------------------------------------------------------------------------
OPatch succeeded.
1.1.9 升级DB至10.2.0.4.4 (14:40)
1.1.9.1 升级DB
[oracle@dwdb1 orainst]$ unzip p9352164_DB_PSU_10.2.0.4.4_Linux-x86-64.zip
[oracle@dwdb1 orainst]$ which opatch
/oracle/product/11.1.0/db_1/OPatch/opatch
[oracle@dwdb1 orainst]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9352164
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/product/11.1.0/db_1
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.4.0
OUI location : /oracle/product/11.1.0/db_1/oui
Log file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2014-11-10_12-34-49PM.log
Patch history file: /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@dwdb1 orainst]$ srvctl stop instance -i odsptdb1 -d odsptdb
[oracle@dwdb1 orainst]$
[oracle@dwdb1 orainst]$ srvctl stop nodeapps -n dwdb1
[oracle@dwdb1 orainst]$ srvctl stop asm -n dwdb1
[oracle@dwdb1 orainst]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application OFFLINE OFFLINE
ora....B1.lsnr application OFFLINE OFFLINE
ora.dwdb1.gsd application OFFLINE OFFLINE
ora.dwdb1.ons application OFFLINE OFFLINE
ora.dwdb1.vip application OFFLINE OFFLINE
ora....SM2.asm application ONLINE ONLINE dwdb2
ora....B2.lsnr application ONLINE ONLINE dwdb2
ora.dwdb2.gsd application ONLINE ONLINE dwdb2
ora.dwdb2.ons application ONLINE ONLINE dwdb2
ora.dwdb2.vip application ONLINE ONLINE dwdb2
ora.odsptdb.db application ONLINE ONLINE dwdb1
ora....b1.inst application OFFLINE OFFLINE
ora....b2.inst application ONLINE ONLINE dwdb2
[oracle@dwdb1 orainst]$ cd 9352164
[oracle@dwdb1 9352164]$ opatch apply
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.1.0/db_1
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.4.0
OUI location : /oracle/product/11.1.0/db_1/oui
Log file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2014-11-10_12-38-39PM.log
Patch history file: /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '9352164' to OH '/oracle/product/11.1.0/db_1'
Running prerequisite checks...
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
OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes.
This node is part of an Oracle Real Application Cluster.
Remote nodes: 'dwdb2'
Local node: 'dwdb1'
elease shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/product/11.1.0/db_1')
Is the local system ready for patching? [y|n]
Y
Execution of 'sh /orainst/9352164/custom/scripts/post -apply 9352164 ':
Return Code = 0
The local system has been patched. You can restart Oracle instances on it.
Patching in rolling mode.
The node 'dwdb2' will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on 'dwdb2'.
(Oracle Home = '/oracle/product/11.1.0/db_1')
Is the node ready for patching? [y|n]
此时数据库不要着急回复,把节点一的数据库启起来,节点二的数据库关闭,再回来回复
[oracle@dwdb1 ~]$ crs_start -all
Attempting to start `ora.dwdb1.vip` on member `dwdb1`
Attempting to start `ora.dwdb1.ASM1.asm` on member `dwdb1`
Start of `ora.dwdb1.vip` on member `dwdb1` succeeded.
Attempting to start `ora.dwdb1.LISTENER_DWDB1.lsnr` on member `dwdb1`
Start of `ora.dwdb1.ASM1.asm` on member `dwdb1` succeeded.
Attempting to start `ora.odsptdb.odsptdb1.inst` on member `dwdb1`
Start of `ora.dwdb1.LISTENER_DWDB1.lsnr` on member `dwdb1` succeeded.
Start of `ora.odsptdb.odsptdb1.inst` on member `dwdb1` succeeded.
CRS-1002: Resource 'ora.dwdb1.ons' is already running on member 'dwdb1'
Attempting to start `ora.dwdb1.gsd` on member `dwdb1`
Start of `ora.dwdb1.gsd` on member `dwdb1` succeeded.
CRS-0223: Resource 'ora.dwdb1.ons' has placement error.
[oracle@dwdb1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE dwdb1
ora....B1.lsnr application ONLINE ONLINE dwdb1
ora.dwdb1.gsd application ONLINE ONLINE dwdb1
ora.dwdb1.ons application ONLINE ONLINE dwdb1
ora.dwdb1.vip application ONLINE ONLINE dwdb1
ora....SM2.asm application ONLINE ONLINE dwdb2
ora....B2.lsnr application ONLINE ONLINE dwdb2
ora.dwdb2.gsd application ONLINE ONLINE dwdb2
ora.dwdb2.ons application ONLINE ONLINE dwdb2
ora.dwdb2.vip application ONLINE ONLINE dwdb2
ora.odsptdb.db application ONLINE ONLINE dwdb1
ora....b1.inst application ONLINE ONLINE dwdb1
ora....b2.inst application ONLINE ONLINE dwdb2
[oracle@dwdb2 9294403]$ srvctl stop instance -i odsptdb2 -d odsptdb
[oracle@dwdb2 9294403]$ srvctl stop asm -n dwdb2
[oracle@dwdb2 9294403]$ srvctl stop nodeapps -n dwdb2
[oracle@dwdb2 9294403]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE dwdb1
ora....B1.lsnr application ONLINE ONLINE dwdb1
ora.dwdb1.gsd application ONLINE ONLINE dwdb1
ora.dwdb1.ons application ONLINE ONLINE dwdb1
ora.dwdb1.vip application ONLINE ONLINE dwdb1
ora....SM2.asm application OFFLINE OFFLINE
ora....B2.lsnr application OFFLINE OFFLINE
ora.dwdb2.gsd application OFFLINE OFFLINE
ora.dwdb2.ons application OFFLINE OFFLINE
ora.dwdb2.vip application OFFLINE OFFLINE
ora.odsptdb.db application ONLINE ONLINE dwdb1
ora....b1.inst application ONLINE ONLINE dwdb1
ora....b2.inst application OFFLINE OFFLINE
回到节点二重新执行:
Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'dwdb2'
Apply-related files are:
FP = "/oracle/product/11.1.0/db_1/.patch_storage/9352164_Apr_1_2010_11_33_14/rac/copy_files.txt"
DP = "/oracle/product/11.1.0/db_1/.patch_storage/9352164_Apr_1_2010_11_33_14/rac/copy_dirs.txt"
MP = "/oracle/product/11.1.0/db_1/.patch_storage/9352164_Apr_1_2010_11_33_14/rac/make_cmds.txt"
RC = "/oracle/product/11.1.0/db_1/.patch_storage/9352164_Apr_1_2010_11_33_14/rac/remote_cmds.txt"
…
The node 'dwdb2' has been patched. You can restart Oracle instances on it.
There were relinks on remote nodes. Remember to check the binary size and timestamp on the nodes 'dwdb2' .
The following make commands were invoked on remote nodes:
'cd /oracle/product/11.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iextjob ORACLE_HOME=/oracle/product/11.1.0/db_1
cd /oracle/product/11.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iextjobo ORACLE_HOME=/oracle/product/11.1.0/db_1
cd /oracle/product/11.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk client_sharedlib ORACLE_HOME=/oracle/product/11.1.0/db_1
cd /oracle/product/11.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk idgmgrl ORACLE_HOME=/oracle/product/11.1.0/db_1
cd /oracle/product/11.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/oracle/product/11.1.0/db_1
cd /oracle/product/11.1.0/db_1/network/lib; /usr/bin/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=/oracle/product/11.1.0/db_1
cd /oracle/product/11.1.0/db_1/network/lib; /usr/bin/make -f ins_net_server.mk itnslsnr ORACLE_HOME=/oracle/product/11.1.0/db_1
cd /oracle/product/11.1.0/db_1/plsql/lib; /usr/bin/make -f ins_plsql.mk iwrap ORACLE_HOME=/oracle/product/11.1.0/db_1
cd /oracle/product/11.1.0/db_1/sqlplus/lib; /usr/bin/make -f ins_sqlplus.mk genplusso ORACLE_HOME=/oracle/product/11.1.0/db_1
'
OPatch succeeded.
[oracle@dwdb1 9352164]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE dwdb1
ora....B1.lsnr application ONLINE ONLINE dwdb1
ora.dwdb1.gsd application ONLINE ONLINE dwdb1
ora.dwdb1.ons application ONLINE ONLINE dwdb1
ora.dwdb1.vip application ONLINE ONLINE dwdb1
ora....SM2.asm application OFFLINE OFFLINE
ora....B2.lsnr application OFFLINE OFFLINE
ora.dwdb2.gsd application OFFLINE OFFLINE
ora.dwdb2.ons application OFFLINE OFFLINE
ora.dwdb2.vip application OFFLINE OFFLINE
ora.odsptdb.db application ONLINE ONLINE dwdb1
ora....b1.inst application ONLINE ONLINE dwdb1
ora....b2.inst application OFFLINE OFFLINE
[oracle@dwdb1 9352164]$ crs_start -all
Attempting to start `ora.dwdb2.ASM2.asm` on member `dwdb2`
Attempting to start `ora.dwdb2.vip` on member `dwdb2`
Start of `ora.dwdb2.vip` on member `dwdb2` succeeded.
Attempting to start `ora.dwdb2.LISTENER_DWDB2.lsnr` on member `dwdb2`
Start of `ora.dwdb2.ASM2.asm` on member `dwdb2` succeeded.
Attempting to start `ora.odsptdb.odsptdb2.inst` on member `dwdb2`
Start of `ora.dwdb2.LISTENER_DWDB2.lsnr` on member `dwdb2` succeeded.
Start of `ora.odsptdb.odsptdb2.inst` on member `dwdb2` succeeded.
CRS-1002: Resource 'ora.dwdb2.ons' is already running on member 'dwdb2'
Attempting to start `ora.dwdb2.gsd` on member `dwdb2`
Start of `ora.dwdb2.gsd` on member `dwdb2` succeeded.
CRS-0223: Resource 'ora.dwdb2.ons' has placement error.
[oracle@dwdb1 9352164]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE dwdb1
ora....B1.lsnr application ONLINE ONLINE dwdb1
ora.dwdb1.gsd application ONLINE ONLINE dwdb1
ora.dwdb1.ons application ONLINE ONLINE dwdb1
ora.dwdb1.vip application ONLINE ONLINE dwdb1
ora....SM2.asm application ONLINE ONLINE dwdb2
ora....B2.lsnr application ONLINE ONLINE dwdb2
ora.dwdb2.gsd application ONLINE ONLINE dwdb2
ora.dwdb2.ons application ONLINE ONLINE dwdb2
ora.dwdb2.vip application ONLINE ONLINE dwdb2
ora.odsptdb.db application ONLINE ONLINE dwdb1
ora....b1.inst application ONLINE ONLINE dwdb1
ora....b2.inst application ONLINE ONLINE dwdb2
1.1.9.2 升级数据字典
升级数据字典
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
@catbundle.sql psu apply
@utlrp.sql
[oracle@dwdb1 ~]$ cd $ORACLE_HOME/cfgtoollogs/catbundle
[oracle@dwdb1 catbundle]$ ls -lrt
total 0
如果有报错,会在该目录下生成文件
1.1.9.3 重编译对象
这一步骤必须停机,STARTUP UPGRADE方式启动,单台节点操作即可。
[oracle@dwdb1 admin]$ cd $ORACLE_HOME/cpu/view_recompile
[oracle@dwdb1 view_recompile]$
[oracle@dwdb1 view_recompile]$ ls -lrt
total 12
-rwxr-xr-x 1 oracle oinstall 5143 Apr 2 2010 view_recompile_jan2008cpu.sql
-rwxr-xr-x 1 oracle oinstall 2095 Apr 2 2010 recompile_precheck_jan2008cpu.sql
[oracle@dwdb1 9352164]$ srvctl stop database -d odsptdb
17:30
cd $ORACLE_HOME/cpu/view_recompile
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP NOMOUNT
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
SQL> SHUTDOWN
SQL> STARTUP UPGRADE
SQL> @view_recompile_jan2008cpu.sql
SQL> @?/rdbms/admin/utlrp.sql
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;
SQL> SHUTDOWN;
SQL> STARTUP NOMOUNT;
Commit complete.
No. of Invalid Objects is :48
Please refer to README.html to for instructions on validating these objects
…
SQL> @?/rdbms/admin/utlrp.sql
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2014-11-10 13:51:22
SQL> select * from dba_objects where object_id=48;
OWNER OBJECT_NAME
------------------------------ --------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SYS I_CON1
48 48 INDEX
05-NOV-14 05-NOV-14 2014-11-05:13:03:24 VALID N N N
失效的对象可以重新跟ultrp.sql脚本来重编译
或
SQL> alterpackage schemaname.packagename compile;
- 【简单的案例分享,停机10分钟】10204升级CRS&DB的PSU至102044
- domino升级不停机或尽量短时间停机升级的技术评估
- Oracle10.2.0.1RAC 升级 Oracle10.2.0.5案例分享 -CRS篇
- 10gRAC在安装了DB的情况下重建CRS
- Oracle11.2.0.4.5升级psu至11.2.0.4.160119的注意事项
- Oracle11g安装GI PSU时失败一案例的解决方法
- 不停机升级ORACLE数据库的方法简介
- Oracle PSU升级 细节引起的报错
- Oracle 10g升级之--PSU升级
- 升级迁移案例分享
- 停机问题的理解
- rocketmq的优雅停机
- STM8的停机模式
- 【PSU升级】Oracle_RAC10.2.0.1到10.2.0.5.9的详细升级过程(一)
- 【PSU升级】Oracle_RAC10.2.0.1到10.2.0.5.9的详细升级过程(二)
- 【PSU升级】Oracle_RAC10.2.0.1到10.2.0.5.9的详细升级过程(三)
- Oracle 10g升级PSU (p9352164)
- Hbuider制作app升级包的简单办法 (升级官方提供的案例)
- WhatsApp CEO向FreeBSD捐赠一百万美金
- 第十二周项目1-3:递归函数
- 如果选错云服务商,后果很严重……
- JPA简介
- 第12周 项目2-2 输出各位数
- 【简单的案例分享,停机10分钟】10204升级CRS&DB的PSU至102044
- 中文用户Xterm中文显示
- 关于onActivtyResult方法的data形参返回null或未被调用的问题
- 如何去掉从数据库中读出的带有html标签的字符串,并是标签起效,显示在前台页面
- PHP学习之在mac下配置php环境(引用其他文章)
- 第十二周项目二——盘子
- 二叉树遍历 小讲
- 用 gdb 调试 GCC 程序
- MS-windows下的Gvim进入块可视模式