Home » RDBMS Server » Networking and Gateways » ORA-12535 TNS: Operation Timed Out (Oracle 9i,windows XP)
ORA-12535 TNS: Operation Timed Out [message #318288] Tue, 06 May 2008 06:35 Go to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi All,
I have been getting this ORA-12535 TNS: Operation Timed Out
whenever I connect to my databse, even scott/tiger.
This is a local database and the server is just another Pc in the same floor.
Also I tried the following:

tnsping orcl.quintiles.net

TNS Ping Utility for 32-bit Windows: Version 9.0.1.4.1 - Production on 06-MAY-20
08 16:56:42

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
C:\oracle\ora93\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = INNES00117)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl) (SRVR =
DEDICATED)))
OK (20 msec)


And also ping INNES00117
This also works.

but still I am not able to connect to the database.
Actually it was all fine till last wednesday .Then suddenly this problem cropped up.
Please help.
Re: ORA-12535 TNS: Operation Timed Out [message #318306 is a reply to message #318288] Tue, 06 May 2008 08:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you have a firewall?

Also read "How I Resolved ORA-03135: connection lost contact" Metalink note 465572.1

I remind you that Oracle only works on Windows XP Pro.

Regards
Michel
Re: ORA-12535 TNS: Operation Timed Out [message #318308 is a reply to message #318288] Tue, 06 May 2008 08:09 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here are 2 other Metalink notes:
- 119706.1, Troubleshooting Guide TNS-12535 & ORA-12535 Errors
- 1013552.102, ORA-12203 ORA-12535: CANNOT CONNECT TO NT SERVER VIA FIREWALL

Regards
Michel

[Updated on: Tue, 06 May 2008 08:10]

Report message to a moderator

Previous Topic: cant connect with OCI8 using php5.2.5
Next Topic: TNS-12541
Goto Forum:
  


Current Time: Thu Mar 28 04:42:19 CDT 2024