how to use IP address in Host String?
Date: 19 Mar 2002 16:09:56 -0800
Message-ID: <e23e8a04.0203191609.4f4dc005_at_posting.google.com>
Hi, everyone
I have installed Oracle 9i on Win 2000. I can connect to db locally
through SQL Plus and works fine. But when i try to connect from
another machine on the same network using IP address as follows
sqlplus system/manager_at_publish:xxx.xxx.xxx.xxx
I get the following error
ERROR:ORA-06401: NETCMN: invalid driver designator
I did search this group buts looks like most of the other ppl are
getting
this error bec of some SQLNet library version differnce.
I tried tnsping to IP and i got the following message
TNS Ping Utility for 32-bit Windows: Version 9.0.1.1.1 - Production on
19-MAR-20
02 15:28:53
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\Oracle\Ora81\network\admin\sqlnet.ora
Used HOSTNAME adapter to resolve the alias
Attempting to contact
(DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=xxx.xxx.xxx.xxx))(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))
OK (30 msec)
Can somebody please help me with this.
Thnaks
Wasiq
Received on Wed Mar 20 2002 - 01:09:56 CET