ORA-16002: database already open for read-write access by
another instance



ORA-16002: database already open for read-write access by another instance..

Answer / guest

Cause: The database has been opened for read-write access by
another instance, and cannot be opened for read-only access
by this instance.

Action: This instance must be opened for read-only access,
or all other instances must first be shut down and re-opened
for read-write access.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01536: space quota exceeded for tablespace 'string'

3 Answers   Bloom Soft Tech, TCS,


RMAN-06102: no channel to restore a backup or copy of log thread number seq number lowscn string

1 Answers  


ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

1 Answers  


ORA-12012: error on auto execute of job string

1 Answers  


ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE

1 Answers  


ORA-01140: cannot end online backup - all files are offline or readonly

1 Answers  


ORA-27468: "string.string" is locked by another process

1 Answers  


DRG-11825: Not Acceptable

1 Answers  


ORA-07224: sfnfy: failed to obtain file size limit; errno = string.

1 Answers  


TNS-12560: TNS:protocol adapter error

1 Answers  


ORA-02059: ORA-2PC-CRASH-TEST-string in commit comment

1 Answers  


RMAN-06454: duplexed backups require Enterprise Edition

1 Answers  


Categories