Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Logging into SQL*Plus (Oracle 8i)

Re: Logging into SQL*Plus (Oracle 8i)

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 04 Jul 2005 15:29:32 -0700
Message-ID: <1120516190.50069@yasure>


Water Cooler v2 wrote:
> I just installed Oracle 8i and am having a tough time just logging into
> SQL*Plus. I've given scott for the User Name and tiger for the
> Password. But heck, what do I give in as the host string?

Not reading documentation when working with Oracle is one of the surest routes to failure I know. I'd suggest not repeating that mistake. And why install an old unsupported version when you could have installed 10g?

Using the operating system userid/password you used to install Oracle log on in SQL*Plus with:

/ as sysdba (leaving password and host string blank)

then

SELECT instance_name
FROM v$instance;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Jul 04 2005 - 17:29:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US