1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How do you switch from an init.ora file to a spfile?

Question Posted / guest

Answers were Sorted based on User's Feedback



How do you switch from an init.ora file to a spfile?..

Answer / santo

Just create a spfile for pfile and then bounce the
database...While restarting, if Oracle finds spile first it
will use it first instead on pfile.

Is This Answer Correct ?    28 Yes 1 No

How do you switch from an init.ora file to a spfile?..

Answer / srinivasarao

just create a spfile for pfile and then bounce the
database...While restarting, if Oracle finds spile first it
will use it first instead on pfile.

Is This Answer Correct ?    9 Yes 1 No

How do you switch from an init.ora file to a spfile?..

Answer / ramakrishnach.dba

oracle searches parameter file in following manner

1) spfile$ORACLE_SID.ora
2) spfile.ora
3) init$ORACLE_SID.ora
4) init.ora

if oracle finds spfile$ORACLE_SID.ora file it ignores rest of the files

Is This Answer Correct ?    7 Yes 1 No

How do you switch from an init.ora file to a spfile?..

Answer / ravindra

create pfile from spfile;

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More DB Administration Interview Questions

What the different components in replication and what is their use? : sql server DBA

0 Answers  

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

what is the differnce between process and thread ?

1 Answers   IBM,




Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

What would you do with an "in-doubt" distributed transaction?

0 Answers  

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

what is difference between user managed backup and rman backup?

1 Answers   CTS,

For more DB Administration Interview Questions Click Here
Categories