Re: Newbie Question: Trying to Start SQLPlus, Error

In article <EHX89.122763$2p2.5576272_at_bin4.nnrp.aus1.giganews.com>, "Patrick says...
>
>Ok, got it. Excuse me for asking another "dumb" question but how do I know
>the password for the "system" account. I am not aware of such an account
>existing on my machine.

Default password is manager if it hasn't been changed. On 9.2 with a database created with Database Configuration Assistant, you're forced to change SYS and SYSTEM passwords at the completion of the database creation.

Pete
>
>Thanks,
>Patrick
>
>"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message
>news:ak0jfl0gpr_at_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;
>>
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Wed Aug 21 2002 - 21:49:05 CDT