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

LPX-00284: namespace prefix to NULL URI is not allowed

1 Answers  


ORA-21614: constraint violation for attribute number [string]

1 Answers  


ORA-07206: slgtd: gettimeofday error, unable to obtain time.

1 Answers  


SQL*Loader-00810: error creating external table: string

1 Answers  


ORA-07276: no dba group in /etc/group.

1 Answers  


EXP-00072: error closing export file string

1 Answers  


ORA-27151: buffer not large enough to hold process ID string

1 Answers  


IMP-00001: respond with either string, string, RETURN or '.' to quit

1 Answers  


NNL-01051: Server name: string

1 Answers  


LSX-00134: attribute "~1S" has invalid qualification "~2S"

1 Answers  


ORA-19724: snapshot too old: snapshot time is before file string plug-in time

1 Answers  


ORA-36812: (XSTBLFUNC06) Invalid Syntax at '?'.

1 Answers  


Categories