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: Dave <JustShutUp_at_azwhole.com>
Date: Tue, 26 Aug 2003 13:25:45 -0400
Message-ID: <big56r$4opm$1@netnews.upenn.edu>

>"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
news:3F4B8FB9.FD002DB0_at_exxesolutions.com...

>
> Databases can not be deleted.
>
> Seems you are a SQL Server person with little background in Oracle. In
Oracle a
> user account with objects is a SCHEMA ... not a database. If you want to
drop
> the database ... just shut it down and delete the physical files.
>
> If you can log on as sys then you have the Internal account password. If
you
> wish to change it log on as SYS and:
>
> ALTER USER sys IDENTIFIED BY <new_password>;
>
> Then get yourself a book and learn some Oracle.

You're right, I do have little experience in Oracle. But, I actually used the Database Configuration Assistant and 'deleted' the database instead of dropping all the files from sqlplus. But in order to use that tool, you need the INTERNAL account's password. I did have the SYS and SYSTEM passwords, but the INTERNAL password was changed by a previous system admin. Using the ALTER USER command cannot be used on the INTERNAL account. Using orapwd utility worked for changing the INTERNAL and SYSTEM accounts' passwords.

Dave Received on Tue Aug 26 2003 - 12:25:45 CDT

Original text of this message

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