Monday, May 14, 2012

Oracle 10g:Create New Database Manually.



1.Create New Service

Go to Command Prompt.

oradim -new -sid blogdb -intpwd blogdb

2.Create Parameter File

Sample Pfile

*.__db_cache_size=444596224
*.__java_pool_size=4194304
*.__large_pool_size=4194304
*.__shared_pool_size=150994944
*.__streams_pool_size=0
*.compatible='11.1.0'
*.control_files='D:\Database\control01.ctl','D:\Database\control02.ctl','D:\Database\control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='blogdb'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='blogdb'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=blogdbXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384

3.Start Database in NoMount mode with pfile 

startup nomount pfile=D:\oracle\product\10.2.0\db_1\database\INITblogdb.ora

4. Create Database 

Sample Script

create database blogdb
  logfile   group 1 ('D:\Database\redo1.log') size 50M,
            group 2 ('D:\Database\redo2.log') size 50M,
            group 3 ('D:\Database\redo3.log') size 50M
  character set          WE8ISO8859P1
  national character set utf8
  datafile 'D:\Database\system.dbf'
            size 100M
            autoextend on
            next 50M maxsize unlimited
            extent management local
  sysaux datafile 'D:\Database\sysaux.dbf'
            size 100M
            autoextend on
            next 50M
            maxsize unlimited
  undo tablespace undo
            datafile 'D:\Database\undo.dbf'
            size 100M
  default temporary tablespace temp
            tempfile 'D:\Database\temp.dbf'
            size 100M;

Check Message

Database created.

SQL>
SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

5.Execute Database Scripts

@?\RDBMS\ADMIN\catalog.sql

@?\RDBMS\ADMIN\cataproc.sql

@?\RDBMS\ADMIN\utlrp.sql

No comments:

Post a Comment

Dear User,

Thank you very much for your kind response