阿里云上Centos6.9+ASM+Oracle 11g R2 RAC数据库集群配置

本文适用于阿里云上ECS自建Oracle数据库RAC集群配置。共享块存储提供共享存储功能,弹性网卡提供private网络,高可用虚拟IP提供RAC集群所需的vip

前言

  本文适用于阿里云上ECS自建Oracle数据库RAC集群配置。共享块存储提供共享存储功能,弹性网卡提供private网络,高可用虚拟IP提供RAC集群所需的vip。

1、资源准备

下载Oracle

https://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html

Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64 linux.x64_11gR2_database_1of2.zip linux.x64_11gR2_database_2of2.zip Oracle Grid Infrastructure 11g Release 2 (11.2.0.1.0) for Linux x86-64 linux.x64_11gR2_grid.zip

下载ASM

https://www.oracle.com/technetwork/server-storage/linux/asmlib/rhel6-1940776.html

阿里云高可用虚拟IP

  私网高可用虚拟IP(Private High-Availability Virtual IP Address,简称HaVip),是一种可以独立创建和释放的私网IP资源。这种私网IP的特殊之处在于,用户可以在ECS上使用ARP协议进行该IP的宣告。   需要提前向阿里申请开通,我们将使用到3个HaVip。分别用作两个rac节点的vip以及scan ip。 image image image image

阿里云弹性网卡

  弹性网卡(ENI)是一种可以附加到专有网络VPC类型ECS实例上的虚拟网卡,通过弹性网卡,您可以实现高可用集群搭建、低成本故障转移和精细化的网络管理。   开通两个弹性网卡分别绑定至两个rac节点,用于Private IP的网络。 image

阿里云共享块存储

  ECS 共享块存储是一种支持多台ECS实例并发读写访问的数据块级存储设备,具备多并发、高性能、高可靠等特性,单块共享块存储最多支持同时挂载到8台ECS实例。   需提前向阿里申请开通。这里申请了2块共享块存储,一块20GB,一块50GB。分别挂载给rac-1&rac-2. image

2、修改主机名,hosts配置

[root@rac-1 ~]# hostname rac-1 
[root@rac-1 ~]# cat /etc/sysconfig/network 
NETWORKING=yes 
HOSTNAME=rac-1 
[root@rac-2 ~]# hostname rac-2 
[root@rac-2 ~]# cat /etc/sysconfig/network 
NETWORKING=yes 
HOSTNAME=rac-2 
[root@rac-1 ~]# cat /etc/hosts 
#Public-ip 
172.17.200.214 rac-1 
172.17.200.216 rac-2 
#Private-ip 
172.18.200.1 rac-1-priv 
172.18.200.2 rac-2-priv 
#Vip 
172.17.200.215 rac-1-vip 
172.17.200.217 rac-2-vip 
#Scan-ip 
172.17.200.200 rac-scan 

3、修改参数内核

[root@rac-1 ~]# vim /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall =7864320
kernel.shmmax = 52451655680
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
[root@rac-1 ~]# sysctl -p

4、修改/etc/pam.d/login

[root@rac-1 ~]# echo 'session required pam_limits.so' >>/etc/pam.d/login

5、修改limits.conf

[root@rac-1 ~]# vim /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 10240

6、修改/etc/profile

[root@rac-1 ~]# vim /etc/profile
#添加以下内容
#set oracle rac env
if [ $USER = "ORACLE" ] || [ $USER = "GRID" ];then
    if [ $SHELL = "/bin/ksh" ];then
       ulimit -p 16384
       ulimit -n 65536
    else
       ulimit -u 16384 -n 65536
    fi
    umask 022
fi

7、关闭selinux&iptables

  略

8、关闭NTP服务

[root@rac-1 ~]# /etc/init.d/ntpd status
ntpd (pid  1556) is running...
[root@rac-1 ~]# /etc/init.d/ntpd stop
Shutting down ntpd:                                        [  OK  ]
[root@rac-1 ~]# chkconfig ntpd off
[root@rac-1 ~]# mv /etc/ntp.conf /etc/ntp.conf.bak

