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

Question Posted / guest

4 Answers
20102 Views
TCS, I also Faced
E-Mail Answers

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 you open a cluster administrator? : sql server DBA

0 Answers

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

3 Answers

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers

how can you get actual data change values from previous transactions in oracle?

0 Answers Oracle,

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers

how can you record information about current session?

0 Answers Oracle,

What background process refreshes materialized views?

2 Answers Accenture, FLSmidth,

Why would you call update statistics? : sql server DBA

0 Answers

what is meant by gateway

1 Answers IBM,

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

5 Answers CSC, Logica CMG,

who owns the operating system files created by the utl_file package?

0 Answers Oracle,

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

For more DB Administration Interview Questions Click Here