12.2RAC利用asm创建ACFS用于部署OGG

最新推荐文章于 2023-02-01 15:25:41 发布

cuicong9120

最新推荐文章于 2023-02-01 15:25:41 发布

阅读量534

点赞数

文章标签：数据库

环境描述：

双节点RAC

数据库：版本12.2.0.1

操作系统：linux 6.9

一、利用图形化

准备好挂载点

cd /
mkdir ogg
chown oracle:oinstall ogg
chmod 775 /ogg

图形化

asmca

我这里是有问题，不知道什么原因，做个记录。后面手动挂载。

PRCA-1138 : failed to start one or more file system resources:
Error mounting file system '/dev/asm/ogg-177' on '/ogg': /sbin/mount.acfs.bin: error while loading shared libraries: libhasgen12.so: failed to map segment from shared object: Permission denied
Error mounting file system '/dev/asm/ogg-177' on '/ogg': /sbin/mount.acfs.bin: error while loading shared libraries: libhasgen12.so: failed to map segment from shared object: Permission denied
CRS-2674: Start of 'ora.data1.ogg.acfs' on 'hnrst-ssbybcsdb2-bm001' failed
CRS-2674: Start of 'ora.data1.ogg.acfs' on 'hnrst-ssbybcsdb2-bm002' failed

每个节点都要手动挂载成功

/sbin/mount.acfs -o all

最后查看状态，成功

crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE ONLINE       csdb2-bm001   STABLE
               ONLINE ONLINE       csdb2-bm002   STABLE
ora.DATA1.OGG.advm
               ONLINE ONLINE       csdb2-bm001   STABLE
               ONLINE ONLINE       csdb2-bm002   STABLE
ora.DATA1.dg
               ONLINE ONLINE       csdb2-bm001   STABLE
               ONLINE ONLINE       csdb2-bm002   STABLE
ora.LISTENER.lsnr
               ONLINE ONLINE       csdb2-bm001   STABLE
               ONLINE ONLINE       csdb2-bm002   STABLE
ora.MGMT.dg
               ONLINE ONLINE       csdb2-bm001   STABLE
               ONLINE ONLINE       csdb2-bm002   STABLE
ora.OCR.dg
               ONLINE ONLINE       csdb2-bm001   STABLE
               ONLINE ONLINE       csdb2-bm002   STABLE
ora.chad
               ONLINE ONLINE       csdb2-bm001   STABLE
               OFFLINE OFFLINE      csdb2-bm002   STABLE
ora.data1.ogg.acfs
               ONLINE ONLINE       csdb2-bm001   mounted on /ogg,STAB
                                                             LE
               ONLINE ONLINE       csdb2-bm002   mounted on /ogg,STAB
                                                             LE
ora.net1.network
               ONLINE ONLINE       csdb2-bm001   STABLE
               ONLINE ONLINE       csdb2-bm002   STABLE
ora.ons
               ONLINE ONLINE       csdb2-bm001   STABLE
               ONLINE ONLINE       csdb2-bm002   STABLE
ora.proxy_advm
               ONLINE ONLINE       csdb2-bm001   STABLE
               ONLINE ONLINE       csdb2-bm002   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE ONLINE       csdb2-bm002   STABLE
ora.MGMTLSNR
      1        ONLINE ONLINE       csdb2-bm002   169.254.34.243 192.1
                                                             68.83.123,STABLE
ora.asm
      1        ONLINE ONLINE       csdb2-bm001   Started,STABLE
      2        ONLINE ONLINE       csdb2-bm002   Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE ONLINE       csdb2-bm002   STABLE
ora.csdb2-bm001.vip
      1        ONLINE ONLINE       csdb2-bm001   STABLE
ora.csdb2-bm002.vip
      1        ONLINE ONLINE       csdb2-bm002   STABLE
ora.mgmtdb
      1        ONLINE ONLINE       csdb2-bm002   Open,STABLE
ora.qosmserver
      1        ONLINE ONLINE       csdb2-bm002   STABLE
ora.scan1.vip
      1        ONLINE ONLINE       csdb2-bm002   STABLE
ora.sibcwdc1.db
      1        ONLINE ONLINE       csdb2-bm001   Open,HOME=/home/u01/
                                                             app/oracle/product/1
                                                             2.2.0/db1,STABLE
      2        ONLINE ONLINE       csdb2-bm002   Open,HOME=/home/u01/
                                                             app/oracle/product/1
                                                             2.2.0/db1,STABLE
--------------------------------------------------------------------------------

二、命令行
su - root
df -h
date

su - grid
--查看现有的asm空间分配情况
asmcmd -p lsdg

--从DATA1磁盘分配500G大小创建逻辑卷ogg
asmca -silent -createvolume -volumeName ogg -volumeDiskGroup DATA1 -volumesizeGB 500

--查看创建的信息（/dev/asm/vologg-3）

ll /dev/asm/*

su - root --所有的节点都要执行创建目录并改对应的属组
cd /
mkdir ogg
chown oracle:oinstall ogg
chmod 775 /ogg
--另外的节点也要执行
su - root
cd /
mkdir ogg
chown oracle:oinstall ogg
chmod 775 /ogg

--挂载目录
su - grid
asmca -silent -createACFS -acfsvolumeDevice /dev/asm/ogg-3 -acfsMountPoint /ogg -acfsUserName oracle -acfsGroupName oinstall

--执行脚本
su - root
cd /home/u01/app/grid/cfgtoollogs/asmca/scripts
./acfs_script.sh