Re: orapwd

  • From: Sanjay Mishra <smishra_97@xxxxxxxxx>
  • To: dbvision@xxxxxxxxxxxx
  • Date: Mon, 2 Jun 2008 06:23:26 -0700 (PDT)

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@xxxxxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx


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@xxxxxxxxxxxxx 
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sanjay Mishra
> *Sent:* 01 June 2008 22:45
> *To:* oracle-l@xxxxxxxxxxxxx
> *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.
> 
>  
> 

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


      

Other related posts: