--reference
--How to Manually Install and Uninstall XBRL to your XML Database (XDB) [ID 1297384.1]
-- the below has been done in a non-rac database , below this post the steps of RAC follows
-- check for opatch for any applied patch details
[oracle@subhendb-01 logs]$ cd /oracle/app/database/11.2.0.3/dbhome_2/OPatch/
[oracle@subhendb-01 OPatch]$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_2
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_14-35-59PM.log
Lsinventory Output file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2013-03-15_14-35-59PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
-- scp the downloaded XBRL patch to database server [p13347017 for XBRL unzip the patch to the designated folder it would create a folder named XBRLRelease112022]
[oracle@subhendb-01 XBRL]$ ls -ltr
total 8
drwxr-xr-x 2 oracle oinstall 4096 Mar 15 16:24 RDBMS_patch
drwxr-xr-x 2 oracle oinstall 4096 Mar 15 16:24 XBRL_patch
[oracle@subhendb-01 XBRL]$ cd XBRL_patch
[oracle@subhendb-01 XBRL_patch]$ ls -ltr
total 2672
-rw-r--r-- 1 oracle oinstall 2730588 Mar 15 16:06 p13347017_112030_Generic.zip
[oracle@subhendb-01 XBRL_patch]$ unzip -d /oracle/app/PATCH/XBRL/XBRL_patch p13347017_112030_Generic.zip
[oracle@subhendb-01 XBRL_patch]$ ls -ltr
total 2676
drwxr-xr-x 5 oracle oinstall 4096 Feb 11 2012 XBRLRelease112022
-rw-r--r-- 1 oracle oinstall 2730588 Mar 15 16:06 p13347017_112030_Generic.zip
[oracle@subhendb-01 XBRL_patch]$ cd XBRLRelease112022
[oracle@subhendb-01 XBRLRelease112022]$ ls -ltr
total 28
drwxr-xr-x 6 oracle oinstall 4096 Dec 9 2011 xbrl_xdb
-rwxr-xr-x 1 oracle oinstall 12440 Feb 11 2012 README.TXT
drwxr-xr-x 3 oracle oinstall 4096 Feb 11 2012 files
drwxr-xr-x 4 oracle oinstall 4096 Feb 11 2012 etc
-- download the downloaded RDBMs patch to database server [p11883969 for RDBMS and unzip it]
[oracle@subhendb-01 XBRL]$ cd RDBMS_patch/
[oracle@subhendb-01 RDBMS_patch]$ ls -ltr
total 604
-rw-r--r-- 1 oracle oinstall 612229 Mar 15 16:00 p11883969_112030_Linux-x86-64.zip
[oracle@subhendb-01 RDBMS_patch]$ pwd
/oracle/app/PATCH/XBRL/RDBMS_patch
[oracle@subhendb-01 RDBMS_patch]$ unzip -d /oracle/app/PATCH/XBRL/RDBMS_patch p11883969_112030_Linux-x86-64.zip
[oracle@subhendb-01 RDBMS_patch]$ ls -ltr
total 608
drwxrwxr-x 4 oracle oinstall 4096 Dec 17 2011 11883969
-rw-r--r-- 1 oracle oinstall 612229 Mar 15 16:00 p11883969_112030_Linux-x86-64.zip
[oracle@subhendb-01 RDBMS_patch]$ cd 11883969/
[oracle@subhendb-01 11883969]$ ls -ltr
total 16
-rw-rw-r-- 1 oracle oinstall 4433 Dec 17 2011 README.txt
drwxr-xr-x 3 oracle oinstall 4096 Dec 17 2011 files
drwxr-xr-x 4 oracle oinstall 4096 Dec 17 2011 etc
-- proceed for RDBMS patch apply stop all services(databases and listeners) runnning out of the ORACLE_HOME alternatively stop ORACLE_HOME
[oracle@subhendb-01 11883969]$ export PATH=$PATH:/oracle/app/database/11.2.0.3/dbhome_2/OPatch
[oracle@subhendb-01 11883969]$ echo $PATH
/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/oracle/app/database/11.2.0.3/dbhome_2/bin:/oracle/app/database/11.2.0.3/dbhome_2/OPatch
[oracle@subhendb-01 11883969]$ pwd
/oracle/app/PATCH/XBRL/RDBMS_patch/11883969
[oracle@subhendb-01 11883969]$ opatch apply
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_2
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-25-31PM.log
Applying interim patch '11883969' to OH '/oracle/app/database/11.2.0.3/dbhome_2'
Verifying environment and performing prerequisite checks...
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/database/11.2.0.3/dbhome_2')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Patch 11883969 successfully applied
Log file location: /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-25-31PM.log
OPatch succeeded.
-- check if successfully applied
[oracle@subhendb-01 11883969]$ opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_2
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-27-09PM.log
Lsinventory Output file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2013-03-15_17-27-09PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 11883969 : applied on Fri Mar 15 17:26:34 EST 2013
Unique Patch ID: 14352013
Created on 16 Dec 2011, 12:53:41 hrs PST8PDT
Bugs fixed:
11883969
--------------------------------------------------------------------------------
OPatch succeeded.
-- proceed with XBRL patch apply
[oracle@subhendb-01 ~]$ echo $PATH
/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/oracle/app/database/11.2.0.3/dbhome_2/bin
[oracle@subhendb-01 ~]$ export PATH=$PATH:/oracle/app/database/11.2.0.3/dbhome_2/OPatch/
-- go to the location of the XBRL patch set and apply it
[oracle@subhendb-01 XBRL_patch]$ cd XBRLRelease112022/
[oracle@subhendb-01 XBRLRelease112022]$ ls -ltr
total 44
drwxrwxr-x+ 6 oracle oinstall 4096 Dec 9 2011 xbrl_xdb
-rwxrwxr-x+ 1 oracle oinstall 12440 Feb 11 2012 README.TXT
drwxrwxr-x+ 3 oracle oinstall 4096 Feb 11 2012 files
drwxrwxr-x+ 4 oracle oinstall 4096 Feb 11 2012 etc
[oracle@subhendb-01 XBRLRelease112022]$ opatch apply
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_2
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-47-50PM.log
Applying interim patch '13347017' to OH '/oracle/app/database/11.2.0.3/dbhome_2'
Verifying environment and performing prerequisite checks...
Patch 13347017: Optional component(s) missing : [ oracle.rdbms, 11.2.0.2.0, higher version 11.2.0.3.0 found. ]
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Patch 13347017 successfully applied
Log file location: /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-47-50PM.log
OPatch succeeded.
-- check it for successful apply
[oracle@subhendb-01 XBRLRelease112022]$ opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_2
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-49-30PM.log
Lsinventory Output file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2013-03-15_17-49-30PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 13347017 : applied on Fri Mar 15 17:48:06 EST 2013
Unique Patch ID: 14615728
Created on 10 Feb 2012, 13:10:13 hrs PST8PDT
Bugs fixed:
12388668, 13347017, 10411201
Patch 11883969 : applied on Fri Mar 15 17:26:34 EST 2013
Unique Patch ID: 14352013
Created on 16 Dec 2011, 12:53:41 hrs PST8PDT
Bugs fixed:
11883969
--------------------------------------------------------------------------------
OPatch succeeded.
-- proceed for runnning scripts for XBRL and start the services for the ORACLE_HOME
[oracle@subhendb-01 XBRLRelease112022]$ cd /oracle/app/database/11.2.0.3/dbhome_2/rdbms/xbrl_xdb/XBRLScripts/
[oracle@subhendb-01 XBRLScripts]$ ls -ltr
total 1240
-rw-rwxr--+ 1 oracle oinstall 2093 Feb 11 2012 xbrlurep112021.sql
-rwxrwxr-x+ 1 oracle oinstall 3188 Feb 11 2012 xbrluninstall.sql
-rwxrwxr-x+ 1 oracle oinstall 2031 Feb 11 2012 xbrludpurge.sql
-rw-rwxr--+ 1 oracle oinstall 8664 Feb 11 2012 xbrluddl112021.sql
-rw-rwxr--+ 1 oracle oinstall 4069 Feb 11 2012 xbrlu112021.sql
-rwxrwxr-x+ 1 oracle oinstall 30127 Feb 11 2012 xbrltiview.sql
-rwxrwxr-x+ 1 oracle oinstall 4098 Feb 11 2012 xbrlregschema.sql
-r--rwxr--+ 1 oracle oinstall 1331 Feb 11 2012 xbrlrecidx.sql
-rw-rwxr-x+ 1 oracle oinstall 2569 Feb 11 2012 xbrlrecidxdrv.sql
-rwxrwxr-x+ 1 oracle oinstall 3105 Feb 11 2012 xbrlpurgefile.sql
-rwxrwxr-x+ 1 oracle oinstall 3364 Feb 11 2012 xbrlloaderrmsg.sql
-rwxrwxr-x+ 1 oracle oinstall 7299 Feb 11 2012 xbrlinstall.sql
-rwxrwxr-x+ 1 oracle oinstall 7875 Feb 11 2012 xbrleventhdl.plb
-rwxrwxr-x+ 1 oracle oinstall 922 Feb 11 2012 xbrlerrmsg.sql
-rwxrwxr-x+ 1 oracle oinstall 3802 Feb 11 2012 xbrldrop.sql
-rwxrwxr-x+ 1 oracle oinstall 10287 Feb 11 2012 xbrlddl.sql
-r--rwxr--+ 1 oracle oinstall 28738 Feb 11 2012 xbrlddlindex.sql
-rwxrwxr-x+ 1 oracle oinstall 3950 Feb 11 2012 xbrlcrt.sql
-rwxrwxr-x+ 1 oracle oinstall 922045 Feb 11 2012 xbrlcompins.sql
-rwxrwxr-x+ 1 oracle oinstall 47878 Feb 11 2012 xbrlapi.plb
-rwxrwxr-x+ 1 oracle oinstall 11746 Feb 11 2012 xbrlapi0.plb
-rwxrwxr-x+ 1 oracle oinstall 10934 Feb 11 2012 License.txt
-rwxrwxr-x+ 1 oracle oinstall 2769 Feb 11 2012 InstallXBRLDemo.sql
drwxrwxr-x+ 2 oracle oinstall 4096 Mar 15 17:48 mesg
-- login to database and execute below
SQL> @xbrlinstall.sql Oracle321 xbrlsys sysaux temp true
-- verification
SQL> SELECT OBJECT_NAME FROM USER_OBJECTS
WHERE STATUS = 'VALID' AND OBJECT_TYPE = 'PACKAGE'; 2
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_ORAXBRL_INTERNAL
DBMS_ORAXBRLV
DBMS_ORAXBRLD
DBMS_ORAXBRL_UBM
DBMS_ORAXBRLI
DBMS_ORAXBRLT
DBMS_ORAXBRL
7 rows selected.
SQL> SELECT ANY_PATH FROM RESOURCE_VIEW WHERE ANY_PATH = '/xbrl';
ANY_PATH
--------------------------------------------------------------------------------
/xbrl
1 row selected.
SQL> SELECT INDEX_NAME FROM USER_INDEXES
WHERE INDEX_TYPE = 'FUNCTION-BASED DOMAIN' AND STATUS = 'VALID'; 2
INDEX_NAME
------------------------------
XBRL$SCHEMAIDX
XBRL$INSTANCEIDX
ORA$XBRLCACHEIDX
3 rows selected.
SQL> select object_name, object_type from user_objects
where status!='VALID'; 2
no rows selected
===========================
FOR RAC database
===========================
-- Stop all services running out of the ORACLE_HOME
[oracle@subhen_db01 ~]$ srvctl stop home -o /oracle/app/database/11.2.0.3/dbhome_1 -s /home/oracle/state_file_1 -n subhen_db01 -t IMMEDIATE
-- RDBMS PATCH apply
[oracle@subhen_db01 ~]$ cd /home/oracle/PATCH/XBRL/RDBMS_patch/11883969
[oracle@subhen_db01 11883969]$ ls -ltr
total 16
-rw-rw-r-- 1 oracle oinstall 4433 Dec 17 2011 README.txt
drwxr-xr-x 3 oracle oinstall 4096 Dec 17 2011 files
drwxr-xr-x 4 oracle oinstall 4096 Dec 17 2011 etc
[oracle@subhen_db01 11883969]$ which opatch
/oracle/app/database/11.2.0.3/dbhome_1/OPatch/opatch
[oracle@subhen_db01 11883969]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.2
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/database/11.2.0.3/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.2
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/11883969_Mar_27_2013_17_55_56/apply2013-03-27_17-55-56PM_1.log
Applying interim patch '11883969' to OH '/oracle/app/database/11.2.0.3/dbhome_1'
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/oracle/app/database/11.2.0.3/dbhome_1/bin/oracle
Log file location: /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/11883969_Mar_27_2013_17_55_56/apply2013-03-27_17-55-56PM_1.log
Recommended actions: OPatch needs to modify files which are being used by some processes.
OPatch failed with error code 41
-- here the problem was in a different window i had logged in the same Database host so i closed the putty window and tried opatch again and it was success
-- close all the window except the one you are trying for opatch
-- here the opatch is rolling fashion so after 1st node patch apply done start the ORACLE_HOME in 1st node and stop the ORACLE_HOME in 2nd node continue the same for other remaining nodes also
[oracle@subhen_db01 11883969]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.2
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/database/11.2.0.3/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.2
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/11883969_Mar_27_2013_18_03_40/apply2013-03-27_18-03-40PM_1.log
Applying interim patch '11883969' to OH '/oracle/app/database/11.2.0.3/dbhome_1'
Verifying environment and performing prerequisite checks...
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
This node is part of an Oracle Real Application Cluster.
Remote nodes: 'subhen_db02' 'subhen_db03'
Local node: 'subhen_db01'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/database/11.2.0.3/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Verifying the update...
The local system has been patched. You can restart Oracle instances on it.
Patching in rolling mode.
Remaining nodes to be patched:
'subhen_db02' 'subhen_db03'
What is the next node to be patched?
subhen_db02
You have selected 'subhen_db02' from 'subhen_db02' 'subhen_db03'
The node 'subhen_db02' will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on 'subhen_db02'.
(Oracle Home = '/oracle/app/database/11.2.0.3/dbhome_1')
Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'subhen_db02'
Apply-related files are:
FP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_files.txt"
DP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_dirs.txt"
MP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt"
RC = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/remote_cmds.txt"
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt" with actual path.
Running command on remote node 'subhen_db02':
cd /oracle/app/database/11.2.0.3/dbhome_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/oracle/app/database/11.2.0.3/dbhome_1 || echo REMOTE_MAKE_FAILED::>&2
The node 'subhen_db02' has been patched. You can restart Oracle instances on it.
The node 'subhen_db03' will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on 'subhen_db03'.
(Oracle Home = '/oracle/app/database/11.2.0.3/dbhome_1')
Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'subhen_db03'
Apply-related files are:
FP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_files.txt"
DP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_dirs.txt"
MP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt"
RC = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/remote_cmds.txt"
Propagating files to remote nodes...
Propagating directories to remote nodes...
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt" with actual path.
Running command on remote node 'subhen_db03':
cd /oracle/app/database/11.2.0.3/dbhome_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/oracle/app/database/11.2.0.3/dbhome_1 || echo REMOTE_MAKE_FAILED::>&2
The node 'subhen_db03' 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 'subhen_db02' 'subhen_db03' .
The following make commands were invoked on remote nodes:
'cd /oracle/app/database/11.2.0.3/dbhome_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/oracle/app/database/11.2.0.3/dbhome_1
'
Patch 11883969 successfully applied
Log file location: /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/11883969_Mar_27_2013_18_03_40/apply2013-03-27_18-03-40PM_1.log
OPatch succeeded.
[oracle@subhen_db01 11883969]$ sleep 2d
-- XBRL patch apply
[oracle@subhen_db01 XBRLRelease112022]$ pwd
/home/oracle/PATCH/XBRL/XBRL_patch/XBRLRelease112022
[oracle@subhen_db01 XBRLRelease112022]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.2
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/database/11.2.0.3/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.2
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/13347017_Mar_27_2013_19_07_55/apply2013-03-27_19-07-55PM_1.log
Applying interim patch '13347017' to OH '/oracle/app/database/11.2.0.3/dbhome_1'
Verifying environment and performing prerequisite checks...
Patch 13347017: Optional component(s) missing : [ oracle.rdbms, 11.2.0.2.0, higher version 11.2.0.3.0 found. ]
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
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Verifying the update...
Patching in all-node mode.
Updating nodes 'subhen_db02' 'subhen_db03'
Apply-related files are:
FP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_files.txt"
DP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_dirs.txt"
MP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/make_cmds.txt"
RC = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/remote_cmds.txt"
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_files.txt.instantiated" by replacing $ORCLE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_dirs.txt.instantiated" by replacing $ORALE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Patch 13347017 successfully applied
Log file location: /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/13347017_Mar_27_2013_19_07_55/apply2013-03-27_19-07-55PM_1.log
OPatch succeeded.
--How to Manually Install and Uninstall XBRL to your XML Database (XDB) [ID 1297384.1]
-- the below has been done in a non-rac database , below this post the steps of RAC follows
-- check for opatch for any applied patch details
[oracle@subhendb-01 logs]$ cd /oracle/app/database/11.2.0.3/dbhome_2/OPatch/
[oracle@subhendb-01 OPatch]$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_2
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_14-35-59PM.log
Lsinventory Output file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2013-03-15_14-35-59PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
-- scp the downloaded XBRL patch to database server [p13347017 for XBRL unzip the patch to the designated folder it would create a folder named XBRLRelease112022]
[oracle@subhendb-01 XBRL]$ ls -ltr
total 8
drwxr-xr-x 2 oracle oinstall 4096 Mar 15 16:24 RDBMS_patch
drwxr-xr-x 2 oracle oinstall 4096 Mar 15 16:24 XBRL_patch
[oracle@subhendb-01 XBRL]$ cd XBRL_patch
[oracle@subhendb-01 XBRL_patch]$ ls -ltr
total 2672
-rw-r--r-- 1 oracle oinstall 2730588 Mar 15 16:06 p13347017_112030_Generic.zip
[oracle@subhendb-01 XBRL_patch]$ unzip -d /oracle/app/PATCH/XBRL/XBRL_patch p13347017_112030_Generic.zip
[oracle@subhendb-01 XBRL_patch]$ ls -ltr
total 2676
drwxr-xr-x 5 oracle oinstall 4096 Feb 11 2012 XBRLRelease112022
-rw-r--r-- 1 oracle oinstall 2730588 Mar 15 16:06 p13347017_112030_Generic.zip
[oracle@subhendb-01 XBRL_patch]$ cd XBRLRelease112022
[oracle@subhendb-01 XBRLRelease112022]$ ls -ltr
total 28
drwxr-xr-x 6 oracle oinstall 4096 Dec 9 2011 xbrl_xdb
-rwxr-xr-x 1 oracle oinstall 12440 Feb 11 2012 README.TXT
drwxr-xr-x 3 oracle oinstall 4096 Feb 11 2012 files
drwxr-xr-x 4 oracle oinstall 4096 Feb 11 2012 etc
-- download the downloaded RDBMs patch to database server [p11883969 for RDBMS and unzip it]
[oracle@subhendb-01 XBRL]$ cd RDBMS_patch/
[oracle@subhendb-01 RDBMS_patch]$ ls -ltr
total 604
-rw-r--r-- 1 oracle oinstall 612229 Mar 15 16:00 p11883969_112030_Linux-x86-64.zip
[oracle@subhendb-01 RDBMS_patch]$ pwd
/oracle/app/PATCH/XBRL/RDBMS_patch
[oracle@subhendb-01 RDBMS_patch]$ unzip -d /oracle/app/PATCH/XBRL/RDBMS_patch p11883969_112030_Linux-x86-64.zip
[oracle@subhendb-01 RDBMS_patch]$ ls -ltr
total 608
drwxrwxr-x 4 oracle oinstall 4096 Dec 17 2011 11883969
-rw-r--r-- 1 oracle oinstall 612229 Mar 15 16:00 p11883969_112030_Linux-x86-64.zip
[oracle@subhendb-01 RDBMS_patch]$ cd 11883969/
[oracle@subhendb-01 11883969]$ ls -ltr
total 16
-rw-rw-r-- 1 oracle oinstall 4433 Dec 17 2011 README.txt
drwxr-xr-x 3 oracle oinstall 4096 Dec 17 2011 files
drwxr-xr-x 4 oracle oinstall 4096 Dec 17 2011 etc
-- proceed for RDBMS patch apply stop all services(databases and listeners) runnning out of the ORACLE_HOME alternatively stop ORACLE_HOME
[oracle@subhendb-01 11883969]$ export PATH=$PATH:/oracle/app/database/11.2.0.3/dbhome_2/OPatch
[oracle@subhendb-01 11883969]$ echo $PATH
/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/oracle/app/database/11.2.0.3/dbhome_2/bin:/oracle/app/database/11.2.0.3/dbhome_2/OPatch
[oracle@subhendb-01 11883969]$ pwd
/oracle/app/PATCH/XBRL/RDBMS_patch/11883969
[oracle@subhendb-01 11883969]$ opatch apply
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_2
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-25-31PM.log
Applying interim patch '11883969' to OH '/oracle/app/database/11.2.0.3/dbhome_2'
Verifying environment and performing prerequisite checks...
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/database/11.2.0.3/dbhome_2')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Patch 11883969 successfully applied
Log file location: /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-25-31PM.log
OPatch succeeded.
-- check if successfully applied
[oracle@subhendb-01 11883969]$ opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_2
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-27-09PM.log
Lsinventory Output file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2013-03-15_17-27-09PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 11883969 : applied on Fri Mar 15 17:26:34 EST 2013
Unique Patch ID: 14352013
Created on 16 Dec 2011, 12:53:41 hrs PST8PDT
Bugs fixed:
11883969
--------------------------------------------------------------------------------
OPatch succeeded.
-- proceed with XBRL patch apply
[oracle@subhendb-01 ~]$ echo $PATH
/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/oracle/app/database/11.2.0.3/dbhome_2/bin
[oracle@subhendb-01 ~]$ export PATH=$PATH:/oracle/app/database/11.2.0.3/dbhome_2/OPatch/
-- go to the location of the XBRL patch set and apply it
[oracle@subhendb-01 XBRL_patch]$ cd XBRLRelease112022/
[oracle@subhendb-01 XBRLRelease112022]$ ls -ltr
total 44
drwxrwxr-x+ 6 oracle oinstall 4096 Dec 9 2011 xbrl_xdb
-rwxrwxr-x+ 1 oracle oinstall 12440 Feb 11 2012 README.TXT
drwxrwxr-x+ 3 oracle oinstall 4096 Feb 11 2012 files
drwxrwxr-x+ 4 oracle oinstall 4096 Feb 11 2012 etc
[oracle@subhendb-01 XBRLRelease112022]$ opatch apply
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_2
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-47-50PM.log
Applying interim patch '13347017' to OH '/oracle/app/database/11.2.0.3/dbhome_2'
Verifying environment and performing prerequisite checks...
Patch 13347017: Optional component(s) missing : [ oracle.rdbms, 11.2.0.2.0, higher version 11.2.0.3.0 found. ]
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Patch 13347017 successfully applied
Log file location: /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-47-50PM.log
OPatch succeeded.
-- check it for successful apply
[oracle@subhendb-01 XBRLRelease112022]$ opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_2
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/opatch2013-03-15_17-49-30PM.log
Lsinventory Output file location : /oracle/app/database/11.2.0.3/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2013-03-15_17-49-30PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 13347017 : applied on Fri Mar 15 17:48:06 EST 2013
Unique Patch ID: 14615728
Created on 10 Feb 2012, 13:10:13 hrs PST8PDT
Bugs fixed:
12388668, 13347017, 10411201
Patch 11883969 : applied on Fri Mar 15 17:26:34 EST 2013
Unique Patch ID: 14352013
Created on 16 Dec 2011, 12:53:41 hrs PST8PDT
Bugs fixed:
11883969
--------------------------------------------------------------------------------
OPatch succeeded.
-- proceed for runnning scripts for XBRL and start the services for the ORACLE_HOME
[oracle@subhendb-01 XBRLRelease112022]$ cd /oracle/app/database/11.2.0.3/dbhome_2/rdbms/xbrl_xdb/XBRLScripts/
[oracle@subhendb-01 XBRLScripts]$ ls -ltr
total 1240
-rw-rwxr--+ 1 oracle oinstall 2093 Feb 11 2012 xbrlurep112021.sql
-rwxrwxr-x+ 1 oracle oinstall 3188 Feb 11 2012 xbrluninstall.sql
-rwxrwxr-x+ 1 oracle oinstall 2031 Feb 11 2012 xbrludpurge.sql
-rw-rwxr--+ 1 oracle oinstall 8664 Feb 11 2012 xbrluddl112021.sql
-rw-rwxr--+ 1 oracle oinstall 4069 Feb 11 2012 xbrlu112021.sql
-rwxrwxr-x+ 1 oracle oinstall 30127 Feb 11 2012 xbrltiview.sql
-rwxrwxr-x+ 1 oracle oinstall 4098 Feb 11 2012 xbrlregschema.sql
-r--rwxr--+ 1 oracle oinstall 1331 Feb 11 2012 xbrlrecidx.sql
-rw-rwxr-x+ 1 oracle oinstall 2569 Feb 11 2012 xbrlrecidxdrv.sql
-rwxrwxr-x+ 1 oracle oinstall 3105 Feb 11 2012 xbrlpurgefile.sql
-rwxrwxr-x+ 1 oracle oinstall 3364 Feb 11 2012 xbrlloaderrmsg.sql
-rwxrwxr-x+ 1 oracle oinstall 7299 Feb 11 2012 xbrlinstall.sql
-rwxrwxr-x+ 1 oracle oinstall 7875 Feb 11 2012 xbrleventhdl.plb
-rwxrwxr-x+ 1 oracle oinstall 922 Feb 11 2012 xbrlerrmsg.sql
-rwxrwxr-x+ 1 oracle oinstall 3802 Feb 11 2012 xbrldrop.sql
-rwxrwxr-x+ 1 oracle oinstall 10287 Feb 11 2012 xbrlddl.sql
-r--rwxr--+ 1 oracle oinstall 28738 Feb 11 2012 xbrlddlindex.sql
-rwxrwxr-x+ 1 oracle oinstall 3950 Feb 11 2012 xbrlcrt.sql
-rwxrwxr-x+ 1 oracle oinstall 922045 Feb 11 2012 xbrlcompins.sql
-rwxrwxr-x+ 1 oracle oinstall 47878 Feb 11 2012 xbrlapi.plb
-rwxrwxr-x+ 1 oracle oinstall 11746 Feb 11 2012 xbrlapi0.plb
-rwxrwxr-x+ 1 oracle oinstall 10934 Feb 11 2012 License.txt
-rwxrwxr-x+ 1 oracle oinstall 2769 Feb 11 2012 InstallXBRLDemo.sql
drwxrwxr-x+ 2 oracle oinstall 4096 Mar 15 17:48 mesg
-- login to database and execute below
SQL> @xbrlinstall.sql Oracle321 xbrlsys sysaux temp true
-- verification
SQL> SELECT OBJECT_NAME FROM USER_OBJECTS
WHERE STATUS = 'VALID' AND OBJECT_TYPE = 'PACKAGE'; 2
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_ORAXBRL_INTERNAL
DBMS_ORAXBRLV
DBMS_ORAXBRLD
DBMS_ORAXBRL_UBM
DBMS_ORAXBRLI
DBMS_ORAXBRLT
DBMS_ORAXBRL
7 rows selected.
SQL> SELECT ANY_PATH FROM RESOURCE_VIEW WHERE ANY_PATH = '/xbrl';
ANY_PATH
--------------------------------------------------------------------------------
/xbrl
1 row selected.
SQL> SELECT INDEX_NAME FROM USER_INDEXES
WHERE INDEX_TYPE = 'FUNCTION-BASED DOMAIN' AND STATUS = 'VALID'; 2
INDEX_NAME
------------------------------
XBRL$SCHEMAIDX
XBRL$INSTANCEIDX
ORA$XBRLCACHEIDX
3 rows selected.
SQL> select object_name, object_type from user_objects
where status!='VALID'; 2
no rows selected
===========================
FOR RAC database
===========================
-- Stop all services running out of the ORACLE_HOME
[oracle@subhen_db01 ~]$ srvctl stop home -o /oracle/app/database/11.2.0.3/dbhome_1 -s /home/oracle/state_file_1 -n subhen_db01 -t IMMEDIATE
-- RDBMS PATCH apply
[oracle@subhen_db01 ~]$ cd /home/oracle/PATCH/XBRL/RDBMS_patch/11883969
[oracle@subhen_db01 11883969]$ ls -ltr
total 16
-rw-rw-r-- 1 oracle oinstall 4433 Dec 17 2011 README.txt
drwxr-xr-x 3 oracle oinstall 4096 Dec 17 2011 files
drwxr-xr-x 4 oracle oinstall 4096 Dec 17 2011 etc
[oracle@subhen_db01 11883969]$ which opatch
/oracle/app/database/11.2.0.3/dbhome_1/OPatch/opatch
[oracle@subhen_db01 11883969]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.2
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/database/11.2.0.3/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.2
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/11883969_Mar_27_2013_17_55_56/apply2013-03-27_17-55-56PM_1.log
Applying interim patch '11883969' to OH '/oracle/app/database/11.2.0.3/dbhome_1'
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/oracle/app/database/11.2.0.3/dbhome_1/bin/oracle
Log file location: /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/11883969_Mar_27_2013_17_55_56/apply2013-03-27_17-55-56PM_1.log
Recommended actions: OPatch needs to modify files which are being used by some processes.
OPatch failed with error code 41
-- here the problem was in a different window i had logged in the same Database host so i closed the putty window and tried opatch again and it was success
-- close all the window except the one you are trying for opatch
-- here the opatch is rolling fashion so after 1st node patch apply done start the ORACLE_HOME in 1st node and stop the ORACLE_HOME in 2nd node continue the same for other remaining nodes also
[oracle@subhen_db01 11883969]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.2
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/database/11.2.0.3/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.2
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/11883969_Mar_27_2013_18_03_40/apply2013-03-27_18-03-40PM_1.log
Applying interim patch '11883969' to OH '/oracle/app/database/11.2.0.3/dbhome_1'
Verifying environment and performing prerequisite checks...
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
This node is part of an Oracle Real Application Cluster.
Remote nodes: 'subhen_db02' 'subhen_db03'
Local node: 'subhen_db01'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/database/11.2.0.3/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Verifying the update...
The local system has been patched. You can restart Oracle instances on it.
Patching in rolling mode.
Remaining nodes to be patched:
'subhen_db02' 'subhen_db03'
What is the next node to be patched?
subhen_db02
You have selected 'subhen_db02' from 'subhen_db02' 'subhen_db03'
The node 'subhen_db02' will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on 'subhen_db02'.
(Oracle Home = '/oracle/app/database/11.2.0.3/dbhome_1')
Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'subhen_db02'
Apply-related files are:
FP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_files.txt"
DP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_dirs.txt"
MP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt"
RC = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/remote_cmds.txt"
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt" with actual path.
Running command on remote node 'subhen_db02':
cd /oracle/app/database/11.2.0.3/dbhome_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/oracle/app/database/11.2.0.3/dbhome_1 || echo REMOTE_MAKE_FAILED::>&2
The node 'subhen_db02' has been patched. You can restart Oracle instances on it.
The node 'subhen_db03' will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on 'subhen_db03'.
(Oracle Home = '/oracle/app/database/11.2.0.3/dbhome_1')
Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'subhen_db03'
Apply-related files are:
FP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_files.txt"
DP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/copy_dirs.txt"
MP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt"
RC = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/remote_cmds.txt"
Propagating files to remote nodes...
Propagating directories to remote nodes...
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/11883969_Dec_16_2011_12_53_41/rac/make_cmds.txt" with actual path.
Running command on remote node 'subhen_db03':
cd /oracle/app/database/11.2.0.3/dbhome_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/oracle/app/database/11.2.0.3/dbhome_1 || echo REMOTE_MAKE_FAILED::>&2
The node 'subhen_db03' 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 'subhen_db02' 'subhen_db03' .
The following make commands were invoked on remote nodes:
'cd /oracle/app/database/11.2.0.3/dbhome_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/oracle/app/database/11.2.0.3/dbhome_1
'
Patch 11883969 successfully applied
Log file location: /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/11883969_Mar_27_2013_18_03_40/apply2013-03-27_18-03-40PM_1.log
OPatch succeeded.
[oracle@subhen_db01 11883969]$ sleep 2d
-- XBRL patch apply
[oracle@subhen_db01 XBRLRelease112022]$ pwd
/home/oracle/PATCH/XBRL/XBRL_patch/XBRLRelease112022
[oracle@subhen_db01 XBRLRelease112022]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.2
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/database/11.2.0.3/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/database/11.2.0.3/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.2
OUI version : 11.2.0.3.0
Log file location : /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/13347017_Mar_27_2013_19_07_55/apply2013-03-27_19-07-55PM_1.log
Applying interim patch '13347017' to OH '/oracle/app/database/11.2.0.3/dbhome_1'
Verifying environment and performing prerequisite checks...
Patch 13347017: Optional component(s) missing : [ oracle.rdbms, 11.2.0.2.0, higher version 11.2.0.3.0 found. ]
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
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Verifying the update...
Patching in all-node mode.
Updating nodes 'subhen_db02' 'subhen_db03'
Apply-related files are:
FP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_files.txt"
DP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_dirs.txt"
MP = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/make_cmds.txt"
RC = "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/remote_cmds.txt"
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_files.txt.instantiated" by replacing $ORCLE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_dirs.txt.instantiated" by replacing $ORALE_HOME in "/oracle/app/database/11.2.0.3/dbhome_1/.patch_storage/13347017_Feb_10_2012_13_10_13/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Patch 13347017 successfully applied
Log file location: /oracle/app/database/11.2.0.3/dbhome_1/cfgtoollogs/opatch/13347017_Mar_27_2013_19_07_55/apply2013-03-27_19-07-55PM_1.log
OPatch succeeded.