redhat5.8安装oracle11g---1

安装rehat5.8在安装的时候安装必须的软件

安装完成后进入rehat系统

chkconfig sendmail off 执行命令来优化rehat5,8的开机速度

vi /etc/hosts

 

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1       localhost.localdomain localhost

::1             localhost6.localdomain6 localhost6

x.x.x.x    *** x.x.x.x 这个是你redhat系统的ip地址，**这个是你的redhat的主机名称

:wq 退出保存

rpm -qa | grep ssh  查看ssh有没有安装

 

 

Free 运行此命令查看

             total       used       free     shared    buffers     cached

Mem:       2054408    1631284     423124          0     163088    1154996

-/+ buffers/cache:     313200    1741208

Swap:      4192924          0    4192924

vi /etc/fstab    编辑添加

LABEL=/                 /                       ext3    defaults        1 1

LABEL=/u01              /u01                    ext3    defaults        1 2

LABEL=/tmp              /tmp                    ext3    defaults        1 2

LABEL=/boot             /boot                   ext3    defaults        1 2

tmpfs                   /dev/shm                tmpfs   defaults        0 0

devpts                  /dev/pts                devpts  gid=5,mode=620  0 0

sysfs                   /sys                    sysfs   defaults        0 0

proc                    /proc                   proc    defaults        0 0

LABEL=SWAP-sda                    swap    defaults        0 0

shmfs                   /dev/shm tmpfs size=10g 0  在最下面添加这个

df -h /dev/shm

Filesystem            Size  Used Avail Use% Mounted on

tmpfs                1004M     0 1004M   0% /dev/shm

uname -m

x86_64  查看系统的版本

df -h /tmp

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda3             3.9G   73M  3.7G   2% /tmp

查看这些软件有没有安装，如果没有安装的必须安装

rpm -qa | grep binutils

binutils220-2.20.51.0.2-5.29.el5

binutils-2.17.50.0.6-20.el5

rpm -qa | grep compat-libstdc

compat-libstdc++-33-3.2.3-61

compat-libstdc++-296-2.96-138

compat-libstdc++-33-3.2.3-61

rpm -qa | grep elfutils

elfutils-libs-0.137-3.el5

elfutils-libelf-0.137-3.el5

elfutils-libelf-devel-0.137-3.el5

elfutils-libelf-devel-static-0.137-3.el5

elfutils-0.137-3.el5

elfutils-libelf-0.137-3.el5

rpm -qa | grep gcc

gcc44-c++-4.4.6-3.el5.1

compat-libgcc-296-2.96-138

gcc-gfortran-4.1.2-52.el5

gcc44-4.4.6-3.el5.1

libgcc-4.1.2-52.el5

compat-gcc-34-3.4.6-4.1

compat-gcc-34-g77-3.4.6-4.1

gcc-4.1.2-52.el5

gcc-gnat-4.1.2-52.el5

libgcc-4.1.2-52.el5

gcc44-gfortran-4.4.6-3.el5.1

gcc-c++-4.1.2-52.el5

compat-gcc-34-c++-3.4.6-4.1

gcc-java-4.1.2-52.el5

gcc-objc-4.1.2-52.el5

rpm -qa | grep gcc-c++

gcc-c++-4.1.2-52.el5

rpm -qa | grep glibc

compat-glibc-headers-2.3.4-2.26

glibc-2.5-81

compat-glibc-2.3.4-2.26

compat-glibc-2.3.4-2.26

glibc-headers-2.5-81

glibc-2.5-81

glibc-devel-2.5-81

glibc-common-2.5-81

glibc-devel-2.5-81

rpm -qa | grep ksh

ksh-20100621-5.el5

rpm -qa | grep libaio

rpm -qa | grep libaio-devel （这边包默认是没有安装的）

mkdir /disk

chmod -R 777 /disk

cd /disk/（在光盘里找到libaio-devel-0.3.106-5.i386.rpm  libaio-devel-0.3.106-5.x86_64.rpm这两个安装包后拷贝到这个目录下然后执行下面的安装命令）

rpm -ivh *

rpm -qa | grep libaio-devel

rpm -qa | grep unixODBC

mount /dev/cdrom /mnt （挂载光盘）

修改yum源

cd /etc/yum.repos.d/

cp rhel-debuginfo.repo rhel-debuginfo.repo.bak

vim rhel-debuginfo.repo

[rhel-debuginfo]

name=Red Hat Enterprise Linux $releasever - $basearch - Debug

baseurl=file:///mnt/Server （指定yum源）

enabled=1（启用yum）

gpgcheck=0（禁用效验）

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release

yum list （测试）

yum -y install unixODBC

rpm -qa | grep unixODBC

unixODBC-2.2.11-10.el5

unixODBC-libs-2.2.11-10.el5

unixODBC-libs-2.2.11-10.el5

unixODBC-2.2.11-10.el5

还差unixODBC-devel-2.2.11 or later

yum -y install unixODBC-devel

rpm -qa | grep unixODBC

unixODBC-2.2.11-10.el5

unixODBC-libs-2.2.11-10.el5

unixODBC-devel-2.2.11-10.el5

unixODBC-libs-2.2.11-10.el5

unixODBC-devel-2.2.11-10.el5

unixODBC-2.2.11-10.el5

rpm -qa | grep sysstat

建立组和用户

/usr/sbin/groupadd oinstall

