Re: Host String

"Jeff" <96gtjeff_at_msn.com> wrote in message news:<gnS%9.166618$6G4.17067_at_sccrnsc02>...
> Hi, I am brand new to Oracle. I am trying to install Oracle 8i Personal on
> my home PC. Everything installs fine, I remembered to write down all of the
> Username and Password stuff that Oracle displays at the end; however, when I
> try to go into SQL+ it displays the LOG ON screen with (Username, Password,
> and Host String).
>
> What is the Host String? I don't remember being given this info. The name
> of the DB is JeffDB.
>
> Thanks,
> Jeff

Host string is an alias/service_name that points to a connect url in $ORACLE_HOME\network\admin\tnsnames.ora file. Oracle middleware (Net8/9) uses that url to connect to the database. Look up the tnsnames.ora file and a typical entry would look something like,

SERVICE_NAME.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <YOUR PC NAME>)(PORT = 1521))     (CONNECT_DATA = (SERVICE_NAME = <YOUR DBNAME>))   )

Your host string is SERVICE_NAME.WORLD

Regards
/Rauf Sarwar Received on Wed Feb 05 2003 - 01:07:05 CET