Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 19722 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
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what are the performance views in an oracle rac environment?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what are the differences of where and if in SAS?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
what is the diffrence between core dba and apps dba?
how can you process messages in order asynchronously?
What is transparent data encryption? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is the use of ocr?
what do you understand by fine-grained auditing?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
who owns the operating system files created by the utl_file package?
