ORA-01138: database must either be open in this instance or
not at all

Answers were Sorted based on User's Feedback



ORA-01138: database must either be open in this instance or not at all..

Answer / linda s

You will see this on RAC 12c if you mistakenly only shutdown one node of the RAC and the start RMAN. You have to use srvctl to shutdown both nodes and then you can run rman.

Is This Answer Correct ?    1 Yes 0 No

ORA-01138: database must either be open in this instance or not at all..

Answer / guest

Cause: The requested operation can not be done when the
database is mounted but not open in this instance, and
another instance has the database open.

Action: Execute the operation in an open instance, open the
datbase in this instance, or close the database in the other
instances.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24405: error occured while trying to create connections in the pool

1 Answers  


ORA-09743: smscre: could not attach shared memory.

1 Answers  


ORA-00910: specified length too long for its datatype

1 Answers  


ORA-24038: RETRY_DELAY and MAX_RETRIES cannot be used for a 8.0 compatible multiple consumer queue

1 Answers  


NNL-00001: request argument "string" is invalid

1 Answers  






ORA-31634: job already exists

1 Answers  


ORA-12414: internal LBAC error: string Error: string

1 Answers  


QSM-01005: no query rewrite when query has slave SQL

1 Answers  


ORA-25138: %s initialization parameter has been made obsolete

1 Answers  


QSM-02053: collection subquery in mv

1 Answers  


NNL-00229: Request-processing delay is now disabled

1 Answers  


SQL*Loader-00474: no value set for dynamic file for column string in table string row number

1 Answers  


Categories