1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / guest

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

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

What is the default fill factor value? : sql server DBA

0 Answers  

Where would you look for errors from the database engine?

0 Answers   IBM,

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  




how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

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

0 Answers  

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

What is the importance of a recovery model? : sql server DBA

0 Answers  

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

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

5 Answers   CSC, Logica CMG,

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

4 Answers   TCS,

For more DB Administration Interview Questions Click Here
Categories