第一章 Oracle安装部署

一.部署环境步骤

1.1软件环境

操作系统：CentOS release 6.5

oracle安装包：linux.x64_11gR2_database_1of1.zip；linux.x64_11gR2_database_1of2.zip

1.2 配置主机名

# vim /etc/sysconfig/network HOSTNAME= oracle235 # 或者执行 hostname oracle235

1.3 配置网络

# vim /etc/hosts 192.168.1.235 oracle235

1.4 配置系统内核参数

配置 /etc/sysctl.conf ：添加如下内容：

fs.aio-max-nr = 1048576 fs.file-max = 6815744 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

　　注意上述参数中，需要根据实际情况修改 kernel.shmmax 参数的值，可以直接设置为物理内存大小。

　　执行命令使之生效： 

# /sbin/sysctl -p

1.5 设置 Shell对Oracle用户的限制

配置 /etc/security/limits.conf 文件：增加如下内容

oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 2047 oracle hard nofile 65536

session required /lib64/security/pam_limits.so

　　最后，修改 /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

　　所有修改完毕，重启所有 Linux 系统

1.6 创建grid/Oracle用户和组

# /usr/sbin/groupadd oinstall # /usr/sbin/groupadd dba # /usr/sbin/groupadd oper # /usr/sbin/useradd -g oinstall -G dba,oper oracle # passwd oracle

　　创建 oracle 软件安装目录

# mkdir -p /u01/oraInventory # chown -R oracle:oinstall /u01/ # chmod -R 775 /u01/

　　配置 oracle 用户的环境变量

export ORACLE_BASE=/u01/app

export ORACLE_HOME=$ORACLE_BASE/oracle

export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

export NLS_LANG=AMERICAN_AMERICA.UTF8

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

alias sqlplus='rlwrap sqlplus'

1.7 安装 oracle 安装包的依赖

binutils-2.17.50.0.6 compat-libstdc++-33-3.2.3 compat-libcap1 elfutils-libelf-0.125 elfutils-libelf-devel-0.125 elfutils-libelf-devel-static-0.125 gcc-4.1.2 gcc-c++-4.1.2 glibc-2.5-24 glibc-common-2.5 glibc-devel-2.5 glibc-headers-2.5 kernel-headers-2.6.18 ksh-20060214 libaio-0.3.106 libaio-devel-0.3.106 libgcc-4.1.2 libgomp-4.1.2 libstdc++-4.1.2 libstdc++-devel-4.1.2 make-3.81 sysstat-7.0.2 unixODBC-2.2.11 unixODBC-devel-2.2.11

　　执行命令 查看是否遗漏包;

rpm -q binutils compat-libstdc++-33 compat-libcap1 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel

　　安装依赖包

yum install -y binutils compat-libstdc++-33 compat-libcap1 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel

二. 用xshell打开图形界面

　可以采用 VNC 或者 xshell 软件登录 linux 界面去安装 Oracle Grid Infrastructure 软件。本例采用 xshell 软件

2.1 安装与下载图形界面GNOME

yum groupinstall "Desktop"

yum groupinstall "X Window System"

2.2 修改 /etc/gdm/custom.conf

[daemon] [security] AllowRemoteRoot=true [xdmcp] Port=177 Enable=true [gui] [greeter] [chooser] [debug]

2.3 启动xshell工具

三. 安装Oracle数据库图解

3.1 安装 Oracle 软件

　　进入 linux 桌面；打开终端；用 oracle 用户登录。进入 oracle 安装包目录；执行命令

./runInstaller

　　下面是每一步都图解演示：点击 next 按钮

 

跳过软件更新；点击next按钮

选择只安装数据库软件

 选择单实例安装 

选择Languages

选择"Enterprise Edition"

　　选择oracle软件安装路径

 　安装前环境监测

 安装Oracle软件

 　接下来的时间慢慢等待 Oracle 软件安装；在安装过程中要用 root 用户执行两个脚本；如下截图

3.2 配置Oracle数据库

Oracle服务器软件已经安装完成；接下来需要配置Oracle数据库；在终端下执行命令

dbca

执行dbca之后；会弹出数据库配置助手；如下图所示：

 　跳过软件更新；点击 next 按钮

选择定制；可以根据业务定制

 

填写实例名称，这里写ora235

经过漫长的等待；Oracle安装就完成 

 四. Oracle网络配置

数据库启动之后，要想提供对外服务。还需要配置 Oracle 的监听器配置文件 listener.ora（可以使用 netca 命令创建）；而远程客户端则需要配置 tnsnames.ora 文件。与服务器建立网络连接。

