Re: Oracle8 DB Init Files - Where ?

Its part of the OFA. If you have mutiple instances on the same box it seperates all the parameter files into their own directory - also all the alert and trace files - makes things much easier to administer. For example if you have an alias 'pfile' that does a 'cd $ORACLE_BASE/$ORACLE_SID/pfile' - it takes you straight to the directory containing the parameter files of the SID you are working on.

Alex

Doug Cowles wrote in message <379E564B.CFB65BBC_at_bigfoot.com>...
>Our Senior DBA does exactly the same thing...why? What's the
>rationale?
>
>Jonathan Gennick wrote:
>
>> By default, Oracle will look in $ORACLE_HOME/dbs. Usually I
>> place file system links in that directory that point to the
>> real init files, which I store in
>> $ORACLE_BASE/admin/SID/pfile. For example, when I create a
>> new database, I create a link like this:
>>
>> ln -f $ORACLE_BASE/admin/SID/pfile $ORACLE_HOME/dbs
>>
>> Hope this helps.
>>
>> Jonathan
>>
>> _____________________________________________________
>> jonathan_at_gennick.com
>> http://gennick.com
>> Brighten the Corner Where You Are
>>
>> On Wed, 21 Jul 1999 12:19:37 -0400, Stan Novinsky
>> <stan_novinsky_at_jhuapl.edu> wrote:
>>
>> >We are running Oracle 8.0.5.1 On Digital Unix.
>> >
>> >Can someone answer the following:
>> >
>> >When I connect as SVRMGR and issue
>> >
>> >SVRMGR> connect internal
>> >Connected.
>> >SVRMGR> startup
>> >
>> > where does startup look for the db init files ?
>> >
>> > is it
>> >
>> >/disk1/oracle/o805/dbs
>> >
>> >or
>> >
>> >/disk1/oracle/admin/sid sid = database sid name
>> >
>> > also, what is the admin directory used for ?
>> >
>> >thanks
>> >
>
>
>
Received on Wed Jul 28 1999 - 03:42:04 CDT