{"id":1775,"date":"2016-03-09T12:03:57","date_gmt":"2016-03-09T09:03:57","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1775"},"modified":"2016-10-21T12:06:45","modified_gmt":"2016-10-21T09:06:45","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-04900-to-ora-06100","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-04900-to-ora-06100\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-04900 to ORA-06100"},"content":{"rendered":"

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

\n
ORA-04930: open sequence number failed or initial state is valid<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-04931: unable to set initial sequence number value<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-04932: increment or adjust of sequence number failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A call to the SSN failed to increment the sequence number.<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-04933: initial service identifier is non-zero<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A valid service identifier existed before the sequence number service was opened.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the instance is completely shut down.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04934: unable to obtain the current sequence number<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the MC hardware is functioning properly. If it is, contact Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04935: unable to get\/convert SCN recovery lock<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Contact Oracle Support.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-04940: unsupported optimization of Oracle binary, check alert log for more info<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE binary has been optimized with unsupported options or a required option has not been used.<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-04941: required operating system patch needs to be applied<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The operating system could not return the start time of a process.<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-06000: NETASY: port open failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Autologin unable to open port<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06001: NETASY: port set-up failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Autologin unable to change port attributes<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06002: NETASY: port read failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Autologin unable to read from port<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06003: NETASY: port write failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Autologin unable to write to port<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06004: NETASY: dialogue file open failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Autologin unable to open dialogue file<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check connect string for accuracy\/typos<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06005: NETASY: dialogue file read failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Autologin unable to read dialogue file<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06006: NETASY: dialogue execute failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Expected response never received<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06007: NETASY: bad dialogue format<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Dialogue file contains syntax error<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the dialogue file<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06009: NETASY: dialogue filename too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Full file spec for dialogue file exceeds 64 bytes<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Amend connect string accordingly<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06010: NETASY: dialogue file too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Dialogue file exceeds 768 bytes in length<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Simplify dialogue (e.g. remove comments, redundant white space), or split into two and link with “more” command<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06011: NETASY: dialogue too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One of two:<\/span><\/span><\/span><\/dd>\n
1. Dialogue contains more than 24 exchange blocks<\/span><\/span><\/span><\/dd>\n
2. Dialogue send string exceeds 84 bytes in length<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Simplify dialogue or split into two and link with “more” command<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06017: NETASY: message receive failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Async driver gets I\/O error while doing network read operation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code and contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06018: NETASY: message send failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Async driver gets I\/O error while doing network write operation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code and contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06019: NETASY: invalid login (connect) string<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Syntax error in login string.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Resubmit with correct string.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06020: NETASY: initialisation failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Async driver unable to complete initialisation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06021: NETASY: connect failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Async driver unable to establish connection with partner<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06022: NETASY: channel open failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0no free channel [should never happen]<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06023: NETASY: port open failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Async driver unable to open port<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06024: NETASY: VTM error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Virtual Terminal Manager unable to read\/write to port<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06025: NETASY: Configuration error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Async driver genned for server-only, but client service requested<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06026: NETASY: port close failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Async driver unable to close port<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06027: NETASY: channel close failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Async driver unable to close channel<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check log file for OS-specific error code<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06028: NETASY: unable to intialise for logging<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Async driver unable to initialise for logging I\/O<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06029: NETASY: port assignment failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Async driver unable to assign port to channel [should never happen]<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06030: NETDNT: connect failed, unrecognized node name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Node name specified in host string is unknown (probably misspelled)<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry with correct node name<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06031: NETDNT: connect failed, unrecognized object name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Host string contains reference to object (which doesn’t exist): @d:<node>-<obj> => object is ORDN<obj>; when <node> is VMS, the object is ORDN<obj>.COM when <node> is UNIX, the object is ORDN<obj> @d:<node>::”task=<obj>” => object is <obj>; when <node> is VMS, the object is <obj>.COM when <node> is UNIX, the object is <obj><\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry with correct object name or create the required object on host node<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06032: NETDNT: connect failed, access control data rejected<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Host string contains invalid username\/password<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry with correct username\/password<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06033: NETDNT: connect failed, partner rejected connection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Connection with partner was made but was rejected.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your network administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06034: NETDNT: connect failed, partner exited unexpectedly<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Connection with host node was made but partner aborted<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-06035: NETDNT: connect failed, insufficient resources<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Insufficient system resources are available to complete the connection; for example, all DECnet channels are in use.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your network administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06037: NETDNT: connect failed, node unreachable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Host node is down.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your network administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06039: NETDNT: connect failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Connect failed for unexpected reason (see OSD error).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06040: NETDNT: invalid login (connect) string<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Syntax error in login string.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Resubmit with correct string.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06041: NETDNT: disconnect failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Driver gets error while doing network close operation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06042: NETDNT: message receive failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Driver gets I\/O error while doing network read operation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06043: NETDNT: message send failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Driver gets I\/O error while doing network write operation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-06044: NETDNT: connect failed, byte count quota exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Connect failed because of insufficient byte count quota.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Increase byte count quota.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-04900 to ORA-06100 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 or…<\/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-1775","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-sD","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1775","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=1775"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1775\/revisions"}],"predecessor-version":[{"id":1776,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1775\/revisions\/1776"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1775"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}