create-db-10.sql

from:http://www.db-ora.nl/create-db-10.html

 

create-db-10.sql:

### execute first.
### vi /etc/oratab
### . oraenv
#!/bin/bash

export ORA_BASE=/oracle
export ORA_DATA=/oracle/data
export ORA_FLASH=/oracle/flash

export ORA_ADMIN=$ORA_BASE/admin/$ORACLE_SID
export CHARSET=UTF8
export ORA_ARCH=NOARCHIVELOG
export PASSWD=password

echo "db_domain=''" > init-10.ora
echo "db_name=$ORACLE_SID" >> init-10.ora

echo "background_dump_dest=$ORA_ADMIN/bdump" >> init-10.ora
echo "core_dump_dest=$ORA_ADMIN/cdump" >> init-10.ora
echo "user_dump_dest=$ORA_ADMIN/udump" >> init-10.ora
echo "max_dump_file_size=20M" >> init-10.ora

echo "control_files= ('$ORA_DATA/$ORACLE_SID/control_01.ctl'" >> init-10.ora
echo "                    ,'$ORA_DATA/$ORACLE_SID/control_02.ctl'" >> init-10.ora
echo "                    ,'$ORA_DATA/$ORACLE_SID/control_03.ctl')" >> init-10.ora

echo "db_recovery_file_dest=$ORA_FLASH" >> init-10.ora
echo "db_recovery_file_dest_size=4G" >> init-10.ora

echo "log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'" >> init-10.ora
echo "log_archive_format='log_%t_%s_%r.arc'" >> init-10.ora

echo "db_create_file_dest=$ORA_DATA" >> init-10.ora

echo "sga_target=350M" >> init-10.ora
echo "log_buffer=1048576" >> init-10.ora

echo "pga_aggregate_target=35M" >> init-10.ora
echo "workarea_size_policy=auto" >> init-10.ora

echo "job_queue_processes=10" >> init-10.ora

echo "db_block_size=8192" >> init-10.ora

echo "open_cursors=300" >> init-10.ora
echo "processes=150" >> init-10.ora

echo "audit_trail=db" >> init-10.ora

echo "remote_login_passwordfile=EXCLUSIVE" >> init-10.ora

echo "dispatchers='(PROTOCOL=TCP)(SERVICE="$ORACLE_SID"XDB)'" >> init-10.ora

echo "undo_management=AUTO" >> init-10.ora
echo "undo_tablespace=UNDOTBS1" >> init-10.ora

# ----------------- Do not modify anything below. --------------------------------------------------

mkdir -p $ORA_ADMIN/bdump $ORA_ADMIN/cdump $ORA_ADMIN/udump
mkdir -p $ORA_ADMIN/adump $ORA_ADMIN/spfile $ORA_ADMIN/pfile
mkdir -p $ORA_DATA/$ORACLE_SID $ORA_FLASH

cp init-10.ora $ORA_ADMIN/pfile/init$ORACLE_SID.ora

orapwd file=$ORA_ADMIN/pfile/orapw$ORACLE_SID password=$PASSWD entries=5
ln -sf $ORA_ADMIN/pfile/orapw$ORACLE_SID $ORACLE_HOME/dbs/orapw$ORACLE_SID

sqlplus /nolog << EOF

spool create-$ORACLE_SID.log

set verify off
DEFINE ORACLE_HOME=$ORACLE_HOME
DEFINE ORACLE_SID=$ORACLE_SID
DEFINE ORA_ADMIN=$ORA_ADMIN
DEFINE ORA_DATA=$ORA_DATA/$ORACLE_SID
DEFINE CHARSET=$CHARSET
DEFINE ORA_ARCH=$ORA_ARCH
DEFINE PASSWD=$PASSWD

connect SYS/&PASSWD as SYSDBA

startup nomount pfile='&ORA_ADMIN/pfile/init&ORACLE_SID/.ora';

create spfile='&ORA_ADMIN/spfile/spfile&ORACLE_SID/.ora'
from pfile='&ORA_ADMIN/pfile/init&ORACLE_SID/.ora';

host ln -sf $ORA_ADMIN/spfile/spfile$ORACLE_SID.ora $ORACLE_HOME/dbs/spfile$ORACLE_SID.ora

CREATE DATABASE &ORACLE_SID
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '&ORA_DATA/system01.dbf'
SIZE 500M
AUTOEXTEND ON
NEXT 10240K
MAXSIZE 1000M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '&ORA_DATA/sysaux01.dbf'
SIZE 120M
AUTOEXTEND ON
NEXT 10240K
MAXSIZE 1000M
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE '&ORA_DATA/temp01.dbf'
SIZE 250M
AUTOEXTEND ON
NEXT 5120K
MAXSIZE 2000M
UNDO TABLESPACE UNDOTBS1
DATAFILE '&ORA_DATA/undotbs101.dbf'
SIZE 200M
AUTOEXTEND ON
NEXT 5120K
MAXSIZE 4000M
CHARACTER SET &CHARSET
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('&ORA_DATA/redo01a.log','&ORA_DATA/redo01b.log') SIZE 50M,
GROUP 2 ('&ORA_DATA/redo02a.log','&ORA_DATA/redo02b.log') SIZE 50M,
GROUP 3 ('&ORA_DATA/redo03a.log','&ORA_DATA/redo03b.log') SIZE 50M,
GROUP 4 ('&ORA_DATA/redo04a.log','&ORA_DATA/redo04b.log') SIZE 50M
USER SYS IDENTIFIED BY &PASSWD
USER SYSTEM IDENTIFIED BY &PASSWD
&ORA_ARCH;

@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catblock.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/catoctk.sql
@$ORACLE_HOME/rdbms/admin/owminst.plb
@$ORACLE_HOME/rdbms/admin/catexp.sql
@$ORACLE_HOME/rdbms/admin/dbmspool.sql

alter user sys temporary tablespace temp;
alter user system temporary tablespace temp;

connect system/&PASSWD

@$ORACLE_HOME/sqlplus/admin/pupbld.sql
@$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql

CREATE TABLESPACE USERS
LOGGING
DATAFILE '&ORA_DATA/users01.dbf'
SIZE 25M
AUTOEXTEND ON
NEXT 1280K
MAXSIZE 200M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE TOOLS
LOGGING
DATAFILE '&ORA_DATA/tools01.dbf'
SIZE 100M
AUTOEXTEND ON
NEXT 1280K
MAXSIZE 200M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

ALTER DATABASE DEFAULT TABLESPACE USERS;

ALTER USER OUTLN ACCOUNT LOCK;
ALTER USER DBSNMP IDENTIFIED BY &PASSWD;

connect sys/&PASSWD as sysdba

@$ORACLE_HOME/javavm/install/initjvm.sql
@$ORACLE_HOME/xdk/admin/initxml.sql
@$ORACLE_HOME/xdk/admin/xmlja.sql
@$ORACLE_HOME/rdbms/admin/catjava.sql
@$ORACLE_HOME/rdbms/admin/catexf.sql

@$ORACLE_HOME/ctx/admin/catctx.sql &PASSWD SYSAUX TEMP NOLOCK
connect CTXSYS/&PASSWD
@$ORACLE_HOME/ctx/admin/defaults/dr0defin.sql AMERICAN

connect sys/&PASSWD as sysdba

@$ORACLE_HOME/rdbms/admin/catqm.sql &PASSWD SYSAUX TEMP
@$ORACLE_HOME/rdbms/admin/catxdbj.sql
@$ORACLE_HOME/rdbms/admin/catrul.sql

@$ORACLE_HOME/ord/admin/ordinst.sql SYSAUX SYSAUX
@$ORACLE_HOME/ord/im/admin/iminst.sql

@$ORACLE_HOME/rdbms/admin/utlrp.sql

spool off

exit

EOF