Re: how to use IP address in Host String?

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 - 13:43:48 CET