| ORACLE LAN CONNECTION [message #66490] |
Thu, 04 July 2002 15:49  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
