ORACLE
DATABASE CREATION IN UNIX
---------------------------------
STEP 1.
Create
Oracle User in Unix
1.1
Create oracle user in group dba with system privileges
1.2
Create mount points for each disk
1.3
Change ownership / group for each mount point to oracle / dba
1.4
Check unix settings ulimit -Sa /
ulimit -Ha umask=022
STEP 2.
Set
up environment variables
2.1 Set up environment variable in the
.profile of oracle home directory
TERM=VT100
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/818
ORACLE_SID=<sid>
DBA=$ORACLE_HOME/admin
TNS_ADMIN=$ORACLE_HOME/network/admin
NLS_LANG=
STEP 3.
Create
Directories
3.1 Create directories as per OFA i.e /u1/oradata/<sid>data/ etc. etc.
3.2 Create directory $DBA/<sid>
3.3 Create subdirectories adump, bdump,
cdump, pfile, create
3.4 Copy initseed.ora file to
$ORACLE_HOME/dbs/init<sid>.ora and edit
(U can place the init<sid>.ora in the $DBA/<sid>/pfile
directory
and
create a link to this in $ORACLE_HOME/dbs directory.)
3.5 Copy create_db<sid>.sql file to
$DBA/<sid>/create directory and edit
*************************************************************************
-- create_db<sid>.sql file
-- Edit as required
CREATE DATABASE <sid>
maxlogfiles
16
maxlogmembers 3
maxdatafiles 100
maxinstances 1
maxloghistory 100
CONTROLFILE REUSE
LOGFILE
group 1 (
'/u1/oradata/<sid>data/log1a.rdo',
'/u5/oradata/<sid>data/log1b.rdo'
) size 500k,
group 2 (
'/u2/oradata/<sid>data/log2a.rdo',
'/u6/oradata/<sid>data/log2b.rdo'
) size 500k,
group 3 (
'/u3/oradata/<sid>data/log3a.rdo',
'/u7/oradata/<sid>data/log3b.rdo'
) size 500k
DATAFILE '/u1/oradata/<sid>data/system01.dbf' SIZE 10M REUSE
AUTOEXTEND ON
NEXT 10M MAXSIZE 400M
CHARACTER SET US7ASCII;
*************************************************************************
STEP 4
Create
Orapwd file
4.1 From command prompt run orapwd utility
orapwd file=<fname> password=<password>
entries=<users>
STEP 5
Start Oracle Instance
5.1 Run svrmgrl
5.2 Connect internal
5.3 CHECK ENVIRONMENTAL PARAMETERS
5.4 Start <sid> instance :
SVRMGR>startup nomount pfile ='$ORACLE_HOME/dbs/init<sid>.ora’
STEP 6
Create
Database
6.1 Run create_db<sid>.sql file
SVRMGR>@$DBA/<sid>/create/create_db<sid>.sql
6.2 Bounce the database
6.3 Run
$ORACLE_HOME/rdbms/admin/catalog.sql
6.4 Run $ORACLE_HOME/rdbms/admin/catproc.sql
6.5 Run
$ORACLE_HOME/sqlplus/admin/pupbld.sql
STEP 7.
Create
TABLESPACES AND ROLLBACK SEGMENTS
7.1 Copy the file
create_ts_<sid>.sql to $DBA/<sid>/create directory and edit
7.2 Run the create_ts_<sid>.sql file
******************************************************************
-- create_ts.sql_<sid> file
-- Create another (temporary) system
tablespace
CREATE ROLLBACK SEGMENT rb_temp STORAGE
(INITIAL 100 k NEXT 250 k);
-- Alter temporary system tablespace
online before proceding
ALTER ROLLBACK SEGMENT rb_temp ONLINE;
-- Create additional tablespaces ...
-- RBS: For rollback segments
-- USERS: Create user sets this as the
default tablespace
-- TEMP: Create user sets this as the
temporary tablespace
CREATE TABLESPACE RBS
DATAFILE '/u2/oradata/<sid>data/rbs01.dbf' SIZE 5M REUSE
AUTOEXTEND ON
NEXT 5M MAXSIZE 1024M;
CREATE TABLESPACE USERDATA
DATAFILE '/u3/oradata/<sid>data/users01.dbf' SIZE 10M REUSE
AUTOEXTEND ON
NEXT 10M MAXSIZE 1024M;
ALTER TABLESPACE USERDATA ADD DATAFILE
'/u5/oradata/<sid>data/users01.dbf' SIZE 10M REUSE AUTOEXTEND ON
NEXT 10M MAXSIZE 1024M;
CREATE TABLESPACE USERTEMP TEMPORARY
DATAFILE '/u4/oradata/<sid>data/temp01.dbf' SIZE 2M REUSE
AUTOEXTEND ON
NEXT 5M MAXSIZE 1024M;
CREATE TABLESPACE USERINDEX
DATAFILE '/u6/oradata/<sid>data/indx01.dbf' SIZE 2M REUSE
AUTOEXTEND ON
NEXT 5M MAXSIZE 1024M;
-- Create rollback segments.
CREATE ROLLBACK SEGMENT RBS1
STORAGE(INITIAL 50K NEXT 250K)
tablespace RBS;
CREATE ROLLBACK SEGMENT RBS2
STORAGE(INITIAL 50K NEXT 250K)
tablespace RBS;
CREATE ROLLBACK SEGMENT RBS3
STORAGE(INITIAL 50K NEXT 250K)
tablespace RBS;
CREATE ROLLBACK SEGMENT RBS4
STORAGE(INITIAL 50K NEXT 250K)
tablespace RBS;
-- Bring new rollback segments online
ALTER ROLLBACK SEGMENT RBS1 ONLINE;
ALTER ROLLBACK SEGMENT RBS2 ONLINE;
ALTER ROLLBACK SEGMENT RBS3 ONLINE;
ALTER ROLLBACK SEGMENT RBS4 ONLINE;
--drop the temporary system one
ALTER ROLLBACK SEGMENT rb_temp OFFLINE;
DROP ROLLBACK SEGMENT rb_temp ;
******************************************************************
STEP 8
Configure
Network
8.1 Copy the listener.ora file to the
$TNS_ADMIN/ directory and edit.
8.2 Copy the tnsnames.ora file to the
$TNS_ADMIN/ directory and edit.
******************************************************************
---$TNS_ADMIN/listener.ora file
# LISTENER.ORA Network Configuration File:
/oracle/818/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host>)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = <sid>)
(ORACLE_HOME = /oracle/817)
(PROGRAM = extproc)
)
)
******************************************************************
8.3 Start Listener from os prompt $lsnrctl
start
8.4 Configure Client copy the tnsnames.ora
file to the client $TNS_ADMIN/ directory.
******************************************************************
-- $TNS_ADMIN/tnsnames.ora
# TNSNAMES.ORA Network Configuration File:
C:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
<SERVICE_NAME> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SID = <sid>)
)
)
******************************************************************
END OF DATABASE CREATION STEPS