dbaseek
asked on
init.ora
can you please explain creation of init.ora while creation of database in oracle 10g?
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 ??
* .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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER