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: URGENT: Is there any way to change the INTERNAL password?

Re: URGENT: Is there any way to change the INTERNAL password?

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Tue, 26 Aug 2003 12:36:19 -0700
Message-ID: <3F4BB6B3.91A6F0C3@exxesolutions.com>


Michael Spellbrink wrote:

> "Dave" <JustShutUp_at_azwhole.com> wrote in message news:<bifsma$4d5e$1_at_netnews.upenn.edu>...
> > Hi Group,
> > I have inherited a database with an INTERNAL account whose password was
> > changed and never documented. I can logon to the database as SYS and SYSTEM
> > and another account that has full DBA privileges. I need to delete the
> > database. Can I delete the database without the INTERNAL password (the
> > database config asst won't let me) or is there a way to change this
> > password?
> >
> > Dave
>
> if you have sysdba authority you might be able to change the
> 'INTERNAL'
> password in a way similar to this:
>
> alter user internal identified by values 'tehs00k';
>
> and then connect using 'tehs00k' as password, i never tried it with
> the user INTERNAL, but it's worth a try.
> please post the current environment as it may helping finding some
> other way.
> anyway, couldnt you just drop the tablespaces ?
> or even opening the controlfiles in an editor?
>
> hth, michael spellbrink

Internal is NOT a user in Oracle. The user is SYS.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Aug 26 2003 - 14:36:19 CDT

Original text of this message

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