Re: INTERNAL Password problem

Use the orapwd utility to reset the password. The syntax is orapwd file=$ORACLE_HOME/dbs/orapwd<sid> password=... users. Consult the documentation for exact details. Afaik the unix implementation, if Oracle has been installed correctly using user oracle group dba, anyone in the dba group will be able to connect as internal automatically.
BTW: if you want to use the password file the remote_password_file parameter in init<sid>.ora should be set to exclusive, or you will not be able to grant sysdba or sysoper privileges to 'normal' users.

Hth,

Sybrand Bakker, Oracle DBA

Mike wrote:

> Hi
> I have the same problem with internal connect and SCO. start the orainst
> script and make a full relink of the database ( make a backup from the hole
> oracle home before)
>
> ML <mlluk_at_technologist.com> schrieb im Beitrag
> <3671BE66.FAC6A619_at_technologist.com>...
> > Hi guys,
> >
> > We have a testing Oracle 8 instance running on an Solaris mahcnie.
> > Someone has set the inernal password and left the company. After the
> > machine reboot, we tried to bring the Oracle instance up, it keeps
> > asking for the internal password. I did try using
> > "oracle/change_on_install/manager" but with no luck. Is there any way to
> > reset this internal password?
> >
> > Thanks in advance.
> >
> > Regards.
> > ML
> >
> >
> >

Received on Wed Dec 30 1998 - 05:59:00 CST