STEPS TO CREATE ORACLE DATABASE MANUALLY ON LINUX


Step 1: 
 
First create all the necessary directories. Followings are my directories: 
 
testdb1]$ ls 
admin backup archive 
admin]$ ls 
adump bdump cdump udump 
 
Step 2: 
 
Next prepare the database creation script. Following is my script "testdb1.sql" 
 
CREATE DATABASE "testdb1" 
MAXLOGFILES 5 
MAXLOGMEMBERS 5 
MAXDATAFILES 100 
MAXINSTANCES 1 
MAXLOGHISTORY 292 
LOGFILE 
GROUP 1 '/d02/monish/testdb1/redo1.log' SIZE 10M, 
GROUP 2 '/d02/monish/testdb1/redo2.log' SIZE 10M, 
GROUP 3 '/d02/monish/testdb1/redo3.log' SIZE 10M 
DATAFILE 
'/d02/monish/testdb1/system.dbf' size 100m, 
'/d02/monish/testdb1/usr04.dbf' size 10m 
sysaux datafile '/d02/monish/testdb1/sysaux.dbf' size 100m 
undo tablespace undotbs 
datafile '/d02/monish/testdb1/undo.dbf' size 50m 
CHARACTER SET US7ASCII 
; 
 
Step 3: 
 
Prepare the init file. Like this one [inittestdb1.ora] 
 
*.audit_file_dest='/d02/monish/testdb1/admin/adump' 
*.background_dump_dest='/d02/monish/testdb1/admin/bdump' 
*.compatible='10.2.0.3.0' 
*.control_files='/d02/monish/testdb1/control01.ctl', 
'/d02/monish/testdb1/control02.ctl','/d02/monish/testdb1/control03.ctl' 
*.core_dump_dest='/d02/monish/testdb1/admin/cdump' 
*.db_block_size=8192 
*.db_domain='' 
*.db_file_multiblock_read_count=16 
*.db_name='testdb1' 
*.dispatchers='(PROTOCOL=TCP) (SERVICE=indiaXDB)' 
*.job_queue_processes=10 
*.log_archive_dest_1='LOCATION=/d02/monish/testdb1/archive' 
*.log_archive_format='%t_%s_%r.dbf' 
*.open_cursors=300 
*.pga_aggregate_target=200278016 *.processes=150 
*.remote_login_passwordfile='EXCLUSIVE' 
*.sga_target=601882624 
*.undo_management='AUTO' 
*.undo_tablespace='UNDOTBS' 
*.user_dump_dest='/d02/monish/testdb1/admin/udump' 
*.db_recovery_file_dest='/d02/monish/testdb1/backup' 
*.db_recovery_file_dest_size=2147483648 
 
Step 4: 
 
Now perform the following steps: 
 
$ export ORACLE_SID=testdb1 
 
$ sqlplus / as sysdba 
 
SQL*Plus: Release 10.2.0.3.0 - Production on Thu May 22 17:35:28 2013 
Copyright (c) 1982, 2006, Oracle. All Rights Reserved. 
Connected to an idle instance. 
 
SQL> startup pfile=/u01/app/oracle/product/10.2.0/db_1/dbs/inittestdb1.ora nomount 
 
ORACLE instance started. 
Total System Global Area 603979776 bytes 
Fixed Size 1263176 bytes 
Variable Size 167774648 bytes 
Database Buffers 427819008 bytes 
Redo Buffers 7122944 bytes 
 
SQL> @testdb1.sql 
Database created. 
 
Step 5: 
 
So your database is create. Now just run the catalog.sql and catproc.sql scripts. 
You will find the in $ cd $ORACLE_HOME/rdbms/admin 
 
SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql 
SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql 
SQL> select name from v$database; 
 
NAME 
--------- 
TESTDB1
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: