Oracel 10g静默安装和手工建库全过程扫描(LINUX DEBIAN 4.0)

升木

Oracle 10g installing process by silence on debian 4.0:
1.Swap partition created
dd if=/dev/zero of=/swapfile bs=1M count=2048;
mkswap /swapfile
swapon /swapfile
vim /etc/fstab
/swapfile swap default 0 0
2.groupadd oninstall
groupadd dba
useradd -g oinstall -G dba oracle -d /home/oracle oracle
passwd oracle
mkdir -p /u01/app/oracle/product/10.2.0/db1
chown -R oracle.oinstall /u01/app/
3.vim /etc/hosts
4.vim /etc/sysctl.conf
kernel.shmmax = 1000000000(#0.5*nG*1024*1024*1024)
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=1048576
net.core.rmem_max=1048576
net.core.wmem_default=262144
net.core.wmem_max=262144
fs.file-max = 65536
sysctl -p
5.vim /home/oracle/.bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db1
export ORACLE_SID=db1
export ORACLE_TERM=xterm
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export DISPLAY="127.0.0.1:0.0"
export LC_CTYPE=en_US.UTF-8
6.apt-get install make gcc g++ libc6-dev gnome xorg glibc-common gnome-libs libstdc++ libstdc++-devel
7.vim /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Taroon)
8.apt-get install unzip
unzip -x 10201_database_linux-32
mv database /u01/app/
chown -R oracle oinstall /u01/app/database
cp /u01/app/database/response/enterprise.rsp /u01/app/db1.rsp
vim /u01/app/db1.rsp
n_configurationOption=3
UNIX_GROUP_NAME="oinstall"
ORACLE_HOME="/opt/u01/app/oracle/product/10g"
ORACLE_HOME_NAME="OraDbHome1"
ORACLE_HOSTNAME="$hostname"
s_nameForDBAGrp="dba"
s_nameForOPERGrp="dba"
9.cd /u01app/database
ls
./runInstaller -silent -responsefile /u01/app/db1.rsp -ignoreSysPrereqs
10.cd /u01/app/oracle/admin/db1
touch adump bdump cdump dpdump udump
11.vim /u01/app/oracle/db1.sql
CREATE DATABASE db1
USER SYS IDENTIFIED BY sys
USER SYSTEM IDENTIFIED BY sys
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/db1/redo01.log') SIZE 50M,
        GROUP 2 ('/u01/app/oracle/oradata/db1/redo02.log') SIZE 50M,
        GROUP 3 ('/u01/app/oracle/oradata/db1/redo03.log') SIZE 50M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/app/oracle/oradata/db1/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/db1/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE usertbs DATAFILE '/u01/app/oracle/oradata/db1/usertbs.dbf' SIZE 10M  REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/db1/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/db1/undotbs01.dbf'
SIZE 20M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
12.vim $ORACLE_HOME/dbs/initdb1.ora
db_name=db1
shared_pool_size=120000000
undo_tablespace=undotbs
undo_management=AUTO
13. $ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapwdb1 password=123
14.sqlplus / as sysdba
@/u01/app/oracle/db1.sql
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
conn system/manage
@$ORACLE_HOME/sqlplus/admin/pupbld.sql