{"id":2041,"date":"2016-08-02T11:06:56","date_gmt":"2016-08-02T08:06:56","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2041"},"modified":"2016-12-12T09:31:26","modified_gmt":"2016-12-12T06:31:26","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-00100-to-ora-00200","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-00100-to-ora-00200\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00100 to ORA-00200"},"content":{"rendered":"<p><strong>Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00100 to ORA-00200<\/strong><\/p>\n<dl>\n<dt><span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00100: no data found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0An application made reference to unknown or inaccessible data.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Handle this condition within the application or make appropriate modifications to the application code. NOTE: If the application uses Oracle-mode SQL instead of ANSI-mode SQL, ORA-01403 will be generated instead of ORA-00100.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-D1D97B88-BA48-4A56-8312-E24C655E4757\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00101: invalid specification for system parameter DISPATCHERS<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The syntax for the DISPATCHERS parameter is incorrect.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Refer to the manual for correct syntax.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-1A422858-3F39-4C92-9B9D-7A778DBDEB0F\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00102: network protocol\u00a0<i>string<\/i>\u00a0cannot be used by dispatchers<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The network specified in DISPATCHERS does not have the functionality required by the dispatchers.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Refer to the manual on network protocols supported by the dispatchers.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-DD2FA14E-23B8-4A98-91FE-3B2617538615\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00103: invalid network protocol; reserved for use by dispatchers<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The network specified in the SQL*Net connect string is reserved for use by the dispatchers.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Specify other network protocols in the connection string.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-B88DDC2C-67F0-4A43-8A1F-0D56A97EB46C\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00104: deadlock detected; all public servers blocked waiting for resources<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0All available public servers are servicing requests that require resources locked by a client which is unable to get a public server to release the resources.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Increase the limit for the system parameter MAX_SHARED_SERVERS as the system will automaticaly start up new servers to break the deadlock until the number of servers reaches the value specified in MAX_SHARED_SERVERS.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-E1E12529-3B3E-43D6-9B54-FB86F09934A5\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00105: too many dispatcher configurations<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0Too many dispatcher configurations have been specified. No more can be added.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Consolidate the dispatcher configurations if possible.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-888E26B2-5A3D-49AC-AAF5-B5773C408D67\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00106: cannot startup\/shutdown database when connected to a dispatcher<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0An attempt was made to startup\/shutdown database when connected to a shared server via a dispatcher.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Re-connect as user INTERNAL without going through the dispatcher. For most cases, this can be done by connect to INTERNAL without specifying a network connect string.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-969CC958-2D73-442B-B22A-E06A75AA1EAD\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00107: failed to connect to ORACLE listener process<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0Most likely due to the fact that ORACLE listener has not been started.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Start ORACLE listener if it has not been started. Or else contact your ORACLE representative.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-ADE623E5-3B55-482B-BA46-81342DE94ABC\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00108: failed to set up dispatcher to accept connection asynchronously<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0Most likely due to the fact that the network protocol used by the the dispatcher does not support aynchronous operations.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Contact your ORACLE representative.<\/span><\/span><br \/>\n<!--more--><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-F5400939-5470-43CB-AF3F-60D6AA86F41E\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00109: invalid value for attribute\u00a0<i>string<\/i>:\u00a0<i>string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The value specified for the attribute was incorrect.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Refer to the manual for the proper values.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-48E67532-7638-4F71-BC23-487697521E05\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00110: invalid value\u00a0<i>string<\/i>\u00a0for attribute\u00a0<i>string<\/i>, must be between\u00a0<i>string<\/i>\u00a0and\u00a0<i>string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The value specified for the attribute was incorrect.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Specify a value within the range allowed.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-F3DC1A46-8F9B-4452-9A5F-409ABF07F6DD\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00111: invalid attribute\u00a0<i>string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The specified attribute was not recognized.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Refer to the manual for the proper keyword to use to specify a dispatcher attribute.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-8228A3C8-F0CB-47E0-8534-C6AC11BA5AF6\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00112: value of\u00a0<i>string<\/i>\u00a0is null<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The attribute was specified with no value.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Specify a non-null value.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-1AE00568-9565-4387-8EEE-65797584CCDE\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00113: protocol name\u00a0<i>string<\/i>\u00a0is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0A protocol name specified in the DISPATCHERS system parameter is too long.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Use a valid protocol name for the DISPATCHERS value.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-CD75FA9D-8581-483F-9CDA-E88DB89C88CB\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00114: missing value for system parameter SERVICE_NAMES<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0No value was specified for the SERVICE_NAMES system parameter, nor for the DB_NAME parameter.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Add an SERVICE_NAMES or DB_NAME definition to the INIT.ORA file. By default, SERVICE_NAMES is the value of DB_NAME unless SERVICE_NAMES is explicitly specified.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-7AE9A599-68A6-4DDF-B224-700BE6395AFC\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00115: connection refused; dispatcher connection table is full<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0A connection request was refused by a dispatcher because the dispatcher cannot support any more connections.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Connect to a different dispatcher, or use a dedicated server.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-F3EB6EBC-DB1A-4A14-8943-243D3AEB000D\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00116: SERVICE_NAMES name is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0A service name specified in the SERVICE_NAMES system parameter is too long.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Use a shorter name in the SERVICE_NAMES value (&lt;= 255 chars).<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-BCBF9A1C-1C96-4D21-8837-FF224377C18F\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0PROTOCOL, ADDRESS or DESCRIPTION was not specified.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Use one of the attributes: PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-65E9E3AF-78E3-4A6A-9558-0C898E9EDE06\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0More than one of PROTOCOL, ADDRESS or DESCRIPTION was specified.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Use only one of the attributes: PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-D015BEB0-2AD5-4710-A406-CA992C7D496F\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00119: invalid specification for system parameter\u00a0<i>string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The syntax for the specified parameter is incorrect.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Refer to the Oracle Reference Manual for the correct syntax.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-3B96B6F6-9B41-4584-B970-4D7B62CF7097\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00120: invalid &#8216;shared_servers&#8217; value for the PDB<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0&#8216;shared_servers&#8217; cannot be set to a non-zero value in a non-ROOT pluggable database (PDB).<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0In a multitenant container database (CDB) setup, shared servers can be configured only in ROOT. A non-ROOT PDB can disable shared servers for the PDB by setting &#8216;shared_servers&#8217; to 0. No other values are allowed. To reenable within the PDB, use &#8216;alter system reset shared_servers&#8217;.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-99324AF7-0CD3-400E-820C-43BD320304B2\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00122: cannot initialize network configuration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0ORACLE could not initialize SQL*Net version 2.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Check the error stack for detailed information.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-2E96F13B-5EAF-4881-9B05-BCA64DA6B51A\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00123: idle public server terminating<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0Too many idle servers were waiting on the common queue.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0This error is used internally, no action is required.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-7B0C5EA0-7FE1-4B51-88A1-811AC4C22F11\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00125: connection refused; invalid presentation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The PRESENTATION in the CONNECT_DATA of the TNS address DESCRIPTION is not correct or is not supported.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Correct the PRESENTATION specified in the TNS address.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-FA9699D2-D8F2-4241-B4FB-EAF239F77757\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00126: connection refused; invalid duplicity<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The DUPLICITY in the CONNECT_DATA of the TNS address DESCRIPTION is not correct or is not supported.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Correct the DUPLICITY specified in the TNS address.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-AC4A770D-3C6E-479B-878D-CD4B79DA5FC0\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00127: dispatcher\u00a0<i>string<\/i>\u00a0does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0There is currently no dispatcher running with the specified name.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Retry with a name of the form &#8220;D###&#8221; denoting an existing dispatcher process.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-E1FAC9B6-2123-4967-B6A5-3FF6D155A31A\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00128: this command requires a dispatcher name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0Wrong syntax for ALTER SYSTEM SHUTDOWN<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Use correct syntax: ALTER SYSTEM SHUTDOWN [ IMMEDIATE ] &#8216;dispatcher name&#8217;<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-5C2424A4-1F3D-4189-9617-0ABAC9408CCA\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00129: listener address validation failed &#8216;<i>string<\/i>&#8216;<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0An error was encountered while validating the listener address.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Resolve error or contact your ORACLE representative.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-A7D96765-6BD6-4673-A35E-E3EF08166AAA\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00130: invalid listener address &#8216;<i>string<\/i>&#8216;<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The listener address specification is not valid.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Make sure that all fields in the listener address (protocol, port, host, key, &#8230;) are correct.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-AD905758-6F61-4801-B87F-262F676C49B9\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00131: network protocol does not support registration &#8216;<i>string<\/i>&#8216;<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The specified protocol does not support async notification.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Refer to the manual for information on supported network protocols.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-067E6BD0-9B0E-4898-93BE-90E97F89BB12\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00132: syntax error or unresolved network name &#8216;<i>string<\/i>&#8216;<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0Listener address has syntax error or cannot be resolved.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0If a network name is specified, check that it corresponds to an entry in TNSNAMES.ORA or other address repository as configured for your system. Make sure that the entry is syntactically correct.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-02C94AF2-8896-4E13-A0BF-C3322CD204B1\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00133: value of\u00a0<i>string<\/i>\u00a0is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The value specified for the attribute was too long.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Use shorter names and keywords or remove unneeded blanks.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-BAE3F586-FC5B-4AAA-AD68-4B1D4BEFBD41\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00134: invalid DISPATCHERS specification #<i>string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The syntax for the n-th DISPATCHERS specification was incorrect.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Refer to the Oracle Reference Manual for the correct syntax.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-406356FA-5D93-48B0-BA35-E37069D65FB0\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00135: missing attribute\u00a0<i>string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The indicated mandatory attribute was not specified.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Specify a non-null value for the attribute.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-3431AAC8-54A7-4122-90F1-26597A70A80F\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00136: invalid LISTENER_NETWORKS specification #<i>string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The syntax for the nth LISTENER_NETWORKS specification was invalid.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Refer to the Oracle Reference Manual for the correct syntax.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-E88B0C34-4606-4C1D-BBE5-94D572FAD0E4\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00137: invalid LISTENER_NETWORKS specification with NAME=<i>string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The syntax for the LISTENER_NETWORKS specification with the indicated NAME was invalid.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Refer to the Oracle Reference Manual for the correct syntax.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-F85746DC-F9D5-40FA-9B1F-12743E8D3F86\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00138: all addresses specified for attribute\u00a0<i>string<\/i>\u00a0are invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0All of the specified addresses or aliases for the attribute were invalid.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Specify at least one valid address or alias.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-FEB6D0C7-1E78-4946-B10F-7B6733D88C14\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00139: duplicate attribute\u00a0<i>string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The indicated attribute was specified more than once.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Specify the attribute at most once.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-3E6C03B9-61BC-43E4-B5A5-6E7FF9BD780D\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00140: LISTENER_NETWORKS specification with NAME=<i>string<\/i>\u00a0not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0An internal network name has been specified.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Specify a different network name.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-14D81C0A-7E7A-41E4-B0A2-7E347ADB0CC7\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00141: all addresses specified for parameter\u00a0<i>string<\/i>\u00a0are invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0All of the specified addresses or aliases for the parameter were invalid.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Specify at least one valid address or alias.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-680DC847-48D8-4832-8B54-B60C7B0F7018\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00142: FORWARD_LISTENER and LOCAL_LISTENER are on the same network.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0FORWARD_LISTENER was used with LOCAL_LISTENER for the same network.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Do not use FORWARD_LISTENER with LOCAL_LISTENER in the same network.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-33A1C828-F157-4275-ADBB-327BFFBF8E7D\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00143: The registration of a remote port is not supported without the registration of a local port.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The remote HTTP\/HTTPS port could not be registered without the local HTTP\/HTTPS port.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Register the local HTTP\/HTTPS port first.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-470B4386-0724-4369-A1B3-E43B714A57AA\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00150: duplicate transaction ID<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0Attempted to start a new transaction with an ID already in use by an existing transaction.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Check your application.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-EF25D9A4-BB46-4227-8AF7-C2F1AEC43895\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00151: invalid transaction ID<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The specified transaction ID does not correspond to an existing valid transaction.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Check your application.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-9A7F3B1C-3B43-4492-ABF1-266C82DE3989\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00152: current session does not match requested session<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The current session is not the same as the session that was passed into a upixado() call.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Check your application.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-D0880C30-B62E-4948-BBAD-A2EBEC233725\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00153: internal error in XA library<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The XA library could not access thread-specific pointers.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Contact customer support.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-F834CDC9-5101-46D9-B15A-EB47AFB21BCF\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00154: protocol error in transaction monitor<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The transaction monitor returned TMJOIN on an AX_REG call but the transaction was locally suspended.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Contact the transaction monitor customer support.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-6D0A8B5F-9084-487E-8B0A-8BBB23003FBF\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00155: cannot perform work outside of global transaction<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0The application tried to perform some work on either an Oracle 7.3 server or an Oracle8 server with local transactions disabled while outside of a global transaction.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Check if the application is connected to an Oracle 7.3 server. The Transaction monitor must not return a NULL XID on an AX_REG call when the resource manager is Oracle 7.3. If the application is connected to an Oracle8 server, either set nolocal=f in the xa_open string or start a global transaction prior to attempting the work.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-C8EFF7D4-9B15-45E5-80CE-A315C701B85C\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00160: global transaction length\u00a0<i>string<\/i>\u00a0is greater than maximum (<i>string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0An external global transaction ID with a too large length field was passed in.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Report the problem to your external transaction coordinator vendor.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-83F4AF31-122C-4464-91EF-D3613E3CC20C\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00161: transaction branch length\u00a0<i>string<\/i>\u00a0is illegal (maximum allowed\u00a0<i>string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0An external transaction branch ID with a length either too large or 0 was passed in.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Report the problem to your external transaction coordinator vendor.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-6D182773-50D3-442E-8EC4-F5C832A2EE5C\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00162: external dbid length\u00a0<i>string<\/i>\u00a0is greater than maximum (<i>string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0An external database name with too large a length field was passed in.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Report the problem to your external transaction coordinator vendor.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-6CA822D7-014F-4995-BFCC-8F05BCE001D0\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00163: internal database name length\u00a0<i>string<\/i>\u00a0is greater than maximum (<i>string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0An internal database name with a too large length field was passed in.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Report the problem to your external transaction coordinator vendor.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-6C3A5D51-BCF7-4168-BABB-3EA2DB8BC957\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00164: distributed autonomous transaction disallowed within migratable distributed transaction<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0A request was made by the application to start a distributed autonomous transaction when the application was in a migratable distributed transaction.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Roll back or commit the current distributed transaction first.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-1C94F2B6-B1C6-43EC-9D0C-8749AEA7408B\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0A request was made by the application to start a migratable distributed autonomous transaction with remote operation.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-0C06AB16-CA40-4D36-BA24-0814FFD848DB\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00166: remote\/local nesting level is too deep<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0Too many remote table operations required a reverse trip back to the local site, for example to execute a local function on a remote table.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Rearrange the query or co-locate the functions with the tables.<\/span><\/span><\/p>\n<dl>\n<dt><a name=\"GUID-27437B7F-F0C3-4F1F-9C6E-6780706FB0F6__GUID-E9337D8D-17B6-4DE7-8AED-3C5F82484325\"><\/a> <span style=\"color: #1d5aab;\"><span style=\"font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ORA-00200: control file could not be created<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Cause:<\/b>\u00a0It was not possible to create the control file.<\/span><\/span><\/p>\n<p><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b>Action:<\/b>\u00a0Check that there is sufficient disk space and no conflicts in filenames and try to create the control file again.<\/span><\/span><\/p>\n<dl>\n<dd><\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"<p>Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00100 to ORA-00200 ORA-00100: no data found Cause:\u00a0An application made reference to unknown or inaccessible data. Action:\u00a0Handle this condition within the application or make appropriate modifications to the application code. NOTE: If the application uses Oracle-mode SQL instead of ANSI-mode SQL, ORA-01403 will be generated instead&#8230;<\/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":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2041","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-wV","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2041","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=2041"}],"version-history":[{"count":3,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2041\/revisions"}],"predecessor-version":[{"id":2114,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2041\/revisions\/2114"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2041"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}