Re: orapwd

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Mon, 2 Jun 2008 06:23:26 -0700 (PDT)
Message-ID: <987534.90134.qm@web51308.mail.re2.yahoo.com>

Thanks Nuno. This is 9i. But it is goog to know this parameter as I was not aware of it.


----- Original Message ----
From: Nuno Souto <dbvision@iinet.net.au>
Cc: oracle-l@freelists.org
Sent: Monday, June 2, 2008 8:23:30 AM
Subject: Re: orapwd

*If* this is 10g, you can try using
the new parameter "force=y" in the
command line for orapwd:
it causes a running instance to
re-read and accept any changes to orapwd
without a restart.


-- 
Cheers
Nuno Souto
in wet Sydney, Australia
dbvision@iinet.net.au


John Hallas wrote,on my timestamp of 2/06/2008 9:35 PM:
> You should restart the database after creating a orapwd file.
> 
> Oracle may still have a pointer in to the old file which was Ądamagedą 
> and therefore not be picking  the new one up.
> 
>  
> 
> I was going to suggest using the lsof command to see open files but the 
> orapwd is not actually open during normal usage
> 
>  
> 
> www.jhdba.wordpress.com
> 
> ------------------------------------------------------------------------
> 
> *From:* oracle-l-bounce@freelists.org 
> [mailto:oracle-l-bounce@freelists.org] *On Behalf Of *Sanjay Mishra
> *Sent:* 01 June 2008 22:45
> *To:* oracle-l@freelists.org
> *Subject:* orapwd
> 
>  
> 
> The problem is for Window platform. If somebody damaged the Password 
> file and if I recreate it while Database is running, then is it going to 
> work or I need to stop and restart the database. I had 
> remote_passwor....... parameter is EXCLUSIVE but can't see any entry in 
> v$pwfile_users. THis is the reason Backup cannot be scheduled thru 
> Oracle Management Console as it is failing with insufficient priviliges. 
> It is now allowing to add any new users with SYSDBA privieges.
> 
>  
> 

--
http://www.freelists.org/webpage/oracle-l


      
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 02 2008 - 08:23:26 CDT

Original text of this message