Home » RDBMS Server » Server Administration » TNS ERROR (oracle 11 g r2 RAC ,solaris 10)
TNS ERROR [message #546328] Tue, 06 March 2012 03:14 Go to next message
janakors
Messages: 171
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




Re: TNS ERROR [message #546335 is a reply to message #546328] Tue, 06 March 2012 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 58959
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: TNS ERROR [message #546336 is a reply to message #546335] Tue, 06 March 2012 03:44 Go to previous messageGo to next message
janakors
Messages: 171
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.
Re: TNS ERROR [message #546338 is a reply to message #546336] Tue, 06 March 2012 03:54 Go to previous messageGo to next message
janakors
Messages: 171
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
Re: TNS ERROR [message #546339 is a reply to message #546338] Tue, 06 March 2012 04:03 Go to previous messageGo to next message
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
Re: TNS ERROR [message #546343 is a reply to message #546328] Tue, 06 March 2012 04:30 Go to previous message
John Watson
Messages: 4523
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.
Previous Topic: ora-00600 internal error code
Next Topic: Deleting Archive log in DR
Goto Forum:
  


Current Time: Tue Sep 02 17:24:53 CDT 2014

Total time taken to generate the page: 0.10199 seconds