Oracle Database Errors or Warnings from Error ORA-38815 to ORA-38855

SQLServerF1

ORA-38815: ALTER SESSION SET EDITION must be a top-level SQL statement
Cause: An edition switch failed because it was executed from a PL/SQL block or using recursive SQL.
Action: Execute the statement from a top-level OCI call, or use dbms_session.set_edition if its deferred effect is appropriate.
ORA-38816: edition has a child that inherits objects from the edition
Cause: This error occurred because an attempt was made to drop an edition that a child that inherits objects from the edition.
Action: Retry after the child edition has no inherited objects.
ORA-38817: Insufficient privileges
Cause: You did not have sufficient privileges to execute the subprogram package DBMS_EDITIONS_UTIL.
Action: Obtain the necessary privileges. Please see the package specification for details.

ORA-38818: illegal reference to versionable object string.string
Cause: A non-versioned edition object referenced a versionable object.
Action: Remove the reference to the versionable object.
ORA-38850: an enabled thread missing from control file
Cause: A CREATE CONTROLFILE statement was given that did not list all the enabled threads for the database.
Action: Reissue the CREATE CONTROLFILE statement, including all enabled threads.
ORA-38851: cannot mark the current instance (redo thread) as disabled
Cause: The standby switchover or failover operation failed because it needs to mark the current instance (redo thread) as disabled.
Action: Shut down this instance and start up using a different instance name or redo thread number and retry.

ORA-38852: cannot mark the current instance (redo thread) as disabled
Cause: The open resetlogs or standby activation operation failed because it must use a different instance (redo thread) than the current instance (redo thread) to open the database.
Action: Shut down this instance and start up using a different instance name or redo thread number and retry.
ORA-38853: cannot mark instance string (redo thread string) as disabled
Cause: The standby switchover or failover operation failed because it needs to mark an instance (redo thread) as disabled. That instance was up, which prevented it from being disabled.
Action: Shut down the specified instance and retry this command.
ORA-38854: cannot mark instance string (redo thread string) as disabled
Cause: The open resetlogs or standby activation operation failed because it needs to mark an instance (redo thread) as disabled. That instance was up, which prevented it from being disabled.
Action: Shut down the specified instance and retry this command.
ORA-38855: cannot mark instance string (redo thread string) as enabled
Cause: The standby switchover or failover operation failed because it needs to mark an instance (redo thread) as enabled. However, it had less than 2 online redo logs, which prevented it from being enabled.
Action: Add more logfiles to the specified instance and retry the command.

Above are list of Oracle Database Errors or Warnings from Error ORA-38815 to ORA-38855 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *