江苏龙网

  1. 主页 > 生活百科 > >

Oracle单机实例+ASM

Oracle

本环境centos7.4使用的主要软件包：
 

Oracle单机实例+ASM

文章插图
 

Oracle单机实例+ASM

文章插图
 
11.2.0.1版本
linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip
linux.x64_11gR2_grid.zip
需要额外一个磁盘做完ASM挂载磁盘：本实例使用50G
使用x-shell进行远程，通过Xmanager进行图形化显示(需关闭selinux)
 
一、环境准备1.创建ORACLE用户和组成员
groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin
groupadd asmdba
groupadd asmoper
useradd -g oinstall -G dba,asmdba,oper -d /home/oracle oracle (命令自动创建/home/oracle目录)
useradd -g oinstall -G dba,asmadmin,asmdba,asmoper -d /home/grid grid (命令自动创建/home/grid目录)
 
2.分别创建oracle、grid用户的密码
passwd oracle
new unix password: oracle
passwd grid
new unix password: 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
mkdir -p /u02/arch
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/app/oracle
chown -R oracle:oinstall /u02
chmod -R 775 /u01
chmod -R 775 /u02
 
4.使用oracle用户登陆，设置oracle用户的环境变量
//增加以下几行
[oracle@rac31 ~]$ vim .bash_profile
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
ORACLE_SID=orcl
PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH
export NLS_LANG=AMERICAN_AMERICA.UTF8
umask 022
 
5.使用grid域名登陆，设置grid用户的环境变量
//增加以下几行
[grid@rac31 ~]$ vim .bash_profile
export PATH
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:$HOME/bin
export ORACLE_SID=+ASM
 
[root@rac31 ~]# vi /etc/security/limits.conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
 
[root@rac31 ~]# vim /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2147483648
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 = 1048576
[root@rac31 ~]# sysctl -p
 
关闭selinux
[root@rac31 ~]#vim /etc/selinux/config
SELINUX=disabled
[root@rac31 ~]#setenforce 0
 
安装缺失的包
yum -y install compat-libcap1 compat-libstdc++-33-3.2.3 libstdc++-devel-4.4.4 gcc gcc-c++ ksh libaio-devel
 
fdisk dev/sdb
N新建分区
【Oracle单机实例+ASM】P创建主分区
1 分区数1个
回车
回车
W保存
[root@rac31 ~]#ls /dev/sdb*
/dev/sdb /dev/sdb1
 
安装ASM依赖文件
[root@rac31 ~]#yum install –y oracleasmlib-2.0.12-1.el7.x86_64.rpm oracleasm-support-2.1.11-2.el7.x86_64.rpm
 
需要重启主机才能正常挂载oracleasm模块
[root@rac31 ~]#reboot
 
挂载oracleasm模块
# oracleasm configure -i
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.
 
Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
 
oracleasm createdisk OCR_VOTE1 /dev/sdb1
oracleasm module not loaded or /dev/oracleasm not mounted.
 
解决 方法
linux7需要手动挂载oracleasm模块
 
#oracleasm status
Checking if ASM is loaded: no
Checking if /dev/oracleasm is mounted: no
 
#oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm


推荐阅读


上一篇：彻底明白Linux硬链接和软链接

下一篇：百度seo公司如何借助百度资源平台获取网站早排名的权益？