OraFAQ Forum: Networking and Gateways » TNS-12535 TNS:operation timed out

Home » RDBMS Server » Networking and Gateways » TNS-12535 TNS:operation timed out

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

TNS-12535 TNS:operation timed out [message #129650]

Tue, 26 July 2005 03:05

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

Report message to a moderator

Re: TNS-12535 TNS:operation timed out [message #129657 is a reply to message #129650]

Tue, 26 July 2005 03:40

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

Report message to a moderator

Re: TNS-12535 TNS:operation timed out [message #129664 is a reply to message #129657]

Tue, 26 July 2005 03:57

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

Report message to a moderator

Re: TNS-12535 TNS:operation timed out [message #129675 is a reply to message #129664]

Tue, 26 July 2005 04:32

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

Report message to a moderator

Re: TNS-12535 TNS:operation timed out [message #129676 is a reply to message #129675]

Tue, 26 July 2005 04:35

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

Report message to a moderator

TNS-12535 TNS:operation timed out [message #129684 is a reply to message #129676]

Tue, 26 July 2005 04:55

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

Report message to a moderator

Re: TNS-12535 TNS:operation timed out [message #129690 is a reply to message #129684]

Tue, 26 July 2005 05:00

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

Report message to a moderator

Re: TNS-12535 TNS:operation timed out [message #129694 is a reply to message #129690]

Tue, 26 July 2005 05:08

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

Report message to a moderator

Re: TNS-12535 TNS:operation timed out [message #448917 is a reply to message #129694]

Thu, 25 March 2010 13:52

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?

Report message to a moderator

Re: TNS-12535 TNS:operation timed out [message #511370 is a reply to message #448917]

Sun, 12 June 2011 07:50

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!!!

Report message to a moderator

Previous Topic:	ORA-02019: connection description
Next Topic:	Need help to connect Oracle Report and Forms 6i to sysbase

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 05 22:21:22 CDT 2025