Re: orapwd

From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Mon, 02 Jun 2008 22:23:30 +1000
Message-ID: <4843E642.2060907@iinet.net.au>


*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_at_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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Sanjay Mishra
> *Sent:* 01 June 2008 22:45
> *To:* oracle-l_at_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
Received on Mon Jun 02 2008 - 07:23:30 CDT

Original text of this message