oracle 11g(11.2.0.4) install on rhel 6

最新推荐文章于 2022-09-26 10:32:52 发布

weixin_34191734

最新推荐文章于 2022-09-26 10:32:52 发布

阅读量98

点赞数

文章标签：数据库操作系统 python

原文链接：https://my.oschina.net/rootliu/blog/1551603

版权

2019独角兽企业重金招聘Python工程师标准>>>

oracle 11g(11.2.0.4) install on rhel 6

听语音

|
浏览：1902
|
更新：2014-10-31 10:21

分步阅读

oracle 11g 安装高版本可以直接安装，无需升级安装。

安装思路：

1：安装rhel 6时需要做的设置

2：设置主机名

3：编辑/etc/hosts 文件

4：设置内核参数

5：安装oracle 11g 所需安装的rpm包

6：创建oracle用户

7：创建安装目录

8：关闭防火墙

9：安装oracle 11.2.0.4 软件

10：编辑oracle环境

11：dbca 建库

12：netca 创建监听

注意：安装推荐工具使用 xmanager

方法/步骤

1

安装rhel 6时需要做的设置

1：swap 最小2G

2：secure Linux disabled（/etc/selinux/config文件SELINUX=permissive）

3：选择的安装包：

Base System ----> Base

Base System ----> Client management tools

Base System ----> Compatibility libraries

Base System ----> Hardware monitoring utilities

Base System ----> Large Systems Performance

Base System ----> Network file system client

Base System ----> Performance Tools

Base System ----> Perl Support

Servers ----> Server Platform

Servers ----> System administration tools

Desktops ----> Desktop

Desktops ----> Desktop Platform

Desktops ----> Fonts

Desktops ----> General Purpose Desktop

Desktops ----> Graphical Administration Tools

Desktops ----> Input Methods

Desktops ----> X Window System

Development ----> Additional Development

Development ----> Development Tools

Applications ----> Internet Browser
2

设置主机名

编辑/etc/sysconfig/network中的HOSTNAME

设置完成之后重启，永久生效
编辑/etc/hosts 文件

添加（ip 主机名）：

192.168.56.126 oracle11g

ip 如何快捷有效设置，参考我的经验：怎样设置虚拟机virtualbox 网关和linux ip
设置内核参数

1：编辑/etc/sysctl.conf

     添加：

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

#kernel.shmall = 2097152

#kernel.shmmax = 536870912

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

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

编辑完之后需要执行命令：/sbin/sysctl -p

2：编辑/etc/security/limits.conf

     添加：

oracle              soft    nproc   16384

oracle              hard    nproc   16384

oracle              soft    nofile 4096

oracle              hard    nofile 65536

oracle              soft    stack   10240

3：编辑/etc/pam.d/login

     添加

    session    required     pam_limits.so

4：编辑/etc/security/limits.d/90-nproc.conf

将

*          soft    nproc    1024

设置成

* - nproc 16384

5：编辑/etc/selinux/config

将SELINUX设置为permissive：SELINUX=permissive
安装oracle所需安装的rpm包

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*

注意：rhel 6 安装rpm包，可以参考我的经验：oracle rac 11g on rhel 6：[1]准备

32位rpm包可以不安装
创建oracle用户

groupadd -g 1000 oinstall

groupadd -g 1100 dba

useradd -m -g oinstall -G dba -u 1200 oracle

[root@oracle11g ~]# id oracle

uid=1200(oracle) gid=1000(oinstall) groups=1000(oinstall),1100(dba)

设置密码

[root@oracle11g ~]# passwd oracle
创建安装目录

[root@oracle11g ~]# mkdir -p /u01/app/oracle/product/11.2.0/db_1

[root@oracle11g ~]# chown -R oracle:oinstall /u01 权限赋予
关闭防火墙

[root@oracle11g oracle]# chkconfig --level 2345 ip6tables off 设置Linux级别中防火墙关闭

[root@oracle11g oracle]# chkconfig --level 2345 iptables off

[root@oracle11g oracle]# service ip6tables stop   设置当前Linux级别中防火墙关闭

[root@oracle11g oracle]# service iptables stop      查看

[root@oracle11g oracle]# chkconfig --list | grep ip

ip6tables            0:off 1:off 2:off 3:off 4:off 5:off 6:off

iptables             0:off 1:off 2:off 3:off 4:off 5:off 6:off

参考我的经验：oracle rac 11g on rhel 6：[1]准备
安装oracle 11.2.0.4 软件

[root@oracle11g oracle]# ll      上传后查看权限

total 2489640

-rw-r--r--. 1 root root 1395582860 Oct 29 08:31 p13390677_112040_Linux-x86-64_1of7.zip

-rw-r--r--. 1 root root 1151304589 Oct 29 08:31 p13390677_112040_Linux-x86-64_2of7.zip

[root@oracle11g oracle]# chown -R oracle:oinstall /zxx_software/oracle/ 设置权限

[root@oracle11g oracle]# pwd

/zxx_software/oracle

[root@oracle11g oracle]# ll

total 2489640

-rw-r--r--. 1 oracle oinstall 1395582860 Oct 29 08:31 p13390677_112040_Linux-x86-64_1of7.zip

-rw-r--r--. 1 oracle oinstall 1151304589 Oct 29 08:31 p13390677_112040_Linux-x86-64_2of7.zip

[root@oracle11g oracle]# su - oracle   切换到oracle 用户解压

[oracle@oracle11g ~]$ cd /zxx_software/oracle/

[oracle@oracle11g oracle]$ unzip p13390677_112040_Linux-x86-64_1of7.zip

[oracle@oracle11g oracle]$ unzip p13390677_112040_Linux-x86-64_2of7.zip

[oracle@oracle11g oracle]$ ll   解压之后

total 2489644

drwxr-xr-x. 7 oracle oinstall       4096 Aug 27 2013 database

-rw-r--r--. 1 oracle oinstall 1395582860 Oct 29 08:31 p13390677_112040_Linux-x86-64_1of7.zip

-rw-r--r--. 1 oracle oinstall 1151304589 Oct 29 08:31 p13390677_112040_Linux-x86-64_2of7.zip

[oracle@oracle11g database]$ ./runInstaller 安装

[root@oracle11g ~]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@oracle11g ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.
编辑oracle环境

[oracle@node1 ~]$ vi .bash_profile

export ORACLE_SID=test

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

if [ $USER = "oracle" ]; then

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

    ulimit -p 16384

    ulimit -n 65536

else

    ulimit -u 16384 -n 65536

fi

fi

[oracle@oracle11g ~]$ source .bash_profile   使环境生效

[oracle@oracle11g ~]$ echo $ORACLE_HOME 测试是否生效

/u01/app/oracle/product/11.2.0/db_1
dbca 建库

建库可参考我的经验：oracle 10g(10.2.0.4) install on rhel 5 中的 dbca建库
netca 创建监听

[oracle@oracle11g ~]$ netca

然后一直点击 next ,最后点击finish 即可

END