Oracle OJVM +PSU Patch 2018 --
p28689146_121020_Linux-x86-64
28259833-PSU
28440711- OJVM
p6880880_121010_Linux-x86-64 - Opatch for version support
##############################################################################
smrprodb1:/u01 # chown -R oracle:oinstall 28689146/
oracle@smrprodb1:/u01/28689146/28259833> sqlplus sys/system123@smrprodb as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 17:39:44 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB READ WRITE PRIMARY
SQL>
oracle@smrprodb1:/u01/28689146/28259833> lsnrctl stop
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-JAN-2019 17:41:34
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
oracle@smrprodb1:/u01/28689146/28259833> ps -ef |grep lsnr
oracle 6203 4529 0 17:41 pts/0 00:00:00 grep lsnr
oracle@smrprodb1:/u01/28689146/28259833>
smrprodb:/u01/app/oracle/product/12.1.0/dbhome_1:N
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
export PATH=$ORACLE_HOME/perl/bin:$PATH
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail"not executed
Unable to create Patch Object.
Exception occured : Version field of the component "delete" in actions file cannot be <null> or empty. Please check patch metadata.
oracle@smrprodb1:/u01/28689146/28259833> opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_17-58-48PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail"not executed
Unable to create Patch Object.
Exception occured : Version field of the component "delete" in actions file cannot be <null> or empty. Please check patch metadata.
OPatch succeeded.
oracle@smrprodb1:/u01/28689146/28259833>
oracle@smrprodb1:/u01/28689146/28259833> opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-11-55PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
oracle@smrprodb1:/u01/28689146/28259833>
##################################################################################################################
-rw-rw-r-- 1 oracle oinstall 20886 Oct 26 12:50 README.html
oracle@smrprodb1:/u01/28689146> cd 28259833/
oracle@smrprodb1:/u01/28689146/28259833> ll
total 152
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 19769480
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 20299023
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 20831110
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21359755
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21948354
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 22291127
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 23054246
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24006101
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24732082
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25171037
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25755742
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26609783
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 26713565
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26925311
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27338041
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27547329
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 28259833
-rw-rw-r-- 1 oracle oinstall 74685 Oct 12 19:52 README.html
-rw-r--r-- 1 oracle oinstall 21 Oct 8 18:41 README.txt
oracle@smrprodb1:/u01/28689146/28259833> opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-11-55PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
oracle@smrprodb1:/u01/28689146/28259833> ./opatch apply
bash: ./opatch: No such file or directory
oracle@smrprodb1:/u01/28689146/28259833> ll
total 152
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 19769480
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 20299023
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 20831110
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21359755
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21948354
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 22291127
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 23054246
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24006101
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24732082
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25171037
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25755742
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26609783
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 26713565
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26925311
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27338041
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27547329
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 28259833
-rw-rw-r-- 1 oracle oinstall 74685 Oct 12 19:52 README.html
-rw-r--r-- 1 oracle oinstall 21 Oct 8 18:41 README.txt
oracle@smrprodb1:/u01/28689146/28259833> ./opatch apply
bash: ./opatch: No such file or directory
oracle@smrprodb1:/u01/28689146/28259833> . oraenv
ORACLE_SID = [smrprodb] ?
The Oracle base remains unchanged with value /u01/app/oracle
oracle@smrprodb1:/u01/28689146/28259833> opatch apply
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-13-07PM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-13-51PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19769480 20299023 20831110 21359755 21948354 22291127 23054246 24006101 24732082 25171037 25755742 26609783 26713565 26925311 27338041 27547329 28259833
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_1')
Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.util, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Patching component oracle.oraolap, 12.1.0.2.0...
Patching component oracle.xdk.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20299023' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf.ic, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20831110' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '21359755' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.assistants.server, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Applying sub-patch '21948354' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.xdk.rsf, 12.1.0.2.0...
Applying sub-patch '22291127' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ldap.client, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.oraolap, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
Applying sub-patch '23054246' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.dv, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.install.deinstalltool, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...
Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Patching component oracle.ctx.atg, 12.1.0.2.0...
Applying sub-patch '24006101' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.sqlplus, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.network.listener, 12.1.0.2.0...
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.dv, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.sqlplus.ic, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '24732082' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying sub-patch '25171037' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.sqlplus.ic, 12.1.0.2.0...
Patching component oracle.sqlplus, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.ordim.client, 12.1.0.2.0...
Patching component oracle.ordim.client, 12.1.0.2.0...
Patching component oracle.ordim.jai, 12.1.0.2.0...
Patching component oracle.ordim.server, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...
Patching component oracle.javavm.containers, 12.1.0.2.0...
Applying sub-patch '25755742' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ldap.client, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.network.listener, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Applying sub-patch '26609783' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Applying sub-patch '26713565' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.client, 12.1.0.2.0...
Patching component oracle.rdbms.crs, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Patching component oracle.xdk.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Applying sub-patch '26925311' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying sub-patch '27338041' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.assistants.asm, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.assistants.server, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.sqlplus.rsf, 12.1.0.2.0...
Applying sub-patch '27547329' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ctx.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '28259833' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.crs, 12.1.0.2.0...
OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
chmod: changing permissions of `/u01/app/oracle/product/12.1.0/dbhome_1/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)
Composite patch 28259833 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-13-51PM_1.log
OPatch completed with warnings.
oracle@smrprodb1:/u01/28689146/28259833>
oracle@smrprodb1:/u01/28689146/28259833>
oracle@smrprodb1:/u01/28689146/28259833>
oracle@smrprodb1:/u01/28689146/28259833>
oracle@smrprodb1:/u01/28689146/28259833> ll
total 152
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 19769480
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 20299023
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 20831110
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21359755
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21948354
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 22291127
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 23054246
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24006101
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24732082
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25171037
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25755742
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26609783
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 26713565
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26925311
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27338041
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27547329
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 28259833
-rw-rw-r-- 1 oracle oinstall 74685 Oct 12 19:52 README.html
-rw-r--r-- 1 oracle oinstall 21 Oct 8 18:41 README.txt
oracle@smrprodb1:/u01/28689146/28259833> ll
total 152
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 19769480
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 20299023
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 20831110
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21359755
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21948354
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 22291127
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 23054246
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24006101
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24732082
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25171037
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25755742
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26609783
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 26713565
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26925311
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27338041
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27547329
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 28259833
-rw-rw-r-- 1 oracle oinstall 74685 Oct 12 19:52 README.html
-rw-r--r-- 1 oracle oinstall 21 Oct 8 18:41 README.txt
oracle@smrprodb1:/u01/28689146/28259833> ll
total 152
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 19769480
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 20299023
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 20831110
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21359755
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21948354
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 22291127
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 23054246
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24006101
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24732082
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25171037
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25755742
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26609783
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 26713565
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26925311
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27338041
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27547329
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 28259833
-rw-rw-r-- 1 oracle oinstall 74685 Oct 12 19:52 README.html
-rw-r--r-- 1 oracle oinstall 21 Oct 8 18:41 README.txt
oracle@smrprodb1:/u01/28689146/28259833>
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@smrprodb1:/u01/28689146/28259833> cd $ORACLE_HOME/OPatch
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Fri Jan 25 19:28:01 2019
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_7731_2019_01_25_19_28_01/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 181016 in the binary registry and not installed in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
28259833 (DATABASE PATCH SET UPDATE 12.1.0.2.181016)
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 28259833 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28259833/22488632/28259833_apply_SMRPRODB_2019Jan25_19_28_52.log (no errors)
SQL Patching tool complete on Fri Jan 25 19:30:40 2019
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>
oracle@smrprodb1:/root/Desktop> lsnrctl start
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-JAN-2019 19:35:38
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/smrprodb1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=smrprodb1.example.com)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 25-JAN-2019 19:35:38
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/smrprodb1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=smrprodb1.example.com)(PORT=1521)))
The listener supports no services
The command completed successfully
oracle@smrprodb1:/root/Desktop> sqlplus sys/system123@smrprodb as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:35:56 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
oracle@smrprodb1:/root/Desktop>
oracle@smrprodb1:/root/Desktop> sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:36:07 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name from v$database;
NAME
---------
SMRPRODB
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@smrprodb1:/root/Desktop> lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-JAN-2019 19:36:19
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 25-JAN-2019 19:35:38
Uptime 0 days 0 hr. 0 min. 41 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/smrprodb1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=smrprodb1.example.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=smrprodb1.example.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/smrprodb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "smrprodb" has 1 instance(s).
Instance "smrprodb", status READY, has 1 handler(s) for this service...
Service "smrprodbXDB" has 1 instance(s).
Instance "smrprodb", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@smrprodb1:/root/Desktop> sqlplus sys/system123@smrprodb as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:36:34 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
oracle@smrprodb1:/u01/28689146/28440711> opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-39-05PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
oracle@smrprodb1:/u01/28689146/28440711> opatch apply
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-39-19PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 28440711
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 = '/u01/app/oracle/product/12.1.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '28440711' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.sqlj, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.javavm.server, 12.1.0.2.0...
Patching component oracle.javavm.server.core, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.javavm.client, 12.1.0.2.0...
Patching component oracle.dbjava.jdbc, 12.1.0.2.0...
Patching component oracle.dbjava.ic, 12.1.0.2.0...
Patch 28440711 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-39-19PM_1.log
OPatch succeeded.
oracle@smrprodb1:/u01/28689146/28440711>
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1> cd OPatch
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> opatch lsinventory
If 'opatch' is not a typo you can run the following command to lookup the package that contains the binary:
command-not-found opatch
bash: opatch: command not found
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-43-30PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-01-25_19-43-30PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: smrprodb1.example.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 28440711 : applied on Fri Jan 25 19:40:32 IST 2019
Unique Patch ID: 22440644
Patch description: "Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)"
Created on 12 Sep 2018, 13:15:28 hrs PST8PDT
Bugs fixed:
28440711, 28502128, 28502113, 27923320, 27952584, 27952577, 27642235
27475603, 27461789, 27461842, 25649873, 27001733, 27000663, 27000690
26635845, 26637592, 26570171, 26027162, 26023002, 26023025, 25437695
25494413, 25494379, 24917972, 25067795, 24534298, 25076732, 25076756
24315824, 21659726, 24448240, 24448282, 23177536, 22675136, 23265914
23265965, 23727148, 22674709, 22670413, 22670385, 21188537, 22139226
22118835, 22118851, 21555660, 21811517, 19623450, 21566993, 21566944
19176885, 21068507, 21047803, 21047766, 20415564, 20408829, 20408866
19877336, 19855285, 19909862, 19895362, 19895326, 19153980, 19231857
19223010, 19245191, 19699946
Patch 28259833 : applied on Fri Jan 25 19:20:40 IST 2019
Unique Patch ID: 22488632
Patch description: "Database Patch Set Update : 12.1.0.2.181016 (28259833)"
Created on 8 Oct 2018, 06:11:15 hrs PST8PDT
Sub-patch 27547329; "Database Patch Set Update : 12.1.0.2.180717 (27547329)"
Sub-patch 27338041; "Database Patch Set Update : 12.1.0.2.180417 (27338041)"
Sub-patch 26925311; "Database Patch Set Update : 12.1.0.2.180116 (26925311)"
Sub-patch 26713565; "Database Patch Set Update : 12.1.0.2.171017 (26713565)"
Sub-patch 26609783; "Database Patch Set Update : 12.1.0.2.170814 (26609783)"
Sub-patch 25755742; "Database Patch Set Update : 12.1.0.2.170718 (25755742)"
Sub-patch 25171037; "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
Sub-patch 24732082; "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Sub-patch 24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
Sub-patch 23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch 22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19309466, 19902195, 18250893, 25437699, 19383839, 16756406, 18456643
26546664, 22364044, 18845653, 19915271, 20172151, 18417036, 23713236
24796092, 23140259, 19243521, 19658708, 18272672, 21153266, 19174430
22243719, 20688221, 20493163, 21387964, 13542050, 22734547, 21623164
19012119, 19932634, 19869255, 22232606, 18681056, 23324000, 25427662
22068305, 24589081, 19439759, 19303936, 22916353, 24835538, 22353346
21106027, 26444887, 23088803, 22529728, 26256131, 19134173, 20447445
21188584, 19390567, 26513709, 25780343, 19769480, 21097043, 21225209
26245237, 20677396, 19284031, 19450314, 19016730, 20919320, 22075064
22551446, 22721409, 18440095, 22496904, 16439813, 18354830, 20596234
22022760, 20936905, 23197103, 21514877, 26111842, 18990023, 22492533
20173897, 24624166, 17210525, 21260431, 20181030, 25056052, 19370504
21868720, 23068169, 19124589, 19402853, 19888853, 24341675, 17722075
20882568, 25653109, 23026585, 18604692, 20717081, 25546608, 27370965
19081128, 22173980, 23514710, 19178851, 20951038, 22168163, 25161298
20569094, 24308635, 19791377, 19050649, 20920911, 19189525, 19469538
27052607, 20598042, 22458049, 18988834, 23302839, 25307368, 17409174
22729345, 22842151, 19238590, 16941434, 20387265, 24397438, 20673810
23108128, 20356733, 22380919, 18436647, 23065323, 20825533, 19124336
22294260, 24790914, 20284155, 25539063, 17365043, 25914276, 20952966
22961508, 19176223, 21300341, 23237313, 18288842, 22353199, 22083366
25670786, 21419850, 26898563, 19577410, 23294548, 24737064, 19931709
25423453, 25547060, 23533807, 27726780, 24600330, 25600421, 18122373
20043616, 23124895, 18856999, 21450666, 18893947, 20076781, 26633558
26029780, 21196809, 21354456, 23725036, 20464614, 19562381, 24808595
27375542, 19189317, 25669791, 18307021, 21917884, 19708632, 27213224
25633101, 20711718, 18973548, 25982666, 19718981, 22826718, 25655390
23567857, 21773465, 20250147, 19197175, 26263721, 19597439, 21387128
22007324, 19180770, 19879746, 21785691, 20424183, 24285405, 26544823
20322560, 22228324, 23172924, 22520320, 21575362, 25058080, 22365117
22645009, 25165496, 18774543, 20124446, 21429602, 26153977, 19371175
21863727, 18940497, 19074147, 22923409, 25489342, 21380789, 19154375
19044962, 19532017, 19662635, 22374754, 20560611, 25654936, 21492036
18705806, 19578247, 22024071, 22238921, 22809871, 21184223, 23089357
19404068, 18921743, 19065677, 19018447, 19018206, 18308268, 19777862
22223463, 19304354, 22519146, 27199245, 20890311, 22977256, 21142837
20869721, 24555417, 22179537, 21756699, 20217801, 18819908, 22760595
25483815, 23007241, 19593445, 21080143, 27351628, 20031873, 18618122
24737581, 26784509, 24739928, 18966843, 19077215, 20704450, 19068970
20543011, 19023822, 24713381, 20432873, 21756677, 20328248, 18674047
18849537, 25459958, 20315311, 22897344, 27534509, 25178179, 19308965
18948177, 19468991, 20868862, 21780146, 20466628, 21756661, 20397490
23315153, 19706965, 20302006, 24831514, 23240358, 22178855, 19032777
20862087, 19329654, 18974476, 20603378, 20859910, 19307662, 21847223
20281121, 19075256, 19076343, 18866977, 22808310, 25635149, 20844426
20904530, 20441797, 21442094, 25079710, 24674955, 18840932, 18740837
20294666, 25602488, 21517440, 22062517, 27337759, 19174942, 20671094
21889720, 18411216, 20117253, 24386767, 20641666, 25264559, 22092979
21625179, 20879709, 23003979, 20165574, 19272708, 19547370, 22624709
23084507, 20228093, 21281532, 19805359, 19461270, 19434529, 18799063
20378086, 17008068, 21246723, 20831538, 20424899, 20361671, 18674024
19689979, 24411921, 19873610, 16619249, 20562898, 21641414, 21091431
19440586, 22757364, 22175564, 21241052, 20725343, 19561643, 20736227
19399918, 19195895, 20830459, 20017509, 25790353, 21828126, 21665897
25555252, 20746251, 25764020, 25612095, 25357142, 23096938, 19067244
18043064, 21329301, 18885870, 26243698, 26187943, 20324049, 19536415
23709062, 28174827, 20446883, 27314206, 21299490, 25313154, 21744290
18254023, 20591183, 27847259, 19185876, 27207110, 22465352, 24326444
20402832, 19627012, 27441326, 27620950, 16863642, 19639483, 19315691
21479753, 19174521, 20401975, 18306996, 18851894, 27034890, 20581111
20318889, 20936731, 21060755, 26828994, 22256560, 19188927, 27229389
24570598, 25475853, 21172913, 17655240, 21266085, 19028800, 19035573
19366375, 24523374, 25034396, 19289642, 21291274, 18007682, 23521523
20475845, 22148226, 22528741, 25417958, 24652769, 26088426, 19326908
19597583, 17414008, 23019710, 20897759, 26822620, 22046677, 20938170
24825843, 19891090, 21960504, 26318627, 24509056, 19054077, 26262953
22657942, 20428621, 21899588, 19723336, 19835133, 17532734, 19333670
21842017, 19285025, 21373473, 23260854, 19687159, 23061453, 14643995
20977794, 20734332, 17551063, 27548131, 21977392, 24461826, 19676012
20588502, 23315889, 19520602, 23053606, 19841800, 20245930, 19001359
21476308, 26546754, 19393542, 23533524, 21099555, 25429959, 19141838
19644859, 21915719, 19908836, 21421886, 19358317, 19524158, 23548817
25861398, 20803014, 23025340, 19335438, 19058490, 19207117, 23642282
18799993, 25919622, 26569225, 20835241, 24662775, 19475971, 18967382
20347562, 20348653, 19896336, 24812585, 20048359, 21896069, 19524384
25392535, 21147908, 20440930, 25789277, 19171086, 24718260, 17867700
19791273, 21241829, 19591608, 22707244, 18419520, 22296366, 18914624
19571367, 22654475, 21522582, 19501299, 20425790, 19708342, 27997875
16870214, 18202441, 24415926, 18743542, 19001390, 21875360, 25091141
28000269, 19149990, 20382309, 22855193, 16777441, 19606174, 20848335
25495682, 19382851, 20528052, 22762046, 24563422, 23125826, 22503297
25192729, 23338911, 22730454, 19176326, 19048007, 18849970, 21532755
20860659, 22905130, 21263635, 22160989, 18499088, 21059919, 18952989
22894949, 22518784, 25856821, 25484507, 20794034, 19468347, 17533661
19883092, 20657441, 24401351, 21285458, 18051556, 25330273, 19699191
24437510, 20669434, 18964978, 22972770, 20828947, 21373076, 25551676
25492379, 14283239, 25766822, 22922076, 25575628, 20368850, 21239530
20437153, 24848928, 20880215, 20798891, 25606091, 19013183, 21133343
22695831, 24365589, 25634317, 19587324, 20273319, 18542562, 26758193
21063322, 22062026, 20134339, 22077517, 22815955, 24690216, 22507210
20101006, 16354467, 21795111, 27938623, 23501901, 18797519, 25879984
21260397, 25029423, 19354335, 19730508, 22366558, 26658759, 6599380
20717359, 24321547, 21297872, 18964939, 26366517, 21913183, 22366322
20171986, 20603431, 21132297, 25957038, 21542577, 22507234, 23170620
24719736, 25600342, 18868646, 20627866, 26637824, 18110491, 16923858
24642295, 19518079, 20466322, 25823754, 25110233, 24908321, 20842388
17274537, 26575788, 20474192, 21644640, 21794615, 18899974, 20471920
22806698, 19052488, 19503821, 24350620, 20074391, 19157754, 21220620
24316947, 19865345, 19065556, 22816287, 25947799, 20878790, 23492665
21322887, 22305887, 20879889, 24350831, 19578350, 19363645, 21072646
20898391, 19291380, 27060167, 27086138, 22536802, 22087683, 21656630
20373598, 19248799, 22707866, 19155797, 19279273, 18886413, 25490238
20922010, 19990037, 25150925, 20509482, 24717859, 20703000, 22862134
21526048, 24929210, 24560906, 20144308, 21620471, 19670108, 19068610
20267166, 25123585, 20476175, 18549238, 22950945, 19385656, 23528412
19684504, 21174504, 20899461, 20557786, 21911701, 19143550, 20118035
19024808, 25760195, 20009833, 19604659, 16359751, 26039623, 19928926
23314180, 20212067, 24737403, 20480209, 26430737, 20856766, 27169796
21668627, 20877664, 19487147, 23149541, 24577566, 19430401, 19676905
20925795, 21296029, 21629064, 23229229, 22865673, 20708701, 25353983
19280225, 21315084, 19213447, 19989009, 18191823, 27314390, 25775213
24393981, 25639019, 17319928, 19703301, 21626377, 20122715, 6418158
23105538, 26198926, 19258504, 21188532, 23151677, 17890099, 21649497
26446098, 16887946, 26024732, 18791688, 19721304, 19490948, 27012701
19619732, 21164318, 18090142, 21641760, 19818513, 20139391, 24693382
19978542, 23543183, 22165897, 22359063, 19409212, 23035249, 18990693
20470877, 21422580, 21632821, 22351572, 20235511, 23220453, 18604493
23008056, 22901797, 18610915, 20832516, 24801152, 26089440, 20907061
20505778, 19183343, 21787056, 21273804, 25093739, 17835294, 24413809
18371441, 26714910, 24385983, 20413820, 24421668, 25897615, 25643931
23195445, 21281607, 20513399, 20558005, 20093776, 18909599, 20618595
23572982, 19211433, 20331945, 19512341, 22256431, 19637186, 19022470
18607546, 24573817, 19649152, 23115139, 19201867, 21294938, 20898997
18510194, 21842740, 22454326, 24683149, 19534363, 25489607
--------------------------------------------------------------------------------
OPatch succeeded.
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:43:46 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> Connect / as sysdba
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 2923824 bytes
Variable Size 838861520 bytes
Database Buffers 369098752 bytes
Redo Buffers 13852672 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> cd $ORACLE_HOME/OPatch
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Fri Jan 25 19:44:59 2019
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_9436_2019_01_25_19_44_59/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Patch 28440711 (Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)):
Installed in the binary registry only
Bundle series PSU:
ID 181016 in the binary registry and ID 181016 in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
28440711 (Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018))
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 28440711 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28440711/22440644/28440711_apply_SMRPRODB_2019Jan25_19_45_42.log (no errors)
SQL Patching tool complete on Fri Jan 25 19:48:16 2019
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:49:08 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL>
Patch 28440711 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28440711/22440644/28440711_apply_SMRPRODB_2019Jan25_19_45_42.log (no errors)
SQL Patching tool complete on Fri Jan 25 19:48:16 2019
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:49:08 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> Connect / as sysdba
Connected.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 2923824 bytes
Variable Size 889193168 bytes
Database Buffers 318767104 bytes
Redo Buffers 13852672 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./opatch
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-52-27PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-01-25_19-52-27PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: smrprodb1.example.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 28440711 : applied on Fri Jan 25 19:40:32 IST 2019
Unique Patch ID: 22440644
Patch description: "Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)"
Created on 12 Sep 2018, 13:15:28 hrs PST8PDT
Bugs fixed:
28440711, 28502128, 28502113, 27923320, 27952584, 27952577, 27642235
27475603, 27461789, 27461842, 25649873, 27001733, 27000663, 27000690
26635845, 26637592, 26570171, 26027162, 26023002, 26023025, 25437695
25494413, 25494379, 24917972, 25067795, 24534298, 25076732, 25076756
24315824, 21659726, 24448240, 24448282, 23177536, 22675136, 23265914
23265965, 23727148, 22674709, 22670413, 22670385, 21188537, 22139226
22118835, 22118851, 21555660, 21811517, 19623450, 21566993, 21566944
19176885, 21068507, 21047803, 21047766, 20415564, 20408829, 20408866
19877336, 19855285, 19909862, 19895362, 19895326, 19153980, 19231857
19223010, 19245191, 19699946
Patch 28259833 : applied on Fri Jan 25 19:20:40 IST 2019
Unique Patch ID: 22488632
Patch description: "Database Patch Set Update : 12.1.0.2.181016 (28259833)"
Created on 8 Oct 2018, 06:11:15 hrs PST8PDT
Sub-patch 27547329; "Database Patch Set Update : 12.1.0.2.180717 (27547329)"
Sub-patch 27338041; "Database Patch Set Update : 12.1.0.2.180417 (27338041)"
Sub-patch 26925311; "Database Patch Set Update : 12.1.0.2.180116 (26925311)"
Sub-patch 26713565; "Database Patch Set Update : 12.1.0.2.171017 (26713565)"
Sub-patch 26609783; "Database Patch Set Update : 12.1.0.2.170814 (26609783)"
Sub-patch 25755742; "Database Patch Set Update : 12.1.0.2.170718 (25755742)"
Sub-patch 25171037; "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
Sub-patch 24732082; "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Sub-patch 24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
Sub-patch 23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch 22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19309466, 19902195, 18250893, 25437699, 19383839, 16756406, 18456643
26546664, 22364044, 18845653, 19915271, 20172151, 18417036, 23713236
24796092, 23140259, 19243521, 19658708, 18272672, 21153266, 19174430
22243719, 20688221, 20493163, 21387964, 13542050, 22734547, 21623164
19012119, 19932634, 19869255, 22232606, 18681056, 23324000, 25427662
22068305, 24589081, 19439759, 19303936, 22916353, 24835538, 22353346
21106027, 26444887, 23088803, 22529728, 26256131, 19134173, 20447445
21188584, 19390567, 26513709, 25780343, 19769480, 21097043, 21225209
26245237, 20677396, 19284031, 19450314, 19016730, 20919320, 22075064
22551446, 22721409, 18440095, 22496904, 16439813, 18354830, 20596234
22022760, 20936905, 23197103, 21514877, 26111842, 18990023, 22492533
20173897, 24624166, 17210525, 21260431, 20181030, 25056052, 19370504
21868720, 23068169, 19124589, 19402853, 19888853, 24341675, 17722075
20882568, 25653109, 23026585, 18604692, 20717081, 25546608, 27370965
19081128, 22173980, 23514710, 19178851, 20951038, 22168163, 25161298
20569094, 24308635, 19791377, 19050649, 20920911, 19189525, 19469538
27052607, 20598042, 22458049, 18988834, 23302839, 25307368, 17409174
22729345, 22842151, 19238590, 16941434, 20387265, 24397438, 20673810
23108128, 20356733, 22380919, 18436647, 23065323, 20825533, 19124336
22294260, 24790914, 20284155, 25539063, 17365043, 25914276, 20952966
22961508, 19176223, 21300341, 23237313, 18288842, 22353199, 22083366
25670786, 21419850, 26898563, 19577410, 23294548, 24737064, 19931709
25423453, 25547060, 23533807, 27726780, 24600330, 25600421, 18122373
20043616, 23124895, 18856999, 21450666, 18893947, 20076781, 26633558
26029780, 21196809, 21354456, 23725036, 20464614, 19562381, 24808595
27375542, 19189317, 25669791, 18307021, 21917884, 19708632, 27213224
25633101, 20711718, 18973548, 25982666, 19718981, 22826718, 25655390
23567857, 21773465, 20250147, 19197175, 26263721, 19597439, 21387128
22007324, 19180770, 19879746, 21785691, 20424183, 24285405, 26544823
20322560, 22228324, 23172924, 22520320, 21575362, 25058080, 22365117
22645009, 25165496, 18774543, 20124446, 21429602, 26153977, 19371175
21863727, 18940497, 19074147, 22923409, 25489342, 21380789, 19154375
19044962, 19532017, 19662635, 22374754, 20560611, 25654936, 21492036
18705806, 19578247, 22024071, 22238921, 22809871, 21184223, 23089357
19404068, 18921743, 19065677, 19018447, 19018206, 18308268, 19777862
22223463, 19304354, 22519146, 27199245, 20890311, 22977256, 21142837
20869721, 24555417, 22179537, 21756699, 20217801, 18819908, 22760595
25483815, 23007241, 19593445, 21080143, 27351628, 20031873, 18618122
24737581, 26784509, 24739928, 18966843, 19077215, 20704450, 19068970
20543011, 19023822, 24713381, 20432873, 21756677, 20328248, 18674047
18849537, 25459958, 20315311, 22897344, 27534509, 25178179, 19308965
18948177, 19468991, 20868862, 21780146, 20466628, 21756661, 20397490
23315153, 19706965, 20302006, 24831514, 23240358, 22178855, 19032777
20862087, 19329654, 18974476, 20603378, 20859910, 19307662, 21847223
20281121, 19075256, 19076343, 18866977, 22808310, 25635149, 20844426
20904530, 20441797, 21442094, 25079710, 24674955, 18840932, 18740837
20294666, 25602488, 21517440, 22062517, 27337759, 19174942, 20671094
21889720, 18411216, 20117253, 24386767, 20641666, 25264559, 22092979
21625179, 20879709, 23003979, 20165574, 19272708, 19547370, 22624709
23084507, 20228093, 21281532, 19805359, 19461270, 19434529, 18799063
20378086, 17008068, 21246723, 20831538, 20424899, 20361671, 18674024
19689979, 24411921, 19873610, 16619249, 20562898, 21641414, 21091431
19440586, 22757364, 22175564, 21241052, 20725343, 19561643, 20736227
19399918, 19195895, 20830459, 20017509, 25790353, 21828126, 21665897
25555252, 20746251, 25764020, 25612095, 25357142, 23096938, 19067244
18043064, 21329301, 18885870, 26243698, 26187943, 20324049, 19536415
23709062, 28174827, 20446883, 27314206, 21299490, 25313154, 21744290
18254023, 20591183, 27847259, 19185876, 27207110, 22465352, 24326444
20402832, 19627012, 27441326, 27620950, 16863642, 19639483, 19315691
21479753, 19174521, 20401975, 18306996, 18851894, 27034890, 20581111
20318889, 20936731, 21060755, 26828994, 22256560, 19188927, 27229389
24570598, 25475853, 21172913, 17655240, 21266085, 19028800, 19035573
19366375, 24523374, 25034396, 19289642, 21291274, 18007682, 23521523
20475845, 22148226, 22528741, 25417958, 24652769, 26088426, 19326908
19597583, 17414008, 23019710, 20897759, 26822620, 22046677, 20938170
24825843, 19891090, 21960504, 26318627, 24509056, 19054077, 26262953
22657942, 20428621, 21899588, 19723336, 19835133, 17532734, 19333670
21842017, 19285025, 21373473, 23260854, 19687159, 23061453, 14643995
20977794, 20734332, 17551063, 27548131, 21977392, 24461826, 19676012
20588502, 23315889, 19520602, 23053606, 19841800, 20245930, 19001359
21476308, 26546754, 19393542, 23533524, 21099555, 25429959, 19141838
19644859, 21915719, 19908836, 21421886, 19358317, 19524158, 23548817
25861398, 20803014, 23025340, 19335438, 19058490, 19207117, 23642282
18799993, 25919622, 26569225, 20835241, 24662775, 19475971, 18967382
20347562, 20348653, 19896336, 24812585, 20048359, 21896069, 19524384
25392535, 21147908, 20440930, 25789277, 19171086, 24718260, 17867700
19791273, 21241829, 19591608, 22707244, 18419520, 22296366, 18914624
19571367, 22654475, 21522582, 19501299, 20425790, 19708342, 27997875
16870214, 18202441, 24415926, 18743542, 19001390, 21875360, 25091141
28000269, 19149990, 20382309, 22855193, 16777441, 19606174, 20848335
25495682, 19382851, 20528052, 22762046, 24563422, 23125826, 22503297
25192729, 23338911, 22730454, 19176326, 19048007, 18849970, 21532755
20860659, 22905130, 21263635, 22160989, 18499088, 21059919, 18952989
22894949, 22518784, 25856821, 25484507, 20794034, 19468347, 17533661
19883092, 20657441, 24401351, 21285458, 18051556, 25330273, 19699191
24437510, 20669434, 18964978, 22972770, 20828947, 21373076, 25551676
25492379, 14283239, 25766822, 22922076, 25575628, 20368850, 21239530
20437153, 24848928, 20880215, 20798891, 25606091, 19013183, 21133343
22695831, 24365589, 25634317, 19587324, 20273319, 18542562, 26758193
21063322, 22062026, 20134339, 22077517, 22815955, 24690216, 22507210
20101006, 16354467, 21795111, 27938623, 23501901, 18797519, 25879984
21260397, 25029423, 19354335, 19730508, 22366558, 26658759, 6599380
20717359, 24321547, 21297872, 18964939, 26366517, 21913183, 22366322
20171986, 20603431, 21132297, 25957038, 21542577, 22507234, 23170620
24719736, 25600342, 18868646, 20627866, 26637824, 18110491, 16923858
24642295, 19518079, 20466322, 25823754, 25110233, 24908321, 20842388
17274537, 26575788, 20474192, 21644640, 21794615, 18899974, 20471920
22806698, 19052488, 19503821, 24350620, 20074391, 19157754, 21220620
24316947, 19865345, 19065556, 22816287, 25947799, 20878790, 23492665
21322887, 22305887, 20879889, 24350831, 19578350, 19363645, 21072646
20898391, 19291380, 27060167, 27086138, 22536802, 22087683, 21656630
20373598, 19248799, 22707866, 19155797, 19279273, 18886413, 25490238
20922010, 19990037, 25150925, 20509482, 24717859, 20703000, 22862134
21526048, 24929210, 24560906, 20144308, 21620471, 19670108, 19068610
20267166, 25123585, 20476175, 18549238, 22950945, 19385656, 23528412
19684504, 21174504, 20899461, 20557786, 21911701, 19143550, 20118035
19024808, 25760195, 20009833, 19604659, 16359751, 26039623, 19928926
23314180, 20212067, 24737403, 20480209, 26430737, 20856766, 27169796
21668627, 20877664, 19487147, 23149541, 24577566, 19430401, 19676905
20925795, 21296029, 21629064, 23229229, 22865673, 20708701, 25353983
19280225, 21315084, 19213447, 19989009, 18191823, 27314390, 25775213
24393981, 25639019, 17319928, 19703301, 21626377, 20122715, 6418158
23105538, 26198926, 19258504, 21188532, 23151677, 17890099, 21649497
26446098, 16887946, 26024732, 18791688, 19721304, 19490948, 27012701
19619732, 21164318, 18090142, 21641760, 19818513, 20139391, 24693382
19978542, 23543183, 22165897, 22359063, 19409212, 23035249, 18990693
20470877, 21422580, 21632821, 22351572, 20235511, 23220453, 18604493
23008056, 22901797, 18610915, 20832516, 24801152, 26089440, 20907061
20505778, 19183343, 21787056, 21273804, 25093739, 17835294, 24413809
18371441, 26714910, 24385983, 20413820, 24421668, 25897615, 25643931
23195445, 21281607, 20513399, 20558005, 20093776, 18909599, 20618595
23572982, 19211433, 20331945, 19512341, 22256431, 19637186, 19022470
18607546, 24573817, 19649152, 23115139, 19201867, 21294938, 20898997
18510194, 21842740, 22454326, 24683149, 19534363, 25489607
--------------------------------------------------------------------------------
OPatch succeeded.
p28689146_121020_Linux-x86-64
28259833-PSU
28440711- OJVM
p6880880_121010_Linux-x86-64 - Opatch for version support
##############################################################################
smrprodb1:/u01 # chown -R oracle:oinstall 28689146/
oracle@smrprodb1:/u01/28689146/28259833> sqlplus sys/system123@smrprodb as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 17:39:44 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB READ WRITE PRIMARY
SQL>
oracle@smrprodb1:/u01/28689146/28259833> lsnrctl stop
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-JAN-2019 17:41:34
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
oracle@smrprodb1:/u01/28689146/28259833> ps -ef |grep lsnr
oracle 6203 4529 0 17:41 pts/0 00:00:00 grep lsnr
oracle@smrprodb1:/u01/28689146/28259833>
smrprodb:/u01/app/oracle/product/12.1.0/dbhome_1:N
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
export PATH=$ORACLE_HOME/perl/bin:$PATH
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail"not executed
Unable to create Patch Object.
Exception occured : Version field of the component "delete" in actions file cannot be <null> or empty. Please check patch metadata.
oracle@smrprodb1:/u01/28689146/28259833> opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_17-58-48PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail"not executed
Unable to create Patch Object.
Exception occured : Version field of the component "delete" in actions file cannot be <null> or empty. Please check patch metadata.
OPatch succeeded.
oracle@smrprodb1:/u01/28689146/28259833>
oracle@smrprodb1:/u01/28689146/28259833> opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-11-55PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
oracle@smrprodb1:/u01/28689146/28259833>
##################################################################################################################
-rw-rw-r-- 1 oracle oinstall 20886 Oct 26 12:50 README.html
oracle@smrprodb1:/u01/28689146> cd 28259833/
oracle@smrprodb1:/u01/28689146/28259833> ll
total 152
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 19769480
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 20299023
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 20831110
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21359755
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21948354
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 22291127
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 23054246
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24006101
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24732082
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25171037
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25755742
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26609783
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 26713565
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26925311
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27338041
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27547329
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 28259833
-rw-rw-r-- 1 oracle oinstall 74685 Oct 12 19:52 README.html
-rw-r--r-- 1 oracle oinstall 21 Oct 8 18:41 README.txt
oracle@smrprodb1:/u01/28689146/28259833> opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-11-55PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
oracle@smrprodb1:/u01/28689146/28259833> ./opatch apply
bash: ./opatch: No such file or directory
oracle@smrprodb1:/u01/28689146/28259833> ll
total 152
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 19769480
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 20299023
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 20831110
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21359755
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21948354
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 22291127
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 23054246
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24006101
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24732082
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25171037
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25755742
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26609783
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 26713565
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26925311
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27338041
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27547329
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 28259833
-rw-rw-r-- 1 oracle oinstall 74685 Oct 12 19:52 README.html
-rw-r--r-- 1 oracle oinstall 21 Oct 8 18:41 README.txt
oracle@smrprodb1:/u01/28689146/28259833> ./opatch apply
bash: ./opatch: No such file or directory
oracle@smrprodb1:/u01/28689146/28259833> . oraenv
ORACLE_SID = [smrprodb] ?
The Oracle base remains unchanged with value /u01/app/oracle
oracle@smrprodb1:/u01/28689146/28259833> opatch apply
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-13-07PM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-13-51PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19769480 20299023 20831110 21359755 21948354 22291127 23054246 24006101 24732082 25171037 25755742 26609783 26713565 26925311 27338041 27547329 28259833
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_1')
Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.util, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Patching component oracle.oraolap, 12.1.0.2.0...
Patching component oracle.xdk.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20299023' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf.ic, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20831110' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '21359755' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.assistants.server, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Applying sub-patch '21948354' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.xdk.rsf, 12.1.0.2.0...
Applying sub-patch '22291127' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ldap.client, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.oraolap, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
Applying sub-patch '23054246' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.dv, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.install.deinstalltool, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...
Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Patching component oracle.ctx.atg, 12.1.0.2.0...
Applying sub-patch '24006101' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.sqlplus, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.network.listener, 12.1.0.2.0...
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.dv, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.sqlplus.ic, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '24732082' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying sub-patch '25171037' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.sqlplus.ic, 12.1.0.2.0...
Patching component oracle.sqlplus, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.ordim.client, 12.1.0.2.0...
Patching component oracle.ordim.client, 12.1.0.2.0...
Patching component oracle.ordim.jai, 12.1.0.2.0...
Patching component oracle.ordim.server, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...
Patching component oracle.javavm.containers, 12.1.0.2.0...
Applying sub-patch '25755742' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ldap.client, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.network.listener, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Applying sub-patch '26609783' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Applying sub-patch '26713565' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.client, 12.1.0.2.0...
Patching component oracle.rdbms.crs, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Patching component oracle.xdk.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Applying sub-patch '26925311' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying sub-patch '27338041' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.assistants.asm, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.assistants.server, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.sqlplus.rsf, 12.1.0.2.0...
Applying sub-patch '27547329' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ctx.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '28259833' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.crs, 12.1.0.2.0...
OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
chmod: changing permissions of `/u01/app/oracle/product/12.1.0/dbhome_1/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)
Composite patch 28259833 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-13-51PM_1.log
OPatch completed with warnings.
oracle@smrprodb1:/u01/28689146/28259833>
oracle@smrprodb1:/u01/28689146/28259833>
oracle@smrprodb1:/u01/28689146/28259833>
oracle@smrprodb1:/u01/28689146/28259833>
oracle@smrprodb1:/u01/28689146/28259833> ll
total 152
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 19769480
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 20299023
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 20831110
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21359755
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21948354
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 22291127
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 23054246
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24006101
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24732082
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25171037
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25755742
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26609783
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 26713565
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26925311
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27338041
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27547329
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 28259833
-rw-rw-r-- 1 oracle oinstall 74685 Oct 12 19:52 README.html
-rw-r--r-- 1 oracle oinstall 21 Oct 8 18:41 README.txt
oracle@smrprodb1:/u01/28689146/28259833> ll
total 152
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 19769480
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 20299023
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 20831110
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21359755
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21948354
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 22291127
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 23054246
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24006101
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24732082
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25171037
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25755742
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26609783
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 26713565
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26925311
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27338041
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27547329
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 28259833
-rw-rw-r-- 1 oracle oinstall 74685 Oct 12 19:52 README.html
-rw-r--r-- 1 oracle oinstall 21 Oct 8 18:41 README.txt
oracle@smrprodb1:/u01/28689146/28259833> ll
total 152
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 19769480
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 20299023
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 20831110
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21359755
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 21948354
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 22291127
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 23054246
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24006101
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 24732082
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25171037
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 25755742
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26609783
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:42 26713565
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 26925311
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27338041
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 27547329
drwxr-x--- 4 oracle oinstall 4096 Oct 8 18:41 28259833
-rw-rw-r-- 1 oracle oinstall 74685 Oct 12 19:52 README.html
-rw-r--r-- 1 oracle oinstall 21 Oct 8 18:41 README.txt
oracle@smrprodb1:/u01/28689146/28259833>
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@smrprodb1:/u01/28689146/28259833> cd $ORACLE_HOME/OPatch
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Fri Jan 25 19:28:01 2019
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_7731_2019_01_25_19_28_01/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 181016 in the binary registry and not installed in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
28259833 (DATABASE PATCH SET UPDATE 12.1.0.2.181016)
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 28259833 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28259833/22488632/28259833_apply_SMRPRODB_2019Jan25_19_28_52.log (no errors)
SQL Patching tool complete on Fri Jan 25 19:30:40 2019
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>
oracle@smrprodb1:/root/Desktop> lsnrctl start
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-JAN-2019 19:35:38
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/smrprodb1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=smrprodb1.example.com)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 25-JAN-2019 19:35:38
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/smrprodb1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=smrprodb1.example.com)(PORT=1521)))
The listener supports no services
The command completed successfully
oracle@smrprodb1:/root/Desktop> sqlplus sys/system123@smrprodb as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:35:56 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
oracle@smrprodb1:/root/Desktop>
oracle@smrprodb1:/root/Desktop> sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:36:07 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name from v$database;
NAME
---------
SMRPRODB
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@smrprodb1:/root/Desktop> lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-JAN-2019 19:36:19
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 25-JAN-2019 19:35:38
Uptime 0 days 0 hr. 0 min. 41 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/smrprodb1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=smrprodb1.example.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=smrprodb1.example.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/smrprodb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "smrprodb" has 1 instance(s).
Instance "smrprodb", status READY, has 1 handler(s) for this service...
Service "smrprodbXDB" has 1 instance(s).
Instance "smrprodb", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@smrprodb1:/root/Desktop> sqlplus sys/system123@smrprodb as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:36:34 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
oracle@smrprodb1:/u01/28689146/28440711> opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-39-05PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
oracle@smrprodb1:/u01/28689146/28440711> opatch apply
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-39-19PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 28440711
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 = '/u01/app/oracle/product/12.1.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '28440711' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.sqlj, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.javavm.server, 12.1.0.2.0...
Patching component oracle.javavm.server.core, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.javavm.client, 12.1.0.2.0...
Patching component oracle.dbjava.jdbc, 12.1.0.2.0...
Patching component oracle.dbjava.ic, 12.1.0.2.0...
Patch 28440711 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-39-19PM_1.log
OPatch succeeded.
oracle@smrprodb1:/u01/28689146/28440711>
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1> cd OPatch
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> opatch lsinventory
If 'opatch' is not a typo you can run the following command to lookup the package that contains the binary:
command-not-found opatch
bash: opatch: command not found
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-43-30PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-01-25_19-43-30PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: smrprodb1.example.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 28440711 : applied on Fri Jan 25 19:40:32 IST 2019
Unique Patch ID: 22440644
Patch description: "Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)"
Created on 12 Sep 2018, 13:15:28 hrs PST8PDT
Bugs fixed:
28440711, 28502128, 28502113, 27923320, 27952584, 27952577, 27642235
27475603, 27461789, 27461842, 25649873, 27001733, 27000663, 27000690
26635845, 26637592, 26570171, 26027162, 26023002, 26023025, 25437695
25494413, 25494379, 24917972, 25067795, 24534298, 25076732, 25076756
24315824, 21659726, 24448240, 24448282, 23177536, 22675136, 23265914
23265965, 23727148, 22674709, 22670413, 22670385, 21188537, 22139226
22118835, 22118851, 21555660, 21811517, 19623450, 21566993, 21566944
19176885, 21068507, 21047803, 21047766, 20415564, 20408829, 20408866
19877336, 19855285, 19909862, 19895362, 19895326, 19153980, 19231857
19223010, 19245191, 19699946
Patch 28259833 : applied on Fri Jan 25 19:20:40 IST 2019
Unique Patch ID: 22488632
Patch description: "Database Patch Set Update : 12.1.0.2.181016 (28259833)"
Created on 8 Oct 2018, 06:11:15 hrs PST8PDT
Sub-patch 27547329; "Database Patch Set Update : 12.1.0.2.180717 (27547329)"
Sub-patch 27338041; "Database Patch Set Update : 12.1.0.2.180417 (27338041)"
Sub-patch 26925311; "Database Patch Set Update : 12.1.0.2.180116 (26925311)"
Sub-patch 26713565; "Database Patch Set Update : 12.1.0.2.171017 (26713565)"
Sub-patch 26609783; "Database Patch Set Update : 12.1.0.2.170814 (26609783)"
Sub-patch 25755742; "Database Patch Set Update : 12.1.0.2.170718 (25755742)"
Sub-patch 25171037; "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
Sub-patch 24732082; "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Sub-patch 24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
Sub-patch 23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch 22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19309466, 19902195, 18250893, 25437699, 19383839, 16756406, 18456643
26546664, 22364044, 18845653, 19915271, 20172151, 18417036, 23713236
24796092, 23140259, 19243521, 19658708, 18272672, 21153266, 19174430
22243719, 20688221, 20493163, 21387964, 13542050, 22734547, 21623164
19012119, 19932634, 19869255, 22232606, 18681056, 23324000, 25427662
22068305, 24589081, 19439759, 19303936, 22916353, 24835538, 22353346
21106027, 26444887, 23088803, 22529728, 26256131, 19134173, 20447445
21188584, 19390567, 26513709, 25780343, 19769480, 21097043, 21225209
26245237, 20677396, 19284031, 19450314, 19016730, 20919320, 22075064
22551446, 22721409, 18440095, 22496904, 16439813, 18354830, 20596234
22022760, 20936905, 23197103, 21514877, 26111842, 18990023, 22492533
20173897, 24624166, 17210525, 21260431, 20181030, 25056052, 19370504
21868720, 23068169, 19124589, 19402853, 19888853, 24341675, 17722075
20882568, 25653109, 23026585, 18604692, 20717081, 25546608, 27370965
19081128, 22173980, 23514710, 19178851, 20951038, 22168163, 25161298
20569094, 24308635, 19791377, 19050649, 20920911, 19189525, 19469538
27052607, 20598042, 22458049, 18988834, 23302839, 25307368, 17409174
22729345, 22842151, 19238590, 16941434, 20387265, 24397438, 20673810
23108128, 20356733, 22380919, 18436647, 23065323, 20825533, 19124336
22294260, 24790914, 20284155, 25539063, 17365043, 25914276, 20952966
22961508, 19176223, 21300341, 23237313, 18288842, 22353199, 22083366
25670786, 21419850, 26898563, 19577410, 23294548, 24737064, 19931709
25423453, 25547060, 23533807, 27726780, 24600330, 25600421, 18122373
20043616, 23124895, 18856999, 21450666, 18893947, 20076781, 26633558
26029780, 21196809, 21354456, 23725036, 20464614, 19562381, 24808595
27375542, 19189317, 25669791, 18307021, 21917884, 19708632, 27213224
25633101, 20711718, 18973548, 25982666, 19718981, 22826718, 25655390
23567857, 21773465, 20250147, 19197175, 26263721, 19597439, 21387128
22007324, 19180770, 19879746, 21785691, 20424183, 24285405, 26544823
20322560, 22228324, 23172924, 22520320, 21575362, 25058080, 22365117
22645009, 25165496, 18774543, 20124446, 21429602, 26153977, 19371175
21863727, 18940497, 19074147, 22923409, 25489342, 21380789, 19154375
19044962, 19532017, 19662635, 22374754, 20560611, 25654936, 21492036
18705806, 19578247, 22024071, 22238921, 22809871, 21184223, 23089357
19404068, 18921743, 19065677, 19018447, 19018206, 18308268, 19777862
22223463, 19304354, 22519146, 27199245, 20890311, 22977256, 21142837
20869721, 24555417, 22179537, 21756699, 20217801, 18819908, 22760595
25483815, 23007241, 19593445, 21080143, 27351628, 20031873, 18618122
24737581, 26784509, 24739928, 18966843, 19077215, 20704450, 19068970
20543011, 19023822, 24713381, 20432873, 21756677, 20328248, 18674047
18849537, 25459958, 20315311, 22897344, 27534509, 25178179, 19308965
18948177, 19468991, 20868862, 21780146, 20466628, 21756661, 20397490
23315153, 19706965, 20302006, 24831514, 23240358, 22178855, 19032777
20862087, 19329654, 18974476, 20603378, 20859910, 19307662, 21847223
20281121, 19075256, 19076343, 18866977, 22808310, 25635149, 20844426
20904530, 20441797, 21442094, 25079710, 24674955, 18840932, 18740837
20294666, 25602488, 21517440, 22062517, 27337759, 19174942, 20671094
21889720, 18411216, 20117253, 24386767, 20641666, 25264559, 22092979
21625179, 20879709, 23003979, 20165574, 19272708, 19547370, 22624709
23084507, 20228093, 21281532, 19805359, 19461270, 19434529, 18799063
20378086, 17008068, 21246723, 20831538, 20424899, 20361671, 18674024
19689979, 24411921, 19873610, 16619249, 20562898, 21641414, 21091431
19440586, 22757364, 22175564, 21241052, 20725343, 19561643, 20736227
19399918, 19195895, 20830459, 20017509, 25790353, 21828126, 21665897
25555252, 20746251, 25764020, 25612095, 25357142, 23096938, 19067244
18043064, 21329301, 18885870, 26243698, 26187943, 20324049, 19536415
23709062, 28174827, 20446883, 27314206, 21299490, 25313154, 21744290
18254023, 20591183, 27847259, 19185876, 27207110, 22465352, 24326444
20402832, 19627012, 27441326, 27620950, 16863642, 19639483, 19315691
21479753, 19174521, 20401975, 18306996, 18851894, 27034890, 20581111
20318889, 20936731, 21060755, 26828994, 22256560, 19188927, 27229389
24570598, 25475853, 21172913, 17655240, 21266085, 19028800, 19035573
19366375, 24523374, 25034396, 19289642, 21291274, 18007682, 23521523
20475845, 22148226, 22528741, 25417958, 24652769, 26088426, 19326908
19597583, 17414008, 23019710, 20897759, 26822620, 22046677, 20938170
24825843, 19891090, 21960504, 26318627, 24509056, 19054077, 26262953
22657942, 20428621, 21899588, 19723336, 19835133, 17532734, 19333670
21842017, 19285025, 21373473, 23260854, 19687159, 23061453, 14643995
20977794, 20734332, 17551063, 27548131, 21977392, 24461826, 19676012
20588502, 23315889, 19520602, 23053606, 19841800, 20245930, 19001359
21476308, 26546754, 19393542, 23533524, 21099555, 25429959, 19141838
19644859, 21915719, 19908836, 21421886, 19358317, 19524158, 23548817
25861398, 20803014, 23025340, 19335438, 19058490, 19207117, 23642282
18799993, 25919622, 26569225, 20835241, 24662775, 19475971, 18967382
20347562, 20348653, 19896336, 24812585, 20048359, 21896069, 19524384
25392535, 21147908, 20440930, 25789277, 19171086, 24718260, 17867700
19791273, 21241829, 19591608, 22707244, 18419520, 22296366, 18914624
19571367, 22654475, 21522582, 19501299, 20425790, 19708342, 27997875
16870214, 18202441, 24415926, 18743542, 19001390, 21875360, 25091141
28000269, 19149990, 20382309, 22855193, 16777441, 19606174, 20848335
25495682, 19382851, 20528052, 22762046, 24563422, 23125826, 22503297
25192729, 23338911, 22730454, 19176326, 19048007, 18849970, 21532755
20860659, 22905130, 21263635, 22160989, 18499088, 21059919, 18952989
22894949, 22518784, 25856821, 25484507, 20794034, 19468347, 17533661
19883092, 20657441, 24401351, 21285458, 18051556, 25330273, 19699191
24437510, 20669434, 18964978, 22972770, 20828947, 21373076, 25551676
25492379, 14283239, 25766822, 22922076, 25575628, 20368850, 21239530
20437153, 24848928, 20880215, 20798891, 25606091, 19013183, 21133343
22695831, 24365589, 25634317, 19587324, 20273319, 18542562, 26758193
21063322, 22062026, 20134339, 22077517, 22815955, 24690216, 22507210
20101006, 16354467, 21795111, 27938623, 23501901, 18797519, 25879984
21260397, 25029423, 19354335, 19730508, 22366558, 26658759, 6599380
20717359, 24321547, 21297872, 18964939, 26366517, 21913183, 22366322
20171986, 20603431, 21132297, 25957038, 21542577, 22507234, 23170620
24719736, 25600342, 18868646, 20627866, 26637824, 18110491, 16923858
24642295, 19518079, 20466322, 25823754, 25110233, 24908321, 20842388
17274537, 26575788, 20474192, 21644640, 21794615, 18899974, 20471920
22806698, 19052488, 19503821, 24350620, 20074391, 19157754, 21220620
24316947, 19865345, 19065556, 22816287, 25947799, 20878790, 23492665
21322887, 22305887, 20879889, 24350831, 19578350, 19363645, 21072646
20898391, 19291380, 27060167, 27086138, 22536802, 22087683, 21656630
20373598, 19248799, 22707866, 19155797, 19279273, 18886413, 25490238
20922010, 19990037, 25150925, 20509482, 24717859, 20703000, 22862134
21526048, 24929210, 24560906, 20144308, 21620471, 19670108, 19068610
20267166, 25123585, 20476175, 18549238, 22950945, 19385656, 23528412
19684504, 21174504, 20899461, 20557786, 21911701, 19143550, 20118035
19024808, 25760195, 20009833, 19604659, 16359751, 26039623, 19928926
23314180, 20212067, 24737403, 20480209, 26430737, 20856766, 27169796
21668627, 20877664, 19487147, 23149541, 24577566, 19430401, 19676905
20925795, 21296029, 21629064, 23229229, 22865673, 20708701, 25353983
19280225, 21315084, 19213447, 19989009, 18191823, 27314390, 25775213
24393981, 25639019, 17319928, 19703301, 21626377, 20122715, 6418158
23105538, 26198926, 19258504, 21188532, 23151677, 17890099, 21649497
26446098, 16887946, 26024732, 18791688, 19721304, 19490948, 27012701
19619732, 21164318, 18090142, 21641760, 19818513, 20139391, 24693382
19978542, 23543183, 22165897, 22359063, 19409212, 23035249, 18990693
20470877, 21422580, 21632821, 22351572, 20235511, 23220453, 18604493
23008056, 22901797, 18610915, 20832516, 24801152, 26089440, 20907061
20505778, 19183343, 21787056, 21273804, 25093739, 17835294, 24413809
18371441, 26714910, 24385983, 20413820, 24421668, 25897615, 25643931
23195445, 21281607, 20513399, 20558005, 20093776, 18909599, 20618595
23572982, 19211433, 20331945, 19512341, 22256431, 19637186, 19022470
18607546, 24573817, 19649152, 23115139, 19201867, 21294938, 20898997
18510194, 21842740, 22454326, 24683149, 19534363, 25489607
--------------------------------------------------------------------------------
OPatch succeeded.
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:43:46 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> Connect / as sysdba
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 2923824 bytes
Variable Size 838861520 bytes
Database Buffers 369098752 bytes
Redo Buffers 13852672 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> cd $ORACLE_HOME/OPatch
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Fri Jan 25 19:44:59 2019
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_9436_2019_01_25_19_44_59/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Patch 28440711 (Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)):
Installed in the binary registry only
Bundle series PSU:
ID 181016 in the binary registry and ID 181016 in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
28440711 (Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018))
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 28440711 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28440711/22440644/28440711_apply_SMRPRODB_2019Jan25_19_45_42.log (no errors)
SQL Patching tool complete on Fri Jan 25 19:48:16 2019
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:49:08 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL>
Patch 28440711 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28440711/22440644/28440711_apply_SMRPRODB_2019Jan25_19_45_42.log (no errors)
SQL Patching tool complete on Fri Jan 25 19:48:16 2019
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 19:49:08 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> Connect / as sysdba
Connected.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 2923824 bytes
Variable Size 889193168 bytes
Database Buffers 318767104 bytes
Redo Buffers 13852672 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./opatch
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle@smrprodb1:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-01-25_19-52-27PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-01-25_19-52-27PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: smrprodb1.example.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 28440711 : applied on Fri Jan 25 19:40:32 IST 2019
Unique Patch ID: 22440644
Patch description: "Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)"
Created on 12 Sep 2018, 13:15:28 hrs PST8PDT
Bugs fixed:
28440711, 28502128, 28502113, 27923320, 27952584, 27952577, 27642235
27475603, 27461789, 27461842, 25649873, 27001733, 27000663, 27000690
26635845, 26637592, 26570171, 26027162, 26023002, 26023025, 25437695
25494413, 25494379, 24917972, 25067795, 24534298, 25076732, 25076756
24315824, 21659726, 24448240, 24448282, 23177536, 22675136, 23265914
23265965, 23727148, 22674709, 22670413, 22670385, 21188537, 22139226
22118835, 22118851, 21555660, 21811517, 19623450, 21566993, 21566944
19176885, 21068507, 21047803, 21047766, 20415564, 20408829, 20408866
19877336, 19855285, 19909862, 19895362, 19895326, 19153980, 19231857
19223010, 19245191, 19699946
Patch 28259833 : applied on Fri Jan 25 19:20:40 IST 2019
Unique Patch ID: 22488632
Patch description: "Database Patch Set Update : 12.1.0.2.181016 (28259833)"
Created on 8 Oct 2018, 06:11:15 hrs PST8PDT
Sub-patch 27547329; "Database Patch Set Update : 12.1.0.2.180717 (27547329)"
Sub-patch 27338041; "Database Patch Set Update : 12.1.0.2.180417 (27338041)"
Sub-patch 26925311; "Database Patch Set Update : 12.1.0.2.180116 (26925311)"
Sub-patch 26713565; "Database Patch Set Update : 12.1.0.2.171017 (26713565)"
Sub-patch 26609783; "Database Patch Set Update : 12.1.0.2.170814 (26609783)"
Sub-patch 25755742; "Database Patch Set Update : 12.1.0.2.170718 (25755742)"
Sub-patch 25171037; "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
Sub-patch 24732082; "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Sub-patch 24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
Sub-patch 23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch 22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19309466, 19902195, 18250893, 25437699, 19383839, 16756406, 18456643
26546664, 22364044, 18845653, 19915271, 20172151, 18417036, 23713236
24796092, 23140259, 19243521, 19658708, 18272672, 21153266, 19174430
22243719, 20688221, 20493163, 21387964, 13542050, 22734547, 21623164
19012119, 19932634, 19869255, 22232606, 18681056, 23324000, 25427662
22068305, 24589081, 19439759, 19303936, 22916353, 24835538, 22353346
21106027, 26444887, 23088803, 22529728, 26256131, 19134173, 20447445
21188584, 19390567, 26513709, 25780343, 19769480, 21097043, 21225209
26245237, 20677396, 19284031, 19450314, 19016730, 20919320, 22075064
22551446, 22721409, 18440095, 22496904, 16439813, 18354830, 20596234
22022760, 20936905, 23197103, 21514877, 26111842, 18990023, 22492533
20173897, 24624166, 17210525, 21260431, 20181030, 25056052, 19370504
21868720, 23068169, 19124589, 19402853, 19888853, 24341675, 17722075
20882568, 25653109, 23026585, 18604692, 20717081, 25546608, 27370965
19081128, 22173980, 23514710, 19178851, 20951038, 22168163, 25161298
20569094, 24308635, 19791377, 19050649, 20920911, 19189525, 19469538
27052607, 20598042, 22458049, 18988834, 23302839, 25307368, 17409174
22729345, 22842151, 19238590, 16941434, 20387265, 24397438, 20673810
23108128, 20356733, 22380919, 18436647, 23065323, 20825533, 19124336
22294260, 24790914, 20284155, 25539063, 17365043, 25914276, 20952966
22961508, 19176223, 21300341, 23237313, 18288842, 22353199, 22083366
25670786, 21419850, 26898563, 19577410, 23294548, 24737064, 19931709
25423453, 25547060, 23533807, 27726780, 24600330, 25600421, 18122373
20043616, 23124895, 18856999, 21450666, 18893947, 20076781, 26633558
26029780, 21196809, 21354456, 23725036, 20464614, 19562381, 24808595
27375542, 19189317, 25669791, 18307021, 21917884, 19708632, 27213224
25633101, 20711718, 18973548, 25982666, 19718981, 22826718, 25655390
23567857, 21773465, 20250147, 19197175, 26263721, 19597439, 21387128
22007324, 19180770, 19879746, 21785691, 20424183, 24285405, 26544823
20322560, 22228324, 23172924, 22520320, 21575362, 25058080, 22365117
22645009, 25165496, 18774543, 20124446, 21429602, 26153977, 19371175
21863727, 18940497, 19074147, 22923409, 25489342, 21380789, 19154375
19044962, 19532017, 19662635, 22374754, 20560611, 25654936, 21492036
18705806, 19578247, 22024071, 22238921, 22809871, 21184223, 23089357
19404068, 18921743, 19065677, 19018447, 19018206, 18308268, 19777862
22223463, 19304354, 22519146, 27199245, 20890311, 22977256, 21142837
20869721, 24555417, 22179537, 21756699, 20217801, 18819908, 22760595
25483815, 23007241, 19593445, 21080143, 27351628, 20031873, 18618122
24737581, 26784509, 24739928, 18966843, 19077215, 20704450, 19068970
20543011, 19023822, 24713381, 20432873, 21756677, 20328248, 18674047
18849537, 25459958, 20315311, 22897344, 27534509, 25178179, 19308965
18948177, 19468991, 20868862, 21780146, 20466628, 21756661, 20397490
23315153, 19706965, 20302006, 24831514, 23240358, 22178855, 19032777
20862087, 19329654, 18974476, 20603378, 20859910, 19307662, 21847223
20281121, 19075256, 19076343, 18866977, 22808310, 25635149, 20844426
20904530, 20441797, 21442094, 25079710, 24674955, 18840932, 18740837
20294666, 25602488, 21517440, 22062517, 27337759, 19174942, 20671094
21889720, 18411216, 20117253, 24386767, 20641666, 25264559, 22092979
21625179, 20879709, 23003979, 20165574, 19272708, 19547370, 22624709
23084507, 20228093, 21281532, 19805359, 19461270, 19434529, 18799063
20378086, 17008068, 21246723, 20831538, 20424899, 20361671, 18674024
19689979, 24411921, 19873610, 16619249, 20562898, 21641414, 21091431
19440586, 22757364, 22175564, 21241052, 20725343, 19561643, 20736227
19399918, 19195895, 20830459, 20017509, 25790353, 21828126, 21665897
25555252, 20746251, 25764020, 25612095, 25357142, 23096938, 19067244
18043064, 21329301, 18885870, 26243698, 26187943, 20324049, 19536415
23709062, 28174827, 20446883, 27314206, 21299490, 25313154, 21744290
18254023, 20591183, 27847259, 19185876, 27207110, 22465352, 24326444
20402832, 19627012, 27441326, 27620950, 16863642, 19639483, 19315691
21479753, 19174521, 20401975, 18306996, 18851894, 27034890, 20581111
20318889, 20936731, 21060755, 26828994, 22256560, 19188927, 27229389
24570598, 25475853, 21172913, 17655240, 21266085, 19028800, 19035573
19366375, 24523374, 25034396, 19289642, 21291274, 18007682, 23521523
20475845, 22148226, 22528741, 25417958, 24652769, 26088426, 19326908
19597583, 17414008, 23019710, 20897759, 26822620, 22046677, 20938170
24825843, 19891090, 21960504, 26318627, 24509056, 19054077, 26262953
22657942, 20428621, 21899588, 19723336, 19835133, 17532734, 19333670
21842017, 19285025, 21373473, 23260854, 19687159, 23061453, 14643995
20977794, 20734332, 17551063, 27548131, 21977392, 24461826, 19676012
20588502, 23315889, 19520602, 23053606, 19841800, 20245930, 19001359
21476308, 26546754, 19393542, 23533524, 21099555, 25429959, 19141838
19644859, 21915719, 19908836, 21421886, 19358317, 19524158, 23548817
25861398, 20803014, 23025340, 19335438, 19058490, 19207117, 23642282
18799993, 25919622, 26569225, 20835241, 24662775, 19475971, 18967382
20347562, 20348653, 19896336, 24812585, 20048359, 21896069, 19524384
25392535, 21147908, 20440930, 25789277, 19171086, 24718260, 17867700
19791273, 21241829, 19591608, 22707244, 18419520, 22296366, 18914624
19571367, 22654475, 21522582, 19501299, 20425790, 19708342, 27997875
16870214, 18202441, 24415926, 18743542, 19001390, 21875360, 25091141
28000269, 19149990, 20382309, 22855193, 16777441, 19606174, 20848335
25495682, 19382851, 20528052, 22762046, 24563422, 23125826, 22503297
25192729, 23338911, 22730454, 19176326, 19048007, 18849970, 21532755
20860659, 22905130, 21263635, 22160989, 18499088, 21059919, 18952989
22894949, 22518784, 25856821, 25484507, 20794034, 19468347, 17533661
19883092, 20657441, 24401351, 21285458, 18051556, 25330273, 19699191
24437510, 20669434, 18964978, 22972770, 20828947, 21373076, 25551676
25492379, 14283239, 25766822, 22922076, 25575628, 20368850, 21239530
20437153, 24848928, 20880215, 20798891, 25606091, 19013183, 21133343
22695831, 24365589, 25634317, 19587324, 20273319, 18542562, 26758193
21063322, 22062026, 20134339, 22077517, 22815955, 24690216, 22507210
20101006, 16354467, 21795111, 27938623, 23501901, 18797519, 25879984
21260397, 25029423, 19354335, 19730508, 22366558, 26658759, 6599380
20717359, 24321547, 21297872, 18964939, 26366517, 21913183, 22366322
20171986, 20603431, 21132297, 25957038, 21542577, 22507234, 23170620
24719736, 25600342, 18868646, 20627866, 26637824, 18110491, 16923858
24642295, 19518079, 20466322, 25823754, 25110233, 24908321, 20842388
17274537, 26575788, 20474192, 21644640, 21794615, 18899974, 20471920
22806698, 19052488, 19503821, 24350620, 20074391, 19157754, 21220620
24316947, 19865345, 19065556, 22816287, 25947799, 20878790, 23492665
21322887, 22305887, 20879889, 24350831, 19578350, 19363645, 21072646
20898391, 19291380, 27060167, 27086138, 22536802, 22087683, 21656630
20373598, 19248799, 22707866, 19155797, 19279273, 18886413, 25490238
20922010, 19990037, 25150925, 20509482, 24717859, 20703000, 22862134
21526048, 24929210, 24560906, 20144308, 21620471, 19670108, 19068610
20267166, 25123585, 20476175, 18549238, 22950945, 19385656, 23528412
19684504, 21174504, 20899461, 20557786, 21911701, 19143550, 20118035
19024808, 25760195, 20009833, 19604659, 16359751, 26039623, 19928926
23314180, 20212067, 24737403, 20480209, 26430737, 20856766, 27169796
21668627, 20877664, 19487147, 23149541, 24577566, 19430401, 19676905
20925795, 21296029, 21629064, 23229229, 22865673, 20708701, 25353983
19280225, 21315084, 19213447, 19989009, 18191823, 27314390, 25775213
24393981, 25639019, 17319928, 19703301, 21626377, 20122715, 6418158
23105538, 26198926, 19258504, 21188532, 23151677, 17890099, 21649497
26446098, 16887946, 26024732, 18791688, 19721304, 19490948, 27012701
19619732, 21164318, 18090142, 21641760, 19818513, 20139391, 24693382
19978542, 23543183, 22165897, 22359063, 19409212, 23035249, 18990693
20470877, 21422580, 21632821, 22351572, 20235511, 23220453, 18604493
23008056, 22901797, 18610915, 20832516, 24801152, 26089440, 20907061
20505778, 19183343, 21787056, 21273804, 25093739, 17835294, 24413809
18371441, 26714910, 24385983, 20413820, 24421668, 25897615, 25643931
23195445, 21281607, 20513399, 20558005, 20093776, 18909599, 20618595
23572982, 19211433, 20331945, 19512341, 22256431, 19637186, 19022470
18607546, 24573817, 19649152, 23115139, 19201867, 21294938, 20898997
18510194, 21842740, 22454326, 24683149, 19534363, 25489607
--------------------------------------------------------------------------------
OPatch succeeded.
No comments:
Post a Comment