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: Pete Sharman <peter.sharman_at_oracle.com>
Date: 21 Aug 2002 10:43:17 -0700
Message-ID: <ak0jfl0gpr@drn.newsguy.com>


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

Original text of this message

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