Re: Changing Internal password

In 8i, Internal's password can be changed by changing SYS's password. Example below is Oracle 8.1.6 on NT

SQL PLUS Session:

SQL> ALTER USER sys IDENTIFIED BY mypassword;

User altered.

SQL> DOS PROMPT: H:\mendozaf>svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SVRMGR> connect internal/mypassword
Connected.
SVRMGR> shihyong wrote:
>
> Dear Sybrand,
>
> 1) Pls explain why 'the method Jon quote shouldn't be applied on a live
> database?
> 2) Just FYI, oadim -edit cannot be used to change an existing password.
>
> Thanks.
>
> Jon,
>
> try this
> 1) oradim -DELETE -SID sid
> 2) ORADIM -NEW -SID SID -INTPWD NEW_PASSWORD - STARTMODE AUTO - MAXUSERS N
> -PFILE <drive: \path\init{sid}.ora>
>
> Good Luck.
>
> <sybrandb_at_my-deja.com> wrote in message news:8mrkge$jnc$1_at_nnrp1.deja.com...
> > In article <8mr2i2$sad$1_at_unbe.sarenet.es>,
> > "Jon" <jzuazoa_at_nexo.es> wrote:
> > > Oracle 8.1.5 (NT)
> > > Following the DBA manual, I have tried to change INTERNAL password
 

 using
> > > ORADIM:
> > > 1.- oradim -DELETE -SID sid
> > > 2.- oradim -NEW -SID sid -INTPWD internal_pwd -MAXUSERS n
> > > but when I do this the instance stop does not work anymore.
> > >
> > > Do you know what I am doing wrong?
> > >
> > > Thanks
> > >
> > >
> > Your last sentence is grammatically incorrect and hence
> > incomprehensible.
> > Do you mean
> > 'The instance stops working'
> > or
> > 'The instance doesn't work any more' (meaning: I'm unable to start it)
> > The method you quote shouldn't be applied on a live database.
> >
> > Officially oradim -edit should be sufficient, this can be applied on a
> > live database.
> >
> > A different approach is using the orapwd utility.
> >
> > Hth,
> > --
> > Sybrand Bakker, Oracle DBA
> >
> > All standard disclaimers apply
> > ------------------------------------------------------------------------
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Wed Aug 09 2000 - 00:00:00 CDT