Oracle 12c - PSU
12.1.0.1.7 - PSU Apply to
Container Database
Today we are
going to apply 12.1.0.1.7 PSU to 12.1.0.1.0 Container database and pluggable
database. In this post I will show you
how to debug issue when faced opatch apply failure.
Database Details :
CDB : NOKIA
PDB1 : E7DB (Fresh)
PDB2 : PROD (Upgraded from 11.2.0.4.6 and Plug into
container)
[oracle@vm211 ~]$ ps
-ef | grep pmon
oracle 7475
1 0 03:51 ? 00:00:00 ora_pmon_NOKIA
[oracle@vm211 ~]$ .
oraenv
ORACLE_SID =
[oracle] ? NOKIA
The Oracle base has
been set to /u01/app/oracle
[oracle@vm211 ~]$
sqlplus / as sysdba
SQL*Plus: Release
12.1.0.1.0 Production on Sat Aug 15 07:26:26 2015
Copyright (c) 1982,
2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c
Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the
Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions
SQL> select *
from registry$history ;
ACTION_TIME ACTION NAMESPACE
VERSION ID COMMENTS BUNDLE_SERIES
--------------------------------
------- -------------- ----------- -------------------- ---------------
24-MAY-13
01.20.05.485655 PM APPLY SERVER
12.1.0.1 0 Patchset 12.1.0.0.0 PSU
15-AUG-15
03.48.18.144620 AM APPLY SERVER
12.1.0.1 0 Patchset 12.1.0.0.0 PSU
SQL> save reg
Moving to patch software directory and unzip the patch
[oracle@vm211 ~]$ cd
/SOFT/PSU_12c_12.1.0.1/
[oracle@vm211
PSU_12c_12.1.0.1]$ ls -l
total
866600
-rw-r--r--
1 oracle oinstall 106837668 Jun 28 00:46 p20299016_121010_Linux-x86-64.zip
-rw-r--r--
1 oracle oinstall 779680874 Jun 28 04:30 p20485762_121010_Linux-x86-64.zip
[oracle@vm211
PSU_12c_12.1.0.1]$ unzip p20299016_121010_Linux-x86-64.zip
Archive: p20299016_121010_Linux-x86-64.zip
creating: 20299016/
inflating: 20299016/README.html
creating: 20299016/20299016/
creating: 20299016/20299016/etc/
creating: 20299016/20299016/etc/xml/
…………………………
inflating:
20299016/20299016/etc/xml/ShiphomeDirectoryStructure.xml
inflating:
20299016/20299016/etc/xml/GenericActions.xml
inflating:
20299016/19769486/files/lib/asmcmdexceptions.pm
inflating:
20299016/19769486/files/lib/asmcmdshare.pm
inflating: PatchSearch.xml
Moving to OPatch directory and check the OPatch version. If it is not latest then download latest
OPatch from Oracle Support and unzip into Oracle Home. In my case it is not latest, so I unzip the
downloaded patch into ORACLE_HOME.
[oracle@vm211
PSU_12c_12.1.0.1]$ cd /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/
[oracle@vm211 OPatch]$ ./opatch version
OPatch Version:
12.1.0.1.0
OPatch succeeded.
[oracle@vm211 OPatch]$ cd ..
[oracle@vm211
dbhome_1]$ mv OPatch old_OPatch
[oracle@vm211
dbhome_1]$ pwd
/u01/app/oracle/product/12.1.0.1/dbhome_1
[oracle@vm211 dbhome_1]$
cd /SOFT/OPatch/
[oracle@vm211
OPatch]$ unzip -d /u01/app/oracle/product/12.1.0.1/dbhome_1/
p6880880_121010_Linux-x86-64.zip
Archive: p6880880_121010_Linux-x86-64.zip
creating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/
creating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/scripts/
inflating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/scripts/opatch_jvm_discovery.bat
inflating: /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/scripts/opatch_wls.bat
inflating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/scripts/opatch_wls
inflating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/scripts/opatch_jvm_discovery
inflating: /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/emdpatch.pl
inflating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/operr
inflating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/datapatch
creating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/opatchauto-dir/
creating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/opatchauto-dir/opatchautocore/
inflating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/opatchauto-dir/opatchautocore/oplan.bat
….
…..
inflating: /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/docs/Prereq_Users_Guide.txt
inflating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/docs/cversion.txt
inflating:
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/docs/Users_Guide.txt
/u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch
[oracle@vm211
OPatch]$ ./opatch version
OPatch Version: 12.1.0.1.7
OPatch succeeded.
[oracle@vm211
20299016]$ which make
/usr/bin/make
[oracle@vm211
20299016]$ which ar
/usr/bin/ar
[oracle@vm211
20299016]$ which ld
/usr/bin/ld
[oracle@vm211
20299016]$ which nm
/usr/bin/nm
[oracle@vm211
20299016]$ /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/opatch lsinventory
Oracle Interim
Patch Installer version 12.1.0.1.7
Copyright (c) 2015,
Oracle Corporation. All rights reserved.
Oracle Home :
/u01/app/oracle/product/12.1.0.1/dbhome_1
Central Inventory :
/u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.1/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.7
OUI version : 12.1.0.1.0
Log file location :
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_07-51-30AM_1.log
Lsinventory Output
file location : /u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-08-15_07-51-30AM.txt
--------------------------------------------------------------------------------
Local Machine
Information::
Hostname:
vm211.ora.com
ARU platform id:
226
ARU platform
description:: Linux x86-64
Installed Top-level
Products (1):
Oracle Database
12c
12.1.0.1.0
There are 1
products installed in this Oracle Home.
There are no
Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
Before Applying checking the pre-check and Confliction against
Oracle Home
[oracle@vm211
20299016]$ /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim
Patch Installer version 12.1.0.1.7
Copyright (c) 2015,
Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home :
/u01/app/oracle/product/12.1.0.1/dbhome_1
Central Inventory :
/u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.1/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.7
OUI version : 12.1.0.1.0
Log file location :
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_07-52-27AM_1.log
Invoking prereq
"checkconflictagainstohwithdetail"
Prereq
"checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@vm211
20299016]$ more
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_07-52-27AM_1.log
[Aug 15, 2015
7:52:27 AM] PREREQ session
[Aug 15, 2015
7:52:27 AM] OPatch invoked as follows:
'prereq CheckConflictAgainstOHWithDetail -ph ./ -invPtrLoc
/u01/app/oracle/product/12.1.0
.1/dbhome_1/oraInst.loc
'
[Aug 15, 2015
7:52:27 AM] OUI-67077:
Oracle Home :
/u01/app/oracle/product/12.1.0.1/dbhome_1
Central Inventory
: /u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.1/dbhome_1/oraInst.loc
OPatch
version : 12.1.0.1.7
OUI version : 12.1.0.1.0
OUI location :
/u01/app/oracle/product/12.1.0.1/dbhome_1/oui
Log file location
: /u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_07-52-27AM_1.log
[Aug 15, 2015
7:52:27 AM] Patch history file:
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
[Aug 15, 2015
7:52:27 AM] Invoking prereq
"checkconflictagainstohwithdetail"
[Aug 15, 2015
7:52:27 AM] Ignoring file
"/SOFT/PSU_12c_12.1.0.1/20299016/README.html" in the patch directory.
[Aug 15, 2015
7:52:27 AM] Ignoring file
"/SOFT/PSU_12c_12.1.0.1/20299016/README.txt" in the patch directory.
[Aug 15, 2015
7:52:28 AM]
checkConflictAgainstOHWithDetail start -> Sat Aug 15 07:52:28 IST
2015
[Aug 15, 2015
7:52:28 AM] Sat Aug 15 07:52:28 IST
2015
[Aug 15, 2015
7:52:28 AM] Adapter can go list:
19769486 20299016
[Aug 15, 2015
7:52:28 AM] Adapter not need list:
[Aug 15, 2015
7:52:28 AM] Adapter auto-rollback
list:
[Aug 15, 2015
7:52:28 AM]
checkConflictAgainstOHWithDetail end -> Sat Aug 15 07:52:28 IST 2015
[Aug 15, 2015
7:52:28 AM] Prereq
"checkConflictAgainstOHWithDetail" passed.
[Aug 15, 2015
7:52:28 AM] Finishing PrereqSession at
Sat Aug 15 07:52:28 IST 2015
Check Oracle Registry and Shutdown Listener / Oracle Database
related to this home.
[oracle@vm211
20299016]$ sqlplus / as sysdba
SQL*Plus: Release
12.1.0.1.0 Production on Sat Aug 15 07:53:45 2015
Copyright (c) 1982,
2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c
Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the
Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
@/home/oracle/reg
ACTION_TIME ACTION NAMESPACE VERSION
ID COMMENTS BUNDLE_SERIES
----------------------------
------- ---------- --------- -- ------------------- ---------------
24-MAY-13
01.20.05.485655 PM APPLY SERVER
12.1.0.1 0 Patchset 12.1.0.0.0 PSU
15-AUG-15
03.48.18.144620 AM APPLY SERVER
12.1.0.1 0 Patchset 12.1.0.0.0 PSU
SQL> alter
session set container=PROD ;
Session altered.
SQL>
@/home/oracle/reg
ACTION_TIME ACTION
NAMESPACE VERSION ID COMMENTS BUNDLE_SERIES
-----------------------------
------------- -------------- ------------------- -------------------------
-------------
24-AUG-13 12.03.45.119862
PM APPLY SERVER 11.2.0.4 0 Patchset 11.2.0.2.0 PSU
15-AUG-15
01.47.26.575232 AM APPLY SERVER 11.2.0.4 6 PSU 11.2.0.4.6 PSU
15-AUG-15
02.35.21.118449 AM VIEW INVALIDA 8289601 view invalidation
TE
15-AUG-15
02.37.41.906179 AM UPGRADE SERVER 12.1.0.1.0 Upgraded from 11.2.0.4.0
15-AUG-15
02.43.12.703450 AM APPLY SERVER 12.1.0.1 0 Patchset 12.1.0.0.0 PSU
SQL> alter
session set container=E7DB;
Session altered.
SQL> show
con_name
CON_NAME
------------------------------
E7DB
SQL>
@/home/oracle/reg
ACTION_TIME ACTION NAMESPACE
VERSION ID COMMENTS BUNDLE_SERIE
----------------------------
------- -------------- --------- -- -------------------- -------------
24-MAY-13
01.20.09.465028 PM APPLY SERVER
12.1.0.1 0 Patchset 12.1.0.0.0 PSU
[oracle@vm211
20299016]$ lsnrctl stop
LSNRCTL for Linux:
Version 12.1.0.1.0 - Production on 15-AUG-2015 07:55:34
Copyright (c) 1991,
2013, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vm211.ora.com)(PORT=1521)))
The command
completed successfully
[oracle@vm211
20299016]$ sqlplus / as sysdba
SQL*Plus: Release
12.1.0.1.0 Production on Sat Aug 15 07:55:39 2015
Copyright (c) 1982,
2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c
Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the
Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> shut
immediate
Database closed.
Database
dismounted.
ORACLE instance
shut down.
[oracle@vm211
20299016]$ ps -ef | grep pmon
oracle 11944 10775
0 07:59 pts/4 00:00:00 grep
pmon
Apply Patch to 12c Oracle Home
[oracle@vm211
20299016]$ /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/opatch apply
Oracle Interim
Patch Installer version 12.1.0.1.7
Copyright (c) 2015,
Oracle Corporation. All rights reserved.
Oracle Home :
/u01/app/oracle/product/12.1.0.1/dbhome_1
Central Inventory :
/u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.1/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.7
OUI version : 12.1.0.1.0
Log file location :
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_07-59-56AM_1.log
Verifying environment and performing prerequisite
checks...
Prerequisite check "CheckActiveFilesAndExecutables"
failed.
The details are:
Following
executables are active :
/u01/app/oracle/product/12.1.0.1/dbhome_1/bin/rman
/u01/app/oracle/product/12.1.0.1/dbhome_1/lib/libclntsh.so.12.1
UtilSession failed:
Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location:
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_07-59-56AM_1.log
OPatch failed with error code 73
Tracing Error from patch
logfile.
[oracle@vm211 20299016]$ more
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_07-59-56AM_1.log
[Aug 15, 2015
7:59:56 AM] OPatch invoked as follows:
'apply -invPtrLoc /u01/app/oracle/product/12.1.0.1/dbhome_1/oraInst.loc '
[Aug 15, 2015
7:59:56 AM] OUI-67077:
Oracle Home :
/u01/app/oracle/product/12.1.0.1/dbhome_1
Central Inventory
: /u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.1/dbhome_1/oraInst.loc
OPatch
version : 12.1.0.1.7
OUI version : 12.1.0.1.0
OUI location :
/u01/app/oracle/product/12.1.0.1/dbhome_1/oui
Log file location
:
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_07-59-56AM_1.log
[Aug 15, 2015
7:59:56 AM] Patch history file:
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
[Aug 15, 2015
7:59:59 AM] Verifying environment and
performing prerequisite checks...
[Aug 15, 2015
7:59:59 AM] Ignoring file
"/SOFT/PSU_12c_12.1.0.1/20299016/README.html" in the patch directory.
[Aug 15, 2015
7:59:59 AM] Ignoring file
"/SOFT/PSU_12c_12.1.0.1/20299016/README.txt" in the patch directory.
[Aug 15, 2015
7:59:59 AM] Checking conflict among
patches...
[Aug 15, 2015
7:59:59 AM]
checkConflictAmongPatchesWithDetail start -> Sat Aug 15 07:59:59 IST
2015
[Aug 15, 2015
7:59:59 AM] Sat Aug 15 07:59:59 IST
2015
[Aug 15, 2015
7:59:59 AM] Adapter can go list:
19769486 20299016
[Aug 15, 2015
7:59:59 AM] Adapter not need list:
[Aug 15, 2015
7:59:59 AM] Adapter auto-rollback
list:
[Aug 15, 2015
7:59:59 AM]
checkConflictAmongPatchesWithDetail end -> Sat Aug 15 07:59:59 IST
2015
[Aug 15, 2015
7:59:59 AM] Intra-Conflict check
PASSED
[Aug 15, 2015
7:59:59 AM] Checking if Oracle Home
has components required by patches...
[Aug 15, 2015
7:59:59 AM] Check if patch
"19769486" is a no-op patch.
[Aug 15, 2015
7:59:59 AM] Opt. comp. not in OH
inventory: oracle.network.cman, 12.1.0.1.0
[Aug 15, 2015
7:59:59 AM] [ oracle.network.cman,
12.1.0.1.0 ]
[Aug 15, 2015
7:59:59 AM] Check if patch
"20299016" is a no-op patch.
[Aug 15, 2015
7:59:59 AM] Checking conflicts against
Oracle Home...
[Aug 15, 2015
7:59:59 AM]
checkConflictAgainstOHWithDetail start -> Sat Aug 15 07:59:59 IST
2015
[Aug 15, 2015
7:59:59 AM] Sat Aug 15 07:59:59 IST
2015
[Aug 15, 2015
7:59:59 AM] Adapter can go list:
19769486 20299016
[Aug 15, 2015
7:59:59 AM] Adapter not need list:
[Aug 15, 2015
7:59:59 AM] Adapter auto-rollback
list:
[Aug 15, 2015
7:59:59 AM]
checkConflictAgainstOHWithDetail end -> Sat Aug 15 07:59:59 IST 2015
[Aug 15, 2015
7:59:59 AM] Running prerequisite
checks...
[Aug 15, 2015
7:59:59 AM] Check if patch
"19769486" is a no-op patch.
[Aug 15, 2015
7:59:59 AM] Opt. comp. not in OH
inventory: oracle.network.cman, 12.1.0.1.0
[Aug 15, 2015
7:59:59 AM] [ oracle.network.cman,
12.1.0.1.0 ]
[Aug 15, 2015
7:59:59 AM] Check if patch
"20299016" is a no-op patch.
[Aug 15, 2015
8:00:00 AM] None of the selected patches
are no-op. patches..
[Aug 15, 2015
8:00:00 AM] Space Needed : 1370.444MB
[Aug 15, 2015
8:00:00 AM] Prereq
checkPatchApplicableOnCurrentPlatform Passed for patch : 19769486
[Aug 15, 2015
8:00:00 AM] Prereq
checkPatchApplicableOnCurrentPlatform Passed for patch : 20299016
[Aug 15, 2015
8:00:00 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/oracle at Sat Aug 15
08:00:00 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/oracle at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/renamedg at Sat Aug
15 08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/renamedg at Sat Aug
15 08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/amdu at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/amdu at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/kfed at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/kfed at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/kfod at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/kfod at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/proc at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/proc at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/procob at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/procob at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/rman at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/rman at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/wrap at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015 8:00:01
AM] Finish fuser command /sbin/fuser
/u01/app/oracle/product/12.1.0.1/dbhome_1/bin/wrap at Sat Aug 15 08:00:01 IST
2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/plshprof at Sat Aug
15 08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/plshprof at Sat Aug
15 08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/orapwd at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/orapwd at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/expdp at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/expdp at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/impdp at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/impdp at Sat Aug 15
08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Start fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/lib/libclntsh.so.12.1 at
Sat Aug 15 08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Finish fuser command
/sbin/fuser /u01/app/oracle/product/12.1.0.1/dbhome_1/lib/libclntsh.so.12.1 at
Sat Aug 15 08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Following executables are
active :
/u01/app/oracle/product/12.1.0.1/dbhome_1/bin/rman
/u01/app/oracle/product/12.1.0.1/dbhome_1/lib/libclntsh.so.12.1
[Aug 15, 2015
8:00:01 AM] Prerequisite check
"CheckActiveFilesAndExecutables" failed.
The details are:
Following
executables are active :
/u01/app/oracle/product/12.1.0.1/dbhome_1/bin/rman
/u01/app/oracle/product/12.1.0.1/dbhome_1/lib/libclntsh.so.12.1
[Aug 15, 2015 8:00:01 AM] OUI-67073:UtilSession failed: Prerequisite
check "CheckActiveFilesAndExecutables" failed.
[Aug 15, 2015
8:00:01 AM] Finishing UtilSession at
Sat Aug 15 08:00:01 IST 2015
[Aug 15, 2015
8:00:01 AM] Log file location: /u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_07-59-56AM_1.log
[Aug 15, 2015
8:00:01 AM] Stack Description:
java.lang.RuntimeException: Prerequisite check
"CheckActiveFilesAndExecutables" failed.
[Aug 15, 2015
8:00:01 AM] StackTrace:
oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6014)
[Aug 15, 2015
8:00:01 AM] StackTrace:
oracle.opatch.opatchutil.NApply.process(NApply.java:697)
[Aug 15, 2015
8:00:01 AM] StackTrace:
oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1112)
[Aug 15, 2015
8:00:01 AM] StackTrace:
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[Aug 15, 2015
8:00:01 AM] StackTrace:
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[Aug 15, 2015
8:00:01 AM] StackTrace:
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[Aug 15, 2015
8:00:01 AM] StackTrace:
java.lang.reflect.Method.invoke(Method.java:597)
[Aug 15, 2015
8:00:01 AM] StackTrace:
oracle.opatch.UtilSession.process(UtilSession.java:322)
[Aug 15, 2015
8:00:01 AM] StackTrace:
oracle.opatch.OPatchSession.main(OPatchSession.java:2607)
[Aug 15, 2015
8:00:01 AM] StackTrace:
oracle.opatch.OPatch.main(OPatch.java:645)
[oracle@vm211
20299016]$ ps -ef | grep rman
oracle 9662 9167 0 05:43
pts/3 00:00:00 rman target /
oracle 12097 10775
0 08:01 pts/4 00:00:00 grep
rman
[oracle@vm211 20299016]$ kill -9 9662
[oracle@vm211
20299016]$ ps -ef | grep rman
oracle 12099 10775
0 08:01 pts/4 00:00:00 grep
rman
Retry applying patches after
fixing issue.
[oracle@vm211
20299016]$ /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/opatch apply
Oracle Interim
Patch Installer version 12.1.0.1.7
Copyright (c) 2015,
Oracle Corporation. All rights reserved.
Oracle Home :
/u01/app/oracle/product/12.1.0.1/dbhome_1
Central Inventory :
/u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.1/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.7
OUI version : 12.1.0.1.0
Log file location :
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_08-02-04AM_1.log
Verifying
environment and performing prerequisite checks...
OPatch continues
with these patches: 19769486 20299016
Do you want to
proceed? [y|n]
Y
User Responded
with: Y
All checks passed.
Provide your email
address to be informed of security issues, install and
initiate Oracle
Configuration Manager. Easier for you if you use your My
Oracle Support
Email address/User Name.
Visit
http://www.oracle.com/support/policies.html for details.
Email address/User
Name:
You have not
provided an email address for notification of security issues.
Do you wish to
remain uninformed of security issues ([Y]es, [N]o) [N]: Y
Please shutdown
Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home =
'/u01/app/oracle/product/12.1.0.1/dbhome_1')
Is the local system
ready for patching? [y|n]
y
User Responded
with: Y
Backing up files...
Applying sub-patch
'19769486' to OH '/u01/app/oracle/product/12.1.0.1/dbhome_1'
ApplySession:
Optional component(s) [ oracle.network.cman, 12.1.0.1.0 ] not present in the Oracle Home or a higher
version is found.
Patching component
oracle.network.rsf, 12.1.0.1.0...
Patching component
oracle.ldap.rsf, 12.1.0.1.0...
Patching component
oracle.precomp.common, 12.1.0.1.0...
Patching component
oracle.ovm, 12.1.0.1.0...
Patching component
oracle.ldap.rsf.ic, 12.1.0.1.0...
Patching component
oracle.rdbms.deconfig, 12.1.0.1.0...
Patching component
oracle.xdk, 12.1.0.1.0...
Patching component
oracle.rdbms.util, 12.1.0.1.0...
Patching component
oracle.rdbms, 12.1.0.1.0...
Patching component
oracle.rdbms.dbscripts, 12.1.0.1.0...
Patching component
oracle.nlsrtl.rsf, 12.1.0.1.0...
Patching component
oracle.xdk.parser.java, 12.1.0.1.0...
Patching component
oracle.oraolap, 12.1.0.1.0...
Patching component
oracle.rdbms.rsf, 12.1.0.1.0...
Patching component
oracle.xdk.rsf, 12.1.0.1.0...
Patching component
oracle.rdbms.rman, 12.1.0.1.0...
Patching component
oracle.precomp.lang, 12.1.0.1.0...
Patching component
oracle.ordim.client, 12.1.0.1.0...
Patching component
oracle.ordim.jai, 12.1.0.1.0...
Patching component
oracle.rsf, 12.1.0.1.0...
Verifying the
update...
Applying sub-patch
'20299016' to OH '/u01/app/oracle/product/12.1.0.1/dbhome_1'
Patching component
oracle.nlsrtl.rsf, 12.1.0.1.0...
Patching component
oracle.xdk.parser.java, 12.1.0.1.0...
Patching component
oracle.xdk.rsf, 12.1.0.1.0...
Patching component
oracle.rdbms.rsf, 12.1.0.1.0...
Patching component
oracle.xdk, 12.1.0.1.0...
Patching component
oracle.rdbms, 12.1.0.1.0...
Verifying the
update...
Composite patch
20299016 successfully applied.
Log file location:
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_08-02-04AM_1.log
OPatch succeeded.
Verify Logs :
[oracle@vm211 20299016]$ tail -20f
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_08-02-4AM_1.log
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/kewm.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/kcvfdb.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/ttcpip.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/prsa.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/kgl.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/krvxb.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/kjgcr.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/krbb.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/ktm.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/ttcclr.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/jscr.o"
[Aug 15, 2015
8:04:57 AM] Deleted the file
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch/knalf.o"
[Aug 15, 2015
8:04:57 AM] Deleted the directory
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage/19769486_Dec_30_2014_09_04_11/scratch"
[Aug 15, 2015
8:04:57 AM] Size of directory
"/u01/app/oracle/product/12.1.0.1/dbhome_1/.patch_storage" after
cleanup is 358276962 bytes.
[Aug 15, 2015
8:04:57 AM] UtilSession: Backup area
for restore has been cleaned up. For a complete list of files/directories
deleted, Please
refer log file.
[Aug 15, 2015
8:04:57 AM] Composite patch 20299016
successfully applied.
[Aug 15, 2015
8:04:57 AM] UtilSession: N-Apply done.
[Aug 15, 2015
8:04:57 AM] Finishing UtilSession at
Sat Aug 15 08:04:57 IST 2015
[Aug 15, 2015
8:04:57 AM] Log file location:
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_08-02-04AM_1.log
Checking applied patches
[oracle@vm211
20299016]$ /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/opatch lsinventory
Oracle Interim
Patch Installer version 12.1.0.1.7
Copyright (c) 2015,
Oracle Corporation. All rights reserved.
Oracle Home :
/u01/app/oracle/product/12.1.0.1/dbhome_1
Central Inventory :
/u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.1/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.7
OUI version : 12.1.0.1.0
Log file location :
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-08-15_08-06-02AM_1.log
Lsinventory Output
file location :
/u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-08-15_08-06-02AM.txt
--------------------------------------------------------------------------------
Local Machine
Information::
Hostname:
vm211.ora.com
ARU platform id:
226
ARU platform
description:: Linux x86-64
Installed Top-level
Products (1):
Oracle Database
12c
12.1.0.1.0
There are 1
products installed in this Oracle Home.
Interim patches (1)
:
Patch 20299016
: applied on Sat Aug 15 08:03:59 IST 2015
Unique Patch
ID: 18536956
Patch
description: "Database Patch Set
Update : 12.1.0.1.7 (20299016)"
Created on 2 Feb 2015, 02:34:14 hrs PST8PDT
Sub-patch 19769486; "Database Patch Set Update :
12.1.0.1.6 (19769486)"
Bugs fixed:
16406802, 16576250, 17605522, 16433745,
18439152, 16465158, 16523150
18002100, 17830435, 16101465, 17316776,
16660558, 17797837, 16433540
16462834, 16924879, 16842274, 16663465,
16465149, 18603606, 14010183
16705020, 17912217, 14664684, 15921906,
17817656, 17040764, 17478145
17039360, 19358317, 16991789, 17777061,
18148383, 16485876, 16787973
17405549, 16433869, 18641419, 16715647,
17467075, 13771513, 16911800
16456371, 18420490, 16712618, 17216406,
16825779, 19297295, 16921340
17797453, 16443657, 16994576, 16479182,
17441661, 17465741, 16993424
16788832, 16888264, 17437634, 14237793,
16910001, 16838328, 16689109
17298973, 18126350, 16795944, 19554106,
19458377, 16512817, 16762985
17596344, 17516005, 16524968, 16757934,
18641461, 16946613, 16978185
16495802, 16543323, 19309466, 17171530,
16935643, 17308691, 17571945
16782193, 17226980, 18641451, 17982838,
16855202, 16683859, 16619979
17888553, 16173738, 17364702, 16837842,
17005047, 16772060, 16710753
14197853, 17205719, 17848854, 16459685,
17860549, 17976046, 17750832
16347904, 17359546, 17080436, 17898041,
18155703, 18078926, 16007562
16410570, 17551812, 17390431, 16856570,
16613964, 16802693, 19556045
16061921, 18355572, 16551086, 17954431,
16668226, 17217040, 17600719
17184677, 16527374, 20074391, 16228604,
16042673, 14576755, 17393683
19006849, 17174582, 18393024, 17210416,
17000176, 18121501, 18348157
16697600, 17436936, 17034172, 17762296,
16450169, 17019974, 17974104
17898730, 18423374, 15994107, 15914210,
17289787, 16191248, 15986012
16679874, 16570023, 17442449, 15905421,
15996344, 19866250, 16475788
17489214, 17572525, 20296213, 14595800,
16263492, 15931910, 17608025
17659488, 17753428, 17391312, 17027533,
17311728, 17753514, 18096714
17897716, 16681689, 17478811, 16320173,
18554871, 16178562, 16864562
16362358, 16855292, 16039096, 17026503,
20299016, 18093615, 17324822
18513099, 16864359, 16698577, 17806676,
17867137, 20328279, 16850996
16901482, 17182200, 17892268, 17257820,
16603924, 16930325, 16212405
19248799, 16849982, 15987992, 16457621,
17443671, 16473934, 16913149
18308576, 17158214, 18856947, 18889652,
16707927, 16275522, 14355775
18099539, 16816103, 16912439, 16584684,
16517900, 16851772, 16859937
16919176, 17349104, 16741246, 17537657,
16972213, 17552800, 18522516
17341326, 17346196, 16928832, 16087650,
16585173, 19049453, 17735933
16796277, 16675739, 17273253, 13521413,
18061914, 17981677, 16822629
16372203, 16845022, 8352043, 17174391,
17810688, 16977973, 16634384
16672859, 16392068, 16863422, 18244962,
17037526, 17491753, 16682595
16575931, 17260090, 18973907, 17490498,
17088068, 17330580, 19915271
16195633, 16936008, 16181570, 17762256,
17721717, 16733884, 17534365
18436307, 17983206, 16793174, 18092561,
17922172, 19121550, 17716565
17446849, 16964686, 16617325, 17761775,
17461374, 16721594, 17179261
18262334, 17610418, 18292893, 16902138,
17042658, 16483559, 15953721
18229326, 16986421, 17305959, 16874123,
16769019, 17006570, 17032726
16070351, 19197175, 16371304, 16964279,
16864864, 17249820, 19692901
17446564, 17343514, 17325413, 17421502,
16170787, 17462687, 17362796
17439871, 16730813, 17883081, 17579911,
12911115, 18082092, 16347068
17946998, 16313881, 16227068, 17997255,
17394724, 17443596, 16836849
16969016, 14852021, 17716305, 17051636,
17244462, 19289642, 17767676
17786278, 18189497, 17572720, 17082983,
16444683, 16621274, 16524071
16709437, 14123213, 14506328, 16943711,
17710315, 13866822, 16503473
16590848, 16784143, 16057129, 18031528,
16619249, 16589507, 16674666
13782826, 19769486, 16790307, 16675710,
17828499, 16864048, 16694728
16910734, 17614134, 17263661, 16448848,
17050888, 16286774, 20128874
17280117, 18362376, 16427054, 16992075,
17016479, 16784167, 16663303
16674842, 17468141, 18436647, 16186165,
14536110, 16946990, 17570606
17235750, 16703112, 16784901, 17068536,
16929165
--------------------------------------------------------------------------------
OPatch succeeded.
Checking Applied version of
OPatch
[oracle@vm211
20299016]$ /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/opatch lspatches
20299016;Database
Patch Set Update : 12.1.0.1.7 (20299016)
OPatch succeeded.
[oracle@vm211
20299016]$
Start the database and apply
datapatch. In 12c datapatch will apply
only on open pdbs. The pdb which are not
open datapatch will not be applied. If we open unapplied datapatch pdb we will
get sycn warning. Let me show the demo.
In my case I have 2 PDSB (E7DB
and PROD). What I am going to do, I will
only open 1 PDB (E7DB). PROD pdb will on close state.
[oracle@vm211
20299016]$ . oraenv
ORACLE_SID =
[NOKIA] ?
The
/u01/app/oracle/product/12.1.0.1/dbhome_1/bin/orabase binary does not have
execute privilege
for the current
user, oracle. Rerun the script after
changing
the permission of
the mentioned executable.
You can set
ORACLE_BASE manually if it is required.
Resetting
ORACLE_BASE to its previous value or ORACLE_HOME
The Oracle base
remains unchanged with value /u01/app/oracle
[oracle@vm211
20299016]$ sqlplus / as sysdba
SQL*Plus: Release
12.1.0.1.0 Production on Sat Aug 15 08:11:31 2015
Copyright (c) 1982,
2013, Oracle. All rights reserved.
Connected to an
idle instance.
SQL>
startup
ORACLE instance
started.
Total System Global
Area 1252663296 bytes
Fixed Size 2850040 bytes
Variable Size 872416008 bytes
Database
Buffers 369098752 bytes
Redo Buffers 8298496 bytes
Database mounted.
Database opened.
SQL>
alter pluggable database E7DB OPEN ;
Pluggable database
altered.
SQL> col name
for a10
SQL> col guid
for a10
SQL> col
open_time for a13
SQL> set lin200
pages 200
SQL>
SQL> select *
from v$pdbs ;
CON_ID
DBID CON_UID GUID NAME OPEN_MODE RES OPEN_TIME CREATE_SCN TOTAL_SIZE
----------
---------- ---------- ---------- ---------- ---------- --- -------------
---------- ----------
2 4130373951 4130373951 1D4DC0EF22
PDB$SEED READ ONLY NO
15-AUG-15 08. 1720762 283115520
6E1AB2E053
11.44.894 AM
D301A8C0CC
D0
3 1010268563 1010268563 1D4DE481E6 E7DB READ WRITE
NO 15-AUG-15 08. 1915708
393216000
F91DB3E053
12.06.830 AM
D301A8C07F
E4
4
299604649 299604649 1D4CD9BC62
PROD MOUNTED 2299813 0
25155FE053
D301A8C0D4
91
Applying datapatch.
[oracle@vm211
20299016]$ /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/datapatch
SQL Patching tool
version 12.1.0.1.0 on Sat Aug 15 08:14:13 2015
Copyright (c) 2014,
Oracle. All rights reserved.
Connecting to
database...OK
Determining current
state...done
Adding patches to
installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
E7DB
Nothing to roll back
The following patches will be
applied: 19769486,20299016
Installing
patches...
Patch installation
complete. Total patches
installed: 2
Validating logfiles...done
SQL Patching tool
complete on Sat Aug 15 08:16:50 2015
Checking the applied datapatch
[oracle@vm211
20299016]$ sqlplus / as sysdba
SQL*Plus: Release
12.1.0.1.0 Production on Sat Aug 15 08:24:19 2015
Copyright (c) 1982,
2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c
Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the
Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
@/home/oracle/reg
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SERIES
----------------------------
------- --------- -------- -- -------------------- ---------------
24-MAY-13
01.20.05.485655 PM APPLY SERVER
12.1.0.1 0 Patchset 12.1.0.0.0 PSU
15-AUG-15
03.48.18.144620 AM APPLY SERVER
12.1.0.1 0 Patchset 12.1.0.0.0 PSU
15-AUG-15
08.15.58.912842 AM APPLY SERVER
12.1.0.1 7 PSU 12.1.0.1.7 PSU
15-AUG-15
08.15.59.425395 AM APPLY SERVER
12.1.0.1 7 PSU 12.1.0.1.7 PSU
SQL> alter
session set container=E7DB;
Session altered.
SQL>
@/home/oracle/pdb.sql
CON_ID DBID
CON_UID GUID NAME OPEN_MODE
RES OPEN_TIME CREATE_SCN
TOTAL_SIZE
------ ----------
---------- ---------- ----- ---------- --- ------------- ---------- ----------
3 1010268563 1010268563 1D4DE481E6 E7DB READ WRITE NO
15-AUG-15 08. 1915708 393216000
F91DB3E053 12.06.830 AM
D301A8C07F
E4
SQL>
@/home/oracle/reg
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SERIES
-----------------------------
------- ---------- -------- -- -------------------- ---------------
24-MAY-13
01.20.09.465028 PM APPLY SERVER
12.1.0.1 0 Patchset 12.1.0.0.0 PSU
15-AUG-15
08.16.42.325741 AM APPLY SERVER
12.1.0.1 7 PSU 12.1.0.1.7 PSU
15-AUG-15
08.16.43.595762 AM APPLY SERVER
12.1.0.1 7 PSU 12.1.0.1.7 PSU
Now try open database PROD where
datapatch has not applied. We will get DB
open
SQL> alter
pluggable database PROD OPEN;
Warning: PDB
altered with errors.
Check logs file
[oracle@vm211 20299016]$ tail -20f
/u01/app/oracle/diag/rdbms/nokia/NOKIA/trace/alert_NOKIA.log
Completed: ALTER
PLUGGABLE DATABASE pdb$seed OPEN READ ONLY
Sat Aug 15 08:28:31
2015
alter pluggable
database PROD OPEN
Sat Aug 15 08:28:32
2015
***************************************************************
WARNING: Pluggable Database PROD with pdb id - 4 is
altered
with errors or warnings. Please look into
PDB_PLUG_IN_VIOLATIONS view for more details.
***************************************************************
Opening pdb PROD (4) with no Resource Manager plan
active
Pluggable database
PROD opened read write
Completed: alter
pluggable database PROD OPEN
Now applying datapatch to rest of remaining PDB’s
[oracle@vm211
20299016]$ /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/datapatch
SQL Patching tool
version 12.1.0.1.0 on Sat Aug 15 08:31:19 2015
Copyright (c) 2014,
Oracle. All rights reserved.
Connecting to
database...OK
Determining current
state...done
Adding patches to
installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
E7DB
Nothing to roll back
Nothing to apply
For the following PDBs: PROD
Nothing to roll back
The following patches will be
applied: 19769486,20299016
Installing
patches...
Patch installation
complete. Total patches
installed: 2
Validating
logfiles...done
SQL Patching tool
complete on Sat Aug 15 08:32:05 2015
[oracle@vm211 ~]$
sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0
Production on Sat Aug 15 08:39:19 2015
Copyright (c) 1982,
2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c
Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the
Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> @pdb
CON_ID
DBID CON_UID GUID NAME OPEN_MODE RES OPEN_TIME CREATE_SCN TOTAL_SIZE
----------
---------- ---------- ---------- ---------- ---------- --- -------------
---------- ----------
2 4130373951 4130373951 1D4DC0EF22
PDB$SEED READ ONLY NO
15-AUG-15 08. 1720762 283115520
6E1AB2E053
32.04.839 AM
D301A8C0CC
D0
3 1010268563 1010268563 1D4DE481E6
E7DB READ WRITE NO 15-AUG-15 08. 1915708
393216000
F91DB3E053
12.06.830 AM
D301A8C07F
E4
4
299604649 299604649 1D4CD9BC62
PROD READ WRITE YES 15-AUG-15 08. 2299813 1053818880
25155FE053
28.31.457 AM
D301A8C0D4
91
SQL> alter pluggable database PROD CLOSE ;
Pluggable database
altered.
SQL> @pdb
CON_ID
DBID CON_UID GUID NAME OPEN_MODE RES OPEN_TIME CREATE_SCN TOTAL_SIZE
----------
---------- ---------- ---------- ---------- ---------- --- -------------
---------- ----------
2 4130373951 4130373951 1D4DC0EF22
PDB$SEED READ ONLY NO
15-AUG-15 08. 1720762 283115520
6E1AB2E053
32.04.839 AM
D301A8C0CC
D0
3 1010268563 1010268563 1D4DE481E6
E7DB READ WRITE NO 15-AUG-15 08. 1915708
393216000
F91DB3E053 12.06.830 AM
D301A8C07F
E4
4
299604649 299604649 1D4CD9BC62
PROD MOUNTED 15-AUG-15 08. 2299813 0
25155FE053 40.55.939 AM
D301A8C0D4
91
SQL> alter pluggable database prod open ;
Pluggable database
altered.
This
time PDB PROD has opened without any warning.
SQL> alter
session set container =PROD ;
Session altered.
SQL> @pdb
CON_ID
DBID CON_UID GUID NAME OPEN_MODE RES OPEN_TIME CREATE_SCN TOTAL_SIZE
----------
---------- ---------- ---------- ---------- ---------- --- -------------
---------- ----------
4
299604649 299604649 1D4CD9BC62
PROD READ WRITE NO 15-AUG-15 08. 2299813 1053818880
25155FE053
41.14.460 AM
D301A8C0D4
91
SQL> @reg
ACTION_TIME ACTION NAMESPACE VERSION
ID COMMENTS BUNDLE_SERIES
--------------------------------
------------- ---------- ------------------ ------------------------
-------------
24-AUG-13
12.03.45.119862 PM APPLY SERVER 11.2.0.4
0 Patchset 11.2.0.2.0 PSU
15-AUG-15
01.47.26.575232 AM APPLY SERVER 11.2.0.4
6 PSU 11.2.0.4.6 PSU
15-AUG-15
02.35.21.118449 AM VIEW INVALIDA 8289601 view invalidation
TE
15-AUG-15
02.37.41.906179 AM UPGRADE SERVER
12.1.0.1.0 Upgraded from 11.2.0.4.0
15-AUG-15
02.43.12.703450 AM APPLY SERVER 12.1.0.1
0 Patchset 12.1.0.0.0 PSU
15-AUG-15
08.31.59.743437 AM APPLY SERVER 12.1.0.1
7 PSU
12.1.0.1.7 PSU
15-AUG-15
08.32.00.599523 AM APPLY SERVER 12.1.0.1
7 PSU
12.1.0.1.7 PSU
7 rows selected.
Hope this will help…. :)
No comments:
Post a Comment