Make your own free website on Tripod.com

Creating Databases
 

Installation of Oracle on SCO

As root run rootpre.sh script then as Oracle user run ./orainst

Steps to be followed to create a Database and an Instance.
 
1) Copy the crdb.sql and crdb2.sql scripts which are situated in the $ORACLE_HOME/rdbms/admin dir.
 
2) Make changes in initSID_0.ora, initSID.ora and configSID.ora to reflect the directory of the datafile and the tuning parameters
 
3) Make entries in /etc/system file
set shmsys:shminfo_shmmax= <about 3/4 the RAM in bytes>
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmseg=5
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmns=150
set semsys:seminfo_semmni=150
           save the file.
 
4) set the oracle sid name
example% ORACLE_SID=<SID>;export ORACLE_SID
example% svrmgrl
SVRMGR> connect internal
SVRMGR> @crdb
SVRMGR> @crdb2                 //this will take a long time to create
 
When loggin on the SQL*Plus if you get ORA-6553 PLS-213 then you have to run pupbld script


example% SYSTEM_PASS="system/manager";export SYSTEM_PASS
example% pupbld