Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 20105 Views
- TCS, I also Faced
- E-Mail Answers
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
What are the commands used in dcl? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you find out if a table can be redefined?
Explain materialized views and how they are used.
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
how does an oracle clusterware manage crs resources?
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?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
how can you generate profile of pl/sql applications to identify performance bottlenecks?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
