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

"Michael Spellbrink" <michaelspellbrink_at_yahoo.de> wrote in message news:638121fa.0308261108.270beaef_at_posting.google.com...
> "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.

Nay, won't work. INTERNAL is the old method of authenticating SYSDBA's via password file authentication, the username only exists in the password file and not the database. The only way to reset the INTERNAL password is to use orapwd, which also resets SYS (which is the default SYSDBA account) to the same password.

> anyway, couldnt you just drop the tablespaces ?
> or even opening the controlfiles in an editor?
>
> hth, michael spellbrink
Received on Tue Aug 26 2003 - 14:57:12 CDT