RE: LISTENER issue

From: <oracle-l-bounce_at_freelists.org>
Date: Tue, 6 Jun 2006 13:27:04 -0600
Message-ID: <61C20FAEF5CD8F419340F43E6AF5A95F03F733BD@COENGEXCMB01.cable.comcast.com>

What does your alert log say? You may be hitting a bug I found in 10.2.0.2 (Bug 4745075)

If you are getting this error, ora-3136, set these parameters -

In the sqlnet.ora add -
SQLNET.INBOUND_CONNECT_TIMEOUT = 0 Listener.ora -
SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener name> = OFF INBOUND_CONNECT_TIMEOUT_<listener name> = 0

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hallas, John, Tech Dev
Sent: Tuesday, June 06, 2006 9:05 AM
To: nirmalya_at_hln.com; oracle-l_at_freelists.org Subject: RE: LISTENER issue

$oerr tns 12500

12500, 00000, "TNS:listener failed to start a dedicated server process"
// *Cause: The process of starting up a dedicated server process
failed.
// The executable could not be found or the environment may be set up
// incorrectly.
// *Action: Turn on tracing at the ADMIN level and reexecute the
operation.
// Verify that the ORACLE Server executable is present and has execute
// permissions enabled. Ensure that the ORACLE environment is specified
// correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being
// called may not be installed on the local hard drive. Please check
that
// the correct Protocol Adapter are successfully linked.
// If error persists, contact Oracle Customer Support.

You have not hit a limit on processes on the server have you?

John

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nirmalya Das Sent: 06 June 2006 15:22
To: oracle-l_at_freelists.org
Subject: LISTENER issue

Environment:

Oracle 10.1.0.4
RHEL AS 3 The Listener stops taking incoming requests and leaves with this messagein the
the log file:

02-JUN-2006 09:16:42 * (CONNECT_DATA=(SID=PROD)(SERVER=DEDICATED) (CID=(PROGRAM=C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE)

   (HOST=DOH000001RV9L81)(USER=AJL))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.x.xxx)
   (PORT=3226)) * establish * PROD * 12500

TNS-12500: TNS:listener failed to start a dedicated server process TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
   TNS-00517: Lost contact
    Linux Error: 32: Broken pipe

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 06 2006 - 14:27:04 CDT