Re: Username, Password and Host String in SQL Plus ???

From: Biss Is Ignorance <bliss_is_ignorance_at_hotmail.com>
Date: Tue, 27 Feb 2001 18:46:36 +0800
Message-ID: <3a9b8615.0_at_news.tm.net.my>

hi,

default user is scott, password is tiger... if u loging into SQL on the same machine where the DB is installed then u dont need the host string.. but to find the host string, open tnsnames.ora in this u'll find an entry something like

<name>=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <host name>)(PORT = <port #>))     )
    (CONNECT_DATA =
      (SERVICE_NAME = <name>)
    )
  )

the entry for service_name should give u ur host string...

hope this helps.. lemme know

regards
"Kim Larsen" <kim_at_kim-larsen.com> wrote in message news:gZEm6.49128$o85.276021_at_news-server.bigpond.net.au...
> Hi.

>

> I have a simple question (I think).
> I have just installed Personal Oracle8i Release 2 Version 8.1.6 for
 Windows
> NT/2000.
> But I don't know the Username, Password and Host String in SQL Plus. I
> believe that Oracle has default values here. Can anybody give them to me?

>

> Thank you in advance

>

> Regards,
> Kim Larsen.

>
> Received on Tue Feb 27 2001 - 11:46:36 CET