Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Internal password?
The internal user ONLY works in svrmgrl or other tools that
allow logon when the database is not up. Just use the sys user
in sql*Plus. The problem isn't the passwords being different
it's that SQL*Plus can't be used if the database is down and
has never recognized the internal user.
> This is a multi-part message in MIME format.
> --------------6AA01CCB903B452E303DA585
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> I ran into a problem running a sql script with svrmgrl in
that it
> doesn't like the "set "options. So, I decided to to it as
sqlplus
> internal
> instead but the internal password is unknown to me
apparently.
> I thought it was suppossed to be the same as sys, but it is
not.
> Why? Should I use orapwd to re-synchronize them? What are
the
> ramifications? I haven't had a password file up to this
point, why
> make one now?
>
> Thanks,
> Dc.
>
> --------------6AA01CCB903B452E303DA585
> Content-Type: text/x-vcard; charset=us-ascii;
name="vcard.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Doug Cowles
> Content-Disposition: attachment; filename="vcard.vcf"
>
> begin: vcard
> fn: Doug Cowles
> n: Cowles;Doug
> org: IBM
> email;internet: dcowles_at_nospambigfoot.com
> title: DBA
> note: Please remove nospam from e-mail to reply.
> x-mozilla-cpt: ;0
> x-mozilla-html: FALSE
> version: 2.1
> end: vcard
>
>
> --------------6AA01CCB903B452E303DA585--
>
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=8663&cus_id=USENET&qtn_id=7975
Received on Mon Dec 13 1999 - 09:54:37 CST
![]() |
![]() |