9、安装依赖

#安装软件依赖
[root@rac-1 ~]# yum install -y compat-libstdc++-33 elfutils-libelf-devel gcc-c++ ksh libaio-devel libstdc++-devel libXp numactl-devel unixODBC unixODBC-devel compat-libcap1.x86_64 smartmontools
#安装ASM
[root@rac-1 ~]# yum install -y oracleasm
[root@rac-1 ~]# rpm -ivh oracleasmlib-2.0.4-1.el6.x86_64.rpm
[root@rac-1 ~]# rpm -ivh oracleasm-support-2.1.8-1.el6.x86_64.rpm

10、创建用户和组

[root@rac-1 ~]# groupadd -g 501 oinstall
[root@rac-1 ~]# groupadd -g 502 dba
[root@rac-1 ~]# groupadd -g 503 oper
[root@rac-1 ~]# groupadd -g 504 asmadmin
[root@rac-1 ~]# groupadd -g 505 asmoper
[root@rac-1 ~]# groupadd -g 506 asmdba
[root@rac-1 ~]# useradd -g oinstall -G dba,asmdba,oper oracle
[root@rac-1 ~]# useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid
[root@rac-1 ~]# passwd oracle
[root@rac-1 ~]# passwd grid

#设置oracle用户环境变量
[root@rac-1 ~]# su - oracle
[oracle@rac-1 ~]$ vim .bash_profile
#添加以下内容
export ORACLE_SID=rac1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export TMP=/tmp
export TMPDIR=$TMP
export PATH=$PATH:$ORACLE_HOME/bin
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
umask 022

#设置grid用户环境变量
[root@rac-1 ~]# su - grid
[grid@rac-1 ~]$ vim .bash_profile 
#添加以下内容
export ORACLE_SID=+ASM1
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export PATH=$ORACLE_HOME/bin:$PATH
export LANG=en_US
umask 022

#rac-2配置环境变量需做相应修改
export ORACLE_SID=rac2
export ORACLE_SID=+ASM2

11、创建目录和权限设置

[root@rac-1 ~]# mkdir -p /u01/app/grid
[root@rac-1 ~]# mkdir -p /u01/app/11.2.0/grid
[root@rac-1 ~]# chown -R grid:oinstall /u01/app/grid
[root@rac-1 ~]# chown -R grid:oinstall /u01/app/11.2.0
[root@rac-1 ~]# chown -R oracle:oinstall /u01/app/oracle
[root@rac-1 ~]# chmod -R 775 /u01
[root@rac-1 ~]# mkdir -p /u01/app/oraInventory
[root@rac-1 ~]# chown -R grid:oinstall /u01/app/oraInventory
[root@rac-1 ~]# chmod -R 775 /u01/app/oraInventory

12、配置oracle、grid用户ssh对等性

[root@rac-1 ~]# su - oracle
[oracle@rac-1 ~]$ ssh-keygen -t rsa
[oracle@rac-1 ~]$ ssh-copy-id -i .ssh/id_rsa.pub rac-2
[oracle@rac-1 ~]$ ssh-copy-id -i .ssh/id_rsa.pub rac-1
[root@rac-1 ~]# su - grid
[grid@rac-1 ~]$ ssh-keygen -t rsa
[grid@rac-1 ~]$ ssh-copy-id -i .ssh/id_rsa.pub rac-2
[grid@rac-1 ~]$ ssh-copy-id -i .ssh/id_rsa.pub rac-1
#验证
[root@rac-1 ~]# su - grid
[grid@rac-1 ~]$ ssh rac-1 date
Wed Jan 30 12:22:04 CST 2019
[grid@rac-1 ~]$ ssh rac-2 date
Wed Jan 30 12:22:10 CST 2019
[grid@rac-1 ~]$ ssh rac-1-priv date
Wed Jan 30 12:22:19 CST 2019
[grid@rac-1 ~]$ ssh rac-2-priv date
Wed Jan 30 12:22:19 CST 2019

