PROBLEM: While dropping a redolog group , got below error. SQL> alter database drop logfile group 1; alter database drop logfile group 1 * ERROR at line 1: ORA-01624: log 1 needed for crash recovery of instance SBIP18DB (thread 1) ORA-00312: online log 1 thread 1: ‘/SIBIP16/SBIP18DB/SBIP18DB/redo01.log’ SOLUTION: First get the status of redolog group: […]

PROBLEM: While trying to recreating a controlfile in RAC database, got below error. ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-12720: operation requires database is in EXCLUSIVE mode SOLUTION: Before recreating controlfile in RAC database, we need to set the cluster_database parameter to FALSE. SQL> show parameter cluster_database NAME TYPE VALUE ———————————— ———– ———————– […]

PROBLEM: While trying to create a table using CTAS , got below error:(ORA-00997) create table test8 AS select DIRECTIONS from siebel.s_org_ext; create table test8 AS select DIRECTIONS from siebel.s_org_ext * ERROR at line 1: ORA-00997: illegal use of LONG datatype SOLUTION: In general, we can’t create an object_type OF LONG datatype using CTAS method. desc […]

PROBLEM: While taking rman backup, it failed with below error ( ORA-19809 & ORA-19804) RMAN> backup archivelog all; Starting backup at 26-MAY-17 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=1942 RECID=1750 STAMP=944758808 input archived log thread=1 sequence=1943 […]

PROBLEM: While dropping a column, got the below error. SQL> ALTER TABLE dbaclass.EMPLIST DROP (empname); ALTER TABLE dbaclass.EMPLIST DROP (empname) * ERROR at line 1: ORA-12991: column is referenced in a multi-column constraint SOLUTION: If the column is part of a multi-column constraint, then we have to drop all the columns of that constraint. Dropping […]

PROBLEM: While dropping a column , got below error. SQL> alter table dbaclass.test89 drop (OWNER,OBJECT_NAME); alter table dbaclass.test89 drop (OWNER,OBJECT_NAME) * ERROR at line 1: ORA-12985: tablespace ‘USERS’ is read only, cannot drop column SOLUTION: The object which is trying to drop belongs to a tablespace is in read only mode. 1. Find the tablespace […]

PROBLEM: While dropping a column on the table, got the below error.(ORA-12984) SQL> alter table dbatest.ORDER_TAB drop (CREATED); alter table dbatest.ORDER_TAB drop (CREATED) * ERROR at line 1: ORA-12984: cannot drop partitioning column REASON: oerr ora 12984 12984, 00000, “cannot drop partitioning column” // *Cause: An attempt was made to drop a column used as […]

PROBLEM: While trying to drop a column from a table, owned by SYS, got below error.(ORA-12988) SQL> show user USER is “SYS” SQL> alter table test3 drop ( CREATED); alter table test3 drop ( CREATED) * ERROR at line 1: ORA-12988: cannot drop column from table owned by SYS SOLUTION: oerr ora 12988 12988, 00000, […]

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 /*+ […]