Oracle 11g Tips

Oracle Base 磁區最小容量

• 至少 7GB；否則無法完成安裝
• 建議 8GB+

Kernel Parameters

請參閱 Configure Kernel Parameters

Preinstalled RPMs

從 DVD 安裝

# From Oracle Linux 6 DVD
cd /media/cdrom/Server/Packages
rpm -Uvh binutils-2*x86_64*
rpm -Uvh glibc-2*x86_64* nss-softokn-freebl-3*x86_64*
rpm -Uvh glibc-2*i686* nss-softokn-freebl-3*i686*
rpm -Uvh compat-libstdc++-33*x86_64*
rpm -Uvh glibc-common-2*x86_64*
rpm -Uvh glibc-devel-2*x86_64*
rpm -Uvh glibc-devel-2*i686*
rpm -Uvh glibc-headers-2*x86_64*
rpm -Uvh elfutils-libelf-0*x86_64*
rpm -Uvh elfutils-libelf-devel-0*x86_64*
rpm -Uvh gcc-4*x86_64*
rpm -Uvh gcc-c++-4*x86_64*
rpm -Uvh ksh-*x86_64*
rpm -Uvh libaio-0*x86_64*
rpm -Uvh libaio-devel-0*x86_64*
rpm -Uvh libaio-0*i686*
rpm -Uvh libaio-devel-0*i686*
rpm -Uvh libgcc-4*x86_64*
rpm -Uvh libgcc-4*i686*
rpm -Uvh libstdc++-4*x86_64*
rpm -Uvh libstdc++-4*i686*
rpm -Uvh libstdc++-devel-4*x86_64*
rpm -Uvh make-3.81*x86_64*
rpm -Uvh numactl-devel-2*x86_64*
rpm -Uvh sysstat-9*x86_64*
rpm -Uvh compat-libstdc++-33*i686*
rpm -Uvh compat-libcap*
rpm -Uvh mksh*x86_64*
cd /
eject

注意： 11g 需要 pdksh 套件，不過 RedHat 6 已經移除此套件，改用  mksh 替代。

雖然安裝了替代套件，Oracle 安裝程序仍會顯示 WARNING

Package: pdksh-5.2.14    Warning

請選擇忽略這項，以繼續安裝。

其他設定

/etc/security/limits.conf

## for Oracle DB 11g
oracle              soft    nproc   16384
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240

/home/oracle/.bash_profile

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/opt/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.4/db_1; export ORACLE_HOME
ORACLE_SID=hcpprod; export ORACLE_SID

PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi

PS1=$'\\n$ [ $LOGNAME@\h:$PWD [SID:${ORACLE_SID:-"no sid"}] ]\\n$ ' ; export PS1

啟動安裝

NOTE: 不用手動修改 /etc/redhat-release。

su - oracle
cd /<Oracle-Install-Source>/database
./runInstaller

Configure Security Updates

• Email: <BLANK>
• I wish to receive security updates via My Oracle Support: <Un-Check>

Do you wish to remain uninformed of critical security issues in your configuration? Yes

Download Software Updates

• Skip software updates

Select Installation Option

• Install database software only

Grid Installation Options

• Single instance database installation

Select Product Languages

• English

Select Database Edition

• Enterprise / Standard

Specify Installation Location

• Oracle Base: /opt/oracle
• Software Location: /opt/oracle/product/11.2.4/db_1

Create Inventory

• Inventory Directory: /opt/oracle/oraInventory        (注意:預設是 /opt/oraInventory)
• oraInventory Group Name: dba

Privileged Operating System Groups

• Database Administrator: dba
• Database Operator: <BLANK>

Prerequisite Checks

• Package: pdksh-5.2.14 Missing    (勾選右上角 Ignore All)