What is force logging: If force logging is enabled, all the database changes will be logged in redo log files, even for nologging operations.The above means that if FORCE LOGGING is enabled at a highe...
ORA-
ORA-02020: too many database links in use
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 c...
ORA-00350: log 4 of instance needs to be archived
PROBLEM: After restoring an RAC database to a standalone database through RMAN, we tried to drop the redolog groups belongs to thread 2. We hit the below error. SQL> alter database drop logfile gro...
ORA-28040: No matching authentication protocol
PROBLEM: We have recently upgraded our database to Oracle 12c. Post upgrade, when they development Team tried to connect to the database using JDBC driver, Got error as ORA-28040: No matching auth...
ORA-30041: Cannot grant quota on the tablespace
PROBLEM: Granting tablespace quota to a user is failing with ORA-30041. SQL> alter user dba_raj quota unlimited on TEMP ; alter user dba_raj quota unlimited on TEMP * ERROR at line 1: ORA-30041: Ca...
ORA-12910: cannot specify temporary tablespace as default tablespace
PROBLEM: While assigning default tablespace for a user, got an ORA-12910 error. SQL> alter user dba_raj default tablespace TEMP; alter user dba_raj default tablespace TEMP * ERROR at line 1: ORA-12...
ORA-30033: Undo tablespace cannot be specified as default user tablespace
PROBLEM: While creating or altering a user with default tablespace got below error. SQL> alter user dba_raj default tablespace UNDOTBS1; alter user dba_raj default tablespace UNDOTBS1 * ERROR at li...
ORA-30032: the suspended (resumable) statement has timed out
PROBLEM: While doing a transaction, it was hung for few seconds and got the below error. SQL> create TABLE TEST_3 as select * from dba_objects; create TABLE TEST_3 as select * from dba_objects * ER...
ORA-14404: partitioned table contains partitions in a different tablespace
PROBLEM: While dropping a tablespace, got error ORA-14404. SQL> drop tablespace TEST_2 including contents and datafiles; drop tablespace TEST_2 including contents and datafiles * ERROR at line 1: O...
ORA-01466: unable to read data – table definition has changed during flashback
PROBLEM: While doing flashback a table to a prior timestamp, got below error. 11:20:45 SQL> FLASHBACK TABLE test2 TO TIMESTAMP TO_TIMESTAMP('2017-07-12 11:18:55', 'YYYY-MM-DD HH24:MI:SS'); FLASHBAC...