For some reason, a database has to be reconfigured with a domain name “.world”. After change the spfile and bounced the database, we need change the global_name manually. Check current global_name in CDB: SQL> select * from global_name;GLOBAL_NAME--------------TESTDB 2. Drop database links now, and need recreate them later. because they are inaccessible after global_name changed. Otherwise you will get the following errors: SQL> drop database link TESTDBLINK; drop database link TESTDBLINK *ERROR at line 1:ORA-02024: database link not found To fix this issue ..read more

When running Oracle PRE-Upgrade Fixup Script “preupgrade_fixups.sql” for upgrading 11g to 19c, the following errors occur : Preup PreupgradeAction Issue IsNumber Preupgrade Check Name Remedied Further DBA Action------ ------------------------ ---------- -------------------------------- 1. purge_recyclebin YES None. 2. parameter_obsolete NO Manual fixup recommended. 3. invalid_objects_exist NO Manual fixup recommended. 4. default_resource_limit NO Manual f ..read more

In Oracle 11.2.0.3 database, after dropped some tables, there are still lob objects in dba_objects and dba_segments. Find the table name the lob belongs to: SQL> show parameter recyclebinNAME TYPE VALUE------------------------------------ ----------- -----------------------recyclebin string on SQL> select u.name, o.name TABLENAME, decode(bitand(c.property, 1), 1, ac.name, c.name) as column_name from sys.obj$ o, sys.col$ c, sys.attrcol$ ac,sys.lob$ l,sys.obj$ lo,sys.obj$ io,sys.user$ u,sys.ts$ ts where o.owner# = u ..read more

Service created from srvctl SQL> select count(*) from gv$session where service_name='test'; COUNT(*)---------- 1SQL> select inst_id,SERVICE_ID,NAME,NAME_HASH,NETWORK_NAME,CREATION_DATE from gv$services where NAME='test'; INST_ID SERVICE_ID NAME NAME_HASH NETWORK_NA CREATION_DATE---------- ---------- ------ ---------- ---------- -------------------- 1 4 test 3237892936 test 19-APR-2024 13:43:50 SQL> exec dbms_service.DELETE_SERVICE('test');BEGIN dbms_service.DELETE_SERVICE('test'); END;*ERROR at line 1:ORA-44305: service test is runningORA-06512 ..read more

OEM agent is unhealthy with the following errors: $ emctl status agentOracle Enterprise Manager Cloud Control 13c Release 4Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.---------------------------------------------------------------Status agent Failure:unable to connect to http server at https://racnode1:3872/emd/lifecycle/main/. [handshake has no peer]$ emctl stop agentOracle Enterprise Manager Cloud Control 13c Release 4Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.$ emctl pingOMSOracle Enterprise Manager Cloud Control 13c Release 4Copyright (c) 1996 ..read more

Debug “cluvfy” or “runcluvfy.sh”: $ rm -rf /tmp/cvutrace$ mkdir /tmp/cvutrace$ export CV_TRACELOC=/tmp/cvutrace$ export SRVM_TRACE=true$ export SRVM_TRACE_LEVEL=1$ cluvfy stage -pre dbinst -allnodes -r 12.2 -d /u01/app/oracle/product/12.2.0/dbhome_1$ ls -ltr /tmp/cvutracetotal 1960-rw-r--r-- 1 grid oinstall 0 Sep 8 21:46 cvutrace.log.0.lck-rw-r--r-- 1 grid oinstall 0 Sep 8 21:47 cvuhelper.log.0.lck-rw-r--r-- 1 grid oinstall 1586 Sep 8 21:47 cvuhelper.log.0-rw-r--r-- 1 grid oinstall 2000962 Sep 8 21:47 cvutrace.log.0 ..read more

OGG extract process is abended due to the missing archive logs as showing in GG error log: 2023-01-21T01:19:23.197+1100 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, CAP01.prm: Could not find archived log for sequence 99 thread 2 under default destinations SQL <SELECT name FROM v$archived_log WHERE sequence# = :1 AND thread# = :2 AND resetlogs_id = :3 AND archived = 'YES' AND deleted = 'NO' AND standby_dest = 'NO' order by name DESC>, error retrieving redo file name for sequence 99, archived = 1, use_alternate = 0. You c ..read more

The replicate process ABENDING due to the following errors exist in replicate process report: ERROR OGG-01172 Discard file (/home/oracle/ggs/dirrpt/REP01.dsc) exceeded max bytes (3000000). SOLUTION Increase the discardfile maximum size in replicate parameter file from default 3M to 100M: discardfile /home/oracle/ggs/dirrpt/REP01.dsc, purge, megabytes 100 ..read more

When starting up OGG extract with the following error in ggserr.log : ERROR OGG-00901 Failed to lookup object ID for table GG.D7A_GGS_TRACEERROR OGG-01668 Oracle GoldenGate Capture for Oracle,CAP.prm:PROCESS ABENDING Check the parameter file of capture with one line: tractable GG.D7A_GGS_TRACE SOLUTION Manually create trace table as required. GGSCI>info credentialstoreGGSCI> DBLOGIN USERIDALIAS ggorGGSCI>DBLOGIN USERID gg, PASSWORD passwdGGSCI> INFO TRACETABLEGGSCI> add tracetable GG.D7A_GGS_TRACEGGSCI> INFO TRACETABLEGGSCI> SQL> desc GG.D7A_GGS_TRACE Name ..read more

When attempting to configure 19c grid infrastructure on Linux 8 by running gridSetup.sh the following error occurs in SSH connectivity step: [INS-06006] Passwordless SSH connectivity not set up between the following node(s): [racnode2] Even after manually setup SSH equivalence successfully, the error still exists and user cannot continue the GI installation and configuration. SOLUTION Apply patch 30159782 before run “gridSetup.sh”, see (Doc ID 1410202.1) for how to apply OneOff patch before run “gridSetup.sh”. OR apply the RU or higher where the fix for 30159782.8 is included OR Before inst ..read more