While querying a view, got below error: SQL> select * from DBA_SYN; select * from DBA_SYN * ERROR at line 1: ORA-00980: synonym translation is no longer valid SOLUTION: This error indicates that synonym is invalid , which is likely due to invalid dependent objects. Lets check this below scenarios: 1. Create a public synonym […]

PROBLEM: We have received below error in the alert log. 2017-12-07 08:01:24.890000 +03:00 Errors in file /oradbtrace/diag/rdbms/prodid2/trace/prodid2_m001_3322.trc: ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated ANALYSIS AND SOLUTION: Lets check the trace file /oradbtrace/diag/rdbms/prodid2/trace/prodid2_m001_3322.trc. Trace file /oradbtrace/diag/rdbms/prodid2/trace/prodid2_m001_101138.trc Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Partitioning, […]

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. […]

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 […]

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 […]

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 […]

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. […]

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 […]

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 […]

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 […]