Category: Oracle

Another reason for verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

In another post I wrote some time ago, I ran into the error ORA-20001 during the datapatch of a 19c upgrade. I got the same error but with a different reason this time: temp data files missing due to OS changes. So we moved a 12c datatabase from Oracle Linux 6 to Oracle Linux 8 … Continue reading Another reason for verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

RollbackSession failed in system modification phase — Archive not rolled back

When patching a 19c database, I ran into an issue when it's trying to roll back the old OJVM patch and applying the newer one. UtilSession failed: RollbackSession failed in system modification phase... 'Archive not rolled back /opt/oracle/190000/.patch_storage/33561310_Jan_5_2022_08_13_10/files/lib/libserver19.a/joxwtp.o to /opt/oracle/190000/lib/libserver19.a... ' OPatch failed with error code 73 It's strange because I could see the backup … Continue reading RollbackSession failed in system modification phase — Archive not rolled back

verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

Ran into a different issue with Oracle 19c datapatch again. The error was: [oracle@joedb OPatch]$ ./datapatch -verbose SQL Patching tool version 19.14.0.0.0 Production on Thu Jun 2 19:35:49 2022 Copyright (c) 2012, 2021, Oracle. All rights reserved. Log file for this invocation: /opt/oracle/cfgtoollogs/sqlpatch/sqlpatch_74090_2022_06_02_19_35_49/sqlpatch_invocation.log Connecting to database...OK Gathering database info...done Bootstrapping registry and package to current … Continue reading verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

SQL Patch fails — Archived Patch Directory Is Empty — sqlpatch_invocation.log

When patching Oracle database, some patches need to update database objects. A SQL patch is a patch that contains SQL scripts which need to be run after OPatch completes. In Oracle 12c, Oracle has introduced a new tool named "datapatch" which enables automation of post-patch SQL actions for RDBMS patches. It's called by OPatchAuto usually. … Continue reading SQL Patch fails — Archived Patch Directory Is Empty — sqlpatch_invocation.log

ORA-16700: The standby database has diverged from the primary database

Had an ODG configuration which contains 1 primary and 1 physical standby databases running with 19c on Oracle Linux 7. We moved them to Oracle Linux 8 with the forklift method. However, because we didn't copy the online redo logs over from old OL7 servers to the new OL8 servers, an incomplete recover was done … Continue reading ORA-16700: The standby database has diverged from the primary database

AUTO_STATS_ADVISOR_TASK missing after the upgrade causing ORA-20001

In another post I've talked about this error ORA-20001. And I saw this error again on another database on 19c: From the alert log: 2022-04-06T22:01:18.392714-05:00 Errors in file /opt/oracle/diag/rdbms/prod/PROD/trace/PROD_j001_364587.trc: ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_16257" ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at "SYS.DBMS_STATS", line 51871 ORA-06512: at "SYS.DBMS_STATS_ADVISOR", … Continue reading AUTO_STATS_ADVISOR_TASK missing after the upgrade causing ORA-20001

Tracing listener dynamic service registration

Service registration with Oracle listener allows processes to identify their available services to the listener, which then acts as a port mapper for those services. The listener uses the dynamic service information about the database and instance received through service registration. Dynamic service registration is configured in the database initialization file. It does not require … Continue reading Tracing listener dynamic service registration

ORA-16766: Redo Apply is stopped

If you see this ORA error "ORA-16766: Redo Apply is stopped" when you check your dataguard configuration in Data Guard command-line interface (DGMGRL) DGMGRL> show configuration; Configuration - DG_PROD Protection Mode: MaxPerformance Databases: PROD1 - Primary database PROD2 - Physical standby database Error: ORA-16766: Redo Apply is stopped Fast-Start Failover: DISABLED Configuration Status: ERROR And … Continue reading ORA-16766: Redo Apply is stopped

Listener — Linux Error: 2: No such file or directory

The other day I was working on a system and noticed an interesting thing -- while the listener was stopped, if I ran "lsnrctl status" and I got the following errors: TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 2: No such file or directory It said "No listener" was expected, … Continue reading Listener — Linux Error: 2: No such file or directory

Unhandled datatype (-25) found in kxsbndinf — capturing bind variables

When dealing with a performance issue of a query, it's important to know what bind variables are being used because Oracle's bind variable peeking feature will make the optimizer to choose a different exeuction plan for different bind variables expecially with the adaptive cursor sharing feature introduced in 11g. There are many ways to check … Continue reading Unhandled datatype (-25) found in kxsbndinf — capturing bind variables