13、增加swap

  由于阿里云ecs默认不存在swap内存,故需要手动开启swap。

[root@rac-1 ~]# dd if=/dev/zero of=/mnt/swap bs=1M count=8192
8192+0 records in
8192+0 records out
8589934592 bytes (8.6 GB) copied, 61.4831 s, 140 MB/s
[root@rac-1 ~]# mkswap /mnt/swap 
mkswap: /mnt/swap: warning: don't erase bootbits sectors        on whole disk. Use -f to force.
Setting up swapspace version 1, size = 8388604 KiB
no label, UUID=0d46fa75-3434-4e56-8d2b-4e29683810de
[root@rac-1 ~]# swapon /mnt/swap 
[root@rac-1 ~]# echo "/mnt/swap swap swap defaults 0 0" >>/etc/fstab 

14、挂载磁盘分区

  将共享块存储分别挂载至rac-1和rac-2,并在rac-1上进行分区,如下图。 image

15、配置ASM

[root@rac-1 ~]# /etc/init.d/oracleasm enable
[root@rac-1 ~]# /etc/init.d/oracleasm start
[root@rac-1 ~]# /usr/sbin/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 []: dba
Start Oracle ASM library driver on boot (y/n) [y]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done

#创建ASM磁盘(只在rac-1上执行即可)
[root@rac-1 ~]# oracleasm createdisk VOLCRS01 /dev/vdb1
[root@rac-1 ~]# oracleasm createdisk VOLCRS02 /dev/vdb2
[root@rac-1 ~]# oracleasm createdisk VOLCRS03 /dev/vdb3
 
[root@rac-1 ~]# oracleasm createdisk VOLDATA01 /dev/vdc1
[root@rac-1 ~]# oracleasm createdisk VOLDATA02 /dev/vdc2
[root@rac-1 ~]# oracleasm createdisk VOLDATA03 /dev/vdc3

#rac-1上listdisks
[root@rac-1 ~]# oracleasm listdisks
VOLCRS01
VOLCRS02
VOLCRS03
VOLDATA01
VOLDATA02
VOLDATA03

#rac-2上搜索磁盘
[root@rac-2 ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "VOLCRS01"
Instantiating disk "VOLCRS02"
Instantiating disk "VOLCRS03"
Instantiating disk "VOLDATA01"
Instantiating disk "VOLDATA02"
Instantiating disk "VOLDATA03"

16、安装前准备

#安装包解压
[root@rac-1 ~]# unzip linux.x64_11gR2_database_1of2.zip
[root@rac-1 ~]# unzip linux.x64_11gR2_database_2of2.zip
[root@rac-1 ~]# unzip linux.x64_11gR2_grid.zip
[root@rac-1 ~]# mv database/ /home/oracle/
[root@rac-1 ~]# mv grid/ /home/grid/
[root@rac-1 ~]# chown -R oracle.oinstall /home/oracle/database/
[root@rac-1 ~]# chown -R grid.oinstall /home/grid/grid/
[root@rac-1 ~]# rpm -ivh /home/grid/grid/rpm/cvuqdisk-1.0.7-1.rpm

#VNC安装配置(rac环境中的grid和database安装,都由于一个节点完成,其他节点会推送过去,故只需要一台配置vnc即可))
[root@rac-1 ~]# yum groupinstall -y "X Window System" "Desktop" "Chinese Support" 
[root@rac-1 ~]# yum install -y tigervnc-server
VNC具体配置略

17、安装grid

  仅在rac-1中执行即可,grid会同步至其他节点。

#安装前预检查
root@rac-1 ~]# su - grid
[grid@rac-1 ~]$ cd grid/
[grid@rac-1 grid]$ ./runcluvfy.sh stage -pre crsinst -n rac-1,rac-2 -fixup -verbose
查看打印信息,检查failed项目,若是有关i386&i688的依赖,忽略即可。确保其他项目passed。

  进入图形化界面,运行/home/grid/grid/runInstaller image image image

  默认只发现本机节点,点击Add添加rac-2节点。 image image image image image image image image image image image   提示执行脚本。按照提示在rac-1和rac-2中执行。   在执行root.sh中遇到以下问题。

