Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!hammer.uoregon.edu!canoe.uoregon.edu!newshub.sdsu.edu!headwall.stanford.edu!newsfeed.stanford.edu!sn-xit-02!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Is it possible not to create any files in $ORACLE_HOME/dbs directory? Date: Thu, 09 Sep 2004 19:36:12 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.verwijderdit.demon.nl References: <43441e77.0409090615.268e6510@posting.google.com> X-Newsreader: Forte Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 46 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224593 On 9 Sep 2004 07:15:27 -0700, premmehrotra@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