Posts

Showing posts from October, 2017

Patching Issues

Datapatch -verbose error: 1) ---------- 1)Opatch apply was successful. 2)opatch lsinventory was showing latest patch applied in the inventory. But, When I give datapatch –verbose to apply modified sqls into database as part of post patch steps, we were getting  D:\oracle\product\12.1.0.2\dbhome\OPatch>datapatch -verbose  SQL Patching tool version 12.1.0.2.0 Production on Sat Feb 18 01:13:34 2017  Copyright (c) 2012, 2017, Oracle. All rights reserved.  Log file for this invocation: D:\oracle\product\12.1.0.2\dbhome\cfgtoollogs\sqlpatch\sqlpatch_4772_2017_02_18_01_13_34\sqlpatch_invocation.log  Connecting to database...OK  Bootstrapping registry and package to current versions...done  Queryable inventory could not determine the current opatch status.  Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'  and/or check the invocation log  D:\oracle\product\12.1.0.2\dbhome\cfgtoollogs\sqlpatch\sqlpatch_4772_2017_02_18_01_13_34\sqlpatch_invocation.log  for the compl