Solved

Difference between init.ora and pfile

Posted on 2008-10-01
2
904 Views
Last Modified: 2013-12-18
Dear Sir,
I am having a confusion between init.ora file and pfile.I know whenever we give the command Startup and Shutdown to start and down the database the database read the init.ora file automatically.But if we start and shutdown the database using pfile, we have to mention the absolute location of the pfile.And I also know the we can modify the pfile.So it will be better for me if you kindly say what is the main difference between the init.ora file and pfile.
Waiting for your suggession.
0
Comment
Question by:pageast
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 75 total points
ID: 22614531
>init.ora file and pfile
its the same thing, with 1 difference: the STARTUP PFILE=xxxx can specify any valid init.ora file, while without PFILE, the STARTUP will look at 1 file:
%ORACLE_HOME%/dbs/init%ORACLE_SID%.ora

0
 
LVL 23

Expert Comment

by:David
ID: 22614807
Are you confused about PFILE vs. SPFILE, perhaps?  The SPFILE allows certain parameters to be dynamically changed, either at a command prompt or by the instance, doing its automated tuning.  Changes to the PFILE do not affect the currect instance.  I can explain this further if matches your intent.

Don't forget that one may search the EE site for past threads on this topic.  Others may have already answered this.

Regards,
dvz
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question