Home » RDBMS Server » Networking and Gateways » TNS-12535 TNS:operation timed out
TNS-12535 TNS:operation timed out [message #129650] Tue, 26 July 2005 03:05 Go to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Hi to all,

I think today is the day of errors for me . Its coming out from every side.
I have a windows XP server with Oracle 9i on it, when i tried to connect this server from another win XP machine after creating a service. I m getting an error

TNS-12535 TNS:operation timed out


But as i know this error is related to CONNECT_TIMEOUT and it is now obsolete in 9i( am i correct ).

I tried it doing from 2 machines but got the same error from everywhere so it means that the problem is with the server.
my files are :

Listener.ora

# LISTENER.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Tarun)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = tanudb1)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = tanudb1)
)

)


SQLNET.ora

# SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


tnsnames.ora

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

SRV_TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tarun)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tanudb1)
)
)


INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Tharun)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)


Pls help me out to overcome this situation..

Thanks,
tarun
Re: TNS-12535 TNS:operation timed out [message #129657 is a reply to message #129650] Tue, 26 July 2005 03:40 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

one more thing, when i run TNSPING srvc_name from client machine, it is also giving the same error.
not able to connect -- connection timeout.

Regards,
tarun
Re: TNS-12535 TNS:operation timed out [message #129664 is a reply to message #129657] Tue, 26 July 2005 03:57 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

Have you checked the connetivity from client to server? Are you able to telnet the server on port 1521 (or any other port that you may have configured for listener) from client side?

I doubt, its not server issue, its a connectivity issue IMO.

Regds
Girish
Re: TNS-12535 TNS:operation timed out [message #129675 is a reply to message #129664] Tue, 26 July 2005 04:32 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
Hi Girish,

Even i m feeling the same now. I created a service on the server itself n tried to connect Oracle using that service n its working perfect.

But when i m trying the same from other machines ,its not working. Even i m able to ping Server from client machines.
Now i m really stuck.

Regards ,
tarun
Re: TNS-12535 TNS:operation timed out [message #129676 is a reply to message #129675] Tue, 26 July 2005 04:35 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

Fine, you are getting response for ping.

Now check for telnet to server on port 1521 & see the response from any of the machines.

In fact even on server, do try to check for telnet on port 1521 both using IP & hostname)

Might be, you may have 1521 blocked either at server or on firewall.

Regds
Girish

TNS-12535 TNS:operation timed out [message #129684 is a reply to message #129676] Tue, 26 July 2005 04:55 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


I m not able to telnet 1521 port from any other machine, it says connection failed.

Even i created another listener listening on 1522 port and then tried to connect it bt the result is same.

thanks ,
tarun
Re: TNS-12535 TNS:operation timed out [message #129690 is a reply to message #129684] Tue, 26 July 2005 05:00 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Yes Sir

There lies the issue. Resolve this telnet issue & then your problem will be resolved.

Check for firewall settings if any had been configured.

Regds
Girish
Re: TNS-12535 TNS:operation timed out [message #129694 is a reply to message #129690] Tue, 26 July 2005 05:08 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Hi,

It really worked, firewall on server was on.

I changed the settings n it worked. Now i m able to log on. Really u know a lot of things, Thanks a lot. U know, with these problems i m learning a lot. Thanks again.


Regards,
Tarun
Re: TNS-12535 TNS:operation timed out [message #448917 is a reply to message #129694] Thu, 25 March 2010 13:52 Go to previous messageGo to next message
cgonzalez
Messages: 2
Registered: March 2010
Junior Member
What should I do, if I don't wanna to disable the firewall, Can I configure some ports? Which ones?
Re: TNS-12535 TNS:operation timed out [message #511370 is a reply to message #448917] Sun, 12 June 2011 07:50 Go to previous message
olimatco
Messages: 1
Registered: June 2011
Junior Member
Hey

Just disable your network adapters, stop oracle server then restart server then re enable your network adapters, everything will be just fine now... hope this helps!!!
Previous Topic: ORA-02019: connection description
Next Topic: Need help to connect Oracle Report and Forms 6i to sysbase
Goto Forum:
  


Current Time: Sun Sep 25 06:07:53 CDT 2016

Total time taken to generate the page: 0.26820 seconds