Posted on 2006-10-22
Medium Priority
Last Modified: 2012-08-13
can you please explain creation of init.ora while creation of database in oracle 10g?
Question by:dbaseek

Author Comment

ID: 17782959
very urgent please........
LVL 13

Expert Comment

ID: 17783698
if you are creating a database manuall you need to create a pfile which contains the details like
  * .database name
  *.control file location
  *.database block size
  *.Udump,bdump ,cdump locations
  *.Sga max size
  *.Other sga parameters
  *.Archivelog path

 you need to specify all this when you are creating a pfile.

*. only using a init file you can bring up ur database to nomount state,when u give startup nomount pfile=path\inittest.ora  the intifile details will be fetched.
*.the after that you can create the database using database creation commands as like i given you recently
          Please Refer,

 when you see 8i,9i,10g ,Some of the parameters in old versions will be made obsolute in the new version ( made default true ).
 Like in 10g,You can see many of the parameters avail in 9i has been made obsolute.

let me know wat you exactly looking for ??

Accepted Solution

konektor earned 2000 total points
ID: 17783934
pfile is not necessary in 10g, even in 9i.
pfile (name initSID.ora, it's text file) was used as parameter file for startup database. all necessary parameter was stored there. some of them can be modified via ALTER SYSTEM command, but after restart they will be taken from pfile. if you want to make change persistent you must chane parameter both in pfile and dynamically for database.
9i and 10g uses spfile (it's binary file). you can do changes via ALTER SYSTEM SET parameter=value SCOPE [MEMORY|SPFILE|BOTH] command. for backwadr comatibility u can also use pfile for startup and there is posibility to create pfile from spfile and vice versa using CREATE  SPFILE FROM PFILE or CREATE PFILE FROM SPFILE

see http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref441 for more details

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question