Re: Newbie Question: Trying to Start SQLPlus, Error

system/manager doesn't work. during the install Oracle gave me a shared memory error during "database configuration assistant" section of the install so that part of the install was not completed.

patrick

"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message news:ak1jf1010eh_at_drn.newsguy.com...
> 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 Thu Aug 22 2002 - 06:32:04 CDT