Sunday, March 20, 2016

ORA Errors

ORA-20000: index owner.index  or partition of such index is in unusable state;

Rebuild the indexes which are unusable state.

ORA-28003: password verification for the specified password failed

alter password_verify_function to null to use the same password.

ORA-00245: control file backup failed; target is likely on a local file system

From 11g R2, snapshot of control file to be backed up to shared storage in RAC.

ORA-1652: unable to extend temp segment by 1024 in tablespace *****;

Add space to the tablespace *****

ORA-02050: transaction 26.17.754787 rolled back, some remote DBs may be in-doubt
ORA-03113: end-of-file on communication channel

Checking for pending transactions

SQL> select LOCAL_TRAN_ID, GLOBAL_TRAN_ID, STATE, FAIL_TIME, RETRY_TIME from dba_2pc_pending;

no rows selected

SQL> select database,local_tran_id,dbid,sess#,branch from dba_2pc_neighbors;

no rows selected

ORA-03136

TNS-12535: TNS:operation timed out

Failed to establish a connection with the database with in the specified time limit, INBOUND_CONNECT_TIMEOUT

ORA-19554: error allocating device, device type: SBT_TAPE, device name:;;

The Netbackup client needs to be linked to Oracle libraries.



No comments:

Post a Comment