Re: how to use IP address in Host String?

Thanks srivenu, it worked.

srivenu_at_hotmail.com (srivenu) wrote in message news:<1a68177.0203200443.cea7497_at_posting.google.com>...
> 1) try this on the machine you are using SQL*PLUS
> sqlplus system/manager_at_(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL =
> TCP)
> (Host = xxx.xxx.xxx.xxx)(Port = 1521)))
> (CONNECT_DATA = (SID = xxx)))
> At HOST= give your server IP
> at SID= give your Oracle SID
> It is very cumbersome to give the entire string everytime you connect
> to the database. So do the following.
>
> 2)From the output of TNSPING it seems that you are using HOSTNAMES as
> your local naming method.
> (You can see the naming method in the SQLNET.ORA file
> names.directory_path)
> In the hosts file
> (/etc/hosts on unix
> c:\winnt\system32\drivers\etc\lmhosts on windows)
> add an entry like this
> xxx.xxx.xxx.xxx sid
> then give this command
> sqlplus system/manager_at_sid
> I assumed that the listener on the server is running on port 1521 and
> your sid is sid.
Received on Wed Mar 20 2002 - 22:36:54 CET