Opatch apply show error msg
sfcstb2:/apps/oracle/product/10.2.0/OPatch$ ./opatch apply ./4637902
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /apps/oracle/product/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /apps/oracle/product/10.2.0/oui
Log file location : /apps/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2013-04-16_10-30-41AM.log
ApplySession applying interim patch '4637902' to OH '/apps/oracle/product/10.2.0'
List of Homes on this system:
Home name= clusterware10g, Location= "/apps/oracle/product/clusterware10g"
OPatchSession cannot load inventory for the given Oracle Home /apps/oracle/product/10.2.0. Possible causes are:
No read or write permission to ORACLE_HOME/.patch_storage
Central Inventory is locked by another OUI instance
No read permission to Central Inventory
The lock file exists in ORACLE_HOME/.patch_storage
The Oracle Home does not exist in Central Inventory
ApplySession failed: ApplySession failed to prepare the system. OracleHomeInventory gets null oracleHomeInfo
System intact, OPatch will not attempt to restore the system
OPatch failed with error code 73
No read or write permission to ORACLE_HOME/.patch_storage ?
Not match
sfcstb2:/apps/oracle/product/10.2.0/.patch_storage$ ls -lrt
total 0
drwxr-xr-x 4 oracle oinstall 96 Apr 12 17:02 4637902_Jul_29_2008_23_48_02
-rw-r--r-- 1 oracle oinstall 0 Apr 16 10:30 patch_free
sfcstb2:/apps/oracle/product/10.2.0/.patch_storage$
No read permission to Central Inventory
Not match
Central Inventory : /apps/oracle/oraInventory
sfcstb2:/apps/oracle$ ls -lrt
total 1642112
-rw-r--r-- 1 oracle oinstall 840751341 Feb 2 2009 10gr2_clusterware_hpi.zip
drwxrwxrwx 4 oracle oinstall 96 Aug 4 2010 product
drwxrwxrwx 4 oracle oinstall 96 Aug 10 2010 admin
drwxr-xr-x 7 oracle oinstall 1024 Apr 15 09:44 oraInventory
sfcstb2:/apps/oracle$
The lock file exists in ORACLE_HOME/.patch_storage
Don’t exist
sfcstb2:/apps/oracle/product/10.2.0/.patch_storage$ ls -lrt
total 0
drwxr-xr-x 4 oracle oinstall 96 Apr 12 17:02 4637902_Jul_29_2008_23_48_02
-rw-r--r-- 1 oracle oinstall 0 Apr 16 10:30 patch_free
The Oracle Home does not exist in Central Inventory
Central Inventory : /apps/oracle/oraInventory
Solution:
cd $ORACLE_HOME/oui/bin
./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/apps/oracle/product/10.2.0" ORACLE_HOME_NAME="OraDb10g_home1" LOCAL_NODE="sfcstb2"
CLUSTER_NODES="{sfcstb1,sfcstb2}"
sfcstb2:/apps/oracle/oraInventory/ContentsXML$ cd $ORACLE_HOME/oui/bin
sfcstb2:/apps/oracle/product/10.2.0/oui/bin$
sfcstb2:/apps/oracle/product/10.2.0/oui/bin$
sfcstb2:/apps/oracle/product/10.2.0/oui/bin$ ls
addLangs.sh attachHome.sh lsnodes ouica.sh runConfig.sh runInstaller.sh
addNode.sh detachHome.sh ouica.bat resource runInstaller
sfcstb2:/apps/oracle/product/10.2.0/oui/bin$ E="OraDb10g_home1" LOCAL_NODE="sfcstb2" CLUSTER_NODES="{sfcstb1,sfcstb2}" <
Starting Oracle Universal Installer...
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
>>> Ignoring required pre-requisite failures. Continuing...
The inventory pointer is located at /var/opt/oracle/oraInst.loc
The inventory is located at /apps/oracle/oraInventory
'AttachHome' was successful.
sfcstb2:/apps/oracle/product/10.2.0/oui/bin$
sfcstb2:/apps/oracle/product/10.2.0/OPatch$ ./opatch lsinventory -all
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /apps/oracle/product/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /apps/oracle/product/10.2.0/oui
Log file location : /apps/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2013-04-22_14-02-25PM.log
Lsinventory Output file location : /apps/oracle/product/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2013-04-22_14-02-25PM.txt
--------------------------------------------------------------------------------
List of Oracle Homes:
Name Location
clusterware10g /apps/oracle/product/clusterware10g
OraDb10g_home1 /apps/oracle/product/10.2.0
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.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = sfcstb2
Remote node = sfcstb1
--------------------------------------------------------------------------------
OPatch succeeded.
sfcstb2:/apps/oracle/product/10.2.0/OPatch$
sfcstb2:/apps/oracle/product/10.2.0/OPatch$ ./opatch apply ./4637902
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /apps/oracle/product/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /apps/oracle/product/10.2.0/oui
Log file location : /apps/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2013-04-22_14-02-48PM.log
ApplySession applying interim patch '4637902' to OH '/apps/oracle/product/10.2.0'
Running prerequisite checks...
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: 'sfcstb1'
Local node: 'sfcstb2'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/apps/oracle/product/10.2.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '4637902' for restore. This might take a while...
*******************************************************************************************
Oracle Configuration Manager is installed but not configured. OCM enables Oracle to
provide superior, proactive support for our customers. Oracle strongly recommends customers
configure OCM. To complete the configuration of OCM, refer to the OCM Installation and
Administration Guide (http://www.oracle.com/technology/documentation/ocm.html).
*******************************************************************************************
Backing up files affected by the patch '4637902' for rollback. This might take a while...
Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/apps/oracle/product/10.2.0/lib/libserver10.a" with "lib/libserver10.a/kcl.o"
Running make for target ioracle
ApplySession adding interim patch '4637902' to inventory
Verifying the update...
Inventory check OK: Patch ID 4637902 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 4637902 are present in Oracle Home.
The local system has been patched. You can restart Oracle instances on it.
Patching in rolling mode.
The node 'sfcstb1' will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on 'sfcstb1'.
(Oracle Home = '/apps/oracle/product/10.2.0')
Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'sfcstb1'
Apply-related files are:
FP = "/apps/oracle/product/10.2.0/.patch_storage/4637902_Jul_29_2008_23_48_02/rac/copy_files.txt"
DP = "/apps/oracle/product/10.2.0/.patch_storage/4637902_Jul_29_2008_23_48_02/rac/copy_dirs.txt"
MP = "/apps/oracle/product/10.2.0/.patch_storage/4637902_Jul_29_2008_23_48_02/rac/make_cmds.txt"
RC = "/apps/oracle/product/10.2.0/.patch_storage/4637902_Jul_29_2008_23_48_02/rac/remote_cmds.txt"
Instantiating the file "/apps/oracle/product/10.2.0/.patch_storage/4637902_Jul_29_2008_23_48_02/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/apps/oracle/product/10.2.0/.patch_storage/4637902_Jul_29_2008_23_48_02/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/apps/oracle/product/10.2.0/.patch_storage/4637902_Jul_29_2008_23_48_02/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/apps/oracle/product/10.2.0/.patch_storage/4637902_Jul_29_2008_23_48_02/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Instantiating the file "/apps/oracle/product/10.2.0/.patch_storage/4637902_Jul_29_2008_23_48_02/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/apps/oracle/product/10.2.0/.patch_storage/4637902_Jul_29_2008_23_48_02/rac/make_cmds.txt" with actual path.
Running command on remote node 'sfcstb1':
cd /apps/oracle/product/10.2.0/rdbms/lib; /usr/ccs/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/apps/oracle/product/10.2.0 || echo REMOTE_MAKE_FAILED::>&2
The node 'sfcstb1' 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 'sfcstb1' .
The following make commands were invoked on remote nodes:
'cd /apps/oracle/product/10.2.0/rdbms/lib; /usr/ccs/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/apps/oracle/product/10.2.0
'
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67294:
*******************************************************************************************
Oracle Configuration Manager is installed but not configured. OCM enables Oracle to
provide superior, proactive support for our customers. Oracle strongly recommends customers
configure OCM. To complete the configuration of OCM, refer to the OCM Installation and
Administration Guide (http://www.oracle.com/technology/documentation/ocm.html).
*******************************************************************************************
--------------------------------------------------------------------------------
OPatch Session completed with warnings.
OPatch completed with warnings.
打补丁时候疏忽没有shutdown sfcstb1导致sfcstb1 无法连接oracle
sfcstb1:/apps/oracle/product/10.2.0/oui/bin$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Apr 22 14:36:37 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ERROR:
ORA-03114: not connected to ORACLE
idle> exit
利用crs_stop 停掉instance 然后重启后OK 所以打补丁时要注意。