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

UDE-00014: invalid value for parameter, 'string'.

1 Answers  


SQL*Loader-00280: table string is a temporary table

1 Answers  


ORA-27081: unable to close the file

1 Answers  


ORA-13510: invalid RETENTION string, must be in the range (string, string)

1 Answers  


ORA-25297: The message options only make sense for buffered messages

1 Answers  


ORA-01114: IO error writing block to file string (block # string)

1 Answers  


DRG-10755: %(1)s and string have characters in common

1 Answers  


ORA-27074: unable to determine limit for open files

1 Answers  


NNL-01045: Errors writing data stream: number

1 Answers  


ORA-07570: szrfc: $IDTOASC failure

1 Answers  


ORA-16751: Resource guard encountered errors in switchover to primary

1 Answers  


ORA-16777: unable to find the destination entry of a standby in V$ARCHIVE_DEST

1 Answers  


Categories