Search This Blog

Wednesday, May 7, 2008

Manually DB Creation with 9i

C:\>rem Create Required Directories

C:\>mkdir c:\ora9ihome\orcl9i\ORADATA
C:\>mkdir c:\ora9ihome\orcl9i\ADMIN\BDUMP
C:\>mkdir c:\ora9ihome\orcl9i\ADMIN\UDUMP
C:\>mkdir c:\ora9ihome\orcl9i\ADMIN\CDUMP

C:\>rem SET ORACLE ENVIOURMENT VARIABLE

C:\>set ORACLE_HOME=c:\ora9ihome
C:\>set PATH=c:\ora9ihome\bin
C:\>set ORACLE_SID=orcl9i

C:\>rem Create PASSWORDFILE for database authentication

C:\>ORAPWD file=c:\ora9ihome\database\PWDORCL9I.ora password=oracle entries=5

C:\>rem Create INIT parameter file and set below parameter

#Cache and I/O

db_block_size=4096

db_cache_size=20971520

#Diagnostics

background_dump_dest=c:\ora9ihome\orcl9i\admin\bdump

core_dump_dest=c:\ora9ihome\orcl9i\admin\cdump

user_dump_dest=c:\ora9ihome\orcl9i\admin\udump

#Control file

control_files='c:\ora9ihome\orcl9i\oradata\control01.ctl'

#Miscellaneous

compatible=9.0.0

db_name=orcl9i

remote_login_passwordfile=exclusive

#pool

java_pool_size=5242880

large_pool_size=5242880

shared_pool_size=20971520

#Processes

processes=75

#sort,hash

sort_area_size=10485760

#undo,rollback

undo_management=auto

undo_tablespace=UNDOTBS

C:\>rem Create Database Services

C:\>ORADIM -new -sid ORCL9I -startmode A
C:\>set oracle_sid=orcl9i


C:\>rem Connect with instance as SYSDBA
C:\>SQLPLUS /nolog
SQL*Plus: Release 9.0.1.0.1 - Production on Wed May 7 10:23:23 2008
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL> conn sys/oracle as sysdba

Connected to an idle instance.

SQL> --Create Spfile from init.ora file.

SQL> create spfile from pfile='c:\temp\init.ora';
File created.

SQL> --Startup the instance at NOMOUNT stage

SQL> startup nomount

ORACLE instance started.
Total System Global Area 67923680 bytes

Fixed Size 282336 bytes

Variable Size 46137344 bytes

Database Buffers 20971520 bytes

Redo Buffers 532480 bytes

SQL> --Issue the Create Database statement

SQL> create database ORCL9I

2 maxinstances 1

3 maxloghistory 1

4 maxlogfiles 5

5 maxlogmembers 5

6 DATAFILE 'c:\ora9ihome\orcl9i\oradata\system01.dbf' size 200m

7 UNDO tablespace undotbs DATAFILE 'c:\ora9ihome\orcl9i\oradata\undotbs01.dbf' size 100m

8 character set US7ASCII

9 national character set AL16UTF16

10 logfile GROUP 1 ('c:\ora9ihome\orcl9i\oradata\redo01.log') size 5m,

11 GROUP 2 ('c:\ora9ihome\orcl9i\oradata\redo02.log') size 5m;

Database created.

SQL> --Create TEMP or additional tablespace

SQL> Create temporary tablespace TEMP

2 TEMPFILE 'c:\ora9ihome\orcl9i\oradata\temp01.dbf' size 10m;

Tablespace created.

SQL> create tablespace USERS

2 DATAFILE 'c:\ora9ihome\orcl9i\oradata\users01.dbf' size 10m;

Tablespace created.

SQL> --Run Scripts to Build Data Dictionary views

SQL> @%ORACLE_HOME%\rdbms\admin\catalog.sql

SQL> @%ORACLE_HOME%\rdbms\admin\catproc.sql

SQL> @%ORACLE_HOME%\sqlplus\admin\pupbld.sql

No comments: