Home » RDBMS Server » Networking and Gateways » TNS:operation timed out (Oracle 11.2.0.2.0 hp-aux)
TNS:operation timed out [message #558761] Tue, 26 June 2012 07:18 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hi Exerts,

One of our production database we are getting error "TNS:operation timed out" from unknown port in alert logfile. Need to help to check why TNS error is occurring to these unknown port as our listener is running on default 1521 port. Also to inform that host=192.191.118.24 itself is the same database hosting server IP.


TNS-12535: TNS:operation timed out
TNS-12535: TNS:operation timed out
    ns secondary err code: 12606

    ns secondary err code: 12606
    nt main err code: 0
TNS-12535: TNS:operation timed out
    nt main err code: 0
    nt secondary err code: 0
    ns secondary err code: 12606
    nt secondary err code: 0
    nt OS err code: 0
    nt main err code: 0
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.191.118.24)(PORT=63708))
    nt secondary err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.191.118.24)(PORT=63679))
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.191.118.24)(PORT=63690))
Re: TNS:operation timed out [message #558775 is a reply to message #558761] Tue, 26 June 2012 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
the most common cause for network timeouts is FireWall on or between client & DB Server
Re: TNS:operation timed out [message #571066 is a reply to message #558775] Tue, 20 November 2012 23:31 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
I am facing the same issue and unable to connect to database using my userid but able to connect using SYS user.

RAC environment

Request your suggestion to resolve the error.
Re: TNS:operation timed out [message #571067 is a reply to message #571066] Tue, 20 November 2012 23:33 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Previous Topic: ORA-12514: TNS:listener does not currently know of service requested
Next Topic: SQL*Net message from client
Goto Forum:
  


Current Time: Thu Apr 18 15:53:14 CDT 2024