Saturday 4 February 2012

ORA-06521: PL or SQL: Error mapping function

ORA-06521: PL or SQL: Error mapping function

Cause: An error was detected by PL or SQL trying to map the mentioned function dynamically.

Action: Check the stacked error (if any) for more details.

ORA-06520: PL or SQL: Error loading external library

ORA-06520: PL or SQL: Error loading external library

Cause: An error was detected by PL or SQL trying to load the external library dynamically.

Action: Check the stacked error (if any) for more details.

ORA-06519: active autonomous transaction detected and rolled back

ORA-06519: active autonomous transaction detected and rolled back

Cause: Before returning from an autonomous PL or SQL block, all autonomous transactions started within the block must be completed (either committed or rolled back). If not, the active autonomous transaction is implicitly rolled back and this error is raised.

Action: Ensure that before returning from an autonomous PL or SQL block, any active autonomous transactions are explicitly committed or rolled back. ----------------------------------------------------------------------- 06520 through 06529 reserved for Foreign function errors

ORA-06518: PL or SQL: Probe version string incompatible with version string

ORA-06518: PL or SQL: Probe version string incompatible with version string

Cause: The current version of Probe is incompatible with the version on the ORACLE server.

Action: Refer to the documentation to ensure that this degree of compatibility is supported.

ORA-06517: PL or SQL: Probe error - string

ORA-06517: PL or SQL: Probe error - string

Cause: An error occurred while passing a Probe operation to the server for execution.

Action: Refer to the entry for the embedded error message.

ORA-06516: PL or SQL: the Probe packages do not exist or are invalid

ORA-06516: PL or SQL: the Probe packages do not exist or are invalid

Cause: A Probe operation, probably an attempt to initialize the ORACLE server to debug PL or SQL, could not be completed because the Probe packages were not loaded or have become invalid.

Action: DBA should load the Probe packages. This can be done by running the pbload.sql script supplied with the RDBMS.

ORA-06515: PL or SQL: unhandled exception string

ORA-06515: PL or SQL: unhandled exception string

Cause: An exception was raised by PL or SQL code, but not handled. The exception number is outside the legal range of Oracle errors.

Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.

ORA-06514: PL or SQL: The remote call cannot be handled by the server

ORA-06514: PL or SQL: The remote call cannot be handled by the server

Cause: The remote call has parameters that are cursor variables or lob variables. This cannot be handled by stored procedures on your server.

Action: Avoid using cursor variables or lob variables as parameters for stored procedures on this server or upgrade your server to a version that supports this.

ORA-06513: PL or SQL: index for PL or SQL table out of range for host language array

ORA-06513: PL or SQL: index for PL or SQL table out of range for host language array

Cause: An attempt is being made to copy a PL or SQL table to a host language array. But an index in the table is either less than one or greater than the maximum size of the host language array. When copying PL or SQL tables to host language arrays, the table entry at index 1 is placed in the first element of the array, the entry at index 2 is placed in the second element of the array, etc. If an table entry has not been assigned then the corresponding element in the host language array is set to null.

Action: Increase size of host language array, or decrease size of PL or SQL table. Also make sure that you don t use index values less than 1.

ORA-06512: at stringline string

ORA-06512: at stringline string

Cause: Backtrace message as the stack is unwound by unhandled exceptions.

Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.

ORA-06511: PL or SQL: cursor already open

ORA-06511: PL or SQL: cursor already open

Cause: An attempt was made to open a cursor that was already open.

Action: Close cursor first before reopening.

ORA-06510: PL or SQL: unhandled user-defined exception

ORA-06510: PL or SQL: unhandled user-defined exception

Cause: A user-defined exception was raised by PL or SQL code, but not handled.

Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.

ORA-06505: PL or SQL: variable requires more than 32767 bytes of contiguous memory

ORA-06505: PL or SQL: variable requires more than 32767 bytes of contiguous memory

Cause: A PL or SQL variable was declared with a constraint which required more than 32767 bytes of memory. PL or SQL does not currently support allocations of contiguous memory greater than 32767 bytes.

