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 is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

Give the reasoning behind using an index.

2 Answers  

What are the different types of indexes available in sql server? : sql server DBA

1 Answers  

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

What authentication modes does sql server support? : sql server DBA

1 Answers  

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1 Answers  

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

what is the differnce between process and thread ?

1 Answers   IBM,

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

For more DB Administration Interview Questions Click Here
Categories