ORA-01616: instance string (thread string) is open - cannot
disable



ORA-01616: instance string (thread string) is open - cannot disable..

Answer / guest

Cause: The thread is not closed. The last instance to use
the thread died leaving the thread open. A thread cannot be
disabled until it is closed. It is still required for crash
or instance recovery.

Action: If the database is open, instance recovery should
close the thread soon - wait a few minutes. Otherwise open
the database - crash recovery will close the thread.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22861: invalid user-defined type

1 Answers  


ORA-09201: sfcopy: error copying file

1 Answers  


TNS-00095: * to trace_on - argument is considered the trace level

1 Answers  


ORA-24752: OCI_TRANS_NEW flag must be specified for local transactions

1 Answers  


ORA-39096: invalid input value string for parameter string

1 Answers  






ORA-30024: Invalid specification for CREATE UNDO TABLESPACE

1 Answers  


LSX-00104: duplicate type "~S"

1 Answers  


ORA-08330: Printing not supported

1 Answers  


ORA-04081: trigger 'string' already exists

1 Answers  


ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE

1 Answers  


PLS-00368: in RAISE statement, 'string' must be an exception name

1 Answers  


DRG-11303: secondary indexes are not supported by this indextype

1 Answers  


Categories