While putting the database in hot backup mode , below error came. ORA-01123: cannot start online backup; media recovery not enabled PROBLEM: SQL> alter database begin bac...
ORA-
ORA-00027: cannot kill current session
ORA-00027: cannot kill current session , error comes, when you are trying to kill your current session,which is not allowed. EXAMPLE: Get the s...
ORA-29516: Aurora assertion failure: Assertion failure
If the java component is corrupted, then while executing java related packages, you may face below error. select dbms_java.longname('TEST') from dual; select dbms_java.longname('TEST') from dual * ERR...
ORA-08104: this index object is being online built or rebuilt
While dropping an index, if you are facing ORA-08104 error, then you need to clean it using dbms_repair Problem: SQL> drop index eric_icmsprod.SOTRAN00_IDX1; drop index eric_icmsprod.SOTRAN0...
ORA-27054: NFS file system where the file is created while expdp
While doing expdp the dumpfile to a NFS mount point, you may receive below error. Error: Connected to: Oracle Database 11g Enterprise Edition Rel...
ORA-00600 kcratr_nab_less_than_odr while starting the database
While opening the database , if you are getting below ORA-0600 error ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr] metalink – 1296264.1 Problem: SQL>startup O...
ORA-27102: out of memory while starting DB instance
While starting DB instance below error coming because of less memory allocated to oracle user at OS level. ORA-27102: out of memory SVR4 Error: 12: Not enough space Additional inform...
ORA-00059: maximum number of DB_FILES exceeded
While adding new datafile, you may face below error. Problem: ALTER TABLESPACE TS_LO_DATA add datafile '+DATA' size 10g autoextend on next 500M * ERROR at line 1: ORA-00059: maximum number of DB_FILES...
ORA-01940: cannot drop a user that is currently connected
While dropping a user in oracle database , you may face below error. ORA-01940 Problem: SQL> drop user SCOTT cascade 2 / drop user SCOTT cascade * ERROR at line 1: ORA-01940: cannot drop a user t...
ORA-31623: a job is not attached to this session via the specified handle
PROBLEM: While taking export or import , you may face below issue. oracle@TEST0$ impdp dumpfile=CX_HIZRI_TRANS_Apr10.dmp logfile=test_1_cx_hizri.log tables=SIEBEL.CX_HIZRI_TRANS di...