Re: How to locate the password file?

The password file should be in $ORACLE_HOME/dbs for Unix or %ORACLE_HOME%\database for Windows.

HTH,
Brian

Jeffrey Yee wrote:
>
> Hi,
>
> May I know how do I locate the password file for a database? I'm able
> to query the v$pwfile_users, and it shows a few users that has the
> sysdba & sysoper privileges.
>
> Just in case I can't locate it, would it be ok for me to create a new
> password file? I have a few concerns regarding this:
> 1. Will the database be smart enough to read from the latest password
> file?
> 2. If yes to question 1, do I need to shutdown and startup the
> database to take effect?
>
> Please advice. Thank you in advance.
>
> Best Regards,
> Jeffrey

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"