TROUBLESHOOTING

ORA-19815: WARNING: db_recovery_file_dest_size of bytes is used

PROBLEM: Observed below error in the alert log Wed Nov 29 03:27:44 2017 Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prd_m000_102938.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 1717986918400 bytes is 85.02% used, and has 257437990912 remaining bytes available. Wed Nov 29 03:27:44 2017 ************************************************************************ You have following choices to free up space from recovery area: 1. Consider changing RMAN RETENTION POLICY. […]

Error ORA-235 occurred during an un-locked control file transaction in alert log

PROBLEM: In one of our 12.1.0.2 database, below error was logged in alert log. 2017-11-06 02:28:10.545000 +03:00 Error ORA-235 occurred during an un-locked control file transaction. This CAUSE AND SOLUTION: As per Oracle, this is an expected behavior and can be ignored safely. Starting from Oracle 12c, controlfile transactions are enhanced. We are no longer […]

ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”

PROBLEM: Below errors we have observed in the alert log of oracle 11g database. 2017-11-12 00:00:00.885000 +03:00 Errors in file /oradbtrace/diag/ecnmprod/diag/rdbms/prod1/prod/trace/prod_j000_40300.trc: ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB” ORA-04063: package body “DBSNMP.BSLN_INTERNAL” has errors ORA-06508: PL/SQL: could not find program unit being called: “DBSNMP.BSLN_INTERNAL” ORA-06512: at line 1   SOLUTION: Check the status of […]

ORA-04031: unable to allocate bytes of shared memory (“large pool”,”unknown object”,”large pool”,”CTWR dba buffer”)

PROBLEM: Application Team is running lot of DML activities on the database and suddenly database became slow with lot of blocking sessions with “Block Change Tracking Buffer” event. Also, the alert log was filled with below error: Errors in file /u01/app/oracle/admin/PROD/diag/rdbms/d2crmsit/PROD/trace/DPROD_ctwr_8664.trc (incident=163240): ORA-04031: unable to allocate 46940008 bytes of shared memory (“large pool”,”unknown object”,”large pool”,”CTWR […]

ORA-20002: Version of statistics table SCOTT.STATS is too old

PROBLEM: While importing a stats table in oracle 12c, for which the stats export was done from 11g , got below error. i.e both stats table was exported from a lower version and import attempt was done on higher version(12c).   SQL> exec dbms_stats.import_table_stats(ownname=>’RAJ’, tabname=>’TEST’,  stattab=>’STAT_TEST’, cascade=>true); ORA-20002: Version of statistics table SCOTT.STATS is too old. […]

ORA-28014: cannot drop administrative users

PROBLEM: While dropping APEX user got below error in oracle 12c, got below error.   SQL> drop user APEX_050000 cascade; drop user APEX_050000 cascade * ERROR at line 1: ORA-28014: cannot drop administrative users   SOLUTION: set _oracle_script to TRUE and execute drop command as below. SQL> alter session set “_oracle_script“=true; Session altered SQL> drop user […]

ORA-00392: log 7 of thread 1 is being cleared, operation not allowed

PROBLEM:   I was cloning a database from rman backup . After completion of cloning, when I did RESETLOG it failed with ORA-00392 error. RMAN> alter database open resetlogs; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of sql statement command at 01/25/2017 16:05:27 ORA-00392: log 7 of thread 1 is being […]

ORA-02020: too many database links in use

PROBLEM: While querying against a database link, got below error. select sysdate from dual@DB5 * ERROR at line 1: ORA-02020: too many database links in use CAUSE & SOLUTION: open_links parameter control, the number of database links each session can use without closing it. If you access a database link in a session, then the […]

ORA-00350: log 4 of instance needs to be archived

PROBLEM: After restoring an RAC database to a standalone database through RMAN, we tried to drop the redolog groups belongs to thread 2. We hit the below error. SQL> alter database drop logfile group 8; alter database drop logfile group 8 * ERROR at line 1: ORA-00350: log 4 of instance DBATST2 (thread 2) needs […]

ORA-28040: No matching authentication protocol

PROBLEM: We have recently upgraded our database to Oracle 12c. Post upgrade, when they development Team tried to connect to the database using JDBC driver, Got error as  ORA-28040: No matching authentication protocol.   SOLUTION: This is because, the development is using old JDBC drivers, which are not compatible to Oracle 12c. As development team ruled out upgrading […]