How do you switch from an init.ora file to a spfile?
Answer Posted / 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 |
Post New Answer View All Answers
How would you go about verifying the network name that the local_listener is currently using?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is dcl? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how can you schedule a job in database?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
when does an alert gets signaled?
what is grd?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is logical system in sap basis
Where would you look for errors from the database engine?