Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews2.google.com!not-for-mail
From: premmehrotra@hotmail.com (Prem K Mehrotra)
Newsgroups: comp.databases.oracle.server
Subject: Is it possible not to create any files in $ORACLE_HOME/dbs directory?
Date: 9 Sep 2004 07:15:27 -0700
Organization: http://groups.google.com
Lines: 21
Message-ID: <43441e77.0409090615.268e6510@posting.google.com>
NNTP-Posting-Host: 148.177.1.213
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1094739327 21192 127.0.0.1 (9 Sep 2004 14:15:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 9 Sep 2004 14:15:27 +0000 (UTC)
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224578

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 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. 
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.

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.

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

4.There may be other files as well such as snapshot control file (
that can be created elsewhere).

Prem