Error:-
Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later
1)Download the patch – 17030189 from metalink.
2)Shutdown database.
3)Apply the patch.
4)Start the database.
Patch apply log.
[oracle@vm1 17030189]$ opatch napply -skip_subset -skip_duplicate -local
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /home/oracle/app/oraInventory
from : /home/oracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2017-01-22_08-00-31AM_1.log
Verifying environment and performing prerequisite checks...
Checking skip_duplicate
Checking skip_subset
OPatch continues with these patches: 17030189
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '17030189' to OH '/home/oracle/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.dbscripts, 12.1.0.1.0...
Verifying the update...
Patch 17030189 successfully applied.
Log file location: /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2017-01-22_08-00-31AM_1.log
OPatch succeeded.
[oracle@vm1 17030189]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /home/oracle/app/oraInventory
from : /home/oracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2017-01-22_08-00-54AM_1.log
Lsinventory Output file location : /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-01-22_08-00-54AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 17030189 : applied on Sun Jan 22 08:00:37 EST 2017
Unique Patch ID: 19755187
Created on 14 Jan 2016, 09:29:35 hrs PST8PDT
Bugs fixed:
17030189
--------------------------------------------------------------------------------
OPatch succeeded.
Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later
Replication
of UDT and ANYDATA from redo logs is not supported because the patch required
for Oracle database is missing. Use fetch instead.
Solution:-1)Download the patch – 17030189 from metalink.
2)Shutdown database.
3)Apply the patch.
4)Start the database.
Patch apply log.
[oracle@vm1 17030189]$ opatch napply -skip_subset -skip_duplicate -local
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /home/oracle/app/oraInventory
from : /home/oracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2017-01-22_08-00-31AM_1.log
Verifying environment and performing prerequisite checks...
Checking skip_duplicate
Checking skip_subset
OPatch continues with these patches: 17030189
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '17030189' to OH '/home/oracle/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.dbscripts, 12.1.0.1.0...
Verifying the update...
Patch 17030189 successfully applied.
Log file location: /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2017-01-22_08-00-31AM_1.log
OPatch succeeded.
[oracle@vm1 17030189]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /home/oracle/app/oraInventory
from : /home/oracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2017-01-22_08-00-54AM_1.log
Lsinventory Output file location : /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-01-22_08-00-54AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 17030189 : applied on Sun Jan 22 08:00:37 EST 2017
Unique Patch ID: 19755187
Created on 14 Jan 2016, 09:29:35 hrs PST8PDT
Bugs fixed:
17030189
--------------------------------------------------------------------------------
OPatch succeeded.
No comments:
Post a Comment