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.
Cheers
________________________________
From: sol beach [sol.beach@xxxxxxxxx]
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@xxxxxxxxxxx<mailto:VIVEK_SHARMA@xxxxxxxxxxx>> 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***
--
//www.freelists.org/webpage/oracle-l
Other related posts:
