Category: Oracle

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 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 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 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 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 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 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…

Oracle 11g Error Codes and Solution Suggestions from ORA-14700 to ORA-15000 ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user Cause: Attempt to issue a LOCK TABLE statement on SYS owned object(s) by a non-SYS user, user should minimally have DML privileges Action: Re-issue LOCK TABLE statement for non-SYS user after granting DML privileges on…

Oracle 11g Error Codes and Solution Suggestions from ORA-14500 to ORA-14700 ORA-14500: LOCAL option not valid without partition name Cause: Incorrect syntax specified Action: Retry the command ORA-14501: object is not partitioned Cause: Table or index is not partitioned. Invalid syntax. Action: Retry the command with correct syntax. ORA-14503: only one partition name can be specified Cause: More than one…

Oracle 11g Error Codes and Solution Suggestions from ORA-14300 to ORA-14500 ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions Cause: The row inserted had a partitioning key that maps to a partition number greater than 1048575 Action: Ensure that the partitioning key falls within 1048575 partitions or subpartitions. ORA-14301: table-level attributes must…