Manually Install XBRL to your XML Database (XDB)

--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.

Opatch: LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo : OPatch failed with error code 73

{i was trying to opatch lsinventory but it was throwing error as below , i had tried to detach the ORACLE_HOME and attache it again but still i failed
so at last i had removed the oaInventory directory from /oracle/app (after taking a backup of the folder) and did the attach home activity again was successful and opatch lsinventory was also giving correct output}

-- the below was done in non-RAC database env.
-- opatch was throwing the below error

[oracle@subhen-db 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_11-22-00AM.log

List of Homes on this system:

  Home name= OraDb11g_home1, Location= "/oracle/app/database/11.2.0.3/dbhome_2/OPatch"
Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
   Oracle Home dir. path does not exist in Central Inventory
   Oracle Home is a symbolic link
   Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73

-- we were also not able to detach the ORACLE_HOME also

[oracle@subhen-db bin]$ ./runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/oracle/app/database/11.2.0.3/dbhome_2" ORACLE_HOE_NAME="OraDb11g_home1" "CLUSTER_NODES={}"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 1278 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /oracle/app/oraInventory
OUI-10198:Unable to create a new Oracle Home with name OraDb11g_home1. An Oracle Home with this name already exists. Please select another name.
'AttachHome' failed.

[oracle@subhen-db bin]$ ./runInstaller -silent -detachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/oracle/app/database/11.2.0.3/dbhome_2" ORACLE_HOE_NAME="OraDb11g_home1" "CLUSTER_NODES={}"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 1278 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /oracle/app/oraInventory
'DetachHome' failed.

-- remove/move oraInventory directory in order to recreate it from fresh

[oracle@subhen-db app]$ pwd
/oracle/app
[oracle@subhen-db app]$ mv oraInventory oraInventory.old

[oracle@subhen-db bin]$ ./runInstaller -silent -attachHome ORACLE_HOME="/oracle/app/database/11.2.0.3/dbhome_2" ORACLE_HOME_NAME="OraDb11g_home2"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 1278 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /oracle/app/oraInventory
'AttachHome' was successful.

[oracle@subhen-db 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.

TDE(transparent data encryption) in ORACLE database

TDE implementation in databases as below

-- pre checks in database for TDE ( should show closed)

select * from GV$ENCRYPTION_WALLET

  INST_ID WRL_TYPE             WRL_PARAMETER                                                          STATUS
---------- -------------------- ---------------------------------------------------------------------- ------------------
         2 file                 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet           CLOSED
         3 file                 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet           CLOSED
         4 file                 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet           CLOSED
         1 file                 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet           CLOSED


select * from V$ENCRYPTION_WALLET

WRL_TYPE             WRL_PARAMETER                                                          STATUS
-------------------- ---------------------------------------------------------------------- ------------------
file                 /oracle/app/admin/ORCL/wallet                                      CLOSED

-- Create Directories in all respective node servers

mkdir -p -m 0700 /oracle/app/admin/ORCL/wallet

ssh subhen-db03 "mkdir -p -m 0700 /oracle/app/admin/ORCL/wallet"
ssh subhen-db04 "mkdir -p -m 0700 /oracle/app/admin/ORCL/wallet"
ssh subhen-db05 "mkdir -p -m 0700 /oracle/app/admin/ORCL/wallet"

mkdir -p -m 0700 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet
ssh subhen-db03 "mkdir -p -m 0700 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet"
ssh subhen-db04 "mkdir -p -m 0700 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet"
ssh subhen-db05 "mkdir -p -m 0700 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet"

-- Create wallet in 1st node server

[oracle@subhen-db01 bin]$ which orapki
/oracle/app/database/11.2.0.3/dbhome_1/bin/orapki
[oracle@subhen-db01 bin]$ orapki wallet create -wallet /oracle/app/admin/ORCL/wallet -pwd 'XXXXXX' -auto_login
Oracle PKI Tool : Version 11.2.0.3.0 - Production
Copyright (c) 2004, 2011, Oracle and/or its affiliates. All rights reserved.


-- Restart database
srvctl stop database -d ORCL
srvctl start database -d ORCL

-- Set Master Key from sqlplus

[oracle@subhen-db01 bin]$ orapki wallet display -wallet /oracle/app/admin/ORCL/wallet -pwd 'XXXXXX'
Oracle PKI Tool : Version 11.2.0.3.0 - Production
Copyright (c) 2004, 2011, Oracle and/or its affiliates. All rights reserved.

Requested Certificates:
User Certificates:
Trusted Certificates:
Subject:        OU=Class 1 Public Primary Certification Authority,O=VeriSign\, Inc.,C=US
Subject:        OU=Class 3 Public Primary Certification Authority,O=VeriSign\, Inc.,C=US
Subject:        OU=Class 2 Public Primary Certification Authority,O=VeriSign\, Inc.,C=US
Subject:        OU=Secure Server Certification Authority,O=RSA Data Security\, Inc.,C=US
Subject:        CN=GTE CyberTrust Global Root,OU=GTE CyberTrust Solutions\, Inc.,O=GTE Corporation,C=US

SQL> ALTER SYSTEM SET ENCRYPTION KEY AUTHENTICATED BY "XXXXXX";

System altered.

-- Shutdown database
srvctl stop database -d ORCL


-- Copy wallets into all directories of all servers..

cd /oracle/app/admin/ORCL/wallet
scp -p * oracle@subhen-db03:/oracle/app/admin/ORCL/wallet
scp -p * oracle@subhen-db04:/oracle/app/admin/ORCL/wallet
scp -p * oracle@subhen-db05:/oracle/app/admin/ORCL/wallet

cp -p * /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet/
scp -p * oracle@subhen-db03:/oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet
scp -p * oracle@subhen-db04:/oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet
scp -p * oracle@subhen-db05:/oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet

-- Startup database
srvctl start database -d ORCL


-- Check the status


SQL> select * from v$encryption_wallet;

WRL_TYPE             WRL_PARAMETER                                                          STATUS
-------------------- ---------------------------------------------------------------------- ------------------
file                 /oracle/app/admin/ORCL/wallet                                      OPEN

SQL> select * from gv$encryption_wallet;

   INST_ID WRL_TYPE             WRL_PARAMETER                                                          STATUS
---------- -------------------- ---------------------------------------------------------------------- ------------------
         1 file                 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet           OPEN
         3 file                 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet           OPEN
         2 file                 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet           OPEN
         4 file                 /oracle/app/database/11.2.0.3/dbhome_1/admin/ORCL/wallet           OPEN


-- TDE implementation finished

-- creating a tablespace as encrypted and assigning a new user this encrypted tablespace

SQL> CREATE TABLESPACE subu_ENCRYPTED  DATAFILE '+DATA' SIZE 2G
AUTOEXTEND ON NEXT 104857600 MAXSIZE UNLIMITED
  2    3  LOGGING ONLINE PERMANENT BLOCKSIZE 8192
  4  EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO
  5  ENCRYPTION USING 'AES256' DEFAULT STORAGE(ENCRYPT);

Tablespace created.

SQL> create user subu_XBRL identified by subu#123
default tablespace subu_ENCRYPTED
temporary tablespace TEMP
quota UNLIMITED on subu_ENCRYPTED
profile  APP_PROFILE;