Re: hoststring in SQL PLUS

Matt wrote:

> I just download Oracle database server from Oracle site. In SQL PLUS,
> I enter scott as username, tiger as password, but how about
> hoststring? What I should enter for hoststring?
>
> please advise. thanks!!

Open the file tnsnames.ora in the Oracle home \network\admin directory.

You should see something like this:

XYZ =
   (DESCRIPTION =

     (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = orcl)
     )

The host name is the value I have replaced with "XYZ".

If you have an entry like this:

EXTPROC_CONNECTION_DATA = Ignore it.

If the file does not exist you will need to create it using the Network Configuration Assistant.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)