Sunday, January 22, 2017

Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later




Error:-
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