Action: Consider reducing the constraint in the variable declaration. If that is not possible, try changing the database or national character set to such, that requires less memory for the same constraint. Note: changing the character set will impact execution of all PL or SQL code.

ORA-06504: PL or SQL: Return types of Result Set variables or query do not match

ORA-06504: PL or SQL: Return types of Result Set variables or query do not match

Cause: Number and or or types of columns in a query does not match declared return type of a result set variable, or declared types of two Result Set variables do not match.

Action: Change the program statement or declaration. Verify what query the variable actually refers to during execution.

ORA-06503: PL or SQL: Function returned without value

ORA-06503: PL or SQL: Function returned without value

Cause: A call to PL or SQL function completed, but no RETURN statement was executed.

Action: Rewrite PL or SQL function, making sure that it always returns a value of a proper type.

ORA-06500: PL or SQL: storage error

ORA-06500: PL or SQL: storage error

Cause: PL or SQL was unable to allocate additional storage. This message normally Sometimes this error can be caused by runaway programs.

Action: 1) Ensure there are no issues or bugs in your PL or SQL program which are causing excessive amounts of memory to be used. 2) Programmatically cause unused objects to be freed (e.g. by setting them to NULL). 3) Increase the amount of shared or process memory (as appropriate) available to you.

ORA-06449: The list IO or the sysvendor is not installed.

ORA-06449: The list IO or the sysvendor is not installed.

Cause: ORACLE tries to use the sysvendor interface (INIT.ORA parameter use_ sysvendor=true) but the UNIX kernel does not have the ORACLE sysvendor interface linked in.

Action: Set use_sysvendor=false in INIT.ORA, if you don t want to use this interface or link the UNIX kernel with this interface so that ORACLE can use it.

ORA-06448: ssvpstp: Failed with unexpected error number.

ORA-06448: ssvpstp: Failed with unexpected error number.

Cause: Some system problems may exists on your system, please check error logs.

Action: The additional information indicates the error number. Look up the additional information returned in your operating system manual.

ORA-06447: ssvpstp: Incorrect parameter passed to function call

ORA-06447: ssvpstp: Incorrect parameter passed to function call

Cause: Invalid oracle process ID is passed in to this routine.

Action: The additional information indicates the process id.

ORA-06446: ssvpstevrg: Failed with unexpected error number.

ORA-06446: ssvpstevrg: Failed with unexpected error number.

Cause: Some system problems may exist on your system, please check error logs.

Action: The additional information indicates the error number. Look up the additional information returned in your operating system manual.

ORA-06445: ssvpstevrg: Incorrect parameters passed to function call

ORA-06445: ssvpstevrg: Incorrect parameters passed to function call

Cause: An invalid event id, or the low and high event ID do not exist.

Action: The additional information indicates the error number. It also contains the event id, low boundary and high boundary.

ORA-06444: ssvpstev: Failed with unexpected error number.

ORA-06444: ssvpstev: Failed with unexpected error number.

Cause: Some system problems may exist on your system, please check error logs.

Action: The additional information indicates the error number. Look up the additional information returned in your operating system manual.

ORA-06443: ssvpstev: Incorrect parameter passed to function call

ORA-06443: ssvpstev: Incorrect parameter passed to function call

Cause: An invalid event ID is passed in to this routine.

Action: The additional information indicates the event id.

ORA-06442: ssvwatev: Failed with unexpected error number.

ORA-06442: ssvwatev: Failed with unexpected error number.

Cause: Some system problems may exists on your system, please check error logs.

Action: The additional information indicates the error number. Look up the additional information returned in your operating system manual.

ORA-06441: ssvwatev: Incorrect parameter passed to function call

ORA-06441: ssvwatev: Incorrect parameter passed to function call

Cause: Either the ORACLE process id, or wait time or event ID is invalid.

Action: The additional information indicates the process id, time and event id.

ORA-06440: ssaio: the asynchronous read returned incorrect number of bytes

ORA-06440: ssaio: the asynchronous read returned incorrect number of bytes

Cause: This read call may have been truncated. The additional information returns the block number and number of bytes.

Action: Verify that the block number and the number of bytes read are correct.

ORA-06439: ssaio: the asynchronous write returned incorrect number of bytes

ORA-06439: ssaio: the asynchronous write returned incorrect number of bytes

Cause: This write call may have been truncated. The additional information returns the block number and number of bytes.

Action: Verify that the block number and the number of bytes written are correct.

ORA-06438: ssaio: the asynchronous read was unable to read from the database file.

ORA-06438: ssaio: the asynchronous read was unable to read from the database file.

Cause: The Asynchronous I or O system call returned an error.

Action: The additional information indicates the block number. Look up the additional information returned in your operating system manual.

ORA-06437: ssaio: the asynchronous write was unable to write to the database file.

ORA-06437: ssaio: the asynchronous write was unable to write to the database file.

Cause: The Asynchronous I or O system call returned an error.

Action: The additional information indicates the block number. Look up the additional information returned in your operating system manual.

ORA-06436: ssaio: asynchronous I or O failed due to incorrect parameters.

ORA-06436: ssaio: asynchronous I or O failed due to incorrect parameters.

Cause: The Asynchronous I or O system call returned an error.

Action: The additional information indicates the block number. Look up the additional information returned in your operating system manual.

ORA-06435: ssaio: write error, unable to write requested block to database file.

ORA-06435: ssaio: write error, unable to write requested block to database file.

Cause: The write system call returned an error.

Action: The additional information indicates the block number. Look up the additional information returned in your operating system manual.

ORA-06434: ssaio: read error, unable to read requested block from database file.

ORA-06434: ssaio: read error, unable to read requested block from database file.

Cause: The read system call returned an error.

Action: The additional information indicates the block number. Look up the additional information returned in your operating system manual.

ORA-06433: ssaio: LSEEK error, unable to seek to requested block.

ORA-06433: ssaio: LSEEK error, unable to seek to requested block.

Cause: The additional information returns the block number

Action: Look up the additional information returned in your operating system reference manual. Verify that the block number is correct.

ORA-06432: ssaio: Buffer Not Aligned

ORA-06432: ssaio: Buffer Not Aligned

Cause: The I or O buffer was not aligned on a 2K boundary.

Action: Contact your Oracle Customer Support Representative.

ORA-06431: ssaio: Invalid Block number

ORA-06431: ssaio: Invalid Block number

Cause: The file block number is out of range of the file. The additional information returns the block number.

Action: Verify that the block number is correct. Run dbfsize and check if the block number is in that range. Contact your Oracle Customer Support Representative.

ORA-06430: ssaio: Seals do not match

ORA-06430: ssaio: Seals do not match

Cause: A function was called with an invalid argument.

Action: Contact your Oracle Customer Support Representative.

ORA-06423: NETCMN: Error in receiving data

ORA-06423: NETCMN: Error in receiving data

Cause: Unable to receive data from remote host.

Action: Try reconnect to remote host, and contact your system administrator.

ORA-06422: NETCMN: Error in sending data

ORA-06422: NETCMN: Error in sending data

Cause: Unable to transmit data to remote host.

Action: Try reconnect to remote host, and contact your system administrator.

ORA-06421: NETCMN: Error detected in the read-in data

ORA-06421: NETCMN: Error detected in the read-in data

Cause: Error found during recomputation of checksum or CRC.

Action: Possible hardware failures of communication nodes. Contact system administrator immediately.

ORA-06420: NETCMN: SID lookup failure

ORA-06420: NETCMN: SID lookup failure

Cause: From the remote host s server: the database SID, specified in the login (connect) string, was not recognized.

Action: Add the appropriate SID entry to the CONFIG.ORA or oratab file on the remote host (restarting the remote server may be needed).

ORA-06419: NETCMN: server can not start oracle

ORA-06419: NETCMN: server can not start oracle

Cause: The remote server was unable to start an ORACLE process on behalf of the client.

Action: Make sure permissions on the remote ORACLE program are correctly set. Contact your system administrator.

ORA-06416: NETCMN: error on test

ORA-06416: NETCMN: error on test

Cause: Error occurred while testing I or O status of the network connection.

Action: Contact your customer support representative.

ORA-06413: Connection not open.

