Re: How to locate the password file?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 01 Jul 2003 06:54:59 +0200
Message-ID: <3t42gv8j7o5detilhqvijvl71e2sr4gf05@4ax.com>

On 30 Jun 2003 19:26:28 -0700, jeffyee_at_hotmail.com (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

on Unix the password file is always in $ORACLE_HOME/dbs On Winblows 8i and higher usually in oracle/admin/<SID>/pfile, but there is always a registry variable in HKLM\software\oracle with the correct value.
Two password files are not an option and the directory is fixed. Not sure what you are up to.
Just do some reading.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jun 30 2003 - 23:54:59 CDT