轉載請以超連結註明原文：http://xunzhaoxz.itpub.net/post/40016/520274

PDF下載http://www.itpub.net/thread-1454946-1-1.html

1. 環境說明

作業系統平臺：Redhat Linux 5.4

Oracle版本：Oracle 11gR2

資料儲存方式：檔案系統

主機名：ora11gR2

例項名：ora11gR2

[oracle@ora11g database]$ uname -a

Linux LinuxNBU65 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux

[oracle@ora11g database]$ cat /etc/redhat-release

Red Hat Enterprise Linux Server release 5.4 (Tikanga)

[oracle@ora11g database]$ lsb_release -a

LSB Version: :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch

Distributor ID: RedHatEnterpriseServer

Description: Red Hat Enterprise Linux Server release 5.4 (Tikanga)

Release: 5.4

Codename: Tikanga

[oracle@ora11g database]$ [@more@]

[oracle@ora11g database]$ uname -a

Linux LinuxNBU65 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux

[oracle@ora11g database]$ cat /etc/redhat-release

Red Hat Enterprise Linux Server release 5.4 (Tikanga)

[oracle@ora11g database]$ lsb_release -a

LSB Version: :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch

Distributor ID: RedHatEnterpriseServer

Description: Red Hat Enterprise Linux Server release 5.4 (Tikanga)

Release: 5.4

Codename: Tikanga

[oracle@ora11g database]$

檔案

# more /etc/hosts 根據實際環境新增相應主機、IP的對映

127.0.0.1 localhost

172.16.188.101 ora11gR2

The following or later versions of the operating systems are required for Oracle Database 11g Release 2 (11.2):

· On Linux x86:

o Asianux 2 Update 7

o Asianux 3

o Oracle Enterprise Linux 4 Update 7

o Oracle Enterprise Linux 5 Update 2

o Red Hat Enterprise Linux 4 Update 7

o Red Hat Enterprise Linux 5 Update 2

o SUSE Linux Enterprise Server 10 SP2

o SUSE Linux Enterprise Server 11

· On Linux x86-64

o Asianux 2

o Asianux 3

o Oracle Enterprise Linux 4 Update 7

o Oracle Enterprise Linux 5 Update 2

o Red Hat Enterprise Linux 4 Update 7

o Red Hat Enterprise Linux 5 Update 2

o SUSE Linux Enterprise Server 10 SP2

o SUSE Linux Enterprise Server 11

[root@ora11gR2 ~]# cat /proc/version

Linux version 2.6.18-164.el5 (mockbuild@x86-002.build.bos.redhat.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-46)) #1 SMP Tue Aug 18 15:51:54 EDT 2009

[root@ora11gR2 ~]#

[root@ora11gR2 ~]# lsb_release -id

Distributor ID: RedHatEnterpriseServer

Description: Red Hat Enterprise Linux Server release 5.4 (Tikanga)

[root@ora11gR2 ~]#

[root@ora11gR2 ~]# lsb_release -a

LSB Version: :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch

Distributor ID: RedHatEnterpriseServer

Description: Red Hat Enterprise Linux Server release 5.4 (Tikanga)

Release: 5.4

Codename: Tikanga

[root@ora11gR2 ~]#

[root@ora11gR2 ~]#

Requirements

On Asianux 3, Oracle Enterprise Linux 5, and Red Hat Enterprise Linux 5:

2.6.18 or later

[root@ora11gR2 ~]# uname -r

2.6.18-164.el5

[root@ora11gR2 ~]#

Requirements

Asianux 3, Oracle Enterprise Linux 5, and Red Hat Enterprise Linux 5 The following packages (or later versions) must be installed:

binutils-2.17.50.0.6

compat-libstdc++-33-3.2.3

elfutils-libelf-0.125

elfutils-libelf-devel-0.125

elfutils-libelf-devel-static-0.125

gcc-4.1.2

gcc-c++-4.1.2

glibc-2.5-24

glibc-common-2.5

glibc-devel-2.5

glibc-headers-2.5

kernel-headers-2.6.18

ksh-20060214

libaio-0.3.106

libaio-devel-0.3.106

libgcc-4.1.2

libgomp-4.1.2

libstdc++-4.1.2

libstdc++-devel-4.1.2

make-3.81

sysstat-7.0.2

unixODBC-2.2.11

unixODBC-devel-2.2.11

使用rpm –q命令檢查下系統是否已經安裝了以上軟體包，上傳並安裝缺失的軟體包

rpm -q binutils

rpm -q compat-libstdc++

rpm -q elfutils-libelf

rpm -q elfutils-libelf-devel

rpm -q elfutils-libelf-devel-static

rpm -q gcc

rpm -q gcc-c++

rpm -q glibc

rpm -q glibc-common

rpm -q glibc-devel

rpm -q glibc-headers

rpm -q kernel-headers

rpm -q ksh

rpm -q libaio

rpm -q libaio-devel

rpm -q libgcc

rpm -q libgomp

rpm -q libstdc++

rpm -q libstdc++-devel

rpm -q make

rpm -q sysstat

rpm -q unixODBC

rpm -q unixODBC-devel

簡化為一條命令：

rpm -q binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel|grep not

