{"id":2142,"date":"2016-08-23T16:17:15","date_gmt":"2016-08-23T13:17:15","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2142"},"modified":"2016-12-20T16:28:36","modified_gmt":"2016-12-20T13:28:36","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-04930-to-ora-06145","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-04930-to-ora-06145\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-04930 to ORA-06145"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-04930 to ORA-06145<\/strong><\/p>\n

\n
ORA-04930: open sequence number failed or initial state is valid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either Shared Sequence Number OS component was not installed properly, or an MC hardware failure may have occurred or a previous instance was not shut down properly.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that there are no background or foreground Oracle processes from a previous instance on this node using the OS command ps -ef|grep <instance_name>. Verify that there are no shared memory segments belonging to the user which owns the Oracle installation by isuing the ipcs -b OS command. If there are shared memory segments or processes still on the system, use svrmgrl to shutdown the instance with the abort option. If the instance is not up, verify that the cluster software and\/or the hardware is installed and working. Log in as superuser and issue the cnxshow command. Are all of the nodes in the cluster listed? Are they members of the cluster? Is the communications between nodes okay? If the answer to any of these questions is false, contact Digital’s customer support organization.<\/span><\/span><\/p>\n

\n
<\/a> ORA-04931: unable to set initial sequence number value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A call to the SSN failed to set the sequence number to its initial value, possibly caused by an MC hardware problem.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that the MC hardware is functioning properly. If it is not, contact Digital’s customer support organization. If it is, contact Oracle support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-04932: increment or adjust of sequence number failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A call to the SSN failed to increment the sequence number.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that the MC hardware is functioning properly. If it is not, contact Digital’s customer support organization. If it is, contact Oracle support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-04933: initial service identifier is non-zero<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A valid service identifier existed before the sequence number service was opened.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that the instance is completely shut down.<\/span><\/span><\/p>\n

\n
<\/a> ORA-04934: unable to obtain the current sequence number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A call to the SSN failed to return its current value. Either there are many errors occurring on the MC hardware, or the sequence number has become invalid and cannot be validated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that the MC hardware is functioning properly. If it is, contact Oracle Support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-04935: unable to get\/convert SCN recovery lock<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A process has timed out trying to get or convert the SCN recovery lock. Another process probably has the lock in EX or SHR mode, but is not releasing it.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-04940: unsupported optimization of Oracle binary, check alert log for more info<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ORACLE binary has been optimized with unsupported options or a required option has not been used.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the documentation for a list of supported and required flags for the optimizing utility that you used to optimize ORACLE. Shutdown the instance, optimize ORACLE again with supported combination of options and restart the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-04941: required operating system patch needs to be applied<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The operating system could not return the start time of a process.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that the operating system kernel has been patched to return process start time. Apply the required operating system patch and restart the instance.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-06000: NETASY: port open failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Autologin unable to open port<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06001: NETASY: port set-up failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Autologin unable to change port attributes<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06002: NETASY: port read failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Autologin unable to read from port<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06003: NETASY: port write failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Autologin unable to write to port<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06004: NETASY: dialogue file open failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Autologin unable to open dialogue file<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check connect string for accuracy\/typos<\/span><\/span><\/p>\n

\n
<\/a> ORA-06005: NETASY: dialogue file read failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Autologin unable to read dialogue file<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06006: NETASY: dialogue execute failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Expected response never received<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-06007: NETASY: bad dialogue format<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Dialogue file contains syntax error<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the dialogue file<\/span><\/span><\/p>\n

\n
<\/a> ORA-06009: NETASY: dialogue filename too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Full file spec for dialogue file exceeds 64 bytes<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Amend connect string accordingly<\/span><\/span><\/p>\n

\n
<\/a> ORA-06010: NETASY: dialogue file too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Dialogue file exceeds 768 bytes in length<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Simplify dialogue (e.g. remove comments, redundant white space), or split into two and link with “more” command<\/span><\/span><\/p>\n

\n
<\/a> ORA-06011: NETASY: dialogue too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One of two: 1. Dialogue contains more than 24 exchange blocks 2. Dialogue send string exceeds 84 bytes in length<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Simplify dialogue or split into two and link with “more” command<\/span><\/span><\/p>\n

\n
<\/a> ORA-06017: NETASY: message receive failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Async driver gets I\/O error while doing network read operation<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code and contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06018: NETASY: message send failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Async driver gets I\/O error while doing network write operation<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code and contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06019: NETASY: invalid login (connect) string<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Syntax error in login string.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Resubmit with correct string.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06020: NETASY: initialisation failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Async driver unable to complete initialisation<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06021: NETASY: connect failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Async driver unable to establish connection with partner<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06022: NETASY: channel open failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0no free channel [should never happen]<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06023: NETASY: port open failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Async driver unable to open port<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06024: NETASY: VTM error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Virtual Terminal Manager unable to read\/write to port<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06025: NETASY: Configuration error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Async driver genned for server-only, but client service requested<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06026: NETASY: port close failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Async driver unable to close port<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06027: NETASY: channel close failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Async driver unable to close channel<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/p>\n

