11.2.0.4的安装与配置 (RHEL 6.5)(4)

mount -t iso9660 -o loop /soft/rhel-server-6.5-x86_64-dvd.iso /media
2) 安装公司的yum服务器来配置yum源
 
执行 sh setup_yum.sh yum.99bill.com
对于linux 6.5的环境中pdksh的包在光盘镜像中是没有的是没有的，现提供提供一个该包的下载
 

7. 设置sysctl.conf参数
在sysctl.conf中添加以下配置
# vi /etc/sysctl.conf
kernel.shmmni = 4096
kernel.sem = 2048 65536 1024 256
fs.file-max = 6815744
fs.aio-max-nr = 1048576
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 = 1048576

使配置生效
# sysctl -p

8. 设置limits.conf
在limits.conf中添加以下配置
# vi /etc/security/limits.conf
oracle soft nproc 65536
oracle hard nproc 65536
oracle soft nofile 65536
oracle hard nofile 65536

9. 清空resolv.conf
在生产环境中，不建议使用resolve.conf解析域名，可能会使客户端登录缓慢，建议清空它
# vi /etc/resolv.conf
清空

七、 安装ORACLE软件
进入oracle软件的安装目录
$ ./runInstaller
 去掉I wish to receive security updates via My Oracle Support的勾选
 Skip software updates
 Install database software only
 Single instance database installation
 Enterprise Edition
 Specify Installation Locaion
 Oracle Base /u01/app/oracle
 Software Location/u01/app/oracle/product/11.2.0/db
 Privileged Operating System Groups
 OSOPER Group选择 dba
 Perform Prerequistite Checks
 开始安装
 以root用户运行两个脚本：
 /u01/app/oraInventory/orainstRoot.sh
 /u01/app/oracle/product/11.2.0/db/root.sh

八、 实例的创建
$ dbca
 Global Database Namebdcadb.99bill.com
 SID Prefix bdcadb
 如果报scan listener没有运行，忽略
 Select All
 去掉Enterprise Manager
 Use Common Location for All Data File
 /u02/oradata
 去掉specify fash recovery area
 Character Sets AL32UTF8
 National Character Set UTF8
 其他默认，将来改

九、 Oracle DB的配置
以下为详细的DB配置，配置完成建议重启所有节点服务器，检查是否可以正常启动服务及让参数生效
因为是搭建的DG环境，所以主备库使用静态监听，配置如下
1. listener设置
bdcadb:
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bdcadb.99bill.com)(PORT = 1530))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1530))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC = 
    (GLOBAL_DBNAME = BDCADB.99BILL.COM)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db)
    (SID_NAME = bdcadb)
    )
    (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db)
      (PROGRAM=extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = bdcataf.99bill.com)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db)
    (SID_NAME = bdcadb)
    )
  )
ADR_BASE_LISTENER = /u01/app/oracle ;

bdcadg:
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bdcadg.99bill.com)(PORT = 1530))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1530))
    )
  )