Category: Databases

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-17500 to ORA-18000 ORA-17500: ODM err:string Cause: An error returned by ODM library Action: Look at error message and take appropriate action or contact Oracle Support Services for further assistance ORA-17501: logical block size string is invalid Cause: logical block size for oracle files must be a multiple of the physical…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-16800 to ORA-17000 ORA-16800: redo transport service for a standby database incorrectly set to ALTERNATE Cause: The redo transport service for a standby database was set to ALTERNATE when no other destination is set to alternate to this destination. Action: Reenable the standby database or the entire configuration…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-16600 to ORA-16800 ORA-16600: not connected to target standby database for failover Cause: The failover command failed because the client was not connected to the target standby database. Action: Explicitly connect to the standby database to be failed over to and retry the failover command. ORA-16602: member must…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-16400 to ORA-16600 ORA-16400: quota attributes are not allowed with DB_RECOVERY_FILE_DEST Cause: Quota attributes for the destination parameters are not allowed when the parameter DB_RECOVERY_FILE_DEST is defined. Action: No action is required. ORA-16401: archive log rejected by Remote File Server (RFS) Cause: An attempt was made to re-archive an…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-16200 to ORA-16400 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…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-16000 to ORA-16200 ORA-16000: database or pluggable database open for read-only access Cause: The database or pluggable 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 or pluggable database, it must…

Oracle 12c R2 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…

Oracle 12c R2 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…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-15300 to ORA-15400 ORA-15300: File string is incompatible with this operation Cause: The file type was incompatible with the operation. Action: Use another file of the correct type. ORA-15301: cannot change string of the open file ‘string‘ Cause: A SET OWNERSHIP or SET PERMISSION command was attempted on an open file. Action: Close the…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-15200 to ORA-15300 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 or foreign volume Cause: A disk specified…