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

Question Posted / guest

4 Answers
19738 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 the difference between the 2 operating modes of database mirroring? : sql server DBA

0 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

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers

what is the use of ocr?

0 Answers Oracle,

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers Patni,

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

2 Answers Genpact,

How would you force a log switch?

4 Answers

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers

Give two examples of how you might determine the structure of the table DEPT.

2 Answers

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers Genpact,

how can you find out if a table can be redefined?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here