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>
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-lReceived on Mon Jun 02 2008 - 08:23:26 CDT