#############
localhost:/home/oracle/joshi/24732082:$ $ORACLE_HOME/OPatch/opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : $ORACLE_HOME
Central Inventory : /home/oracle/oraInventory
from : $ORACLE_HOME/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : $ORACLE_HOME/cfgtoollogs/opatch/opatch2017-02-20_07-12-38AM_1.log
Lsinventory Output file location : $ORACLE_HOME/cfgtoollogs/opatch/lsinv/lsinventory2017-02-20_07-12-38AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost.joshi.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.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
localhost:/home/oracle/joshi/24732082:$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : $ORACLE_HOME
Central Inventory : /home/oracle/oraInventory
from : $ORACLE_HOME/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : $ORACLE_HOME/cfgtoollogs/opatch/opatch2017-02-20_07-13-10AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
localhost:/home/oracle/joshi/24732082:$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : $ORACLE_HOME
Central Inventory : /home/oracle/oraInventory
from : $ORACLE_HOME/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : $ORACLE_HOME/cfgtoollogs/opatch/opatch2017-02-20_07-14-22AM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
$ORACLE_HOME/lib/libclntsh.so.12.1
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
$ORACLE_HOME/lib/libsqlplus.so
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: $ORACLE_HOME/cfgtoollogs/opatch/opatch2017-02-20_07-14-22AM_1.log
OPatch failed with error code 73
localhost:/home/oracle/joshi/24732082:$ ps -ef|grep
localhost:/home/oracle/joshi/24732082:$ fuser $ORACLE_HOME/lib/libclntsh.so.12.1
$ORACLE_HOME/lib/libclntsh.so.12.1: 59886m 71311m
localhost:/home/oracle/joshi/24732082:$ lsof $ORACLE_HOME/lib/libclntsh.so.12.1
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
sqlplus 59886 oracle mem REG 253,22 58795804 14161065 $ORACLE_HOME/lib/libclntsh.so.12.1
sqlplus 71311 oracle mem REG 253,22 58795804 14161065 $ORACLE_HOME/lib/libclntsh.so.12.1
localhost:/home/oracle/joshi/24732082:$ lsof $ORACLE_HOME/lib/libsqlplus.so
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
sqlplus 59886 oracle mem REG 253,22 1546540 14157272 $ORACLE_HOME/lib/libsqlplus.so
sqlplus 71311 oracle mem REG 253,22 1546540 14157272 $ORACLE_HOME/lib/libsqlplus.so
localhost:/home/oracle/joshi/24732082:$ ps -ef| grep 59886
oracle 55012 9307 0 07:20 pts/14 00:00:00 grep --color=auto 59886
oracle 59886 52524 0 Feb17 pts/11 00:00:01 sqlplus as sysdba
localhost:/home/oracle/joshi/24732082:$ ps -ef|grep 71311
oracle 55021 9307 0 07:21 pts/14 00:00:00 grep --color=auto 71311
oracle 71311 128820 0 Feb17 pts/9 00:00:00 sqlplus
localhost:/home/oracle/joshi/24732082:$ kill -9 59886
localhost:/home/oracle/joshi/24732082:$ kill -9 71311
localhost:/home/oracle/joshi/24732082:$ fuser $ORACLE_HOME/lib/libclntsh.so.12.1
localhost:/home/oracle/joshi/24732082:$ fuser $ORACLE_HOME/lib/libsqlplus.so
localhost:/home/oracle/joshi/24732082:$ lsof $ORACLE_HOME/lib/libclntsh.so.12.1
localhost:/home/oracle/joshi/24732082:$ lsof $ORACLE_HOME/lib/libsqlplus.so
localhost:/home/oracle/joshi/24732082:$
###
localhost:/home/oracle/joshi/24732082:$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : $ORACLE_HOME
Central Inventory : /home/oracle/oraInventory
from : $ORACLE_HOME/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : $ORACLE_HOME/cfgtoollogs/opatch/opatch2017-02-20_07-23-36AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19769480 20299023 20831110 21359755 21948354 22291127 23054246 24006101 24732082
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '$ORACLE_HOME')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '$ORACLE_HOME'
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...
Skip copying to "$ORACLE_HOME/crs/install/tfa_setup" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/19769480/files/crs/install/tfa_setup"
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...
Skip copying to "$ORACLE_HOME/rdbms/mesg/diaus.msb" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/19769480/files/rdbms/mesg/diaus.msb"
Skip copying to "$ORACLE_HOME/rdbms/mesg/diaus.msg" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/19769480/files/rdbms/mesg/diaus.msg"
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Skip copying to "$ORACLE_HOME/lib/libzt12.a" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/19769480/files/lib/libzt12.a"
Skip copying to "$ORACLE_HOME/lib/libccme_asym.so" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/19769480/files/lib/libccme_asym.so"
Skip copying to "$ORACLE_HOME/lib/libccme_ecc.so" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/19769480/files/lib/libccme_ecc.so"
Skip copying to "$ORACLE_HOME/lib/libccme_ecc_accel_fips.so" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/19769480/files/lib/libccme_ecc_accel_fips.so"
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20299023' to OH '$ORACLE_HOME'
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...
Skip copying to "$ORACLE_HOME/crs/install/tfa_setup" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/20299023/files/crs/install/tfa_setup"
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 '$ORACLE_HOME'
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...
Skip copying to "$ORACLE_HOME/lib/libccme_ecc_accel_non_fips.so" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/20831110/files/lib/libccme_ecc_accel_non_fips.so"
Skip copying to "$ORACLE_HOME/lib/libccme_ecc_non_fips.so" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/20831110/files/lib/libccme_ecc_non_fips.so"
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 '$ORACLE_HOME'
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 '$ORACLE_HOME'
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 '$ORACLE_HOME'
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...
Skip copying to "$ORACLE_HOME/rdbms/admin/prvtbkrs.plb" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/22291127/files/rdbms/admin/prvtbkrs.plb"
Skip copying to "$ORACLE_HOME/rdbms/admin/dbmsbkrs.sql" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/22291127/files/rdbms/admin/dbmsbkrs.sql"
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...
Skip copying to "$ORACLE_HOME/rdbms/admin/dbmsaw.sql" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/22291127/files/rdbms/admin/dbmsaw.sql"
Applying sub-patch '23054246' to OH '$ORACLE_HOME'
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...
Skip copying to "$ORACLE_HOME/lib/libzt12.a" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/lib/libzt12.a"
Patching component oracle.install.deinstalltool, 12.1.0.2.0...
Skip copying to "$ORACLE_HOME/lib/libldapjclnt12.so" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/lib/libldapjclnt12.so"
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...
Skip copying to "$ORACLE_HOME/bin/xmldiff" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/bin/xmldiff"
Skip copying to "$ORACLE_HOME/bin/xvm" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/bin/xvm"
Skip copying to "$ORACLE_HOME/bin/xmlpatch" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/bin/xmlpatch"
Skip copying to "$ORACLE_HOME/bin/xsl" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/bin/xsl"
Skip copying to "$ORACLE_HOME/bin/xmlcg" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/bin/xmlcg"
Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...
Skip copying to "$ORACLE_HOME/bin/lxegen" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/bin/lxegen"
Skip copying to "$ORACLE_HOME/bin/lcsscan" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/bin/lcsscan"
Skip copying to "$ORACLE_HOME/bin/lxchknlb" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/bin/lxchknlb"
Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Skip copying to "$ORACLE_HOME/bin/xml" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/bin/xml"
Patching component oracle.ctx.atg, 12.1.0.2.0...
Skip copying to "$ORACLE_HOME/lib/libanllexer12.so" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/23054246/files/lib/libanllexer12.so"
Applying sub-patch '24006101' to OH '$ORACLE_HOME'
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 '$ORACLE_HOME'
Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Skip copying to "$ORACLE_HOME/rdbms/mesg/oraus.msb" because it is the same as
the file in incoming patch "/home/oracle/joshi/24732082/24732082/files/rdbms/mesg/oraus.msb"
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...
Composite patch 24732082 successfully applied.
Log file location: $ORACLE_HOME/cfgtoollogs/opatch/opatch2017-02-20_07-23-36AM_1.log
OPatch succeeded.
##
localhost:/home/oracle/joshi/24732082:$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 20 07:31:49 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> Connect / as sysdba
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 3712904 bytes
Variable Size 1191184504 bytes
Database Buffers 939524096 bytes
Redo Buffers 13062144 bytes
Database mounted.
Database opened.
SQL>
localhost:$ORACLE_HOME/OPatch:$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Mon Feb 20 07:34:09 2017
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /instora/cfgtoollogs/sqlpatch/sqlpatch_61927_2017_02_20_07_34_09/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 170117 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:
24732082 (DATABASE PATCH SET UPDATE 12.1.0.2.170117)
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 24732082 apply: WITH ERRORS
logfile: /instora/cfgtoollogs/sqlpatch/24732082/20904347/24732082_apply_HCM92GLD_2017Feb20_07_34_24.log (errors)
Error at line 41261: ORA-22308: operation not allowed on evolved type
Please refer to MOS Note 1609718.1 and/or the invocation log
/instora/cfgtoollogs/sqlpatch/sqlpatch_61927_2017_02_20_07_34_09/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Mon Feb 20 07:34:59 2017
##
SQL> -- UDT and object-view for the 'DVPS_REALM_MEMBERSHIP' homogeneous type,
SQL> -- (xmltag: 'DVPS_REALM_MEMBERSHIP_T', XSLT: rdbms/xml/xsl/kudvrlmm.xsl),
SQL> -- representing realm protections created using ADD_OBJECT_TO_REALM.
SQL> create or replace type dvsys.ku$_dv_realm_member_t as object
2 (
3 vers_major char(1), /* UDT major version # */
4 vers_minor char(1), /* UDT minor version # */
5 name varchar2(90), /* name of database vault realm */
6 object_owner varchar2(30), /* owner of object protected by this realm */
7 object_name varchar2(128), /* name of object protected by this realm */
8 object_type varchar2(32) /* type of object protected by this realm */
9 )
10 /
create or replace type dvsys.ku$_dv_realm_member_t as object
*
ERROR at line 1:
ORA-22308: operation not allowed on evolved type
SQL>
##Solution##
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
JOSHIN READ WRITE
SQL> !hostname;date
localhost
Mon Feb 20 07:53:44 EST 2017
SQL> drop type dvsys.ku$_dv_realm_member_t validate;
Type dropped.
SQL>
###
localhost:$ORACLE_HOME/OPatch:$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Mon Feb 20 07:55:37 2017
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /instora/cfgtoollogs/sqlpatch/sqlpatch_70690_2017_02_20_07_55_37/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 170117 in the binary registry and ID 170117 with errors 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:
24732082 (DATABASE PATCH SET UPDATE 12.1.0.2.170117)
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 24732082 apply: SUCCESS
logfile: /instora/cfgtoollogs/sqlpatch/24732082/20904347/24732082_apply_HCM92GLD_2017Feb20_07_55_46.log (no errors)
SQL Patching tool complete on Mon Feb 20 07:55:54 2017
localhost:$ORACLE_HOME/OPatch:$
###
SQL> select PATCH_ID,STATUS,DESCRIPTION,BUNDLE_SERIES from dba_registry_sqlpatch;
PATCH_ID STATUS DESCRIPTION BUNDLE_SERIES
---------- --------------- ---------------------------------------------------------------------------------------------------- ------------------------------
24732082 SUCCESS DATABASE PATCH SET UPDATE 12.1.0.2.170117 PSU
SQL> select name ,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
JOSHIN READ WRITE
SQL> !hostname;date
localhost
Mon Feb 20 08:01:13 EST 2017
SQL>
SQL> set lines 2000 pages 50
col COMP_NAME for a80
select comp_id, comp_name, status, version from dba_registry; SQL> SQL>
COMP_ID COMP_NAME STATUS VERSION
------------------------------ -------------------------------------------------------------------------------- ----------- ------------------------------
CATALOG Oracle Database Catalog Views VALID 12.1.0.2.0
CATPROC Oracle Database Packages and Types VALID 12.1.0.2.0
OWM Oracle Workspace Manager VALID 12.1.0.2.0
OLS Oracle Label Security VALID 12.1.0.2.0
XDB Oracle XML Database VALID 12.1.0.2.0
DV Oracle Database Vault VALID 12.1.0.2.0
6 rows selected.
No comments:
Post a Comment