\n
<\/a> ORA-06028: NETASY: unable to intialise for logging<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Async driver unable to initialise for logging I\/O<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06029: NETASY: port assignment failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Async driver unable to assign port to channel [should never happen]<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06030: NETDNT: connect failed, unrecognized node name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Node name specified in host string is unknown (probably misspelled)<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry with correct node name<\/span><\/span><\/p>\n

\n
<\/a> ORA-06031: NETDNT: connect failed, unrecognized object name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Host string contains reference to object (which doesn’t exist): @d:node<\/i>–obj<\/i>\u00a0=> object is ORDNobj<\/i>; when\u00a0node<\/i>\u00a0is VMS, the object is ORDNobj<\/i>.COM when\u00a0node<\/i>\u00a0is UNIX, the object is ORDNobj<\/i>@d:node<\/i>::”task=obj<\/i>” => object is\u00a0obj<\/i>; when\u00a0node<\/i>\u00a0is VMS, the object is\u00a0obj<\/i>.COM when\u00a0node<\/i>\u00a0is UNIX, the object is\u00a0obj<\/i><\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry with correct object name or create the required object on host node<\/span><\/span><\/p>\n

\n
<\/a> ORA-06032: NETDNT: connect failed, access control data rejected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Host string contains invalid username\/password<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry with correct username\/password<\/span><\/span><\/p>\n

\n
<\/a> ORA-06033: NETDNT: connect failed, partner rejected connection<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Connection with partner was made but was rejected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your network administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06034: NETDNT: connect failed, partner exited unexpectedly<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Connection with host node was made but partner aborted<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure object (see 06031, above) is working (for VMS run the command file and make sure that the ORACLE server process starts up); sometimes happens when the network\/node is under stress – in this case a retry often works.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06035: NETDNT: connect failed, insufficient resources<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Insufficient system resources are available to complete the connection; for example, all DECnet channels are in use.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your network administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06036: NETDNT: connect failed, no response from object<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-06037: NETDNT: connect failed, node unreachable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Host node is down.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your network administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06038: NETDNT: connect failed, network driver not loaded<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-06039: NETDNT: connect failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Connect failed for unexpected reason (see OSD error).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06040: NETDNT: invalid login (connect) string<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Syntax error in login string.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Resubmit with correct string.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06041: NETDNT: disconnect failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Driver gets error while doing network close operation<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06042: NETDNT: message receive failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Driver gets I\/O error while doing network read operation<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06043: NETDNT: message send failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Driver gets I\/O error while doing network write operation<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06044: NETDNT: connect failed, byte count quota exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Connect failed because of insufficient byte count quota.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase byte count quota.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06102: NETTCP: cannot allocate context area<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Insufficient dynamic memory available for connection context area.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06105: NETTCP: remote host is unknown<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Host name specified in the login (connect) string is unknown.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check spelling; make sure name is in the TCP\/IP HOST file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06106: NETTCP: socket creation failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Process open file quota probably exceeded.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06107: NETTCP: ORACLE network server not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No entry in SERVICES file for ORACLE server.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add (“orasrv”) entry to the TCP\/IP SERVICES file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06108: NETTCP: connect to host failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Connection attempt to remote host has failed. Probably means that the SQL*Net TCP\/IP server on the remote host is not up, or the host itself is not up (check the latter by targeting it with Telnet).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Start the SQL*Net TCP\/IP server process on the remote host.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06109: NETTCP: message receive failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0I\/O error occurred while attempting network read operation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06110: NETTCP: message send failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0I\/O error occurred while attempting network write operation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06111: NETTCP: disconnect failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Error occurred while closing a socket.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06112: NETTCP: invalid buffer size<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The buffer size specified in the login string exceeds the allowed maximum (of 4096).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-submit with valid buffer size.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06113: NETTCP: Too many connections<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The maximum no. of concurrently open connections has been reached.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Exit an application with an open connection which is no longer required.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06114: NETTCP: SID lookup failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0From the remote host’s SQL*Net TCP\/IP server: the database SID, specified in the login (connect) string, was not recognized.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add the appropriate SID entry to the CONFIG.ORA file on the remote host (and restart the SQL*Net TCP\/IP server).<\/span><\/span><\/p>\n

