Home > Error Codes > Oracle 11g Error Codes

Oracle 11g Error Codes


Action: Recover the database with the compatible software, shut it down cleanly, then restart with current software. SP2-0834 Package Body altered with compilation errors Cause: The PL/SQL package body has been altered, but has one or more error messages. Action: Ensure a valid sub-expression is being referenced. SP2-0513 Misplaced CREATE keyword Cause: The CREATE keyword was in the wrong position in the COPY command.

Record the error messages that are returned and contact Oracle Support Services. If you find any problems in the documentation, please report them to us in writing. Action: Make sure that the spatial operations are invoked between two geometries with compatible SRIDs. This is followed by another error message line that contains the sqlcode, sqlstate, errd (error array), and errmc (error tokens) returned from the DRDA Server database. Bonuses

Oracle 11g Error Codes

Then retry the operation. SP2-0594 Usage: SET COLSEP {" " | text} Cause: An invalid option was used in the SET COLSEP command. ORA-00228: length of alternate control file name exceeds maximum of string Cause: The specified filename, which was supplied as a parameter to cfileSetSnapshotName or cfileUseCopy, exceeds the maximum filename length for Verify that the appropriate privileges exist on the table.

Action: Specify the variable with valid characters. Check that the SQL*Plus binary message files exist in the SQL*Plus message directory, for example $ORACLE_HOME/sqlplus/mesg. SP2-0017 missing column name after keyword_name keyword Cause: There was no column name after the specified keyword. Oracle 11g Error Codes Pdf Action: Correct and remove the illegal character from the buffer name.

ORA-00331: log version string incompatible with ORACLE version string Cause: The log was written by incompatible version of Oracle. This redo log file is not from the current database. Action: Retry with a name of the form "D###" denoting an existing dispatcher process. ORA-00031: session marked for kill Cause: The session specified in an ALTER SYSTEM KILL SESSION command cannot be killed immediately (because it is rolling back or blocked on a network operation),

Action: No action required. Oracle Common Errors And Solutions ORA-12807: process queue could not receive parallel query message Cause: Internal error. ORA-13027: unable to read dimension definition from string Cause: There was a problem reading the dimension definition from the _SDODIM table. ORA-12845: failed to receive interinstance parallel execution message Cause: OS or interconnect problem receiving interinstance message Action: Check OS specific diagnostics ORA-12850: Could not allocate slaves on all specified instances: string

  • Action: Take the following actions: Change privileges to allow creation of the file.
  • Action: Rewrite the query to select the data with types that SQL*Plus supports.
  • Action: Use the appropriate SQL*Plus command.
  • ORA-13113: invalid tg_layer_id in sdo_topo_geometry constructor Cause: An invalid layer_id was passed to the SDO_TOPO_GEOMETRY constructor.
  • NOTE: If the application uses Oracle-mode SQL instead of ANSI-mode SQL, ORA-01403 will be generated instead of ORA-00100.
  • Action: Check the syntax of the SET command for the correct options.
  • SP2-0265 option_name must be set ON or OFF Cause: An invalid SET option name was specified.

Oracle Error Codes And Solution Pdf

Action: Specify a topology in the range of 1 to 8. Action: See the Oracle Spatial documentation for a description of the syntax and semantics of the relevant SDO_GEOM function. Oracle 11g Error Codes SP2-0519 FROM string missing Oracle Net @database specification Cause: Missing connect string for the database that contains the data to be copied from in the COPY command. Oracle Database Errors And Solutions ORA-00232: snapshot control file is nonexistent, corrupt, or unreadable Cause: The snapshot control file was found to be nonexistent, corrupt, or unreadable during an invocation of cfileUseSnapshot.

Action: Specify the correct redo log file, then retry the operation. This is likely to have been caused by operator or operating system error. Valid HHCODE types are POINT and LINE. Action: Reduce the size of the value and re-enter. Oracle Error Codes List With Description

ADD (...), and so on. Action: Specify a valid process. Also check that the lock has not been corrupted. have a peek here Re-code to use fewer commands and/or shorter variable names.

Try again with outline. Oracle Error Codes Table Cause: There is no help information available for the specified command. Cask framework aims to speed Azure HDInsight data pipeline builds A link between Cask Data's CDAP application and integration environment and Azure HDInsight, Microsoft's Hadoop cloud service, is...

Action: SCAN_INSTANCES / CACHE_INSTANCES may not be set unless running Oracle Real Application Clusters mounted in CLUSTER_DATABASE mode.

ORA-12856: cannot run parallel query on a loopback connection Cause: A table or index in a parallel query is referenced via a loopback connection. Action: Normally occurs after other errors showing that the database is not running, or that the username and password were invalid. SP2-0826 Dimension altered with compilation warnings Cause: The PL/SQL dimension has been altered, but has one or more warnings, informational messages or performance messages that may help you to improve your Oracle 11g Error Codes List With Description Action: Make sure that the correct feature tables are specified in the call to register the feature table with the topology.

Action: Check that the specified variable is correct and try again. SP2-0501 Error in SELECT statement: Oracle_database_error_message Cause: Invalid SELECT statement found in the COPY command. ORA-13152: invalid HHCODE type Cause: Specified HHCODE type is not valid. ORA-13185: failed to generate initial HHCODE Cause: This is an internal error.

ORA-13200: internal error [string] in spatial indexing. SP2-0827 Procedure created with compilation errors Cause: The PL/SQL procedure has been created, but has one or more error messages. ORA-12809: cannot set string_INSTANCES when mounted in exclusive mode Cause: An attempt was made to set SCAN_INSTANCES or CACHE_INSTANCES using the ALTER SYSTEM command while the database was mounted in exclusive