Re: Is it possible not to create any files in $ORACLE_HOME/dbs directory?

On 9 Sep 2004 07:15:27 -0700, premmehrotra_at_hotmail.com (Prem K Mehrotra) wrote:

>I am using Oracle 9i on HP UNIX. We have an environment in which
>installation is
>done using a different login than the "oracle" login

*WHY ON EARTH*
which will create
>database instance and will do dba work. I want to know is there any
>env variable one
>can set so files which are created in dbs can be created elsewhere.

Please RTFM the installation manual for your platform

>Assume my ORACLE_SID=test.
>
>1. Is it possible to create file lkTEST in some other directory. If
>this file cannot be created, will database instance creation fail.

Please RTFM the installation manual for your platform

>
>2. Is it possible to create orapwTEST in another directory, i.e., know
>Oracle provides orapwd with file option, but I have seen problems
>where creating password file outside dbs directory.

Please RTFM the installation manual for your platform

>
>3. I know inittest.ora and spfiletest.ora can be created outside dbs.

Please RTFM the installation manual for your platform They can't!!!!
>
>4.There may be other files as well such as snapshot control file (
>that can be created elsewhere).
>

Please RTFM the installation manual for your platform

>Prem

--
Sybrand Bakker, Senior Oracle DBA