STEPS TO CREATE ORACLE DATABASE MANUALLY ON LINUX

Step 1:
Prepare the database creation script. Following is my script “testdb.sql

CREATE DATABASE TESTDB

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 ‘/opt/oracle/TESTDB/redo01.log’  SIZE 50M BLOCKSIZE 512,

GROUP 2 ‘/opt/oracle/TESTDB/redo02.log’  SIZE 50M BLOCKSIZE 512,

GROUP 3 ‘/opt/oracle/TESTDB/redo03.log’  SIZE 50M BLOCKSIZE 512

— STANDBY LOGFILE

DATAFILE

‘/opt/oracle/TESTDB/system01.dbf’ SIZE 200M,

‘/opt/oracle/TESTDB/users01.dbf’ SIZE 100M

sysaux datafile ‘/opt/oracle/TESTDB/sysaux01.dbf’ SIZE 200M

undo tablespace undotbs1

datafile ‘/opt/oracle/TESTDB/undotbs01.dbf’ SIZE 100M

CHARACTER SET WE8MSWIN1252

;

NOTE :  You can get this similar script , when you perform ‘ALTER DATABASE BACKUP CONTROLFILE TO TRACE’, we can edit this script.

Step 2:

Create all the necessary directories.

Oracle:/opt/oracle $ mkdir TESTDB

Similarly create all necessary directories

Step 3:

Prepare the init file(pfile) [initTESTDB.ora]

TESTDB.__db_cache_size=436207616

TESTDB.__java_pool_size=4194304

TESTDB.__large_pool_size=4194304

TESTDB.__oracle_base=’/opt/oracle’#ORACLE_BASE set from environment

TESTDB.__pga_aggregate_target=432013312

TESTDB.__sga_target=641728512

TESTDB.__shared_io_pool_size=0

TESTDB.__shared_pool_size=184549376

TESTDB.__streams_pool_size=0

*.audit_file_dest=’/opt/oracle/admin/TESTDB/adump’

*.audit_trail=’db’

*.compatible=’11.2.0.0.0′

*.control_files=’/opt/oracle/TESTDB/control01.ctl’,’/opt/oracle/fra/TESTDB/control02.ctl’

*.db_block_size=8192

*.db_domain=”

*.db_name=’TESTDB’

*.db_recovery_file_dest=’/opt/oracle/fra’

*.db_recovery_file_dest_size=4227858432

*.diagnostic_dest=’/opt/oracle/’

*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTDBXDB)’

#*.local_listener=’LISTENER_TESTDB’

*.memory_target=1073741824

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile=’EXCLUSIVE’

*.undo_tablespace=’UNDOTBS’

Step 4:

Now perform the following steps:

$ export ORACLE_SID=TESTDB

$ 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 >

SQL> startup nomount  pfile=/u01/app/oracle/product/10.2.0/db_1/dbs/initTESTDB.ora

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> @testdb.sql

Database created.

Step 5:

So your database is created. Now just run the catalog.sql and catproc.sql scripts.

You will find the in $ cd $ORACLE_HOME/rdbms/admin

SQL> @$ORACLE_HOME/rdbms/admin/catalog.sql

SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql

This will create all dictionary views, now verify

SQL> select name from v$database;

NAME

———

TESTDB

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: