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

Question Posted / guest

4 Answers
19965 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

What is dbcc? : sql server DBA

0 Answers

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers

what is the difference between catalog & nocatalog?

3 Answers CSC,

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

Which autogrowth database setting is good? : sql server DBA

0 Answers

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers

What is the dataguard background process??

1 Answers iGate,

I lost one datafile i dont have backup how can you recover that???

2 Answers HP,

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,

How do you open a cluster administrator? : sql server DBA

0 Answers

what is a user-defined lock?

0 Answers Oracle,

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers

For more DB Administration Interview Questions Click Here