Oracle 11g Error Codes and Solution Suggestions from ORA-16700 to ORA-16800 ORA-16700: the standby database has diverged from the primary database Cause: The primary database may have been flashed back or restored from a backup set and then reopened with the RESETLOGS option. Action: Re-create the standby database from the primary database or flash back the standby…
Tag: Oracle Administration
Oracle 11g Error Codes and Solution Suggestions from ORA-16600 to ORA-16700
Oracle 11g Error Codes and Solution Suggestions from ORA-16600 to ORA-16700 ORA-16602: database must be disabled to perform this operation Cause: An attempt was made to edit a database property while the database was enabled. Action: Disable the database and retry the command. ORA-16603: Data Guard broker detected a mismatch in configuration ID Cause: There was a mismatch…
Oracle 11g Error Codes and Solution Suggestions from ORA-16500 to ORA-16600
Oracle 11g Error Codes and Solution Suggestions from ORA-16500 to ORA-16600 ORA-16501: the Data Guard broker operation failed Cause: The Data Guard broker operation failed. Action: See accompanying messages for details. ORA-16502: the Data Guard broker operation succeeded with warnings Cause: The Data Guard broker operation succeeded with warnings. Action: See accompanying messages for details. ORA-16503: cannot exceed the…
Oracle 11g Error Codes and Solution Suggestions from ORA-16300 to ORA-16500
Oracle 11g Error Codes and Solution Suggestions from ORA-16300 to ORA-16500 ORA-16302: extended data type support is not supported for specified table Cause: A call was made to DBMS_LOGSTDBY.EDS_ADD_TABLE for a table that was not supported for such an operation. The table either does not have a primary key or it has a data type not…
Oracle 11g Error Codes and Solution Suggestions from ORA-16200 to ORA-16300
Oracle 11g Error Codes and Solution Suggestions from ORA-16200 to ORA-16300 ORA-16200: Skip procedure requested to skip statement Cause: Logical standby called a skip procedure that requested for a particular statement not to be applied. Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes. ORA-16201: Skip procedure requested to apply…
Oracle 11g Error Codes and Solution Suggestions from ORA-16100 to ORA-16200
Oracle 11g Error Codes and Solution Suggestions from ORA-16100 to ORA-16200 ORA-16100: not a valid Logical Standby database Cause: This database has not been completely configured as a Logical Standby database. Action: Verify that the database is the intended Logical Standby database. Ensure that you already started logical standby apply with the ALTER DATABASE START LOGICAL APPLY…
Oracle 11g Error Codes and Solution Suggestions from ORA-16000 to ORA-16100
Oracle 11g Error Codes and Solution Suggestions from ORA-16000 to ORA-16100 ORA-16000: database open for read-only access Cause: The database was opened for read-only access. Attempts to modify the database using DML or DDL statements generate this error. Action: In order to modify the database, it must first be shut down and reopened for read/write access. ORA-16001:…
Oracle 11g Error Codes and Solution Suggestions from ORA-15600 to ORA-16000
Oracle 11g Error Codes and Solution Suggestions from ORA-15600 to ORA-16000 ORA-15601: Invalid value specified for parameter “string“ Cause: An invalid value was specified for the given parameter. Action: Correct the value being specified for the parameter. ORA-15602: Parameter “string” cannot be NULL. Cause: An attempt was made to call a procedure without a required parameter. Action: Specify a…
Oracle 11g Error Codes and Solution Suggestions from ORA-15400 to ORA-15600
Oracle 11g Error Codes and Solution Suggestions from ORA-15400 to ORA-15600 ORA-15400: not running on supported ASM appliance Cause: An attempt was made to initialize the server code as an appliance when it was not running a supported appliance configuration. Action: Check the appliance configuration and retry the operation. ORA-15401: command not supported on ASM appliance ‘string‘…
Oracle 11g Error Codes and Solution Suggestions from ORA-15200 to ORA-15400
Oracle 11g Error Codes and Solution Suggestions from ORA-15200 to ORA-15400 ORA-15200: initialization parameter string (string) is not a power of two Cause: The value specified for this initialization parameter was not a power of two. Action: Correct the initialization parameter value and restart the instance. ORA-15201: disk string contains a valid RDBMS file Cause: A disk specified in a CREATE DISKGROUP…