Re: How to change the password of USER "INTERNAL"?

Hi,

Password of internal is usually in password file, not in the database. Password file is named pwd<sid>.ora. Program to create new password file is orapwd80.exe (digits can be different in your case):

E:\ORANT\BIN>ORAPWD80/EXE /?
Usage: orapwd file=<fname> password=<password> entries=<users>

  where
    file - name of password file (mand),     password - password for SYS and INTERNAL (mand),     entries - maximum number of distinct DBA and OPERs (opt),   There are no spaces around the equal-to (=) character.

Shutdown database before changing password file.

Andrew Protasov

> That's the point,
> in svrmgr
> i can connect "internal".
> but when i type "alter user internal identified by newpassword".
> It appear "ORA-01918: user 'internal' does not exist"
> why I can't change the password?
>
> victor wrote:
> >
> > Chim Ian <ianchim_at_yahoo.com> wrote in article
> > <3641C54A.20F052EB_at_yahoo.com>...
> > > Hi all,
> > > I'd like to know how to change the password of USER "INTERNAL"?
> > > Please teach me step by step to do it.
> > >
> > > Thanks in advance.
> > > mailto:ianchim_at_yahoo.com
> > >
> >
> > if you forget it sorry , no comment
> > else connect internal/password;
> > alter user internal identified by newpassword;
> >
> > this all
>
>
Received on Fri Nov 06 1998 - 00:00:32 CST