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

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

Why would you call update statistics? : sql server DBA

0 Answers  

what is the use of recording information about current session?

0 Answers   Oracle,

Explain what partitioning is and what its benefit is.

2 Answers  

What view would you use to determine free space in a tablespace?

3 Answers  




how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

how can you initialize log miner?

0 Answers   Oracle,

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

how can you process messages in order asynchronously?

0 Answers   Oracle,

What is the difference between LMT & DLT?

1 Answers   CTS,

what is meant by gateway

1 Answers   IBM,

For more DB Administration Interview Questions Click Here
Categories