TROUBLESHOOTING

Warning: ORA-16854: apply lag could not be determined

PROBLEM: I was getting Warning: ORA-16854: apply lag could not be determined in dgmgrl show configuration command. , despite my dataguard replication was working fine and no errors were in any of the alert logs. I tried validate database command , still warning was there. DGMGRL> show configuration; Configuration – my_dg_leo Protection Mode: MaxPerformance Members: […]

ORA-15260: permission denied on ASM disk group

PROBLEM: While creating a diskgroup , got ORA-15260: permission denied on ASM disk group error. [oracle@19c]$ sqlplus / as SYSDBA SQL*Plus: Release 19.0.0.0.0 – Production on Fri Jun 18 18:42:58 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.3.0.0.0 SQL> […]

CRS-4013: This command is not supported in a single-node configuration

PROBLEM: While shutting down crs, got below error. [root@bin]# ./crsctl stop crs CRS-4013: This command is not supported in a single-node configuration. CRS-4000: Command Stop failed, or completed with errors. SOLUTION: In case of standalone grid, there will not be any crs . Only has component will be there. So use the below command to […]

Verifying Daemon “avahi-daemon” not configured and running …FAILED (PRVG-1360)

PROBLEM: While running oracle grid precheck using runcluvfy script, got below error. Verifying Daemon “avahi-daemon” not configured and running … Node Name Configured Status ———— ———————— ———————— dbatest2 no passed dbatest1 no passed Node Name Running? Status ———— ———————— ———————— dbatest2 yes failed dbatest1 yes failed Verifying Daemon “avahi-daemon” not configured and running …FAILED (PRVG-1360) […]

OPATCHAUTO-72088: OPatch software version in homes selected for patching are different.

PROBLEM:   While  analyzing/applying patch to both grid and db at a same time using opatchauto command , got below error. root@dbaclass01:/export/home/oracle# /gridapp/app/oracle/product/grid12c/OPatch/opatchauto apply /oradbtrace/JAN2021BP/32131231 -analyze OPatchauto session is initiated at Thu Apr 15 11:10:45 2021 System initialization log file is /gridapp/app/oracle/product/grid12c/cfgtoollogs/opatchautodb/systemconfig2021-04-15_11-10-50AM.log. Session log file is /gridapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/opatchauto2021-04-15_11-12-20AM.log The id for this session is UVGK dbaclass01 […]

LsInventorySession failed: RawInventory gets null OracleHomeInfo

  PROBLEM:   While running opatch lsinventory , got below error LsInventorySession failed: RawInventory gets null OracleHomeInfo: oracle@dbhost1:…p/app/oraInventory/ContentsXML$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /gsmoracle/app/oracle/product/12.1.0/dbhome_1 Central Inventory : /crsapp/app/oraInventory from : /gsmoracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.21 OUI version : 12.1.0.2.0 Log file […]

ORA-01442: column to be modified to NOT NULL is already

PROBLEM: Got error while doing online redefinition of a table, ORA-01442: column to be modified to NOT NULL is already NOT NULL. DECLARE error_count pls_integer := 0; BEGIN DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS(‘RAJDBA’, ‘SOC_TABLE’, ‘SOC_TABLE_INTERIM’, dbms_redefinition.cons_orig_params, TRUE,TRUE,TRUE,FALSE, error_count); DBMS_OUTPUT.PUT_LINE(‘errors := ‘ || TO_CHAR(error_count)); END; / Session altered. SQL> Session altered. SQL> SQL> SQL> 2 3 4 5 6 7 […]

ORA-14024: number of partitions of LOCAL index must equal that of the

PROBLEM: While doing online redefinition of partitioned table, got ORA-012024 error. SQL> DECLARE 2 error_count pls_integer := 0; 3 BEGIN 4 DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS(‘RAJDBA’, ‘SOC_TABLE’, ‘SOC_TABLE_INT’, dbms_redefinition.cons_orig_params, TRUE,TRUE,TRUE,FALSE, error_count); 5 DBMS_OUTPUT.PUT_LINE(‘errors := ‘ || TO_CHAR(error_count)); 6 END; 7 / DECLARE * ERROR at line 1: ORA-14024: number of partitions of LOCAL index must equal that of the […]

ORA-16855: transport lag has exceeded specified threshold

PROBLEM: We have observed below error in dgmgrl : DGMGRL> show database prdstby Database – prdstby Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 9 minutes 24 seconds (computed 0 seconds ago) Apply Lag: 9 minutes 24 seconds (computed 0 seconds ago) Average Apply Rate: 488.00 KByte/s Real Time Query: ON Instance(s): prdstby Database Warning(s): […]

ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace

PROBLEM: Application team was running some upgrade and during that process, they got the below error. ORA-20101: ERROR at line 1: ORA-20101: PGIDX is not a ASSM (Automatic Segment Space Management) tablespace, cannot upgrade BLOB to securefile ORA-06512: at line 28, exiting SOLUTION: NOTE – > This solution contains steps, which may block transaction on the […]