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\CDUMPC:\>rem SET ORACLE ENVIOURMENT VARIABLE
C:\>set ORACLE_HOME=c:\ora9ihome
C:\>set PATH=c:\ora9ihome\bin
C:\>set ORACLE_SID=orcl9iC:\>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 sysdbaConnected 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 bytesFixed 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
"Teach Oracle Learn Oracle" -- Taj Contact me for support at askdbataj@gmail.com This blog is dedicated to all ORACLE Professionals and Learning Students.
Search This Blog
Wednesday, May 7, 2008
Manually DB Creation with 9i
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment