{"id":1852,"date":"2016-04-03T12:02:29","date_gmt":"2016-04-03T09:02:29","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1852"},"modified":"2016-10-24T12:04:46","modified_gmt":"2016-10-24T09:04:46","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-12100-to-ora-12300","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-12100-to-ora-12300\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-12100 to ORA-12300"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12100 to ORA-12300<\/strong><\/p>\n

\n
ORA-12150: TNS:unable to send data<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to send data. Connection probably disconnected.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reestablish connection. If the error is persistent, turn on tracing and reexecute the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12151: TNS:received bad packet type from network layer<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12152: TNS:unable to send break message<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to send break message. Connection probably disconnected.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reestablish connection. If the error is persistent, turn on tracing and reexecute the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12153: TNS:not connected<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Not currently connected to a remote host.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reestablish connection.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12154: TNS:could not resolve the connect identifier specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached.<\/span><\/span><\/span><\/dd>\n
Action:<\/span><\/b><\/span><\/span><\/dd>\n
– If you are using local naming (TNSNAMES.ORA file):<\/span><\/span><\/span><\/dd>\n
– Make sure that “TNSNAMES” is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)<\/span><\/span><\/span><\/dd>\n
– Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.<\/span><\/span><\/span><\/dd>\n
– Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.<\/span><\/span><\/span><\/dd>\n
– Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable.<\/span><\/span><\/span><\/dd>\n
– If you are using directory naming:<\/span><\/span><\/span><\/dd>\n
– Verify that “LDAP” is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).<\/span><\/span><\/span><\/dd>\n
– Verify that the LDAP directory server is up and that it is accessible.<\/span><\/span><\/span><\/dd>\n
– Verify that the net service name or database name used as the connect identifier is configured in the directory.<\/span><\/span><\/span><\/dd>\n
– Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier<\/span><\/span><\/span><\/dd>\n
– If you are using easy connect naming:<\/span><\/span><\/span><\/dd>\n
– Verify that “EZCONNECT” is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).<\/span><\/span><\/span><\/dd>\n
– Make sure the host, port and service name specified are correct.<\/span><\/span><\/span><\/dd>\n
– Try enclosing the connect identifier in quote marks. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12155: TNS:received bad datatype in NSWMARKER packet<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error during break handling.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12156: TNS:tried to reset line from incorrect state<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error during break handling.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12157: TNS:internal network communication error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error during network communication.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12158: TNS:could not initialize parameter subsystem<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to locate parameter file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that a valid parameter file exists, and is readable.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-12159: TNS:trace file not writeable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The trace file to be generated is not writeable by this user.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the user does not have write permissions in the directory to which the trace file will be written, contact an administrator to get the proper permissions or set the TRACE_DIRECTORY_CLIENT parameter in the net profile (SQLNET.ORA file) to a directory the user can write to.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12160: TNS:internal error: Bad error number<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Corrupt error reporting subsystem.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12161: TNS:internal error: partial data received<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The connection may be terminated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reconnect and try again. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12162: TNS:net service name is incorrectly specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If using directory naming check the information provided through the administration used for directory naming.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12163: TNS:connect descriptor is too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The connect descriptor corresponding to the net service name specified as the connect identifier is too long. The maximum length for a connect descriptor is 512 bytes and this limit has been exceeded.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the net service name’s connect descriptor in the local naming file (TNSNAMES.ORA) or in the directory server (Oracle Internet Directory). Use a smaller connect descriptor. If this is not possible, contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12164: TNS:Sqlnet.fdf file not present<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The sqlnet.fdf file doesn’t exist in $ORACLE_HOME\/network\/admin.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The sqlnet.fdf file is required for Oracle Tracing to occur. Either install the sqlnet.fdf file in $ORACLE_HOME\/network\/admin or turn off tracing in your ORA file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12165: TNS:Trying to write trace file into swap space.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Oracle Trace doesn’t allow writing trace information into your swap space.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Oracle Trace cannot write trace information into swap space so either disable tracing or redirect trace files to be written to another area of your disk.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12166: TNS:Client can not connect to HO agent.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0NVstring contained DESCRIPTION\/HO.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Call HO agent from integrating server.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12168: TNS:Unable to contact LDAP Directory Server<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Cannot contact LDAP directory server to get Oracle Net configuration.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the directory server is up and accessible from the network. Verify that directory access configuration is correct. For more information see the Oracle Internet Directory Administrators Guide or the Oracle Net Administrators Guide.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12169: TNS:Net service name given as connect identifier is too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The net service name you are attempting to resolve is too long.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The maximum length of a net service name is 255 bytes; this limit has been exceeded. Use a smaller net service name. If this is not possible, contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12170: TNS:Connect timeout occurred<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The server shut down because connection establishment or communication with a client failed to complete within the allotted time interval. This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the error occurred because of a slow network or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access. Note that logged addresses may not be reliable as they can be forged (e.g. in TCP\/IP).<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12171: TNS:could not resolve connect identifier:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached.<\/span><\/span><\/span><\/dd>\n
Action:<\/span><\/b><\/span><\/span><\/dd>\n
– If you are using local naming (TNSNAMES.ORA file):<\/span><\/span><\/span><\/dd>\n
– Make sure that “TNSNAMES” is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)<\/span><\/span><\/span><\/dd>\n
– Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.<\/span><\/span><\/span><\/dd>\n
– Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.<\/span><\/span><\/span><\/dd>\n
– Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable.<\/span><\/span><\/span><\/dd>\n
– If you are using directory naming:<\/span><\/span><\/span><\/dd>\n
– Verify that “LDAP” is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).<\/span><\/span><\/span><\/dd>\n
– Verify that the LDAP directory server is up and that it is accessible.<\/span><\/span><\/span><\/dd>\n
– Verify that the net service name or database name used as the connect identifier is configured in the directory.<\/span><\/span><\/span><\/dd>\n
– Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier<\/span><\/span><\/span><\/dd>\n
– If you are using easy connect naming:<\/span><\/span><\/span><\/dd>\n
– Verify that “EZCONNECT” is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).<\/span><\/span><\/span><\/dd>\n
– Make sure the host, port and service name specified are correct.<\/span><\/span><\/span><\/dd>\n
– Try enclosing the connect identifier in quote marks. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12196: TNS:received an error from TNS<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The navigation layer received an error from TNS.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See the error log file for the specific TNS error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12197: TNS:keyword-value resolution error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The navigation layer received an error while trying to look up a value for a keyword.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the syntax of the connect descriptor.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12198: TNS:could not find path to destination<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Could not navigate a path through Interchanges to the destination. This error occurs if an invalid community is in the address string, or the address includes a protocol that is not available or the TNSNAV.ORA file does not have a correct CMANAGER address specified or the Interchange is down.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Assure that Interchanges necessary to get to the desired destination are up and have available capacity for an additional connection. Also check that the correct community and protocol have been specified in the CMANAGER address used.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12200: TNS:could not allocate memory<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Out of memory on machine.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reconfigure machine to have more storage or run fewer applications while the Interchange is running.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12201: TNS:encountered too small a connection buffer<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0TNS connection buffer supplied by the application was too small to retrieve the data sent back.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Supply a larger connection buffer. If problem persists, call Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12202: TNS:internal navigation error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal navigation error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Not normally visible to the user. For further details contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12203: TNS:unable to connect to destination<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Invalid address specified or destination is not listening. This error can also occur because of underlying network or network transport problems.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the net service name you entered was correct. Verify that the ADDRESS portion of the connect descriptor which corresponds to the net service name is correct. Ensure that the destination process (for example the listener) is running at the remote node.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12204: TNS:received data refused from an application<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The application using Connection Manager refused the connection at the listener.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the application listener at the destination is functioning correctly. If it is and the problem persists, contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12205: TNS:could not get failed addresses<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal navigation error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Not normally visible to the user. For further details contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12206: TNS:received a TNS error during navigation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal navigation error because of an unexpected TNS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Look at the log file to find the TNS error. If necessary, turn on tracing and repeat the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12207: TNS:unable to perform navigation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Improperly configured navigation file TNSNAV.ORA.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the syntax of the TNSNAV.ORA file on the application`s machine, and verify that it lists the correct communities.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12208: TNS:could not find the TNSNAV.ORA file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Either the ORACLE environment is not set up correctly, or the TNSNAV.ORA file is not present.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the ORACLE environment is set up appropriately on your platform and that a TNSNAV.ORA file is present.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12209: TNS:encountered uninitialized global<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Application calling navigation routine has not properly configured the global variables. There are no TNSNAV.ORA files available, or they are defective.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12210: TNS:error in finding Navigator data<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Application calling navigation routine has not properly configured the TNSNAV.ORA file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the syntax of the TNSNAV.ORA file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0TNSNAV.ORA does not have a PREFERRED_CMANAGERS defined.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Add a PREFERRED_CMANAGERS entry to the TNSNAV.ORA file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12212: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The PREFERRED_CMANAGERS binding in the client’s TNSNAV.ORA file does not have a CMANAGER_NAME specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Define the CMANAGER_NAME as part of the PREFERRED_CMANAGERS binding. Use of the Oracle Network Manager should eliminate this error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The PREFERRED_CMANAGERS binding in the client’s TNSNAV.ORA file does not have an ADDRESS specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Define the ADDRESS as part of the PREFERRED_CMANAGERS binding.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12214: TNS:missing local communities entry in TNSNAV.ORA<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There is no LOCAL_COMMUNITIES entry in TNSNAV.ORA.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Define the LOCAL_COMMUNITIES for this node in the TNSNAV.ORA file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12215: TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Address binding for PREFERRED_NAVIGATORS entry is improperly entered. entry.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check your PREFERRED_NAVIGATORS entry and fix it in TNSNAV.ORA<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12216: TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Address binding for the PREFERRED_CMANAGERS entry in the client’s TNSNAV.ORA file is improperly entered.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Define the ADDRESS as part of the PREFERRED_CMANAGERS binding.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12217: TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There is a syntax error in the PREFERRED_CMANAGERS entry, or addresses specified are wrong, or the intended Connection Managers are unavailable.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the PREFERRED_CMANAGERS entries in the client’s TNSNAV.ORA file and correct them or talk with your network administrator to determine if the specified Connection Managers are available. Verify that the Interchanges are active by using the INTCTL STATUS command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12218: TNS:unacceptable network configuration data<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Poorly formed network configuration data. For example, a PREFERRED_CMANAGERS entry may have an incorrect CMANAGER_NAME in the client’s TNSNAV.ORA file. Or an Interchange downtime parameter (TIMEOUT_INTERVAL) on the Navigator may be set to zero in INTCHG.ORA.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the entries in TNSNAV.ORA and the Interchange configuration files and correct them. If necessary, talk with your network administrator to determine if the specified Interchanges (Connection Managers) are available and properly configured. Use the Oracle Network Manager to generate the configuration files if necessary.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12219: TNS:missing community name from address in ADDRESS_LIST<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This error occurs when an ADDRESS_LIST has some ADDRESSes in it that have no COMMUNITY component and others that do have a COMMUNITY component.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that in the connect descriptors you are using either all the ADDRESSes have a COMMUNITY component or all do not.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12221: TNS:illegal ADDRESS parameters<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An illegal set of protocol adapter parameters was specified. In some cases, this error is returned when a connection cannot be made to the protocol transport.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the destination can be reached using the specified protocol. Check the parameters within the ADDRESS section of TNSNAMES.ORA or in the directory. Legal ADDRESS parameter formats may be found in the Oracle operating system specific documentation or the Oracle Net Administrator’s Guide. Protocols that resolve names at the transport layer are vulnerable to this error if not properly configured or names are misspelled.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12222: TNS:no support is available for the protocol indicated<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The protocol requested in the ADDRESS portion of the connect descriptor identified through the net service name is not available. If the supplied ADDRESS is typographically correct then support for that protocol is not installed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Install support for the protocol or correct typographical error, as appropriate. Note: if the supplied address was derived from resolving the net service name, check the address in the appropriate file (TNSNAMES.ORA, LISTENER.ORA) or in the directory server.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12223: TNS:internal limit restriction exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Too many TNS connections open simultaneously.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait for connections to close and re-try.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12224: TNS:no listener<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The connection request could not be completed because the listener is not running.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the supplied destination address matches one of the addresses used by the listener – compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12225: TNS:destination host unreachable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Contact can not be made with remote party.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the network driver is functioning and the network is up.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12226: TNS:operating system resource quota exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The current user has exceeded the allotted resource assigned in the operating system.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Acquire more operating system resource, or perform a different function.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12227: TNS:syntax error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The supplied connect descriptor contains illegal syntax.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the syntax of the connect descriptor in TNSNAMES.ORA.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12228: TNS:protocol adapter not loadable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0On some platforms (such as Windows) protocol support is loaded at run-time. If the shared library (or DLL) for the protocol adapter is missing or one of its supporting libraries is missing then this error is returned.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0For further details, turn on tracing and reexecute the operation. The trace file will include the name of the shared library (or DLL) that could not be loaded.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12229: TNS:Interchange has no more free connections<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One or more Interchanges along the path to the destination desired has no more free connections available to be used for this call.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try again later when the Interchanges are less busy, or contact your network administrator to have him determine which interchange it is, and increase the number of connections available on that interchange.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12230: TNS:Severe Network error occurred in making this connection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This error is reported by an interchange which fails to make contact with the destination due to a physical network error while calling a destination.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try again later when the network service may have been fixed or report the problem to your Network Administrator so that he may fix the problem.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12231: TNS:No connection possible to destination<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This error is reported by an interchange which fails to find a possible connection along the path to the destination.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Report the problem to your Network Administrator so that he may fix the problem.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12232: TNS:No path available to destination<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This error is reported by an interchange which fails to find a possible path to the destination.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Report the problem to your Network Administrator so that he may fix the problem.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12233: TNS:Failure to accept a connection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This error is reported by an interchange which fails to accept a connection due to a redirect failure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Report the problem to your Network Administrator so that he may isolate the interchange problem.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12234: TNS:Redirect to destination<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This error is reported by an interchange which determines that this interchange is not the right gateway and needs to redirect the connection to another gateway along the path to the destination.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12235: TNS:Failure to redirect to destination<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This error is reported by an interchange which fails to redirect a connection to another interchange along the path to the destination.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Report the problem to your Network Administrator so that he may fix the problem.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12236: TNS:protocol support not loaded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0On some platforms (such as Windows) protocol support is loaded at run-time. If the shared library (or DLL) for the protocol adapter has not been loaded, then this error is returned.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0For further details, turn on tracing and reexecute the operation. The trace file will have the name of the shared library (or DLL) that has not been loaded.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12100 to ORA-12300 ORA-12150: TNS:unable to send data Cause:\u00a0Unable to send data. Connection probably disconnected. Action:\u00a0Reestablish connection. If the error is persistent, turn on tracing and reexecute the operation. ORA-12151: TNS:received bad packet type from network layer Cause:\u00a0Internal error. Action:\u00a0Not normally visible to the user. For further…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1852","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-tS","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1852"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1852\/revisions"}],"predecessor-version":[{"id":1853,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1852\/revisions\/1853"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1852"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}