Oracle Database Errors or Warnings from Error ORA-31134 to ORA-31143


ORA-31134: Cannot delete a configuration that is referenced by other resources
Cause: Attempted to delete a resource configuration that was referenced by other resources.
Action: Remove all references to the target resource configuration by executing DELETERESCONFIG or DELETEREPOSITORYRESCONFIG procedures in DBMS_RESCONFIG package or specify the DELETE_FORCE option in the DELETERESOURCE statement.
ORA-31135: Resource has already been rendered
Cause: One of the following has occurred: 1) Attempted to invoke setRender* method after the resource was rendered through a setRender* method or after data was written to the output stream. 2) Attempted to access the output stream of the resource after a setRender* method was executed on the resource.
Action: Remove the method causing the problem.
ORA-31136: Resource configuration string is already associated with the resource string
Cause: The resource configuration already exists in the resource configuration list of the resource or the repository
Action: Check if this resource configuration really needs to be added. If so, remove it from resource and repository lists before adding it.

ORA-31137: Index out of range
Cause: The position specified was not valid.
Action: Check (0 <= pos < size of the configuration list of the target resource)
ORA-31138: Resource-configuration is being referenced by one or more resources
Cause: Tried to add a resource configuration to the repository that was being referenced by existing resources.
Action: Remove the resource configuration from other resources before trying to add it to the repository again.
ORA-31139: Invalid resource configuration list
Cause: Attempted to create or update a resource that had duplicate resource configurations or conflicted with the repository configurations.
Action: Correct the resource configuration list and re-submit statement.

ORA-31140: Illegal operation: string
Cause: Tried to invoke a method when it was not allowed.
Action: Do not execute the indicated method.
ORA-31141: Must specify a valid path value
Cause: The path specified for the <defaultChildConfig> or <defaultChildACL> element must refer to an existing resource.
Action: Correct problem and resubmit statement.
ORA-31142: Must specify the schema for each listener
Cause: The schema element was not specified.
Action: Correct problem and resubmit statement.
ORA-31143: XDB_SET_INVOKER role is required
Cause: XDB_SET_INVOKER role was required to set the SET-INVOKER attribute to TRUE.
Action: Correct problem and resubmit statement.

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

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database 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.

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 *