Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 965
  • Last Modified:

Difference between init.ora and pfile

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
pageast
Asked:
pageast
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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
 
DavidSenior Oracle Database AdministratorCommented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now