Oracle 11g Tips

教學連結

• Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6

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

啟動安裝

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>