专栏首页从ORACLE起航,领略精彩的IT技术。Linux平台oracle 11g单实例 + ASM存储 安装部署

Linux平台oracle 11g单实例 + ASM存储 安装部署

操作环境:Citrix虚拟化环境中申请一个Linux6.4主机(模板) 目标:创建单机11g + ASM存储 数据库

1. 主机准备

IP地址:
主机名:JY-DB
目录:/u01
磁盘:从主机本地磁盘资源划分50G硬盘1个,从磁阵资源划分10G硬盘3个

1.1 检查主机名和IP地址的映射:hostname -i

hostname
vi /etc/sysconfig/network
vi /etc/hosts

1.2 分配/u01目录为oracle软件安装目录,lv_asm1,lv_asm2,lv_asm3为ASM磁盘

/dev/xvdb 50G 格式化后挂载到/u01目录

/dev/xvdc /dev/xvde /dev/xvdf 各10G,不用格式化,给ASM使用

pvcreate /dev/xvdc /dev/xvde /dev/xvdf
vgcreate ora_vg /dev/xvdc /dev/xvde /dev/xvdf
lvcreate -L 10g -n lv_asm1 ora_vg
lvcreate -L 10g -n lv_asm2 ora_vg
vgdisplay ora_vg
lvcreate -l 2557 -n lv_asm3 ora_vg

在后面创建grid用户后,创建ASM前,需要更改lv的磁盘权限

chown grid:asmadmin /dev/mapper/ora*

1.3 配置YUM,安装依赖包

yum配置参考:http://www.cnblogs.com/jyzhao/p/3938290.html

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

若之前安装系统没有安装图形,需要安装图形界面和xterm

yum groupinstall "X Window System"

yum install xterm

1.4 关闭系统防火墙开机启动

service iptables stop
chkconfig iptables off

2. 创建ORACLE 用户和组成员

groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin
groupadd asmdba
groupadd asmoper

useradd -g oinstall -G dba,asmdba,oper oracle
useradd -g oinstall -G dba,asmadmin,asmdba,asmoper grid

分别指定oracle、grid用户的密码

passwd oracle
passwd grid

3. 创建以下目录并赋予对应权限

mkdir -p /u01/app/11.2.0/grid
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01/app
chmod -R 775 /u01/app

4. 设置oracle、grid用户的环境变量

4.1 oracle用户登陆: vi ~/.bash_profile

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:.
export NLS_LANG=american_america.ZHS16GBK
export ORACLE_SID=jyzhao
export PATH=$PATH:$ORACLE_HOME/bin:.

4.2 grid用户登录:vi ~/.bash_profile

export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:.
export NLS_LANG=American_america.ZHS16GBK
export PATH=$PATH:$ORACLE_HOME/bin:.
export ORACLE_SID=+ASM

5. root用户更改系统参数

5.1 vi /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4398046511104 //一般设置为系统内存75%单位是字节
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

使设置立即生效: /sbin/sysctl -p

5.2 vi /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 1024

5.3 vi /etc/pam.d/login

#oracle
session required /lib64/security/pam_limits.so
session required pam_limits.so

6. 上传Oracle安装介质到/u01/tmp目录下

mkdir -p /u01/tmp

p13390677_112040_Linux-x86-64_1of7.zip
p13390677_112040_Linux-x86-64_2of7.zip
p13390677_112040_Linux-x86-64_3of7.zip

7. 安装grid组件

#cd /u01/tmp/
#unzip p10404530_112030_Linux-x86-64_3of7.zip
#chown -R grid:oinstall grid

Xmanager软件用grid用户登录
$cd /u01/tmp/grid
$./runInstaller

图形界面安装,最后root用户执行两个脚本,执行脚本的屏幕输出如下:

# /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.

# /u01/app/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid

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.

To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user:
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl

To configure Grid Infrastructure for a Cluster execute the following command:
/u01/app/11.2.0/grid/crs/config/config.sh

This command launches the Grid Infrastructure Configuration Wizard. The wizard also supports silent operation, and the parameters can be passed through the response file that is available in the installation media.

8. 根据上步执行的脚本输出提示,确定单节点需要root用户执行下面的命令

/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl

9. 使用asmca创建ASM 磁盘组

Xmanager软件用grid用户登录

$asmca

10. 安装oralce软件

#cd /u01/tmp/
#unzip p13390677_112040_Linux-x86-64_1of7.zip;unzip p13390677_112040_Linux-x86-64_2of7.zip
#chown -R oracle:oinstall database

Xmanager软件用oracle用户登录
$cd /u01/tmp/database/
$./runInstaller

图形界面安装,最后root用户执行一个脚本
#/u01/app/oracle/product/11.2.0/db_1/root.sh

11. 创建数据库

Xmanager软件用oracle用户登录

$dbca

图形界面建库,Storage Type选择ASM,+DATA1磁盘组,数据库字符集根据实际情况选择。

12. 使用grid用户创建监听

Xmanager软件用grid用户登录

$netca

13. 客户端测试数据库连接

ping IP地址
tnsping IP地址

sqlplus system/oracle@IP地址/jyzhao

14. 由于lv的权限在重启后会变回root用户,需要添加开机启动脚本

vi /etc/rc.d/rc.local
chown grid:asmadmin /dev/mapper/ora*

创建rc.local的链接文件

