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

Question Posted / guest

4 Answers
20107 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 are statistics, under what circumstances they go out of date, how do you update them?

0 Answers

How can we see the database version in os level

6 Answers Oracle,

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

2 Answers Genpact,

Oracle 11g new features?

2 Answers

What command would you use to encrypt a PL/SQL application?

1 Answers

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers

What view would you use to look at the size of a data file?

3 Answers

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers

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

5 Answers CSC, Logica CMG,

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers

For more DB Administration Interview Questions Click Here