| 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
|
|
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
|
|
| 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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
