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: <amit.sharma_at_uk.nomura.com>
Date: Mon, 17 Oct 2005 12:36:01 +0100
Message-ID: <CA72331CA11C5D419EC5C71438122F0204AC45AE@lons0227.uk.nomura.com>


You mentioned some problem with spfile/pfile, about migrating from 10g to 9i in another email. Is it the same spfile you are talking about?        

Regards

Amit  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DBA Deepak Sent: 17 October 2005 12:33
To: NEW pop.tiscali.de; oracle-l_at_freelists.org 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 < 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

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

PLEASE READ: The information contained in this email is confidential and intended for the named recipient(s) only. If you are not an intended recipient of this email please notify the sender immediately and delete your copy from your system. You must not copy, distribute or take any further action in reliance on it. Email is not a secure method of communication and Nomura International plc ('NIplc') will not, to the extent permitted by law, accept responsibility or liability for (a) the accuracy or completeness of, or (b) the presence of any virus, worm or similar malicious or disabling code in, this message or any attachment(s) to it. If verification of this email is sought then please request a hard copy. Unless otherwise stated this email: (1) is not, and should not be treated or relied upon as, investment research; (2) contains views or opinions that are solely those of the author and do not necessarily represent those of NIplc; (3) is intended for informational purposes only and is not a recommendation, solicitation or offer to buy or sell securities or related financial instruments. NIplc does not provide investment services to private customers. Authorised and regulated by the Financial Services Authority. Registered in England no. 1550505 VAT No. 447 2492 35. Registered Office: 1 St Martin's-le-Grand, London, EC1A 4NP. A member of the Nomura group of companies.

--

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

Original text of this message

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