Oracle Database Errors or Warnings from Error ORA-01081 to ORA-01090

SQLServerF1

 

ORA-01081: cannot start already-running ORACLE – shut it down first
Cause: Obvious
Action: None
ORA-01082: ‘row_locking = always’ requires the transaction processing option
Cause: “row_locking = always” is specified in INIT.ORA file. This feature is not supported by ORACLE without the transaction processing option.
Action: Remove it from INIT.ORA file or set it to “default” or “intent”.
ORA-01083: value of parameter “string” is inconsistent with that of other instances
Cause: The value of the given parameter is required to be the same for all instances in the cluster database configuration. ROW_LOCKING and SERIALIZABLE are 2 examples.
Action: Change the value of the parameter in INIT.ORA file to match that of other cluster database instances.

ORA-01084: invalid argument in OCI call
Cause: The failing OCI call contains an argument with an invalid value.
Action: Use valid argument values. For more information, see the Programmer’s Guide to the Oracle Call Interfaces and the appropriate programming language supplement.
ORA-01085: preceding errors in deferred rpc to “string.string.string”
Cause: Errors were encountered when the named procedure was executed as a deferred remoted procedure call.
Action: Correct the cause of the preceding errors.
ORA-01086: savepoint ‘string’ never established in this session or is invalid
Cause: An attempt was made to roll back to a savepoint that was never established in this session, or was invalid.
Action: Try rolling back to the savepoint from the session where it is established.

ORA-01088: shutdown in progress – operation not permitted until restart
Cause: The SHUTDOWN command was used to shut down a running Oracle instance but the shutdown operation was not complete.
Action: Wait for the instance to be restarted or contact your database administrator.
ORA-01089: immediate shutdown in progress – no operations are permitted
Cause: The SHUTDOWN IMMEDIATE command was used to shut down a running ORACLE instance, so your operations have been terminated.
Action: Wait for the instance to be restarted, or contact your DBA.
ORA-01090: shutdown in progress – connection is not permitted
Cause: The SHUTDOWN command was used to shut down a running ORACLE instance, so you cannot connect to ORACLE.
Action: Wait for the instance to be restarted, or contact your DBA.

Above are list of Oracle Database Errors or Warnings from Error ORA-01081 to ORA-01090 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.

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 *