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

Question Posted / guest

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

From the database level, how can you tell under which time zone a database is operating?

1 Answers

what is meant by gateway

1 Answers IBM,

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers

which background process will run @ the time of creation of catalog database

1 Answers CSC,

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

2 Answers

How to start SQL Server in minimal configuration mode?

1 Answers

Give the reasoning behind using an index.

2 Answers

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers Cognizant,

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

2 Answers HP,

what is rebuild index??

2 Answers IBM, Sapient,

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers

What is the difference between LMT & DLT?

1 Answers CTS,

For more DB Administration Interview Questions Click Here