STEPS TO CREATE ORACLE DATABASE MANUALLY ON LINUX

This article shows you steps to create a database manually on Linux.
Step 1:
First create all the necessary directories. Followings are my directories:
testdb1]$ ls
admin backup archive
admin]$ ls
data redo control bdump udump adump cdump
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 ‘/home/oracle/testdb1/admin/redo/redo1.log’ SIZE 10M,
GROUP 2 ‘/home/oracle/testdb1/admin/redo/redo2.log’ SIZE 10M,
GROUP 3 ‘/home/oracle/testdb1/admin/redo/redo3.log’ SIZE 10M
DATAFILE
‘/home/oracle/testdb1/admin/data/system.dbf’ size 100m,
‘/home/oracle/testdb1/admin/data/usr04.dbf’ size 10m
sysaux datafile ‘/home/oracle/testdb1/admin/data/sysaux.dbf’ size 100m
undo tablespace undotbs
datafile ‘/home/oracle/testdb1/admin/data/undo.dbf’ size 50m
CHARACTER SET US7ASCII;
Step 3:
Prepare the init file. Like this one [inittestdb1.ora]
*.audit_file_dest=’/home/oracle/testdb1/admin/adump’
*.background_dump_dest=’/home/oracle/testdb1/admin/bdump’
*.compatible=’10.2.0.3.0′
*.control_files=’/home/oracle/testdb1/admin/control/control01.ctl’,
‘/home/oracle/testdb1/admin/control/control02.ctl’,’/home/oracle/testdb1/admin/control/control03.ctl’
*.core_dump_dest=’/home/oracle/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=/home/oracle/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=’/home/oracle/testdb1/admin/udump’
*.db_recovery_file_dest=’/home/oracle/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 2008
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.
so run this script in open stage of the instance
You will find the in $ cd $ORACLE_HOME/rdbms/admin
SQL> @$ORACLE_HOME/rdbms/admin/catalog.sql
SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
SQL> select name from v$database;
NAME
———
TESTDB1

Okay, now your database is ready to use.

Advertisements
Leave a comment

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: