Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 19966 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
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What the different components in replication and what is their use? : sql server DBA
what are the performance views in an oracle rac environment?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What is dbcc? : sql server DBA
what is logical system in sap basis
What is the default fill factor value? : sql server DBA
what is the use of recording information about current session?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
when does an alert gets signaled?
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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