ORA-06413: Connection not open.

Cause: Unable to establish connection.

Action: Use diagnostic procedures to ascertain exact problem.

ORA-06408: NETCMN: incorrect message format

ORA-06408: NETCMN: incorrect message format

Cause: Message from partner contains bad header.

Action: Contact your customer support representative.

ORA-06407: NETCMN: unable to set up break handling environment

ORA-06407: NETCMN: unable to set up break handling environment

Cause: Error occurred while attempting to set up asynchronous handlers for in-coming, out-of-band break messages.

Action: Contact your customer support representative.

ORA-06406: NETCMN: error sending break message

ORA-06406: NETCMN: error sending break message

Cause: Error occurred while attempting to send a break message.

Action: Contact your customer support representative.

ORA-06405: NETCMN: reset protocol error

ORA-06405: NETCMN: reset protocol error

Cause: Unable to reset out of break state.

Action: Contact your customer support representative.

ORA-06404: NETCMN: invalid login (connect) string

ORA-06404: NETCMN: invalid login (connect) string

Cause: Syntax error in login string.

Action: Correct string and re-submit.

ORA-06403: Unable to allocate memory.

ORA-06403: Unable to allocate memory.

Cause: System unable to allocate needed virtual memory.

Action: Configure more memory, reduce load, or simply try again.

ORA-06402: NETCMN: error receiving break message

ORA-06402: NETCMN: error receiving break message

Cause: Error occurred while attempting to read a break message.

Action: Contact your customer support representative.

ORA-06401: NETCMN: invalid driver designator

ORA-06401: NETCMN: invalid driver designator

Cause: The login (connect) string contains an invalid driver designator.

Action: Correct the string and re-submit.

ORA-06400: NETCMN: No default host string specified

ORA-06400: NETCMN: No default host string specified

Cause: There was no default host string specified in the configuration and the user didn t specify any explicit connect string.

Action: Either reconfigure the system specifying a default connect string or use an explicit connect string.

ORA-06323: IPA:

ORA-06323: IPA:

Cause event error Cause: Fatal interprocess communication error.

Action: Contact your system manager.

ORA-06322: IPA: Fatal shared memory error

ORA-06322: IPA: Fatal shared memory error

Cause: An internal error has occurred in the shared memory handling.

Action: Contact customer support.

ORA-06321: IPA: Cannot reach the remote side

ORA-06321: IPA: Cannot reach the remote side

Cause: There has been a timeout on an attempt to connect to a remote server the reason for which is most likely to be the remote SQL*Net IPA software is not running. An alternative reason could be that the remote initiator service name is incorrect.

Action: Check and start the remote SQL*Net software. Check that it is started with the correct service names supplied.

ORA-06320: IPA: Remote maximum number of connections exceeded

ORA-06320: IPA: Remote maximum number of connections exceeded

Cause: The maximum number of simultaneous connections that SQL*Net IPA can handle from different hosts has been exceeded on the remote side.

Action: Wait for free connections to become available. If the problem persists, contact your system manager.

ORA-06319: IPA: Remote maximum number of users exceeded

ORA-06319: IPA: Remote maximum number of users exceeded

Cause: The maximum number of simultaneous users of SQL*Net IPA has been exceeded on the remote side.

Action: Wait for free connections to become available. If the problem persists, contact your system manager.

ORA-06318: IPA: Local maximum number of connections exceeded

ORA-06318: IPA: Local maximum number of connections exceeded

Cause: The maximum number of simultaneous connections that SQL*Net IPA can handle to different hosts has been exceeded on the local side.

Action: Wait for free connections to become available. If the problem persists, contact your system manager.

ORA-06317: IPA: Local maximum number of users exceeded

ORA-06317: IPA: Local maximum number of users exceeded

Cause: The maximum number of simultaneous users of SQL*Net IPA has been exceeded on the local side.

Action: Wait for free connections to become available. If the problem persists, contact your system manager.

ORA-06316: IPA: Invalid database SID

ORA-06316: IPA: Invalid database SID

Cause: The SID is unknown at the remote side.

Action: Either the database does not exist, is not running, or there are no reserved servers for that SID.