Wednesday, 21 March 2012

ORA-16003: standby database is restricted to read-only access

ORA-16003: standby database is restricted to read-only access

Cause: To ensure its integrity, a standby database can only be opened for read-only access.

Action: Re-issue the ALTER DATABASE OPEN specifying READ ONLY.

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

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

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.

ORA-16001: database already open for read-only access by another instance

ORA-16001: database already open for read-only access by another instance

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

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

ORA-16000: database open for read-only access

ORA-16000: database open for read-only access

Cause: The database has been opened for read-only access. Attempts to modify the database using inappropriate DML or DDL statements generate this error.

Action: In order to modify the database, it must first be shut down and re-opened for read-write access.

ORA-15206: duplicate diskgroup string specified

ORA-15206: duplicate diskgroup string specified

Cause: A command specified the same diskgroup twice.

Action: Specify each diskgroup only once.

ORA-15205: requested mirror side unavailable

ORA-15205: requested mirror side unavailable

Cause: The requested mirror side of a block is either unallocated or allocated on a disk that has been dropped from the diskgroup.

Action: Resubmit the request or try another mirror side.

ORA-15204: database version string is incompatible with diskgroup string

ORA-15204: database version string is incompatible with diskgroup string

Cause: The database compatibility of the diskgroup was advanced to a later version.

Action: Upgrade the database instance to appropriate version of ORACLE.