| tns-12535 tns:operation time out [message #222165] |
Fri, 02 March 2007 02:23  |
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 #224690 is a reply to message #222378] |
Thu, 15 March 2007 02:52  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
