Link to home
Start Free TrialLog in
Avatar of dbaseek
dbaseek

asked on

init.ora

can you please explain creation of init.ora while creation of database in oracle 10g?
Avatar of dbaseek
dbaseek

ASKER

very urgent please........
Avatar of anand_2000v
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,
                                 https://www.experts-exchange.com/questions/22025284/db.html        


 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 ??
ASKER CERTIFIED SOLUTION
Avatar of konektor
konektor
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial