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