Posted by: Monish | August 21, 2008

Create Database on LINUX

STEPS TO CREATE 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 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.

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

Okay, now your database is ready to use…


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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

Categories

%d bloggers like this: