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
Month: April 2022
VM (vmware) hanging after delete snapshots
It's a best practice to take a snapshot when doing an upgrade for either OS or application running on a virtual machine. After the upgrade is done and the system/application has been verified running fine for a few days, the snapshot needs to be deleted to release space. We had a VM running an ESXi … Continue reading VM (vmware) hanging after delete snapshots
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
JoeLi's TechLife 