Re: password file location

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 10 Jan 2003 14:35:30 +0100
Message-ID: <5sit1v89jtq7g2qh6evrirkctq9oo1tndb@4ax.com>

On Fri, 10 Jan 2003 13:48:35 +0100, "David COSTE" <dco_at_compaq.com> wrote:

>Does it mean you have noway to specify it at Oracle Level ?

Depends on O/S which you -of course- don't specify. NT has a registry setting for it. On Unix by default the file is in $ORACLE_HOME/dbs. Be aware, if you remove an aliased file, the alias isn't removed also. Hence I would consider this mechanism a bad idea, and I would locate the alias in the $ORACLE_BASE/admin/$ORACLE_SID/pfile directory, and the file in $ORACLE_HOME/dbs. You would do better also to stay OFA compliant, or you must be prepared for havoc.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jan 10 2003 - 07:35:30 CST