Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
When you start an Oracle DB which file is accessed first?
This is a discussion on When you start an Oracle DB which file is accessed first? within the Oracle forums, part of the Databases category; Oracle first opens and reads the initialization parameter file (init.ora)....
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
04-13-2009
|
|||
|
|||
|
When you start an Oracle DB which file is accessed first?
Oracle first opens and reads the initialization parameter file (init.ora).
|
| Sponsored Links |
|
04-13-2009
|
|||
|
|||
|
Re: When you start an Oracle DB which file is accessed first?
what is that ?
why are you posting both questions and answers ?
|
|
04-14-2009
|
|||
|
|||
|
Re: When you start an Oracle DB which file is accessed first?
before parameter file (init.ora) , oracle reads spfile
|
|
04-15-2009
|
|||
|
|||
|
Re: When you start an Oracle DB which file is accessed first?
If it has First read init.ora file otherwise spfile.ora
|
| The Following User Says Thank You to vijaygkm For This Useful Post: | ||
|
04-16-2009
|
|||
|
|||
|
Re: When you start an Oracle DB which file is accessed first?
The order:-
init.ora spfile init
|
|
05-10-2009
|
|||
|
|||
|
Re: When you start an Oracle DB which file is accessed first?
Correction from previous post:
the directory is Oracle_Home\database and not Oracle_Home\dbs the first file which is accessed when an Oracle DB is opened is in the following order 1.firstly the spfile which is located in Oracle_Home\database directory. 2.secondly the pfile which is located in Oracle_Home\database directory. 3.If none of the two file exists then the oracle instance will not startup. 4.if you do not want oracle to use the spfile or pfile which is located in Oracle_Home\dbs directory then you can explicitly startup the instance using the pfile created manually using the following command. startup pfile='..\initinstancename.ora'
|
|
06-03-2009
|
|||
|
|||
|
Re: When you start an Oracle DB which file is accessed first?
Quote:
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to create ASCII file in oracle with out using UTL package | srinivasa.dinesh | Oracle | 2 | 02-05-2008 04:31 AM |
| to start as oracle DBA | rpsheth | Database General | 2 | 08-06-2007 01:31 AM |
| Where and how should I start from to learn Oracle Forms | Geek_Guest | Oracle | 0 | 04-19-2007 04:45 AM |
| Retrive objects which are last accessed or updated | Bhavesh69 | Oracle | 0 | 04-17-2007 04:38 PM |
| Difference between start task and start workflow | JobHelper | Data Warehousing | 1 | 01-04-2007 11:21 AM |
All times are GMT -4. The time now is 12:33 AM.
