Re: Will the REAL pfile Please Stand Up

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Mon, 05 Jul 2004 06:53:03 +0200
Message-ID: <ljnhe0tcms90vqu7jnff5sag027ag13aji@4ax.com>

On 4 Jul 2004 16:49:50 -0700, melliott42_at_yahoo.com (Michael) wrote:

>Hello,
>
>On a Windows 2000 system running Oracle 8.17 I have
>noticed that the Registry shows this as the pfile
>location: C:\oracle\admin\db1\pfile\initdb1.ora
>
>I also noticed however, that every time my database
>shuts down it writes to:
>C:\oracle\ora81\sysman\ifiles\def_DB1.ora
>
>1. If I want to modify the pfile which one should I
>change?
>
>2. Does Oracle 8.17 on Sun UNIX systems have this dual
>pfile scenario too?
>
>Thanks very much for feedback,

You must be running OEM on this system. The second file is the pfile used by OEM when you are starting up and shutting down using OEM The first pfile is the real one.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Jul 04 2004 - 23:53:03 CDT