how to use IP address in Host String?

From: wasiq <wasiq99_at_yahoo.com>
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

Original text of this message