/usr/sbin/groupadd  -g  502  dba

/usr/sbin/groupadd  -g  503  oper

/usr/sbin/groupadd  -g  504  asmadmin

/usr/sbin/groupadd  -g  505  asmdba

/usr/sbin/groupadd  -g  506  asmoper

 

 

/usr/sbin/useradd -u 502 -g oinstall -G dba,oper,asmdba oracle  创建oracle用户

Passwd  oracle   设置密码 oracle

 

/usr/sbin/useradd  -u  503  -g oinstall -G asmadmin,asmdba,asmoper,dba grid  创建grid用户

Passwd grid   设置密码grid

检查账号

[root@tmy ~]# id oracle

uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),505(asmdba)

配置内核参数

vim /etc/security/limits.conf

#for oracle

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

 

#for grid

grid soft nproc 2047

grid hard nproc 16384

grid soft nofile 1024

grid hard nofile 65536

grid soft stack 10240

vim /etc/sysctl.conf    修改系统参数

#fpr prac;e spfte

fs.aio-max-nr = 1048576

fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 4294967295

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_ramge = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

 

/sbin/sysctl -p    改完后生效

more /etc/oratab   检查服务器上有没有安装oracle软件

/etc/oratba: No such file or directory

 

mkdir -p /u01/app/oracle

mkdir -p /u01/app/grid

chown -R grid:oinstall /u01

chown -R oracle:oinstall /u01/app/oracle

chmod -R 775 /u01

 

检查

ll -d /u01/app/grid

drwxrwxr-x 2 grid oinstall 4096 Sep  3 05:59 /u01/app/grid

ll -d /u01/app/oracle

drwxrwxr-x 2 oracle oinstall 4096 Sep  3 05:59 /u01/app/oracle

 

配置用户的环境变量

2个用户oracle grid 都要配置环境变量

cd /home/oracle

vim .bash_profile

加入

export ORACLE_BASE=/u01/app/oracle

export ORACLE_SID=orcl    (实例命名)

export ORACLE_HOME=$ORACLE=BASE/product/11.10/dbhome_1

 

 

cd /home/grid

 

vim .bash_profile

 

加入

export ORACLE_BASE=/u01/app/grid

export ORACLE_SID=+ASM    (实例命名)

export ORACLE_HOME=$ORACLE=BASE/product/11.2.0/grid

 

 

grep MemTotal /proc/meminfo    检查内存

MemTotal:      2054408 kB

grep SwapTotal /proc/meminfo  检查SWAP

SwapTotal:     4192924 kB

 

 

df -hT 检查u01目录

Filesystem    Type    Size  Used Avail Use% Mounted on

/dev/sda2     ext3     15G  4.1G  9.5G  30% /

/dev/sda6     ext3     27G  173M   25G   1% /u01

/dev/sda3     ext3    3.9G   73M  3.7G   2% /tmp

/dev/sda1     ext3     99M   12M   82M  13% /boot

tmpfs        tmpfs   1004M     0 1004M   0% /dev/shm

/dev/sr0   iso9660    3.9G  3.9G     0 100% /media/RHEL_5.8 x86_64 DVD

/dev/sr0   iso9660    3.9G  3.9G     0 100% /mnt

 

 

 

安装驱动包

oracleasm-2.6.18-308.el5-2.0.5-1.el5.x86_64.rpm

oracleasmlib-2.0.4-1.el5.x86_64.rpm

oracleasm-support-2.1.8-1.el5.x86_64.rpm

rpm -ivh *

查看安装的驱动包

[root@tmy disk]# rpm -qa | grep oracleasm

oracleasm-support-2.1.8-1.el5

oracleasm-2.6.18-308.el5-2.0.5-1.el5

oracleasmlib-2.0.4-1.el5

配置asm驱动

 

[root@tmy disk]# /etc/init.d/oracleasm configure

Configuring the Oracle ASM library driver.

 

This will configure the on-boot properties of the Oracle ASM library

driver.  The following questions will determine whether the driver is

loaded on boot and what permissions it will have.  The current values

will be shown in brackets ('[]').  Hitting <ENTER> without typing an

answer will keep that current value.  Ctrl-C will abort.

 

Default user to own the driver interface : grid                

Default group to own the driver interface : asmadmin

Start Oracle ASM library driver on boot (y/n) [y]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver:                     [  OK  ]

Scanning the system for Oracle ASMLib disks:[  OK  ]

 

 

检查asm有没有准备完毕

[root@tmy disk]# /etc/init.d/oracleasm status

Checking if ASM is loaded: yes

Checking if /dev/oracleasm is mounted: yes

接下来生效

 

[root@tmy disk]# mount

/dev/sda2 on / type ext3 (rw)

proc on /proc type proc (rw)

sysfs on /sys type sysfs (rw)

devpts on /dev/pts type devpts (rw,gid=5,mode=620)

/dev/sda6 on /u01 type ext3 (rw)

/dev/sda3 on /tmp type ext3 (rw)

/dev/sda1 on /boot type ext3 (rw)

tmpfs on /dev/shm type tmpfs (rw)

none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)

sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)

/dev/sr0 on /media/RHEL_5.8 x86_64 DVD type iso9660 (ro,nosuid,nodev,uid=0)

/dev/sr0 on /mnt type iso9660 (ro)

oracleasmfs on /dev/oracleasm type oracleasmfs (rw)