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

Question Posted / guest

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

WHEN DOWN TIME WHAT CAN U DO?

1 Answers TCS,

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers

What the different topologies in which replication can be configured? : sql server DBA

0 Answers

How many packages we have in db

1 Answers Tesco,

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers Zenith,

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers Tech Mahindra,

What is the default port no on which sql server listens? : sql server DBA

0 Answers

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers

What is a system database and what is a user database? : sql server DBA

0 Answers

How to determine the service pack currently installed on SQL Server?

1 Answers

For more DB Administration Interview Questions Click Here