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

  • From: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
  • To: sol beach <sol.beach@xxxxxxxxx>
  • Date: Fri, 11 Jan 2008 01:35:01 +0530

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.


From: sol beach [sol.beach@xxxxxxxxx]
Sent: Thursday, January 10, 2008 7:28 AM
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@xxxxxxxxxxx<mailto:VIVEK_SHARMA@xxxxxxxxxxx>> wrote:


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<> (NON-RAC)

Solaris 10

Will share any info needed.



$ 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***

Other related posts: