1. 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 =
fs.file-max =
kernel.shmmni =
kernel.sem =
net.ipv4.ip_local_port_range =
net.core.rmem_default =
net.core.rmem_max =
net.core.wmem_default =
net.core.wmem_max =

  注意上述参数中,需要根据实际情况修改 kernel.shmmax 参数的值,可以直接设置为物理内存大小。
  执行命令使之生效:

# /sbin/sysctl -p

1.5 设置 Shell对Oracle用户的限制

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

oracle      soft  nproc
oracle hard nproc
oracle soft nofile
oracle hard nofile

  接着,修改 /etc/pam.d/login,在文件最后添加如下内容:

session required /lib64/security/pam_limits.so

  最后,修改 /etc/profile,在文件最后添加如下内容

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p
ulimit -n
else
ulimit -u -n
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 /u01/

  配置 oracle 用户的环境变量

export ORACLE_BASE=/u01/app
export ORACLE_HOME=$ORACLE_BASE/oracle
export ORACLE_SID=orcl
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.
compat-libstdc++--3.2.
compat-libcap1
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
elfutils-libelf-devel-static-0.125
gcc-4.1.
gcc-c++-4.1.
glibc-2.5-
glibc-common-2.5
glibc-devel-2.5
glibc-headers-2.5
kernel-headers-2.6.
ksh-
libaio-0.3.
libaio-devel-0.3.
libgcc-4.1.
libgomp-4.1.
libstdc++-4.1.
libstdc++-devel-4.1.
make-3.81
sysstat-7.0.
unixODBC-2.2.
unixODBC-devel-2.2.

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

rpm -q binutils compat-libstdc++- 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++- 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=
Enable=true
[gui]
[greeter]
[chooser]
[debug]

2.3 启动xshell工具

1. Oracle安装部署文档

三. 安装Oracle数据库图解

3.1 安装 Oracle 软件

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

./runInstaller

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

1. Oracle安装部署文档

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

1. Oracle安装部署文档

  选择只安装数据库软件

1. Oracle安装部署文档

  选择单实例安装

1. Oracle安装部署文档

  选择Languages

1. Oracle安装部署文档

  选择"Enterprise Edition"

1. Oracle安装部署文档

  选择oracle软件安装路径

1. Oracle安装部署文档

  安装前环境监测

1. Oracle安装部署文档

  安装Oracle软件

1. Oracle安装部署文档

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

1. Oracle安装部署文档

3.2 配置Oracle数据库

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

dbca

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

1. Oracle安装部署文档

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

1. Oracle安装部署文档

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

1. Oracle安装部署文档

1. Oracle安装部署文档

1. Oracle安装部署文档

1. Oracle安装部署文档

1. Oracle安装部署文档

1. Oracle安装部署文档

1. Oracle安装部署文档

1. Oracle安装部署文档

1. Oracle安装部署文档

  经过漫长的等待;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 = )(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

  在客户端的 $ORACLE_HOME/network/admin/ 目录下;配置如下:

T235=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.235)(PORT = ))
(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. - Production on -AUG- ::

Copyright (c) , , 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 = )) (CONNECT_DATA = (SID = ora235)) (HS = OK))
OK ( msec)

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

五. Oracle开机自启动

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

5.1 修改Oracle系统配置文件

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

$ORACLE_SID:$ORACLE_HOME:<N|Y>:
ora235:/u01/app/oracle:Y

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

#!/bin/bash
#chkconfig:
#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')
$ stop
$ start
;;
esac

5.3 添加服务

# chmod  /etc/init.d/oracle
# chkconfig --level 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.

  本课程总共有 12 课;是给公司员工培训所编辑。未完待续...

上一篇:Nagios check_logfiles插件的使用记录


下一篇:“全栈2019”Java多线程第三十二章:显式锁Lock等待唤醒机制详解