Solved

Difference between init.ora and pfile

Posted on 2008-10-01
2
898 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 142

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VB.Net - CSV to Oracle table 4 67
SQL Retrieve Values 4 66
su - oracle could not open session 6 72
Trying to get a Linked Server to Oracle DB working 21 57
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

813 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now