Home » RDBMS Server » Networking and Gateways » tns-12535 tns:operation time out
tns-12535 tns:operation time out [message #222165] Fri, 02 March 2007 02:23 Go to next message
mats_95
Messages: 7
Registered: May 2006
Junior Member
I have a database server running on 10g.Also I have another server which is the domain controller+Exchange server.I have installed an application running onOracle Forms 6i in the client PCs. But when I try to connect to the database I get error of
tns-12535 tns:operation time out.
The normal ping to the database server is working.
The database server has two network adapters one for internal network so IP and another for extrnal network.
Please advice how to resolve this issue.

SQLNET.ORA
# sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
------
TNSNAMES.ORA
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORION.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
----
LISTENER.ORA
# listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = EMAL01)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)



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


[Updated on: Fri, 02 March 2007 02:32]

Report message to a moderator

Re: tns-12535 tns:operation time out [message #222334 is a reply to message #222165] Fri, 02 March 2007 22:51 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
tns-12535 tns:operation time out.
On server firewall setting enable ?

if enable then try on disable.


regards
Taj
Re: tns-12535 tns:operation time out [message #222352 is a reply to message #222334] Sat, 03 March 2007 03:46 Go to previous messageGo to next message
mats_95
Messages: 7
Registered: May 2006
Junior Member
Hi,

I aleaddy tried it out.Firewall off+antivirus etc.
Re: tns-12535 tns:operation time out [message #222363 is a reply to message #222352] Sat, 03 March 2007 05:50 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
How many tnsnames.ora file in your client.
Check your use correct tnsnames.ora file for connection.



regards
Taj
Re: tns-12535 tns:operation time out [message #222377 is a reply to message #222363] Sat, 03 March 2007 10:18 Go to previous messageGo to next message
mats_95
Messages: 7
Registered: May 2006
Junior Member
THere is only 1 tnsnames.ora file.THere is no issue on that front.
Re: tns-12535 tns:operation time out [message #222378 is a reply to message #222165] Sat, 03 March 2007 10:32 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
The listener.log file should provide clues (or not) whether you are getting to the DB host from the Forms client PC.
Can anything make a successful connection across the network to this DB?
As a test from the client you should be able to
$ telnet 192.168.10.1 1521

FWIW - I find this IP# "odd".
Most/may/some network admins use the ".1" address as the default route into/out of a subnet.

Post the output from the clients which have the problem from:
ipconfig /all

Re: tns-12535 tns:operation time out [message #224690 is a reply to message #222378] Thu, 15 March 2007 02:52 Go to previous message
mats_95
Messages: 7
Registered: May 2006
Junior Member
hi,
I tried to telnet but the message came as port not open and could connect.The network is done by different serveice provirer as they say they defiened the firewall rule to allow this,also we tried without the firewall aslo but it did not work.Pl help me.what else could be the reason.
Previous Topic: Problem between listener.ora and tnsnames.ora
Next Topic: ORA-12508
Goto Forum:
  


Current Time: Sat Dec 03 10:01:34 CST 2016

Total time taken to generate the page: 0.27324 seconds