Home » RDBMS Server » Networking and Gateways » ORACLE LAN CONNECTION
ORACLE LAN CONNECTION [message #66490] Thu, 04 July 2002 15:49 Go to next message
Chris Khan
Messages: 2
Registered: July 2002
Junior Member
Hi,
I have submitted my question befor and I got some great reply, but still can't get it to work. I have the Enterprise Edition installed on a computer running Windows 2000 2k Server (This machine is also a Domain Controller) Oracle is working fine on that machine. I installed the client on a computer running Windows 98. Everytime I try to connect to the server via the LAN I get this error: ORA-12154: TNS: Could not resolve service name. This is what my sqlnet.ora file looks like

# SQLNET.ORA Network Configuration File: /u01/app/oracle/product/8.1.7.0.1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

TRACE_LEVEL_CLIENT=USER
sqlnet.expire_time =50
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN=delcomsoft.com
NAME.DEFAULT_ZONE=delcomsoft.com

and this is what my tnsnames.ora looks like

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =test)
)
)

the domain name for my lan is delcomsoft.com. There is no listener installed on the Win98 machine only the server. Do you guys have any idea what is incorrect.

Thanks
Chris
Re: ORACLE LAN CONNECTION [message #66496 is a reply to message #66490] Sat, 06 July 2002 00:48 Go to previous messageGo to next message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
SIR,

THE PROBLEM IS VERY EASY.

DO THE MODIFICATION IN THE TNSNAMES.ORA FILE

TEST.delcomsoft.com
=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =test)
)
)

I.E YOU SHOULD ADD THE DOMAIN NAME WITH THE HOST STRING NAME.IT WILL WORKS.

WAITING FOR YOUR REPLY.

K.SREENIVASAN
Re: ORACLE LAN CONNECTION [message #66499 is a reply to message #66496] Sun, 07 July 2002 08:55 Go to previous message
Chris Khan
Messages: 2
Registered: July 2002
Junior Member
I have tried the modification but now there is a different error.ORA-12535 TNS:operation timed out.I set the sqlnet timeout to 0. Any ideas

Thanks
Chris
Previous Topic: Problem with Domain-Prefixing on WinNT/8.0.5
Next Topic: Oracle Database Connectivity Remotely
Goto Forum:
  


Current Time: Sat Mar 02 18:36:17 CST 2024