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: Changing Internal password

Re: Changing Internal password

From: shihyong <yongyong_at_singnet.com.sg>
Date: 2000/08/09
Message-ID: <8mru5s$tft$1@mawar.singnet.com.sg>#1/1

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

Original text of this message

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