Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie Question: Trying to Start SQLPlus, Error
Could be many things but my first suspect would be not having ORACLE_HOME in your enviroment.. ( Does anyone read anymore?)
Mark Powers <powers_at_one.net> wrote:
>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;
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Mon Aug 26 2002 - 15:58:32 CDT