use orapwd utility ....
orapwd file=PWDsid.ora password=****

PWD has to be capital... copy this file in oracle_home\database folder

also check init.ora parameter
remote_login_password_file=exclusive


Deepa Kale -DBA
Jyoti Structures - Nasik(IT)



"Chirag Majmundar "
<oracledba-ezmlmshield-x77900527.[Email Address Removed] To: "LazyDBA.com Discussion" <[Email address protected]
azyDBA.com> cc:
Subject: Hw to generate Password file?
05/31/2004 02:54 PM






Hi Friends,

One of the DB another DBA working with has lost his passwords.

Can u tell me hw to regenerate the password file again?

will that affect the password of other schemas too?

- Chirag Majmundar../

_________________________________________________________________
Contact brides & grooms FREE! http://www.shaadi.com/ptnr.php?ptnr=hmltag
Only on www.shaadi.com. Register now!



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:
http://www.lazydba.com/legal.html







Oracle LazyDBA home page