Message-ID: <F001.0048BE09.20020628134331@fatcity.com>
Date: Fri, 28 Jun 2002 13:43:31 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Suzy Vordos <lvordos@qwest.com>
Subject: Re: Tru64 UNIX files: "lkDBNAME" & "sgadefSID.dbf"
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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