[root@ora11gR2 rpm]# rpm -e compat-libstdc++-296-2.96-138.i386

[root@ora11gR2 rpm]# rpm -ivh compat-libstdc++-7.3-2.96.128.i386.rpm

warning: compat-libstdc++-7.3-2.96.128.i386.rpm: Header V3 DSA signature: NOKEY, key ID 025e513b

Preparing... ########################################### [100%]

1:compat-libstdc++ ########################################### [100%]

[root@ora11gR2 rpm]#

[root@ora11gR2 rpm]# rpm -ivh libaio-devel-0.3.106-3.2.i386.rpm

warning: libaio-devel-0.3.106-3.2.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:libaio-devel ########################################### [100%]

[root@ora11gR2 rpm]#

[root@ora11gR2 rpm]# rpm -ivh unixODBC-2.2.11-7.1.i386.rpm unixODBC-devel-2.2.11-7.1.i386.rpm

warning: unixODBC-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:unixODBC ########################################### [ 50%]

2:unixODBC-devel ########################################### [100%]

[root@ora11gR2 rpm]#

[root@ ora11gR2 /]# groupadd -g 501 oinstall

[root@ ora11gR2 /]# groupadd -g 502 dba

[root@ ora11gR2 /]# groupadd -g 503 asmdba

[root@ora11g R2 /]# useradd -u 501 -g oinstall -G dba,asmdba oracle

[root@ora11g R2 /]# passwd oracle

使用文字編輯器將下面列出的行新增到/etc/security/limits.conf、/etc/pam.d/login 和 /etc/profile。

2.4.1. /etc/security/limits.conf

[root@ora11g ~]#vi /etc/security/limits.conf 新增以下內容

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

2.4.2. /

[root@ora11g ~]# vi /etc/pam.d/login 新增以下內容

session required pam_limits.so

2.4.3. /

[root@ora11g ~]#vi /etc/profile 新增以下內容

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

umask 022

fi

使用文字編輯器將下面列出的行新增到 /etc/sysctl.conf。要使更改立即生效，請執行sysctl –p。

[root@ora11g ~]#vi /etc/sysctl.conf 新增以下內容

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

使用者的配置檔案

[oracle@ora11g ~]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_SID=ora11gR2

export ORACLE_BASE=/oracle

export ORACLE_HOME=$ORACLE_BASE/app/oracle/product/11.2

export INVENTORY_LOCATION=/oraInventory

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export NLS_LANG="American_america.zhs16gbk"

#export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss';

export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin

umask 022

[oracle@ora11g ~]$

[root@ora11gR2 ~]# chown -R oracle:oinstall /oracle

[root@ora11gR2 ~]# chmod -R 775 /oracle

[oracle@ora11g ~]$mkdir /oraInventory

[oracle@ora11g ~]$mkdir -p $ORACLE_HOME

[oracle@ora11g ~]$ls -l /

[oracle@ora11g ~]$ls -l /oracle

[oracle@ora11g database]$./runInstaller

後面就是安裝軟體、DBCA建庫等，截圖較多，下載PDF版看吧，排版也會比這個好得多

PDF下載 http://www.itpub.net/viewthread.php?tid=1454946&page=1&extra=page%3D1

___________________________________________________________________

延伸閱讀(近期整理文件)：

主機AIX：

【資訊採集】IBM AIX系統硬體資訊檢視命令（shell指令碼）(附PDF完整版下載)

操作規範（一）—— AIX rootvg mirror(附PDF下載)

AIX系統安全加固（一）限制密碼重試次數，超過限制次數後鎖定使用者（附截圖PDF完整版下載）

AIX平臺下建立檔案系統需要注意的問題

IBM伺服器虛擬化PowerVM——也談“雲端計算”

資料庫Oracle：

新裝Oracle11gR2 11.2.0.2重要說明——Patchsetp10098816（附補丁下載地址）

Attention：new installation of Oracle 11.2.0.2

AIX 5.3/6.1環境下安裝Oracle10gR2 RAC常見報錯（注意事項）

【資料遷移1】Oracle10gR2 rman異機恢復實驗（FS->RAW）（附截圖PDF完整版下載）

【資料遷移2】Oracle10gR2 rman異機恢復實驗（FS-FS）（附截圖PDF完整版下載）

操作規範（二）——RHEL5.4安裝Oracle 10.2.0.4（附截圖PDF完整版下載）

操作規範（三）——Linux5.4安裝Oracle 11gR1（附截圖PDF完整版下載）

操作規範（四）——Linux5.4安裝Oracle 11gR2（附截圖PDF完整版下載）

Oracle RAC環境下重建ASM磁碟組(Re-createASM diskgroup)（附截圖PDF完整版下載）

Oracle RAC srv服務“首選”與“可用”狀態的調整——srvctl modify service 的使用（附截圖PDF完整版下載）

Linux+ASM+OCFS環境下增加ORACLE RAC聯機重做日誌檔案（附截圖PDF完整版下載）

備份還原Symantec Netbackup:

搭建NBU實驗環境——解決虛擬帶庫vistor License過期問題（附截圖PDF完整版下載）

NBU常用命令1——介質管理

--------------------------------------------------------------

親，留個腳印，發表下您的寶貴意見，或者點選左邊“訂閱我的Blog”吧.......