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

Running Oracle 19c gridSetup.sh or runInstaller on Linux 8, the following errors occur: [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’ SOLUTION Set the following variable: $ export CV_ASSUME_DISTID=OEL7.8 OR Edit the file cvu_config which is located in $ORACLE_HOME/cv/admin, change the line from # Fallback to this distribution id #CV_ASSUME_DISTID=OEL5 to # Fallback to this distribution id CV_ASSUME_DISTID=OEL7.8 ..read more

The following errors occur when running Oracle 19c gridSetup.sh: Summary of node specific errors racnode2 - PRVG-11067 : TCP connectivity from node "racnode2": "10.2.2.2" to node "racnode1": "10.2.2.1" failed. PRVG-11095 : The TCP system call "connect" failed with error "113" while executing exectask on node "racnode2" No route to host - Cause: Errors occurred while attempting to establish Transmission Control Protocol (TCP) connectivity between the identified two interfaces. - Action: Ensure that there are no firewalls blocking TCP operations and no process monitors running that can ..read more

SQL> create table test ( id number ); create table test ( id number ) * ERROR at line 1: ORA-01950: no privileges on tablespace ‘USERS’ SOLUTION SQL> select TABLESPACE_NAME,USERNAME,MAX_BYTES,BYTES from dba_ts_quotas where USERNAME='SCOTT';no rows selected SQL> alter user scott default tablespace users quota 10m on users; User altered. SQL> create table test ( id number ); Table created. SQL> select TABLESPACE_NAME,USERNAME,MAX_BYTES,BYTES from dba_ts_quotas where USERNAME='SCOTT'; TABLESPACE_NAME USERNAME MAX_BYTES BYTES ..read more