ln -sf /etc/rc.d/rc.local /etc/rc.d/rc1.d/S999rc.local &&
ln -sf /etc/rc.d/rc.local /etc/rc.d/rc2.d/S999rc.local &&
ln -sf /etc/rc.d/rc.local /etc/rc.d/rc3.d/S999rc.local &&
ln -sf /etc/rc.d/rc.local /etc/rc.d/rc4.d/S999rc.local &&
ln -sf /etc/rc.d/rc.local /etc/rc.d/rc5.d/S999rc.local &&
ln -sf /etc/rc.d/rc.local /etc/rc.d/rc6.d/S999rc.local

15. 重启测试

15.1 关闭数据库

# su - oracle
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 12 14:14:38 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

15.2 关闭has

$ su - grid
Password:
$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'jy-db'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'jy-db'
CRS-2673: Attempting to stop 'ora.DATA1.dg' on 'jy-db'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'jy-db' succeeded
CRS-2677: Stop of 'ora.DATA1.dg' on 'jy-db' succeeded
CRS-2679: Attempting to clean 'ora.DATA1.dg' on 'jy-db'
CRS-2681: Clean of 'ora.DATA1.dg' on 'jy-db' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'jy-db'
CRS-2677: Stop of 'ora.asm' on 'jy-db' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'jy-db'
CRS-2677: Stop of 'ora.cssd' on 'jy-db' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'jy-db'
CRS-2677: Stop of 'ora.evmd' on 'jy-db' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'jy-db' has completed
CRS-4133: Oracle High Availability Services has been stopped.

15.3 重启主机

# sync
# sync
# sync

# shutdown -Fr now

Broadcast message from root@JY-DB

        (/dev/pts/0) at 14:20 ...

The system is going down for reboot NOW!

15.4主机启动后,查看crs状态

# /u01/app/11.2.0/grid/bin/crsctl stat res -t

--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA1.dg
               ONLINE  ONLINE       jy-db                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       jy-db                                       
ora.asm
               ONLINE  ONLINE       jy-db                    Started            
ora.ons
               OFFLINE OFFLINE      jy-db                                        
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       jy-db                                        
ora.diskmon
      1        OFFLINE OFFLINE                                                  
ora.evmd
      1        ONLINE  ONLINE       jy-db                                       
ora.jyzhao.db
      1        OFFLINE OFFLINE                               Instance Shutdown  

15.5 启动数据库

# /u01/app/11.2.0/grid/bin/srvctl start database -d jyzhao

# /u01/app/11.2.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA1.dg
               ONLINE  ONLINE       jy-db                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       jy-db                                       
ora.asm
               ONLINE  ONLINE       jy-db                    Started            
ora.ons
               OFFLINE OFFLINE      jy-db                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       jy-db                                       
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       jy-db                                       
ora.jyzhao.db
      1        ONLINE  ONLINE       jy-db                    Open              

15.6 客户端测试

C:\Users\Alfred>sqlplus system/oracle@IP地址/jyzhao
SQL*Plus: Release 11.2.0.1.0 Production on 星期四 3月 12 14:27:12 2015
Copyright (c) 1982, 2010, Oracle.  All rights reserved.

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL>

至此,Linux平台oracle 11g单实例 + ASM存储 安装部署全部完成。

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

我来说两句

0 条评论
登录 后参与评论

相关文章

  • Oracle 11g RAC之HAIP相关问题总结

    环境:RHEL 6.4 + GI 11.2.0.4 + Oracle 11.2.0.4 对有关HAIP相关问题的总结,包括禁用/启用HAIP,修改ASM资源的依...

    Alfred Zhao
  • 记录一则xtts测试遇到的诡异现象

    背景:在一次xtts的测试中遇到因源库数据文件名称包含特殊字符导致表空间全量备份缺失文件,之所以说是诡异现象,是因为xtts的全备日志不报任何错误,在恢复阶段才...

    Alfred Zhao
  • 11gRAC报错CRS-4535, CRS-4000解决

    使用crsctl查看集群各资源状态,在任一节点都会直接报错CRS-4535, CRS-4000;但此时数据库是可以被正常访问的。 具体故障现象如下:

    Alfred Zhao
  • 真人照片太单调?这个小程序让你的头像脱颖而出

    知晓君
  • Js运动框架

    用户1749219
  • SQL Server 多表数据增量获取和发布 2.2

    数据库环境: 1、SQLServer 2008R2 2、SQLServer 代理打开

    小狐狸
  • SQLServer CDC数据迁移和数据抽取功能介绍 2

    数据库环境: 1、SQLServer 2008R2 2、SQLServer 代理打开

    小狐狸
  • Web正文字体发展简史

    当你正在纠结选择什么样的字体大小,尤其是在您尝试适应不同的屏幕和场景时。回顾一下网页字体发展的历史变化,或许会给你一个新的视角。

    ConardLi
  • [原创] 智慧树刷课js脚本

      最近博主选了两门智慧树的选修课,以前都是电脑安装安卓模拟器然后模拟器安装知到app 使用模拟器播放,挺麻烦的,今天在页面上随便点了下,突然发现智慧树的pc端...

    雨落凋殇
  • Java并发指南13:Java 中的 HashMap 和 ConcurrentHashMap 全解析

    本文是微信公众号【Java技术江湖】的《Java并发指南》其中一篇,本文大部分内容来源于网络,为了把本文主题讲得清晰透彻,也整合了很多我认为不错的技术博客内容,...

    Java技术江湖

扫码关注云+社区

领取腾讯云代金券