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
Why does Oracle not permit the use of PCTUSED with indexes?
how can you schedule a job in database?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What happens on checkpoint? : sql server DBA
how can you find out if a table can be redefined?
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
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is a system database and what is a user database? : sql server DBA
how can a session indicate its interest in receiving alerts?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What authentication modes does sql server support? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
Why would you use sql agent? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.