Date: Mon, 2 Jun 2008 12:35:07 +0100
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
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: 01 June 2008 22:45
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.
BJSS - Platinum Sponsors of the 2008 Agile Business Conference www.agileconference.org The information included in this email and any files transmitted with it may contain information that is confidential and it must not be used by, or its contents or attachments copied or disclosed, to persons other than the intended addressee. If you have received this email in error, please notify BJSS. In the absence of written agreement to the contrary BJSS’ relevant standard terms of contract for any work to be undertaken will apply. Please carry out virus or such other checks as you consider appropriate in respect of this email. BJSS do not accept responsibility for any adverse effect upon your system or data in relation to this email or any files transmitted with it. BJSS Limited, a company registered in England and Wales (Company Number 2777575), VAT Registration Number 613295452, Registered Office Address, First Floor, Coronet House, Queen Street, Leeds, LS1 2TWReceived on Mon Jun 02 2008 - 06:35:07 CDT