\n
<\/a> ORA-06115: NETTCP: unable to create ORACLE logicals<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server was unable to create the necessary logicals required by the ORACLE server process. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your system administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06116: NETTCP: unable to create ORASRV process<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server was unable to create the ORACLE server process. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your system administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06117: NETTCP: unable to create ORASRV: quota exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server was unable to create the ORACLE server process because of quota depletion.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase quota allocations to the SQL*Net TCP\/IP server process.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06118: NETTCP: unable to complete handshake with ORASRV<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ORACLE server process was started but failed to complete its initialization.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06119: NETTCP: spurious client request<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server was unable to recognize this connection request. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06120: NETTCP: network driver not loaded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The TCP\/IP network driver is not loaded.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that the TCP\/IP driver is loaded correctly.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06121: NETTCP: access failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server was unable to test the accessibility of the SID mapping file (specified in CONFIG.ORA) associated with this connection request. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06122: NETTCP: setup failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server was unable to set up the appropriate environment to service this connection request. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06123: NETTCP: cannot set KEEPALIVE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server was unable to set the socket KEEPLIVE option. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06124: NETTCP: timeout waiting for ORASRV<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ORACLE server process was started but failed to respond after N secs.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0For heavily loaded systems this is not an uncommon occurrence. Increase the value of N (the default is 30) by placing the following entry in the CONFIG.ORA file: SQLNET ORASRV_WAIT = <no. of secs> which will come into effect the next time the SQL*Net TCP\/IP server is started.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06125: NETTCP: ORASRV exited unexpectedly<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ORACLE server process was started but exited unexpectedly. Possible causes: 1. Insufficient quotas to run ORASRV 2. ORACLE is not installed See the ORASRV output file for more details; the file will be in the ORA_SQLNET directory and will have a name of the form: ORA_SRVTnn_SID<\/i>.OUT<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If appropriate action is not obvious from the ORASRV output file then contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06126: NETTCP: ORASRV unable to open network connection<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ORACLE server process was started but was unable to open the socket passed to it by TCPSRV.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06127: NETTCP: unable to change username<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server could not establish a PROXY LOGIN connection because the client username is unknown (to the host OS).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create new user account on host.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06128: NETTCP: unable to create mailbox<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server was unable to create a mailbox (needed for IPC communication with the ORACLE server process). See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06129: NETTCP: unable to transfer socket ownership to ORASRV<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server was unable to transfer the network communication handle to the ORACLE server process. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06130: NETTCP: host access denied<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server rejected this connection request because the client node does not have access privilege – as determined by the contents of the Valid Node Table (VNT), a component of the host’s CONFIG.ORA.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0To grant access, add appropriate entry to the host’s VNT.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06131: NETTCP: user access denied<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server rejected this connection request because the client user(name) does not have access privilege – as determined by the contents of the Username Mapping Table (UMT), a component of the host’s CONFIG.ORA.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0To grant access, add appropriate entry to the host’s UMT.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06132: NETTCP: access denied, wrong password<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host SQL*Net TCP\/IP server rejected this connection request because the client password did not match the host password.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0To grant access, get passwords in sync.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06133: NETTCP: file not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server could not find the SID mapping file (specified in CONFIG.ORA) associated with this connection request.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check CONFIG.ORA for spelling; make correct entry.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06134: NETTCP: file access privilege violation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server did not have READ\/ EXECUTE permission for the SID mapping file (specified in CONFIG.ORA) associated with this connection request.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change protection on SID mapping file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06135: NETTCP: connection rejected; server is stopping<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server rejected this connection request because it is in the process of stopping.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-start SQL*Net TCP\/IP server.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06136: NETTCP: error during connection handshake<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Network I\/O failure occurred while communicating with the host’s SQL*Net TCP\/IP server. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06137: NETTCP: error during connection handshake<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Network I\/O failure occurred while communicating with the host’s SQL*Net TCP\/IP server. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06138: NETTCP: error during connection handshake<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Network I\/O failure occurred while communicating with the host’s SQL*Net TCP\/IP server. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06140: NETTCP: no such user<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A proxy login connect attempt failed because the client username has no counterpart on the host.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-06141: NETTCP: no privilege for user<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A proxy login connect attempt failed because the SQL*Net TCP\/IP server had insufficient privileges to access the proxy account.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change account protection; change server privilges.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06142: NETTCP: error getting user information<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A proxy login connect attempt failed because the SQL*Net TCP\/IP server was unable to access the proxy account. See the SQL*Net TCP\/IP server log file for more details.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06143: NETTCP: maximum connections exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The connect failed because the maximum conncurrent connections supported by the host’s SQL*Net TCP\/IP server has already been reached.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait for a short period and re-try.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06144: NETTCP: SID (database) is unavailable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The database administrator on the host has varied the SID offline.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait for it to be varied back on-line.<\/span><\/span><\/p>\n

\n
<\/a> ORA-06145: NETTCP: unable to start ORASRV: images not installed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The host’s SQL*Net TCP\/IP server was unable to start the ORACLE server process because the ORACLE protected images were not installed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Install the images.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-04930 to ORA-06145 ORA-04930: open sequence number failed or initial state is valid Cause:\u00a0Either Shared Sequence Number OS component was not installed properly, or an MC hardware failure may have occurred or a previous instance was not shut down properly. Action:\u00a0Verify that there are no background…<\/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-2142","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-yy","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2142","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=2142"}],"version-history":[{"count":3,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2142\/revisions"}],"predecessor-version":[{"id":2151,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2142\/revisions\/2151"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2142"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}