Linux DataBase Creation

Oracle Version : 10.2.0.1.0
Operating Sys : Suse Linux 9.3

Step 1: Here create oracle OFA folder.

oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/admin> mkdir lamp
oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/admin> cd lamp
oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/admin/lamp> mkdir adump
oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/admin/lamp> mkdir bdump
oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/admin/lamp> mkdir cdump
oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/admin/lamp> mkdir dpdump
oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/admin/lamp> mkdir pfile
oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/admin/lamp> mkdir udump
oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/admin/lamp> cd ..
oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/admin> cd ..
oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/oradata> mkdir lamp


Step 2: Create new password file for your new instance.

oracle@linuxDomain:/u01/app/oracle/product/10.1.0/Db_1/bin> orapwd file=/u01/app/oracle/product/10.1.0/Db_1/dbs/pwdlamp.ora entries=5 password=oracle force=y

Step 3: To start a new instance, say newsid, you create an initnewsid

oracle@linuxDomain:~> export ORACLE_SID=lamp

oracle@linuxDomain:~> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 4 16:09:40 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile=/u01/app/oracle/product/10.1.0/Db_1/dbs/initLAMP.ora
ORACLE instance started.

Total System Global Area 276824064 bytes
Fixed Size 1218920 bytes
Variable Size 75499160 bytes
Database Buffers 192937984 bytes
Redo Buffers 7168000 bytes

SQL>


Step 4: Execute bellow script.

1 CREATE DATABASE "LAMP"
2 MAXINSTANCES 8
3 MAXLOGFILES 16
4 MAXLOGMEMBERS 3
5 MAXDATAFILES 100
6 MAXLOGHISTORY 1
7 DATAFILE '/u01/app/oracle/product/10.1.0/Db_1/oradata/lamp/SYSTEM01.DBF' SIZE 500M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
8 EXTENT MANAGEMENT LOCAL
9 SYSAUX DATAFILE '/u01/app/oracle/product/10.1.0/Db_1/oradata/lamp/SYSAUX01.DBF' SIZE 500M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
10 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/product/10.1.0/Db_1/oradata/lamp/TEMP01.DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
11 UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/app/oracle/product/10.1.0/Db_1/oradata/lamp/UNDOTBS01.DBF' SIZE 500M REUSE AUTOEXTEND ON NEXT 5120K
12 MAXSIZE UNLIMITED
13 CHARACTER SET WE8MSWIN1252
14 NATIONAL CHARACTER SET AL16UTF16
15 LOGFILE GROUP 1 ('/u01/app/oracle/product/10.1.0/Db_1/oradata/lamp/REDO01.LOG') SIZE 10240K,
16 GROUP 2 ('/u01/app/oracle/product/10.1.0/Db_1/oradata/lamp/REDO02.LOG') SIZE 10240K,
17 GROUP 3 ('/u01/app/oracle/product/10.1.0/Db_1/oradata/lamp/REDO03.LOG') SIZE 10240K
18 USER SYS IDENTIFIED BY "&&syspwd"
19* USER SYSTEM IDENTIFIED BY "&&systempwd"
SQL> /
old 18: USER SYS IDENTIFIED BY "&&syspwd"
new 18: USER SYS IDENTIFIED BY "oracle"
old 19: USER SYSTEM IDENTIFIED BY "&&systempwd"
new 19: USER SYSTEM IDENTIFIED BY "oracle"

Database created.

Step 5 : Create users tablespace.


SQL> CREATE TABLESPACE USERS DATAFILE '/u01/app/oracle/product/10.1.0/Db_1/oradata/lamp/USERS01.DBF' SIZE 500M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
2 EXTENT MANAGEMENT LOCAL
3 SEGMENT SPACE MANAGEMENT AUTO;

Step 6: You need run the following script in your database.

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

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

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

Step 7: Create Server parameter file using parameter file.


SQL> CREATE SPFILE FROM PFILE='/u01/app/oracle/product/10.1.0/Db_1/dbs/initLAMP.ora';

File created.

Step 8 : Start your database.

SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> STARTUP

ORACLE instance started.

Total System Global Area 276824064 bytes
Fixed Size 1218920 bytes
Variable Size 75499160 bytes
Database Buffers 192937984 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.