Re: password file location

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:5sit1v89jtq7g2qh6evrirkctq9oo1tndb_at_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.

My question is more general. Of course I know there are default names to specify depending on the OS - for instance on Tru64 you have to name your password file orapwd[DB_SID].
But my question is : is there a way to name my file foo.pwd without creating a symlink ? is there an initialization parameter to set in the init.ora or an environment variable...
Or is it mandatory to name the file orapwd[DBSID] or whatever depending on the rule defined for your OS.

> 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 - 10:47:20 CST