[root@rac-1 ~]# sh /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.
[root@rac-1 ~]# sh /u01/app/11.2.0/grid/root.sh 
Running Oracle 11g root.sh script...
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.sh script.
Now product-specific root actions will be performed.
2019-01-30 15:42:38: Parsing the host name
2019-01-30 15:42:38: Checking for super user privileges
2019-01-30 15:42:38: User has super user privileges
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE 
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
  root wallet
  root wallet cert
  root cert export
  peer wallet
  profile reader wallet
  pa wallet
  peer wallet keys
  pa wallet keys
  peer cert request
  pa cert request
  peer cert
  pa cert
  peer root cert TP
  profile reader root cert TP
  pa root cert TP
  peer pa cert TP
  pa peer cert TP
  profile reader pa cert TP
  profile reader peer cert TP
  peer user cert
  pa user cert
Adding daemon to inittab
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
ohasd failed to start: Inappropriate ioctl for device
ohasd failed to start at /u01/app/11.2.0/grid/crs/install/rootcrs.pl line 443.

#解决方法
#首先删除之前配置
[root@rac-1 ~]# /u01/app/11.2.0/grid/crs/install/roothas.pl --delete -force -verbose
#再次执行
[root@rac-1 ~]# sh /u01/app/11.2.0/grid/root.sh 
#随后当日志输入到“Adding daemon to inittab”时候,在其他shell中执行以下命令
[root@rac-1 ~]# /bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1
#如果出现
/bin/dd: opening`/var/tmp/.oracle/npohasd': No such file or directory
#则文件还没生成,需要继续执行此命令,直到可以执行为止。

18、安装grid之后的状态检查

[root@rac-1 ~]# su - grid
#检查crs状态
[grid@rac-1 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

#检查clusterware资源
[grid@rac-1 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    rac-1       
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac-1       
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    rac-1       
ora.eons       ora.eons.type  0/3    0/     ONLINE    ONLINE    rac-1       
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    rac-1       
ora.oc4j       ora.oc4j.type  0/5    0/0    OFFLINE   OFFLINE               
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    rac-1       
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac-1       
ora.rac-1.gsd  application    0/5    0/0    OFFLINE   OFFLINE               
ora.rac-1.ons  application    0/3    0/0    ONLINE    ONLINE    rac-1       
ora.rac-1.vip  ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac-1       
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac-2       
ora.rac-2.gsd  application    0/5    0/0    OFFLINE   OFFLINE               
ora.rac-2.ons  application    0/3    0/0    ONLINE    ONLINE    rac-2       
ora.rac-2.vip  ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac-2       
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac-1  

#启动oc4j服务
[grid@rac-1 ~]$ srvctl enable oc4j
[grid@rac-1 ~]$ srvctl start oc4j

#启动gsd服务
[grid@rac-1 ~]$ srvctl enable nodeapps
[grid@rac-1 ~]$ srvctl start nodeapps
[grid@rac-1 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    rac-1       
ora.FRA.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac-1       
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    rac-1       
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac-1       
ora.ORC.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac-1       
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    rac-1       
ora.eons       ora.eons.type  0/3    0/     ONLINE    ONLINE    rac-1       
ora.gsd        ora.gsd.type   0/5    0/     ONLINE    ONLINE    rac-1       
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    rac-1       
ora.oc4j       ora.oc4j.type  0/5    0/0    ONLINE    ONLINE    rac-2       
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    rac-1       
ora.orcl.db    ora....se.type 0/2    0/1    ONLINE    ONLINE    rac-1       
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac-1       
ora....-1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac-1       
ora.rac-1.gsd  application    0/5    0/0    ONLINE    ONLINE    rac-1       
ora.rac-1.ons  application    0/3    0/0    ONLINE    ONLINE    rac-1       
ora.rac-1.vip  ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac-1       
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac-2       
ora....-2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac-2       
ora.rac-2.gsd  application    0/5    0/0    ONLINE    ONLINE    rac-2       
ora.rac-2.ons  application    0/3    0/0    ONLINE    ONLINE    rac-2       
ora.rac-2.vip  ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac-2       
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac-1

#检查集群节点     
[grid@rac-1 ~]$ olsnodes -n -i -s -t
rac-1    1    rac-1-vip    Active    Unpinned
rac-2    2    rac-2-vip    Active    Unpinned

#确认针对Oracle Clusterware文件的Oracle ASM功能:
[grid@rac-1 ~]$ srvctl status asm -a
ASM is running on rac-1,rac-2
ASM is enabled.

#检查Oracle集群注册表
[grid@rac-1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :     Version                  :          3     Total space (kbytes)     :     262120     Used space (kbytes)      :       2224     Available space (kbytes) :     259896     ID                       : 1911719288     Device/File Name         :       +ORC                                    Device/File integrity check succeeded                                    Device/File not configured                                    Device/File not configured                                    Device/File not configured                                    Device/File not configured     
    Cluster registry integrity check succeeded     
    Logical corruption check bypassed due to non-privileged user  

#检查表决磁盘
  [grid@rac-1 ~]$ crsctl query css votedisk##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- --------- 1. ONLINE   3d2f8e68320c4fb7bf41073cf32d86ba (/dev/oracleasm/disks/VOLCRS02) [ORC] 2. ONLINE   37eac06032914f47bf61ac5c741c3893 (/dev/oracleasm/disks/VOLCRS01) [ORC] 3. ONLINE   33dfe64661cc4f41bf96401cc08ebc99 (/dev/oracleasm/disks/VOLCRS03) [ORC]
Located 3 voting disk(s).

#查看集群scan vip信息
[grid@rac-1 ~]$ srvctl config scan
SCAN name: rac-scan, Network: 1/172.17.200.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /rac-scan/172.17.200.200

#查看集群scan listener信息
[grid@rac-1 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

19、为数据和快速恢复创建ASM磁盘组

  rac-1中使用图形化界面登录grid用户,执行asmca

  可以看到安装grid时配置的ORC盘已经存在 image

  创建数据盘DATA image image   创建快速恢复盘FRA image image   ASM磁盘组群情况如下 image

20、安装数据库软件

  rac-1中使用图形化界面登录oracle用户,运行/home/oracle/database/runInstaller image image image image   在每个节点执行脚本。 image   安装完成 image

21、创建集群数据库

  rac-1中使用图形化界面登录oracle用户,运行dbca image   创建数据库 image   选择自定义数据库(通用也可以) image   全局数据库名为orcl,前缀为orcl,rac-1&rac-2节点。 image image   设置统一密码 image   使用ASM存储,选择已创建的DATA磁盘组 image   设置ASM密码,如果出现ORA-01031: insufficient privileges 错误,请执行以下命令

[grid@rac-1 ~]$ cd /u01/app/11.2.0/grid/dbs
[grid@rac-1 dbs]$ mv orapw+ASM orapw+ASM.bak
[grid@rac-1 dbs]$ orapwd file=/u01/app/11.2.0/grid/dbs/orapw+ASM password=oracle_4U
[grid@rac-1 dbs]$ scp orapw+ASM rac-2:/u01/app/11.2.0/grid/dbs/
[grid@rac-1 dbs]$ sqlplus / as sysasm
SQL> create user asmsnmp identified by oracle_4U;
User created.
SQL> grant sysdba to asmsnmp;
Grant succeeded.

image   指定闪回区磁盘组 image image image image   开始创建数据库 image   安装完成 image

Comments