export PATH=$PATH:/opt/oracle/product/9.2/bin/
echo Add this entry in the oratab: ora9:/opt/oracle/product/9.2:Y
orapwd file=/opt/oracle/product/9.2/dbs/orapwora9 passWord=change_on_install
sqlplus /nolog @/opt/oracle/admin/ora9/scripts/CreateDB.sql
sqlplus /nolog @/opt/oracle/admin/ora9/scripts/CreateDBFiles.sql
sqlplus /nolog @/opt/oracle/admin/ora9/scripts/CreateDBCatalog.sql
sqlplus /nolog @/opt/oracle/admin/ora9/scripts/postDBCreation.sql
oracle> cat $ORACLE_BASE/admin/ora9/scripts/CreateDB.sql
connect SYS/change_on_install as SYSDBA
set echo on
spool /opt/oracle/product/9.2/assistants/dbca/logs/CreateDB.log
startup nomount pfile="/opt/oracle/admin/ora9/scripts/init.ora";
CREATE DATABASE ora9
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/dev/zvol/rdsk/ora_pool/system_800m' SIZE 800M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/dev/zvol/rdsk/ora_pool/temp01_4000m' SIZE 4000M REUSE
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/dev/zvol/rdsk/ora_pool/undotbs1_01_4000m' SIZE 4000M REUSE
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/dev/zvol/rdsk/ora_pool/redo1_01_400m') SIZE 400M,
GROUP 2 ('/dev/zvol/rdsk/ora_pool/redo2_01_400m') SIZE 400M,
标签: