Re: Tru64 UNIX files: "lkDBNAME" & "sgadefSID.dbf"

sgadefSID.dbf is created at instance startup and stores the memory address of the SGA. This file is no longer used in 8i, and maybe 8.0 I forget...

ltiu wrote:
>
> 1) lkDBName is the lock file for the database currently running.
>
> If you try to run another instance of the same DB, it will look for this file
> and if it finds it, it will give you an error telling you that it is already
> running.
>
> 2) No answer for this.
>
> >Greetings fellow-Listers,
> >
> >On a couple of our Tru64 Unix machines which still have Oracle 7.3.4 running
>
> >on them, I have occasionally noticed the following kinds of files in the
> >$ORACLE_HOME/dbs directory :
> >
> >(1) lkDBNAME
> >This file is formed by "lk" + the database name. There is a file for each
>
> >and every database that was ever created on this machine and the file never
>
> >goes away.
> >
> >The permissions for each are "--w-------", and is owned by "oracle". There
>
> >are 0 records in each.
> >
> >
> >(2) sgadefSID.dbf
> >This file is formed by "sgadef" + the SID + ".dbf". There is one of these
>
> >files only for each of the databases that are currently up and running.
> >Each disappears once the corresponding database is brought down.
> >
> >The permissions for each are "-rw-r-----" and is also owned by "oracle".
> >There are 784 records in each and the contents are binary so there is
> >nothing to be seen by us decimal creatures.
> >
> >
> >Does anybody know what these are and what their function is?
> >
> >Thanks very much,
> >
> >JDamiano
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: James Damiano
> > INET: jadam_at_nhes.state.nh.us
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >
> =================================================================
> Internet service provided by telus.net http://www.telus.net/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: lti
> INET: ltiu_at_alumni.sfu.ca
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).