Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie Question: Trying to Start SQLPlus, Error
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 Wed Aug 21 2002 - 12:43:17 CDT