New DB Connections Failing ?
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 14 Nov 2006 19:42:02 +0530
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
Qs 1 - Will adding a 2nd Listener process to each of the 2 RAC Nodes
Help overcoming the NEW DB connections problem?
Thanks Indeed
Config:-
Oracle 10.2.0.2
HP-UX ver B11.23
Init.ora:-
processes=3500
sessions=3500
../network/admin/cli_14053.trc sample:-
NOTE - It has the Error 12157 below in it.
[14-NOV-2006 12:48:14:839] nnfttran: exit
[14-NOV-2006 12:48:14:839] nnftrne: Using tnsnames.ora address
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sd102-vip)(PORT =
1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = sd106-vip)(PORT = 1521))
(LOAD_BALANCE=YES) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
RACBAT) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES =
180) (DELAY = 5)))) for name RACBAT
[14-NOV-2006 12:48:14:839] nnftrne: exit
. . .
. . .
. . .
[14-NOV-2006 12:48:14:866] ntt2err: entry
[14-NOV-2006 12:48:14:866] ntt2err: soc 9 error - operation=1,
ntresnt[0]=515, ntresnt[1]=227, ntresnt[2]=0
[14-NOV-2006 12:48:14:866] ntt2err: exit
[14-NOV-2006 12:48:14:875] nttcnp: exit
[14-NOV-2006 12:48:14:875] nttcon: exit
[14-NOV-2006 12:48:14:875] niotns: niotns failed to create NS ctx, error
code 12157
[14-NOV-2006 12:48:14:875] niotns: Couldn't connect, returning 12157
[14-NOV-2006 12:48:14:875] niotns: exit
[14-NOV-2006 12:48:14:875] nigcui: entry
[14-NOV-2006 12:48:14:875] nigcui: Clr User Interrupt: hdl=1,
prc=0xbf7a2880, ctx=0x184cf0.
[14-NOV-2006 12:48:14:875] nigtrm: Count in the NI global area is now 1
[14-NOV-2006 12:48:14:875] nigtrm: Count in the NL global area is now 1
[14-NOV-2006 12:48:16:050] nigini: entry
[14-NOV-2006 12:48:16:050] nigini: Count in the NL global area is now 2
[14-NOV-2006 12:48:16:050] nigini: Count in NI global area now: 2
[14-NOV-2006 12:48:16:050] nigini: exit
**************** 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:
