opensuse11oracle11g,Suse11 Oracle11g

linux-udly:~ #  rpm -qa | grep binutils

binutils-2.20.0-0.7.9

linux-udly:~ #  rpm -qa | grep gcc

gcc-4.3-62.198

gcc43-c++-4.3.4_20091019-0.7.35

linux-udly:~ #  rpm -qa | grep glibc

glibc-2.11.1-0.17.4

linux-udly:~ #  rpm -qa | grep libaio

libaio-0.3.109-0.1.46

libaio-devel-0.3.109-0.1.46

linux-udly:~ #  rpm -qa | grep libgcc

libgcc43-4.3.4_20091019-0.7.35

linux-udly:~ #  rpm -qa | grep libstdc

libstdc++-devel-4.3-62.198

libstdc++43-4.3.4_20091019-0.7.35

libstdc++43-32bit-4.3.4_20091019-0.7.35

libstdc++43-devel-4.3.4_20091019-0.7.35

libstdc++43-devel-32bit-4.3.4_20091019-0.7.35

linux-udly:~ #  rpm -qa | grep make

make-3.81-128.20

linux-udly:~ #  rpm -qa | grep sysstat

sysstat-8.1.5-7.9.56

创建用户组

groupadd oinstall

groupadd dba

创建oracle用户

mkdir /home/oracle

useradd -g oinstall -G dba -d /home/oracle oracle

passwd oracle

chown -R oracle:oinstall /home/oracle/

创建oracle数据库安装目录

mkdir -p /u01/app/oracle

chown -R oracle:oinstall /u01

切换用户：

设置环境变量：修改/home/oracle/.bash_profile文件,加入以下内容

export ORACLE_SID=shihfa

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

stty erase ^h

#alias sqlplus='rlwrap sqlplus'

#alias rman='rlwrap rman'

#alias vi=='vim'

vi /etc/sysctl.conf

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

fs.file-max = 6815744

net.ipv4.ip_local_port_range = 9000 65500

net.core.wmem_max = 1048576

fs.aio-max-nr = 1048576

vi /etc/security/limits.conf

oracle           soft    nproc           2047

oracle           hard    nproc           16384

oracle           soft    nofile          1024

oracle           hard    nofile          65536

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

fi

###配置本地源

suse:/mnt/suse/suse/x86_64 # zypper ar   file:///mnt/suse/suse/x86_64 local-sles

Adding repository 'local-sles' [done]

Repository 'local-sles' successfully added

Enabled: Yes

Autorefresh: No

GPG check: Yes

URI: file:/mnt/suse/suse/x86_64

suse:/mnt/suse/suse/x86_64 # zypper ar   file:///mnt/suse/suse/x86_64 local-sles

suse:/mnt/suse/suse/x86_64 # zypper lr

# | Alias                                            | Name                                             | Enabled | Refresh

--+--------------------------------------------------+--------------------------------------------------+---------+--------

1 | SUSE-Linux-Enterprise-Server-11-SP3 11.3.3-1.138 | SUSE-Linux-Enterprise-Server-11-SP3 11.3.3-1.138 | Yes     | No

2 | local-sles                                       | local-sles                                       | Yes     | No

zypper install gcc-4.3-62.198.x86_64.rpm

zypper install gcc-c++-4.3-62.198.x86_64.rpm

zypper install glibc-devel-2.11.3-17.54.1.x86_64.rpm

zypper install libaio-devel-0.3.109-0.1.46.x86_64.rpm

zypper install libstdc++43-devel-4.3.4_20091019-0.37.30.x86_64.rpm

zypper install libstdc++-devel-4.3-62.198.x86_64.rpm

zypper install sysstat-8.1.5-7.45.24.x86_64.rpm

备注：

zypper ar sa  file:///mnt/suse/suse/x86_64 local-sles        --添加源

zypper lr                                                    --列出源

zypper rr                                                    --删除源