PROBLEM: While creating a staging table in oracle database for SYS user, for storing baseline, got below error.(ORA-19381) SQL> show user USER is “SYS” BEGIN DBMS_SPM.CREATE_STGTAB_BASELINE( table_name => ‘spm_stageing_tab’, tablespace_name => ‘USERS’); END; / 2 3 4 5 6 BEGIN * ERROR at line 1: ORA-19381: cannot create staging table in SYS schema ORA-06512: at […]

PROBLEM: We did one DML transaction without parallel, and in the same session, when we did another DML transaction with parallel, we got error as ORA-12839. SQL> ALTER session enable parallel dml; Session altered. SQL> insert into test2 select * from dba_objects; 77635 rows created. SQL> delete /*+ parallel (test2) */ from test2; delete /*+ […]

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