RE: ORA-28547 - "connection to server failed, probable Oracle Net admin error" when Database sessions touched 18,000

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 11 Jan 2008 01:35:01 +0530
Message-ID: <69E1360E54B50C4A828A136C158E4742036A70765C@BLRKECMBX02.ad.infosys.com>

Thanks for the support sol

Do you mean that insufficient Number of Network Cards (1 only) & thus insufficient network thruput versus the high Trasactions' Load is the probable cause of the ORA-28547("connection to server failed, probable Oracle Net admin error") error when sessions gradually increase to 18,000?

NOTE - Additional Network cards will be added soon, whereafter the Listener processes will be setup on different network cards.

Cheers

---

From: sol beach [sol.beach_at_gmail.com]
Sent: Thursday, January 10, 2008 7:28 AM To: VIVEK_SHARMA
Subject: Re: ORA-28547 - "connection to server failed, probable Oracle Net admin error" when Database sessions touched 18,000

Forgive me, but this configuration is daft from my perspective. 1) The Oracle listener ONLY comes into play for establishing the initial connection between a client & new DB session. 2) The NIC is single threaded. While it is servicing request for any 1 port, it can NOT be servicing any other traffic.

So I have to ask, what does having more than 1 listener on the same NIC buy you?

On Jan 9, 2008 4:38 PM, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com<mailto:VIVEK_SHARMA_at_infosys.com>> wrote:

Folks

During a Benchmark Run as Number of Database sessions increased to 18000 following Error Occured:-

ORA-28547 "connection to server failed, probable Oracle Net admin error"

Qs Will increasing the Number of Listener processes help?

ACTION - Listener processes have been increased from 12 to 16. But need to check if the error re-occurs or is resolved.

Qs Could it be a Network bandwidth issue?

Currently all 16 Listener processes sit on the SAME ( 1 ) Network Card, but use different Port Numbers.

Database setup - Shared Server (MTS)

Oracle 10.2.0.3<http://10.2.0.3/> (NON-RAC)

Solaris 10

Will share any info needed.

Cheers

P.S.

$ oerr ora 28547:-

*Action: Check Oracle Net administration in the following ways:

//           --  When using TNSNAMES.ORA or an Oracle Names server, make sure


//               that the client connection to the ORACLE server uses

//               the correct service name or SID.

//           --  Check LISTENER.ORA on the connection end point's host machine


//               to assure that this service name or SID refers

//               to the correct server.

//           --  Confirm in TNSNAMES.ORA or the equivalent service definition


//               that the connect string does NOT contain (HS=).


**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 10 2008 - 14:05:01 CST