OraFAQ Forum: Server Administration » TNS ERROR

Home » RDBMS Server » Server Administration » TNS ERROR (oracle 11 g r2 RAC ,solaris 10)

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

TNS ERROR [message #546328]

Tue, 06 March 2012 03:14

janakors
Messages: 232
Registered: September 2009

Senior Member

Hi,
i am receiving following in alert log

Fatal NI connect error 12170.

TNS-12535: TNS:operation timed out
ns secondary err code : 12560
nt main err code : 505

kindly guide ,is there anything at my database side

Regards

janakors

Report message to a moderator

Re: TNS ERROR [message #546335 is a reply to message #546328]

Tue, 06 March 2012 03:36

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

Senior Member
Account Moderator

TNS-12535: TNS:operation timed out
 *Cause: The requested operation could not be completed within the time out
 period.
 *Action: Look at the documentation on the secondary errors for possible
 remedy. See SQLNET.LOG to find secondary error if not provided explicitly.
 Turn on tracing to gather more information.

Firewall?

Regards
Michel

Report message to a moderator

Re: TNS ERROR [message #546336 is a reply to message #546335]

Tue, 06 March 2012 03:44

janakors
Messages: 232
Registered: September 2009

Senior Member

Thank you for your reply sir as i am not experience dba so kindly le you can let of know the path where i can look at sqlnet.log.

Report message to a moderator

Re: TNS ERROR [message #546338 is a reply to message #546336]

Tue, 06 March 2012 03:54

janakors
Messages: 232
Registered: September 2009

Senior Member

Hi i did not found sqlnet.ora so i can see where the sqlnet.log file is so can u advice me on this

Report message to a moderator

Re: TNS ERROR [message #546339 is a reply to message #546338]

Tue, 06 March 2012 04:03

guyfomi
Messages: 11
Registered: March 2012
Location: Cameroon

Junior Member

try to replace the server name with the IP address in your tnsnames.ora file

Report message to a moderator

Re: TNS ERROR [message #546343 is a reply to message #546328]

Tue, 06 March 2012 04:30

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

This isn't a problem, it's expected behaviour in 11g if you enable ADR logging. All described in note 1286376.1, with the method to disable it.

Report message to a moderator

Previous Topic:	ora-00600 internal error code
Next Topic:	Deleting Archive log in DR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 14:39:13 CST 2024