We have an old Oracle 12c database server that is not up to date (version 220.127.116.11.0). Unforunately a full version upgrade is out of scope right now, but I was hoping to at least apply the latest patch bundle we have on hand, which would take us to 18.104.22.168.160719 and fix a few vulnerabilities.
I used OPatch and got everything applied without incident, but when I tried to run the datapatch utility afterward I recieved the following errors:
SQL Patching tool version 22.214.171.124.0 on Thu Oct 17 12:10:58 2019 Copyright (c) 2014, Oracle. All rights reserved. Connecting to database...OK Determining current state... Currently installed SQL Patches: Currently installed C Patches: 23530410 Adding patches to installation queue and performing prereq checks... Installation queue: Nothing to roll back The following patches will be applied: 23530410 catconInit: database is not open Installing patches... Patch installation complete. Total patches installed: 1 Validating logfiles... Patch 23530410 apply: logfile: (no errors) See support note 1609718.1 for information on how to resolve the above errors SQL Patching tool complete on Thu Oct 17 12:11:41 2019 catconExec: catconInit has not been runcatconWrapUp: catconInit has not been run
I've found similar errors on Google about 'catconInit: database is not open on the default instance' but nothing that is exactly the same message as mine. In fact, when I Google the last error message 'catconExec: catconInit has not been runcatconWrapUp: catconInit has not been run' I only get one result--the Oracle Support page for this error (Doc ID 1609718.1). Unfortunately, we do not have an ongoing support contract and I cannot see the cause/solution for this.
- There is only one database/instance on this server, and I specify that with the datapatch parameter
- The database is open per V$INSTANCE, and both myself and the application can query it just fine
- I've been a DBA for a few years now, but I'm new to Oracle specifically
Does anyone have any ideas? Can anyone relay the information from the support doc? Thanks in advance.
OS is Windows Server 2012 R2 Standard
Rerun of 'datapatch -verbose -db MyDatabase' produces the exact same output (just with newer timestamps)
- The associated log file from the most recent run of datapatch (D:\oracle\MyDatabase\cfgtoollogs\opatch\opatch2019-11-05_13-29-08PM_1):