OraFAQ Forum: Networking and Gateways » Not able to connect to database

Home » RDBMS Server » Networking and Gateways » Not able to connect to database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not able to connect to database [message #541671]

Wed, 01 February 2012 12:49

yashwj
Messages: 3
Registered: April 2007
Location: bangalore

Junior Member

Hi

I am getting beloww error very frequently in database log and not able to connect to the database.

************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 01-FEB-2012 18:00:34
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.1.24)(PORT=65503))
WARNING: inbound connection timed out (ORA-3136)
Wed Feb 01 18:00:44 2012
*****************

Report message to a moderator

Re: Not able to connect to database [message #541672 is a reply to message #541671]

Wed, 01 February 2012 12:55

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ ping 10.179.1.24
2/ tnsping <service name>
3/ firewall?
4/ database and client versions?
5/ network health?

post sqlnet.ora and tnsnames.ora

Regards
Michel

[Updated on: Wed, 01 February 2012 12:56]

Report message to a moderator

Re: Not able to connect to database [message #541673 is a reply to message #541672]

Wed, 01 February 2012 13:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I am getting beloww error very frequently in database log and not able to connect to the database.

Can any or other remote clients connect to the DB?
When was last time no such errors occurred?
What changed since then?
Can you successfully connect via SQL*Net while logged onto DB server itself?
What clues exist within listener.log file?

Report message to a moderator

Previous Topic:	TNS issue
Next Topic:	dblinks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 10:29:32 CDT 2025