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

Question Posted / guest

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

why we use cursors

1 Answers

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers

How to start SQL Server in minimal configuration mode?

1 Answers

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers TCS, Wipro,

what is the difference between db2start command and start database manager command?

1 Answers

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers

Explain the use of table functions.

1 Answers

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers

How would you extract DDL of a table without using a GUI tool?

0 Answers

What is checkpoint?

3 Answers Accenture,

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers Oracle,

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

4 Answers TCS,

For more DB Administration Interview Questions Click Here