Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Which parameter file has been used?

Re: Which parameter file has been used?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Sat, 21 Aug 2004 17:52:45 +0100
Message-ID: <7765c89704082109525dcca7e5@mail.gmail.com>


On Sat, 21 Aug 2004 00:46:54 +0200, Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:
> Diego,
> On unix 'ls -lutr' shows a directory listing with access times, sorted
> from old to new. The latest accessed parameterfile is probably the the
> one used to start the database, unless the files were accessed for
> backup purposes, by vi, grep or whatever. No idea whether this is
> possible in Window$ though.

Yes its possible in Windows. Of course you will only read the last accessed time after having opened both files in a text editor to find out which one it was.

The bottom line though is that only the person responsible for starting the db knows how it was started (or indeed on which system the parameter file lies - who said it was the server).

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Sat Aug 21 2004 - 11:48:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US