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: PFILE from SPFILE

Re: PFILE from SPFILE

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Mon, 17 Oct 2005 17:02:44 +0530
Message-ID: <75aa80160510170432l20cb981ap462db4ce028edd17@mail.gmail.com>


The control_file entry in the pfile created from spfile looks like  ?\oradata\MYDB\control01.ctl

 On 10/17/05, NEW pop.tiscali.de <http://pop.tiscali.de> < adolph.tony_at_tiscali.de> wrote:
>
> Hi Deepak,
> RE 1: as a previous post just noted, in RAC configurations, the * is
> replaced by the instance number for the database.
> RE 2: the ? is ORACLE_HOME, not BASE
> RE 3: looks dodgy to me, what's the control_files entry in the new pfile
> that was just created from the spfile?
> Tony
>
> ----- Original Message -----
> *From:* DBA Deepak <oracle.tutorials_at_gmail.com>
> *To:* oracle-l_at_freelists.org
> *Sent:* Monday, October 17, 2005 12:12 PM
> *Subject:* PFILE from SPFILE
>
> Hi All,
> When I created a pfile from spfile the pfile has lines like the
> following....
> *.background_dump_dest='?\admin\
> I have a few doubts regarding that.
> 1> Why **.* is there before each line.
> 2> Why the locations of the dumps as well as the control files have *?\*prefixed.
> 3> Even when i use sho parameter control_file it shows the ?
> Please help me in understanding the above.
>
> --
> Regards,
>
> Deepak
> Oracle DBA
>
>
>

--
Regards,

Deepak
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 17 2005 - 06:35:14 CDT

Original text of this message

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