Firstly u have to do following to set the parameter for database creation.
for you practice i am telling u by applying practically for DB creation.
*.sga_target=1677721600
*.undo_management=’AUTO’
*.control_files = (‘/home/oracle/oracle/product/10.2.0/control01.ctl’)
*.user_dump_dest=’/home/oracle/oracle/product/10.2.0/udump’
*.background_dump_dest=’/home/oracle/oracle/product/10.2.0/bdump’
*.core_dump_dest=’/home/oracle/oracle/product/10.2.0/cdump’
2.After creation of this parameter file, create below folders in /home/oracle/oracle/product/10.2.0/ directory. Three of them are dump folders (needed for trace files and alert.log file). We’re going to keep Control Files and DataFiles in oradata folder.
- oradata
- udump
- bdump
- cdump
3. Create Server parameter file (SPFILE) using this parameter file and STARTUP the instance in NOMOUNT mode.
CREATE SPFILE FROM PFILE=’/home/oracle/oracle/product/10.2.0/init.ora’;
STARTUP NOMOUNT
4. To create a new database, use the CREATE DATABASE statement. As a result, below files will be created:
- Redo Log files
- system.dbf and sysaux.dbf (files for SYSTEM tablespace)
- undo01.dbf file (for UNDO tablespace)
- temp_tbs.dbf file (for TEMPORARY tablespace)
- users.dbf (for DEFAULT PERMANENT tablespace)
//######## Database Creation Code #######
CREATE DATABASE kamran
USER SYS IDENTIFIED BY kamran
USER SYSTEM IDENTIFIED BY kamran
after applying these steps u gauranteed to make full database creation by manually.
on sql prumpt type DBCA to create DB by help of tools..
for you practice i am telling u by applying practically for DB creation.
For manually DB Creation
1..db_name=kamran
*.db_block_size=8192*.sga_target=1677721600
*.undo_management=’AUTO’
*.control_files = (‘/home/oracle/oracle/product/10.2.0/control01.ctl’)
*.user_dump_dest=’/home/oracle/oracle/product/10.2.0/udump’
*.background_dump_dest=’/home/oracle/oracle/product/10.2.0/bdump’
*.core_dump_dest=’/home/oracle/oracle/product/10.2.0/cdump’
2.After creation of this parameter file, create below folders in /home/oracle/oracle/product/10.2.0/ directory. Three of them are dump folders (needed for trace files and alert.log file). We’re going to keep Control Files and DataFiles in oradata folder.
- oradata
- udump
- bdump
- cdump
3. Create Server parameter file (SPFILE) using this parameter file and STARTUP the instance in NOMOUNT mode.
CREATE SPFILE FROM PFILE=’/home/oracle/oracle/product/10.2.0/init.ora’;
STARTUP NOMOUNT
4. To create a new database, use the CREATE DATABASE statement. As a result, below files will be created:
- Redo Log files
- system.dbf and sysaux.dbf (files for SYSTEM tablespace)
- undo01.dbf file (for UNDO tablespace)
- temp_tbs.dbf file (for TEMPORARY tablespace)
- users.dbf (for DEFAULT PERMANENT tablespace)
//######## Database Creation Code #######
CREATE DATABASE kamran
USER SYS IDENTIFIED BY kamran
USER SYSTEM IDENTIFIED BY kamran
after applying these steps u gauranteed to make full database creation by manually.
Tool for DB creation.
on sql prumpt type DBCA to create DB by help of tools..
No comments:
Post a Comment