4.1 服务器监听文件 listener.ora

　　我们先看下数据库SID和SERVICE_NAME。 

SQL> show parameter instance_name; NAME TYPE VALUE -------------- --------- --------------- service_names string ora235 SQL> alter system set service_names='lottu' scope=both; System altered. SQL> show parameter service_name; NAME TYPE VALUE -------------- --------- --------------- service_names string lottu

　　一般 Oracle 的实例名跟 SERVICE_NAME 是一致的

　　在目录 $ORACLE_HOME/network/admin/ 目录下；配置监听文件 listener.ora

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.235)(PORT = 1521)(IP = FIRST))) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ora235) (GLOBAL_DBNAME = lottu) (ORACLE_HOME =/u01/app/oracle) ) )

　　再启动监听

lsnrctl start

4.2 客户端网络服务文件 tnsnames.ora

T235= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.235)(PORT = 1521)) (CONNECT_DATA = (SID = ora235) ) (HS = OK) ) # 或者用 (SERVICE_NAME = lottu) 替换 (SID = ora235)

　　测试是否配置OK？

[oracle@oracle235 admin]$ tnsping T235 TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 03-AUG-2018 23:48:59 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.235)(PORT = 1521)) (CONNECT_DATA = (SID = ora235)) (HS = OK)) OK (0 msec)

这样就可以通过客户端连接 Oracle 服务器。

五. Oracle开机自启动

　　默认 Oracle 数据库是不会随着机器重启或者开机启动 Oracle 服务。

5.1 修改Oracle系统配置文件

　　用 root 用户修改文件 /etc/oratab ；将 N 改成 Y；本例如下

$ORACLE_SID:$ORACLE_HOME:: ora235:/u01/app/oracle:Y

5.2 在 /etc/init.d/ 下创建文件oracle

#!/bin/bash #chkconfig:345 61 61

#description:oracle

#

# Set ORA_HOME to be equivalent to the $ORACLE_HOME

# from which you wish to execute dbstart and dbshut;

#

# Set ORA_OWNER to the user id of the owner of the

# Oracle database in ORA_HOME.

ORA_HOME=/u01/app/oracle

ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]

then

echo "Oracle startup: cannot start"

exit

fi

case "$1" in 'start')

# Start the Oracle databases:

echo "Starting Oracle Databases ... "

echo "-------------------------------------------------" >> /var/log/oracle date +" %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle

echo "-------------------------------------------------" >> /var/log/oracle su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart" >>/var/log/oracle echo "Done" # Start the Listener:

echo "Starting Oracle Listeners ... "

echo "-------------------------------------------------" >> /var/log/oracle date +" %T %a %D : Starting Oracle Listeners as part of system up." >> /var/log/oracle

echo "-------------------------------------------------" >> /var/log/oracle su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" >>/var/log/oracle echo "Done."

echo "-------------------------------------------------" >> /var/log/oracle date +" %T %a %D : Finished." >> /var/log/oracle echo "-------------------------------------------------" >> /var/log/oracle touch /var/lock/subsys/oracle ;; 'stop') # Stop the Oracle Listener:

echo "Stoping Oracle Listeners ... "

echo "-------------------------------------------------" >> /var/log/oracle date +" %T %a %D : Stoping Oracle Listener as part of system down." >> /var/log/oracle echo "-------------------------------------------------" >> /var/log/oracle su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop" >>/var/log/oracle echo "Done."

rm -f /var/lock/subsys/oracle # Stop the Oracle Database:

echo "Stoping Oracle Databases ... "

echo "-------------------------------------------------" >> /var/log/oracle date +" %T %a %D : Stoping Oracle Databases as part of system down." >> /var/log/oracle

echo "-------------------------------------------------" >> /var/log/oracle su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut" >>/var/log/oracle

echo "Done."

echo "" echo "-------------------------------------------------" >> /var/log/oracle date +" %T %a %D : Finished." >> /var/log/oracle

echo "-------------------------------------------------" >> /var/log/oracle ;; 'restart')

$0 stop

$0 start

;;

esac

5.3 添加服务

# chmod 755 /etc/init.d/oracle

# chkconfig --level 35 oracle on

# ln -s /etc/init.d/oracle /etc/rc0.d/K01oracle

# ln -s /etc/init.d/oracle /etc/rc6.d/K01oracle

5.4 测试启动和关闭 Oracle

[root@oracle235 ~]# service oracle stop

Stoping Oracle Listeners ...

Done.

Stoping Oracle Databases ...

Done.

[root@oracle235 ~]# service oracle start

Starting Oracle Databases ...

Done Starting Oracle Listeners ...

Done.