Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: What is difference between PFile and SPFile?

  1. #1
    Oracle Administrator
    Join Date
    Feb 2012
    Location
    New Delhi, India
    Posts
    53

    Thumbs up What is difference between PFile and SPFile?

    PFILE :-
    A PFILE is a static, client-side text file that must be updated with a standard text editor like "notepad" or "vi". This file normally reside on the server, however, you need a local copy if you want to start Oracle from a remote machine. DBA's commonly refer to this file as the INIT.ORA file.
    SPFILE-:
    An SPFILE (Server Parameter File), on the other hand, is a persistent server-side binary file that can only be modified with the "ALTER SYSTEM SET" command. This means you no longer need a local copy of the pfile to start the database from a remote machine. Editing an SPFILE will corrupt it, and you will not be able to start your database anymore.
    Last edited by devesh_ocp; 04-24-2012 at 07:41 PM.

+ Reply to Thread

Similar Threads

  1. Alteration of Modifiable and Non Modifiable parameters using Spfile/Pfile
    By Jitendra in forum Core Database Administration and Monitoring
    Replies: 4
    Last Post: 06-19-2012, 03:52 AM
  2. RECOVERY SCENARIO: Complete loss of all database files including SPFILE using RMAN
    By devesh_ocp in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 04-25-2012, 10:26 AM
  3. Time Difference between RAC Nodes
    By Hemant in forum RAC Concepts and Administration
    Replies: 1
    Last Post: 01-18-2012, 08:03 PM
  4. Oracle 11g create spfile from memory.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 12-22-2011, 06:10 PM
  5. Difference between Oracle Applications 11i and R12
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 10-29-2011, 11:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics