RE: New DB Connections Failing ?......... ORA-12157

Folks

Will creating a 2nd Network path thru the Switch Between the APPlication & DB Servers by adding an additional Network Card to Both servers perchance help in overcoming the ORA-12157 Error?

A 2nd Listener can be brought up on this IP Address corresponding to the newly added Network Card on the DB Server.

Thanks indeed

-----Original Message-----
From: Mladen Gogala [mailto:mgogala_at_verizon.net] Sent: Wednesday, November 15, 2006 1:46 PM

> 2) There is an Operating System Error in the error stack:

> ntresnt[1]=227, which appear to be 'can't assign requested address',
but

> you would need to verify this on your platform.

This is precisely why I asked you to open a SR. One cannot even begin to resolve this problem

without the entire configuration information, RDA collection at the minimum. For you information,

I had a similar problem quite recently (3 weeks ago) and problem lied squarely on "virtual

addresses". There is a Linux feature which is supposed to create a "virtual address" for cluster

hosts which should float from one host to another one, in the case of failure. For some reasons,

that didn't work quite well with Oracle. When I switched back to Oracle's fail-over methods (TNS entry),

it worked like a charm. When occasionally listener wouldn't be able to use the "virtual" address, it

would report precisely the error you had. Further insisting on solving this problem on the list is

pointless and only makes the list less readable.

--

Mladen Gogala

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: Tuesday, November 14, 2006 7:42 PM Folks

In a NEW Setup, after about 700 database (dedicated server) Connections are spawned, New Connections via the Listener process to the RAC Database node from an Application server machine are FAILING.

Also Performance of Queries becomes very slow of already existing Connections to the Database.

NOTE - CPU Utilization of the DB & APP Servers is Low.

$ sqlplus <user>/<passwd>@<connect string> gives the Oracle Error ORA-12157 $ oerr ora 12157

12157, 00000, "TNS:internal network communication error"

// *Cause: Internal error during network communication.

// *Action: Not normally visible to the user. For further details, turn

// on tracing and reexecute the operation. If error persists, contact

// Worldwide Customer Support.

On DB Server Node:-

$ netstat -a | grep <Port Num of Listener process> | wc -l

700

Thanks Indeed

Config:-

Oracle 10.2.0.2

HP-UX ver B11.23

Init.ora:-

processes=3500

sessions=3500

• 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