oracle11.2.0.4在centos6.0上安装

oracle11.2.0.4安装前系统参数配置.sql

oracle11.2.0.4在centos6.0上安装相关脚本.sql

一． 系统分区

/boot  200MB

/SWAP  内存的2倍（6000MB）

/       其它所有

需要的软件包:

pdksh-5.2.14-37.el5_8.1.x86_64.rpm

安装pdksh包(该程序包未被纳入CentOS的安装盘中)：

使用命令：wget ftp://rpmfind.net/linux/centos/5.9/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm 将pdksh程序包下载到本地

wget ftp://rpmfind.net/linux/centos/5.9/os/x86/CentOS/pdksh-5.2.14-37.el5_8.1.x86.rpm

[root@demo /]# rpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm 

二． 检查网络配置及YUM源

[root@platformdb01 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0 

DEVICE="eth0"

HWADDR="08:00:27:46:DE:B5"

NM_CONTROLLED="yes"

ONBOOT="yes"

BOOTPROTO=static

IPADDR=192.168.56.11

NETMASK=255.255.255.0

GATEWAY=192.168.56.1

DNS1=8.8.8.8

--=======================

DEVICE="eth1"

HWADDR="08:00:27:46:DE:B5"

NM_CONTROLLED="yes"

ONBOOT="yes"

BOOTPROTO=static

IPADDR=192.168.9.11

NETMASK=255.255.252.0

GATEWAY=192.168.10.253

DNS1=8.8.8.8

DNS1=8.8.8.8

[root@platformdb01 ~]# cat /etc/resolv.conf

# Generated by NetworkManager

nameserver 172.18.3.1

[root@platformdb01 ~]# cd /etc/yum.repos.d

[root@platformdb01 yum.repos.d]# ll

总用量 12

-rw-r--r--. 1 root root 1926 7月   3 2011 CentOS-Base.repo

-rw-r--r--. 1 root root  637 7月   3 2011 CentOS-Debuginfo.repo

-rw-r--r--. 1 root root  626 7月   3 2011 CentOS-Media.repo

修改计算机名:

Vi /etc/sysconfig/network中hostname改为，然后重启服务器

--配置YUM源

四，安装步骤

1.

yum install –y binutils* compat-libstdc++*    gcc*  ksh* libaio* libgcc*  libstdc++  make*  numactl-devel* sysstat*   libaio-devel*  unixODBC-devel*

yum install elfutils-libelf-devel

yum install glibc-utils*

--==========================执行下面这个，会提示有包没有找到

yum install elfutils-libelf*

yum install unixODBC*

elfutils-libelf-devel-static-0.148-1.el6.x86_64   --没有

unixODBC-kde-2.2.14-11.el6.x86_64   -- 没有

glibc-static-2.12-1.7.el6.x86_64   --这个包也没有

最后发现：这几个包不要没事的，不影响DB安装的

[root@CAH_Database3 U03]# rpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm 

warning: pdksh-5.2.14-37.el5_8.1.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID e8562897: NOKEY

error: Failed dependencies:

pdksh conflicts with ksh-20120801-28.el6_7.3.x86_64

[root@CAH_Database3 U03]# rpm -qa | grep ksh

ksh-20120801-28.el6_7.3.x86_64

[root@CAH_Database3 U03]# rpm -e ksh-20120801-28.el6_7.3.x86_64

查询rpm –qa | grep lib

2.创建ORCLE用户

[root@platformdb01 ~]# groupadd oinstall

[root@platformdb01 ~]# groupadd dba

[root@platformdb01 ~]# useradd -g oinstall -G dba oracle

[root@platformdb01 ~]# passwd oracle

3.修改sysctl.conf(路径：/etc/sysctl.conf)

#for oracle

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

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

[root@platformdb01 ~]# sysctl -p

Setting Kernel Parameters...

kernel.shmmax = 536870912

kernel.shmmax = 1052530688   --right

4.资源限制

[root@platformdb01 ~]# vi /etc/security/limits.conf

#for oracle

oracle           soft    nproc   2047

oracle           hard    nproc   16384

oracle           soft    nofile  1024

oracle           hard    nofile  65536

oracle           hard    stack   10240

6.创建ORCLCE相关目录

[root@platformdb01 u01]# mkdir -p  /u01/oracle/oracle11g

[root@platformdb01 u01]# chown -R oracle:oinstall  /u01

[root@platformdb01 u01]# chmod -R 775  /u01

7.设置环境变量

[root@platformdb01 ~]# su - oracle

[oracle@platformdb01 ~]$ vi .bash_profile

# for oracle

ORACLE_BASE=/u01/oracle

ORACLE_HOME=$ORACLE_BASE/oracle11g

ORACLE_SID=dcms

PATH=$ORACLE_HOME/bin:$PATH

NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"

NLS_LANG=American_america.AL32UTF8

#NLS_LANG="American_America".ZHS16GBK

EDITOR=vi

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH NLS_DATE_FORMAT NLS_LANG EDITOR

source .bash_profile

8.解压数据库

mkdir /sf

chown -R oracle:oinstall /sf

Cd /u01

[oracle@platformdb01 ~]$ unzip linux.x64_11gR2_database_1of2.zip

[oracle@platformdb01 ~]$ unzip linux.x64_11gR2_database_2of2.zip

xhost +

9.用Xmanager进行安装

export DISPLAY=192.168.9.177:0.0

export LANG=en_us

[root@demo ~]# su - oracle

[oracle@demo ~]$ export DISPLAY=192.168.9.177:0.0

[oracle@demo ~]$ xclock

Warning: Missing charsets in String to FontSet conversion

--看看能不能调出图形化界面

./runInstaller进行安装

6.归档与rman恢复目录路径的设置

SQL> alter system set log_archive_dest_1='location=/rman/arch/';

shutdown immediate;

startup mount; (在mount状态下进行归档设置)

alter database archivelog;

alter database open;

alter system switch logfile;

alter system archive log current;

---下面是安装过程中遇到的问题:

[oracle@demo database]$ ./runInstaller 

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 30493 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 4095 MB    Passed

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-05-05_03-37-00AM. Please wait ...[oracle@demo database]$ #

# An unexpected error has been detected by HotSpot Virtual Machine:

#

#  SIGSEGV (0xb) at pc=0x00007f1ad1a84da0, pid=2384, tid=139752489056016

#

# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_51-b10 mixed mode)

# Problematic frame:

# C  [ld-linux-x86-64.so.2+0x14da0]

#

# An error report file with more information is saved as hs_err_pid2384.log

#

# If you would like to submit a bug report, please visit:

#   http://java.sun.com/webapps/bugreport/crash.jsp

解决方法如下：在运行runInstaller之前，先设定如下的环境变量。

$ export LD_BIND_NOW=1

这个环境变量的作用是，让连接器在程序执行前把所有的函数地址都连接好。

这个原因看起来好像和安装Oracle没什么关系，但是，确实能解决问题。

解决方法如下：在运行runInstaller之前，先设定如下的环境变量。