Re: PFILE from SPFILE

I do not understand how the question is eligible for a stupid question? Yes the files do exist there at the proper place.

On 10/17/05, NEW pop.tiscali.de <http://pop.tiscali.de> < adolph.tony_at_tiscali.de> wrote:
>
> Perhaps a stupid question, *but*....
> (I guess from the back slashes you're on a w2k box)
> Does the controlfile %ORACLE_HOME%\oradata\MYDB\control01.ctl actually
> exist?
> Tony
>
> ----- Original Message -----
> *From:* DBA Deepak <oracle.tutorials_at_gmail.com>
> *To:* NEW pop.tiscali.de <adolph.tony_at_tiscali.de> ; oracle-l_at_freelists.org
> *Sent:* Monday, October 17, 2005 12:32 PM
> *Subject:* Re: PFILE from SPFILE
>
> 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
>
>
>

--
Regards,

Deepak
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l