PROBLEM: While dropping a database in mount stage got below error.(ORA-12719) SQL> startup mount; ORACLE instance started. Total System Global Area 1.4663E+10 bytes Fixed Size 15697000 bytes Variable Size 9865010072 bytes Database Buffers 4731174912 bytes Redo Buffers 51404800 bytes Database mounted. SQL> select name from v$database; NAME ——— TESTDB SQL> drop database; drop database * […]

PROBLEM: While enabling parallel DML option, after doing some transaction, got error ORA-12841 SQL> insert into test2 select * from dba_objects; 77635 rows created. SQL> alter session enable parallel dml; ERROR: ORA-12841: Cannot alter the session parallel DML state within a transaction SOLUTION: If we are enabling parallel DML option, after doing some transaction, then […]

PROBLEM: After doing insert operation in parallel, when I tried to run the select query it is throwing error ORA-12838. SQL> alter session enable parallel dml; Session altered. SQL> insert /*+ parallel (test2) */ into test2 select * from dba_objects; 77635 rows created. SQL> select count(*) from test2; select count(*) from test2 * ERROR at […]

PROBLEM: The application is unable to connect to the database after it was idle for a long time. Error ORA-02396: exceeded maximum idle time, please connect again was logged in the application log. SOLUTION: First, you need to identify, with which user, the application is connecting to the database. Let’s say the user is SIEBEL. […]

PROBLEM: While modifying the retention period of AWR snapshot, got error ORA-13541 SQL> execute dbms_workload_repository.modify_snapshot_settings (interval => 30, retention => 10080); BEGIN dbms_workload_repository.modify_snapshot_settings (interval => 30, retention => 10080); END; * ERROR at line 1: ORA-13541: system moving window baseline size (691200) greater than retention (604800) ORA-06512: at “SYS.DBMS_WORKLOAD_REPOSITORY”, line 198 ORA-06512: at “SYS.DBMS_WORKLOAD_REPOSITORY”, line […]

PROBLEM: While analyzing the table for chained rows, got below error. ORA-1495 ANALYZE TABLE SCOTT.EMPTAB LIST CHAINED ROWS; * ORA-1495 specified chained row table not found SOLUTION: To fix it run the utlchain.sql script. sqlplus / as sysdba $ORACLE_HOME/rdbms/admin/utlchain.sql script After that TRUNCATE TABLE CHAINED_ROWS; ANALYZE TABLE SCOTT.EMPTAB LIST CHAINED ROWS;

PROBLEM: While altering parameter in parameter file got below error. ALTER SYSTEM SET processes = 900 SCOPE=SPFILE; ALTER SYSTEM SET processes = 900 SCOPE=SPFILE * ERROR at line 1: ORA-32001: write to SPFILE requested but no SPFILE is in use SOLUTION: This error comes, if the database is running with pfile instead of spfile. 1. […]

PROBLEM: While duplicating a database using RMAN active cloning in RAC database, got below error.(ORA-65500) RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of sql command on clone_default channel at 1/02/2017 21:40:59 RMAN-11003: failure during parse/execution of SQL statement: alter system set db_unique_name = ‘DBATEST’ comment= ‘Modified by RMAN duplicate’ scope=spfile ORA-32017: failure […]

PROBLEM: While opening a database, getting the error, ORA-01203: wrong incarnation of this file SQL> alter database open; alter database open * ERROR at line 1: ORA-01122: database file 4 failed verification check ORA-01110: data file 4: ‘+B2BCMDB/BMCW/undotbs201.dbf’ ORA-01203: wrong incarnation of this file – wrong creation SCN SOLUTION: To fix this, either you have […]

PROBLEM: While taking rman backup, got below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t4 channel at 05/01/2017 03:18:01 ORA-19588: archived log RECID 143154 STAMP 942443843 is no longer valid SOLUTION: This error is mostly because of 2 reasons. 1. Either 2 backups like […]