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

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie Question: Trying to Start SQLPlus, Error

Re: Newbie Question: Trying to Start SQLPlus, Error

From: Mark Powers <powers_at_one.net>
Date: Mon, 26 Aug 2002 16:23:05 -0400
Message-ID: <3D6A8E29.56C0F1D7@one.net>


I have a slightly different problem getting sqlplus running.

I just did an install of 8i on a new Solaris machine.

The install procedure burped a few times creating the demo database...I suspect because sqlplus won't run.

Every time I try to run sqlplus I get:

$ sqlplus /nolog
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus

Any idea what I'm missing ?

Thanks,

Mark Powers
mpowers_at_powersagency.com

Pete Sharman wrote:

> In article <QfD89.103337$2p2.4844500_at_bin4.nnrp.aus1.giganews.com>, "Patrick
> says...
> >
> >That's just it. I cannot get to a SQL> prompt to issues such commands. It
> >keeps asking for username and password which after I give it, all I get are
> >errors.
> >
> >Patrick
>
> OK, from the OS prompt type in:
>
> sqlplus /nolog
>
> That should give you a SQL prompt where you can enter the command I mentioned in
> the previous post.
>
> Pete
> >
> >"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message
> >news:ajqvlo02gu2_at_drn.newsguy.com...
> >> See Richard Foote's reply on the OEM thread. SYSDBA is not a user. It's
> >a
> >> privilege granted to a user and checked either via the password file or OS
> >> authentication. If SYSTEM has been granted SSYDBA, then you should be
> >able to
> >> connect using this syntax:
> >>
> >> SQL> CONNECT system/your_system_password_here AS SYSDBA
> >>
> >> Pete
> >>
> >> HTH. Additions and corrections welcome.
> >>
> >> Pete
> >>
> >> SELECT standard_disclaimer, witty_remark FROM company_requirements;
> >>
> >
> >
>
> HTH. Additions and corrections welcome.
>
> Pete
>
> SELECT standard_disclaimer, witty_remark FROM company_requirements;
Received on Mon Aug 26 2002 - 15:23:05 CDT

Original text of this message

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