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: Patrick Altman <junk_at_pataltman.com>
Date: Fri, 23 Aug 2002 00:37:32 GMT
Message-ID: <gtf99.130416$m91.5881418@bin5.nnrp.aus1.giganews.com>


Thanks, TurkBear, that really helped a lot and your posting was extremely profitable.

"TurkBear" <jgreco1_at_mn.rr.com> wrote in message news:9hu9mu8qhte4omj0hf70pvncggh8o483kr_at_4ax.com...
> Have you tried a radical approach..Read the F_ manual ( or in this case
the readme files)
>
> - If the database creation failed, what are you expecting to connect to?
>
> Read the stuff about pre-installation requirements
>
> l
> "Patrick Altman" <junk_at_pataltman.com> wrote:
>
> >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;
> >>
> >
>
>
>
> -----------== 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 Thu Aug 22 2002 - 19:37:32 CDT

Original text of this message

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