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

The default password for INTERNAL is ORACLE. I know in Version 7, it will only ask you for a password if your UNIX user account does not belong to the DBA group.

Satar
In article <AK02fGsK42_at_protasov.kiev.ua>,   oracle_at_protasov.kiev.ua wrote:
>
> 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
> >
> >
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 06 1998 - 11:41:13 CST