您好,登錄后才能下訂單哦!
小編給大家分享一下DM7如何使用DMASM安裝DMRAC,希望大家閱讀完這篇文章之后都有所收獲,下面讓我們一起去探討吧!
一.環境準備
主機 IP地址(對外服務) IP地址(內部通信) 實例名 操作系統
dmrac1 10.18.13.161 10.10.10.161 rac0 Redhat 6.7
dmrac2 10.18.13.162 10.10.10.162 rac1 Redhat 6.7
共享存儲
/dev/sdb /dev/raw/raw1 dcr disk 2G
/dev/sdc /dev/raw/raw2 voting disk 2G
/dev/sdd /dev/raw/raw3 log disk 10G
/dev/sde /dev/raw/raw4 data disk1 10G
/dev/sdf /dev/raw/raw5 data disk2 10G
二、操作系統配置
1、關閉防火墻和SELINUX
[root@cs ~]# service iptables stop iptables: Setting chains to policy ACCEPT: nat mangle filter [ OK ] iptables: Flushing firewall rules: [ OK ] iptables: Unloading modules: [ OK ] [root@cs ~]# chkconfig iptables off [root@cs ~]# setenforce 0 [root@cs ~]# sed -i s:^SELINUX=.*$:SELINUX=disabled:g /etc/selinux/config [root@cs ~]# service iptables stop iptables: Setting chains to policy ACCEPT: nat mangle filter [ OK ] iptables: Flushing firewall rules: [ OK ] iptables: Unloading modules: [ OK ] [root@cs ~]# chkconfig iptables off [root@cs ~]# setenforce 0 [root@cs ~]# sed -i s:^SELINUX=.*$:SELINUX=disabled:g /etc/selinux/config
2、修改主機名
[root@cs ~]# hostname dmrac1 [root@cs ~]# hostname dmrac2 [root@cs ~]# sed -i s:^HOSTNAME=.*$:HOSTNAME=dmrac1:g /etc/sysconfig/network [root@cs ~]# sed -i s:^HOSTNAME=.*$:HOSTNAME=dmrac2:g /etc/sysconfig/network
3、修改hosts文件
[root@cs ~]# echo " > 10.18.13.161 dmrac1 > 10.18.13.162 dmrac2" >> /etc/hosts [root@cs ~]# echo " > 10.18.13.161 dmrac1 > 10.18.13.162 dmrac2" >> /etc/hosts
三、 安裝達夢軟件
為了減少對操作系統的影響,用戶不應該以root系統用戶來安裝和運行DM。用戶可以在安裝之前為DM創建一個專用的系統用戶。具體操作詳見
Oracle Linux 7.1中安裝達夢數據庫DM7
四、綁定UDEV
[root@dmrac1 rules.d]# vi 99-dm-devices.rules ACTION=="add", KERNEL=="sdb", RUN+="/bin/raw /dev/raw/raw1 %N" ACTION=="add", KERNEL=="sdc", RUN+="/bin/raw /dev/raw/raw2 %N" ACTION=="add", KERNEL=="sdd", RUN+="/bin/raw /dev/raw/raw3 %N" ACTION=="add", KERNEL=="sde", RUN+="/bin/raw /dev/raw/raw4 %N" ACTION=="add", KERNEL=="sdf", RUN+="/bin/raw /dev/raw/raw5 %N" ACTION=="add", KERNEL=="raw[1-5]", OWNER="dmdba", GROUP="dinstall", MODE="660" ~ [root@dmrac1 rules.d]# start_udev Starting udev: [ OK ] [root@dmrac1 rules.d]# ls -lrt /dev/raw/ total 0 crw-rw----. 1 root disk 162, 0 Apr 24 14:08 rawctl crw-rw----. 1 dmdba dinstall 162, 2 Apr 24 14:08 raw2 crw-rw----. 1 dmdba dinstall 162, 1 Apr 24 14:08 raw1 crw-rw----. 1 dmdba dinstall 162, 4 Apr 24 14:08 raw4 crw-rw----. 1 dmdba dinstall 162, 3 Apr 24 14:08 raw3 crw-rw----. 1 dmdba dinstall 162, 5 Apr 24 14:08 raw5 [root@dmrac2 rules.d]# vi 99-dm-devices.rules ACTION=="add", KERNEL=="sdb", RUN+="/bin/raw /dev/raw/raw1 %N" ACTION=="add", KERNEL=="sdc", RUN+="/bin/raw /dev/raw/raw2 %N" ACTION=="add", KERNEL=="sdd", RUN+="/bin/raw /dev/raw/raw3 %N" ACTION=="add", KERNEL=="sde", RUN+="/bin/raw /dev/raw/raw4 %N" ACTION=="add", KERNEL=="sdf", RUN+="/bin/raw /dev/raw/raw5 %N" ACTION=="add", KERNEL=="raw[1-5]", OWNER="dmdba", GROUP="dinstall", MODE="660" ~ [root@dmrac2 rules.d]# start_udev Starting udev: [ OK ] [root@dmrac2 rules.d]# ls -lrt /dev/raw/ total 0 crw-rw----. 1 root disk 162, 0 Apr 24 14:08 rawctl crw-rw----. 1 dmdba dinstall 162, 2 Apr 24 14:08 raw2 crw-rw----. 1 dmdba dinstall 162, 1 Apr 24 14:08 raw1 crw-rw----. 1 dmdba dinstall 162, 4 Apr 24 14:08 raw4 crw-rw----. 1 dmdba dinstall 162, 3 Apr 24 14:08 raw3 crw-rw----. 1 dmdba dinstall 162, 5 Apr 24 14:08 raw5
可以通過blockdev --getsize64 /dev/raw/raw1命令查看裸設備大小
[root@dmrac1 rules.d]# blockdev --getsize64 /dev/raw/raw1 2147483648 [root@dmrac1 rules.d]# blockdev --getsize64 /dev/raw/raw2 2147483648 [root@dmrac1 rules.d]# blockdev --getsize64 /dev/raw/raw3 10737418240 [root@dmrac1 rules.d]# blockdev --getsize64 /dev/raw/raw4 10737418240 [root@dmrac1 rules.d]# blockdev --getsize64 /dev/raw/raw5 10737418240 [root@dmrac2 rules.d]# blockdev --getsize64 /dev/raw/raw1 2147483648 [root@dmrac2 rules.d]# blockdev --getsize64 /dev/raw/raw2 2147483648 [root@dmrac2 rules.d]# blockdev --getsize64 /dev/raw/raw3 10737418240 [root@dmrac2 rules.d]# blockdev --getsize64 /dev/raw/raw4 10737418240 [root@dmrac2 rules.d]# blockdev --getsize64 /dev/raw/raw5 10737418240
六、配置dmdcr_cfg.ini文件
在2個節點的/dm7/data目錄下創建配置文件dmdcr_cfg.ini,在文件中添加如下內容:
[root@dmrac1 /]# su - dmdba [dmdba@dmrac1 ~]$ mkdir /dm7/data [dmdba@dmrac1 ~]$cd /dm7/data [dmdba@dmrac1 data]$ cat dmdcr_cfg.ini DCR_N_GRP = 3 DCR_VTD_PATH = /dev/raw/raw2 DCR_OGUID = 63635 [GRP] DCR_GRP_TYPE = CSS DCR_GRP_NAME = GRP_CSS DCR_GRP_N_EP = 2 DCR_GRP_DSKCHK_CNT = 60 [GRP_CSS] DCR_EP_NAME = CSS0 DCR_EP_HOST = 10.10.10.161 DCR_EP_PORT = 9541 [GRP_CSS] DCR_EP_NAME = CSS1 DCR_EP_HOST = 10.10.10.162 DCR_EP_PORT = 9542 [GRP] DCR_GRP_TYPE = ASM DCR_GRP_NAME = GRP_ASM DCR_GRP_N_EP = 2 DCR_GRP_DSKCHK_CNT = 60 [GRP_ASM] DCR_EP_NAME = ASM0 DCR_EP_SHM_KEY = 93360 DCR_EP_SHM_SIZE = 10 DCR_EP_HOST = 10.18.13.161 DCR_EP_PORT = 9641 DCR_EP_ASM_LOAD_PATH = /dev/raw [GRP_ASM] DCR_EP_NAME = ASM1 DCR_EP_SHM_KEY = 93361 DCR_EP_SHM_SIZE = 10 DCR_EP_HOST = 10.18.13.162 DCR_EP_PORT = 9642 DCR_EP_ASM_LOAD_PATH = /dev/raw [GRP] DCR_GRP_TYPE = DB DCR_GRP_NAME = GRP_RAC DCR_GRP_N_EP = 2 DCR_GRP_DSKCHK_CNT = 60 [GRP_RAC] DCR_EP_NAME = RAC0 DCR_EP_SEQNO = 0 DCR_EP_PORT = 5236 DCR_CHECK_PORT = 9741 [GRP_RAC] DCR_EP_NAME = RAC1 DCR_EP_SEQNO = 1 DCR_EP_PORT = 5236 DCR_CHECK_PORT = 9742 [root@dmrac2 /]# su - dmdba [dmdba@dmrac2 ~]$ mkdir /dm7/data [dmdba@dmrac2 ~]$cd /dm7/data [dmdba@dmrac2 data]$ cat dmdcr_cfg.ini DCR_N_GRP = 3 DCR_VTD_PATH = /dev/raw/raw2 DCR_OGUID = 63635 [GRP] DCR_GRP_TYPE = CSS DCR_GRP_NAME = GRP_CSS DCR_GRP_N_EP = 2 DCR_GRP_DSKCHK_CNT = 60 [GRP_CSS] DCR_EP_NAME = CSS0 DCR_EP_HOST = 10.10.10.161 DCR_EP_PORT = 9541 [GRP_CSS] DCR_EP_NAME = CSS1 DCR_EP_HOST = 10.10.10.162 DCR_EP_PORT = 9542 [GRP] DCR_GRP_TYPE = ASM DCR_GRP_NAME = GRP_ASM DCR_GRP_N_EP = 2 DCR_GRP_DSKCHK_CNT = 60 [GRP_ASM] DCR_EP_NAME = ASM0 DCR_EP_SHM_KEY = 93360 DCR_EP_SHM_SIZE = 10 DCR_EP_HOST = 10.18.13.161 DCR_EP_PORT = 9641 DCR_EP_ASM_LOAD_PATH = /dev/raw [GRP_ASM] DCR_EP_NAME = ASM1 DCR_EP_SHM_KEY = 93361 DCR_EP_SHM_SIZE = 10 DCR_EP_HOST = 10.18.13.162 DCR_EP_PORT = 9642 DCR_EP_ASM_LOAD_PATH = /dev/raw [GRP] DCR_GRP_TYPE = DB DCR_GRP_NAME = GRP_RAC DCR_GRP_N_EP = 2 DCR_GRP_DSKCHK_CNT = 60 [GRP_RAC] DCR_EP_NAME = RAC0 DCR_EP_SEQNO = 0 DCR_EP_PORT = 5236 DCR_CHECK_PORT = 9741 [GRP_RAC] DCR_EP_NAME = RAC1 DCR_EP_SEQNO = 1 DCR_EP_PORT = 5236 DCR_CHECK_PORT = 9742
七、使用 DMASMCMD 工具初始化(任意一節點執行)
[dmdba@dmrac1 data]$ dmasmcmd DMASMCMD V7.1.6.46-Build(2018.02.08-89107)ENT ASM>create dcrdisk '/dev/raw/raw1' 'dcr' the ASM initialize dcrdisk /dev/raw/raw1 to name DMASMdcr Used time: 9.322(ms). ASM>create votedisk '/dev/raw/raw2' 'vote' the ASM initialize votedisk /dev/raw/raw2 to name DMASMvote Used time: 6.251(ms). ASM>create asmdisk '/dev/raw/raw3' 'LOG0' the ASM initialize asmdisk /dev/raw/raw3 to name DMASMLOG0 Used time: 8.825(ms). ASM>create asmdisk '/dev/raw/raw4' 'DATA0' the ASM initialize asmdisk /dev/raw/raw4 to name DMASMDATA0 Used time: 6.145(ms). ASM>init dcrdisk '/dev/raw/raw1' from '/dm7/data/dmdcr_cfg.ini' identified by 'dameng123' [Trace]DG 126 allocate 4 extents for file 0xfe000002. Check dcr disk failed, please check and try again Used time: 84.489(ms).提示檢查dcr磁盤失敗請再次執行 ASM>init dcrdisk '/dev/raw/raw1' from '/dm7/data/dmdcr_cfg.ini' identified by 'dameng123' [Trace]DG 126 allocate 4 extents for file 0xfe000002. Used time: 00:00:06.078. ASM>init votedisk '/dev/raw/raw2' from '/dm7/data/dmdcr_cfg.ini' [Trace]DG 125 allocate 4 extents for file 0xfd000002. Used time: 36.305(ms).
八、準備DMASM 的 MAL 配置文件
在2個節點的/dm7/data目錄下創建 DMASM 的 MAL 配置文件(命名為 dmasvrmal.ini),使用 DMASM 的所有節點都要配置,內容完全一樣。
[dmdba@dmrac1 data]$ vi dmasvrmal.ini [MAL_INST1] MAL_INST_NAME = ASM0 MAL_HOST = 10.10.10.161 MAL_PORT = 7236 [MAL_INST2] MAL_INST_NAME = ASM1 MAL_HOST = 10.10.10.162 MAL_PORT = 7237 [dmdba@dmrac2 data]$ vi dmasvrmal.ini [MAL_INST1] MAL_INST_NAME = ASM0 MAL_HOST = 10.10.10.161 MAL_PORT = 7236 [MAL_INST2] MAL_INST_NAME = ASM1 MAL_HOST = 10.10.10.162 MAL_PORT = 7237 ~
九、準備dmdcr.ini 配置文件
dmdcr.ini 是 dmcss、dmasmsvr、dmasmtool 工具的輸入參數。記錄了當前節點序列號以及 DCR 磁盤路徑。
在2個節點的/dm/dmdbms/data目錄下創建dmdcr.ini 配置文件,dmdcr_path 相同,dmasvrmal.ini 文件內容也相同,dmdcr_seqo 分別為 0 和 1。
節點 1:
[dmdba@dmrac1 data]$ vi dmdcr.ini DMDCR_PATH = /dev/raw/raw1 DMDCR_MAL_PATH =/dm7/data/dmasvrmal.ini DMDCR_SEQNO = 0 #ASM DMDCR_ASM_RESTART_INTERVAL = 0 DMDCR_ASM_STARTUP_CMD = /dm7/bin/dmasmsvr dcr_ini=/dm7/data/dmdcr.ini #DB DMDCR_DB_RESTART_INTERVAL = 0 DMDCR_DB_STARTUP_CMD = /dm7/bin/dmserver path=/dm7/data/rac0_config/dm.ini dcr_ini=/dm7/data/dmdcr.ini
節點2:
[dmdba@dmrac2 data]$ vi dmdcr.ini DMDCR_PATH = /dev/raw/raw1 DMDCR_MAL_PATH =/dm7/data/dmasvrmal.ini DMDCR_SEQNO = 1 #ASM DMDCR_ASM_RESTART_INTERVAL = 0 DMDCR_ASM_STARTUP_CMD = /dm7/bin/dmasmsvr dcr_ini=/dm7/data/dmdcr.ini #DB DMDCR_DB_RESTART_INTERVAL = 0 DMDCR_DB_STARTUP_CMD = /dm7/bin/dmserver path=/dm7/data/rac1_config/dm.ini dcr_ini=/dm7/data/dmdcr.ini
十、啟動DMCSS、DMASM 服務程序
1、注冊 DMCSS和DMASM服務
節點一:
[root@dmrac1 ~]# /dm7/script/root/dm_service_installer.sh -t dmcss -i /dm7/data/dmdcr.ini -p rac1 Move the service script file(/dm7/bin/DmCSSServicerac1 to /etc/rc.d/init.d/DmCSSServicerac1) Finished to create the service (DmCSSServicerac1) [root@dmrac1 ~]# /dm7/script/root/dm_service_installer.sh -t dmasmsvr -i /dm7/data/dmdcr.ini -p rac1 Move the service script file(/dm7/bin/DmASMSvrServicerac1 to /etc/rc.d/init.d/DmASMSvrServicerac1) Finished to create the service (DmASMSvrServicerac1) [root@dmrac1 ~]#
節點二:
[root@dmrac2 ~]# /dm7/script/root/dm_service_installer.sh -t dmcss -i /dm7/data/dmdcr.ini -p rac2 Move the service script file(/dm7/bin/DmCSSServicerac2 to /etc/rc.d/init.d/DmCSSServicerac2) Finished to create the service (DmCSSServicerac2) [root@dmrac2 ~]# /dm7/script/root/dm_service_installer.sh -t dmasmsvr -i /dm7/data/dmdcr.ini -p rac2 Move the service script file(/dm7/bin/DmASMSvrServicerac2 to /etc/rc.d/init.d/DmASMSvrServicerac2) Finished to create the service (DmASMSvrServicerac2)
2、啟動DMCSS和DMASM服務
節點一:
[root@dmrac1 init.d]# service DmCSSServicerac1 start Starting DmCSSServicerac1: [ OK ] [root@dmrac1 init.d]# service DmASMSvrServicerac1 start Starting DmASMSvrServicerac1: [ OK ]
節點二:
[root@dmrac2 init.d]# service DmCSSServicerac2 start Starting DmCSSServicerac2: [ OK ] [root@dmrac2 init.d]# service DmASMSvrServicerac2 start Starting DmASMSvrServicerac2: [ OK ]
十一、創建DMASM磁盤組
在任意節點使用 dmasmtool 工具創建 DMASM 磁盤組。
[dmdba@dmrac1 ~]$ dmasmtool DCR_INI=/dm7/data/dmdcr.ini DMASMTOOL V7.1.6.46-Build(2018.02.08-89107)ENT ASM>create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3' Used time: 00:00:06.363. ASM>create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4' Used time: 00:00:06.504.
十二、準備dminit.ini 配置文件
在2個節點的/dm/dmdbms/data目錄下創建 dminit.ini 配置文件,添加如下內容。 在2個節點都創建。
[dmdba@dmrac1 data]$ vi dminit.ini db_name = rac system_path = +DMDATA/data system = +DMDATA/data/rac/system.dbf system_size = 128 roll = +DMDATA/data/rac/roll.dbf roll_size = 128 main = +DMDATA/data/rac/main.dbf main_size = 128 ctl_path = +DMDATA/data/rac/dm.ctl ctl_size = 8 log_size = 256 dcr_path = /dev/raw/raw1 #dcr 磁盤路徑,目前不支持 asm,只能是裸設備 dcr_seqno = 0 auto_overwrite = 1 [RAC0] #inst_name 跟 dmdcr_cfg.ini 中 DB 類型 group 中 DCR_EP_NAME 對應 config_path = /dm7/data/rac0_config port_num = 5236 mal_host = 10.10.10.161 mal_port = 9340 log_path = +DMLOG/log/rac0_log01.log log_path = +DMLOG/log/rac0_log02.log [RAC1] #inst_name 跟 dmdcr_cfg.ini 中 DB 類型 group 中 DCR_EP_NAME 對應 config_path = /dm7/data/rac1_config port_num = 5236 mal_host = 10.10.10.162 mal_port = 9341 log_path = +DMLOG/log/rac1_log01.log log_path = +DMLOG/log/rac1_log02.log [dmdba@dmrac2 data]$ vi dminit.ini db_name = rac system_path = +DMDATA/data system = +DMDATA/data/rac/system.dbf system_size = 128 roll = +DMDATA/data/rac/roll.dbf roll_size = 128 main = +DMDATA/data/rac/main.dbf main_size = 128 ctl_path = +DMDATA/data/rac/dm.ctl ctl_size = 8 log_size = 256 dcr_path = /dev/raw/raw1 #dcr 磁盤路徑,目前不支持 asm,只能是裸設備 dcr_seqno = 0 auto_overwrite = 1 [RAC0] #inst_name 跟 dmdcr_cfg.ini 中 DB 類型 group 中 DCR_EP_NAME 對應 config_path = /dm7/data/rac0_config port_num = 5236 mal_host = 10.10.10.161 mal_port = 9340 log_path = +DMLOG/log/rac0_log01.log log_path = +DMLOG/log/rac0_log02.log [RAC1] #inst_name 跟 dmdcr_cfg.ini 中 DB 類型 group 中 DCR_EP_NAME 對應 config_path = /dm7/data/rac1_config port_num = 5236 mal_host = 10.10.10.162 mal_port = 9341 log_path = +DMLOG/log/rac1_log01.log log_path = +DMLOG/log/rac1_log02.log
十三、使用dminit初始化數據庫
在任意節點啟動 dminit 工具初始化數據庫。dminit 執行完成后,會在 config_path 目錄(/dm7/data/rac0_config 和/dm7/data/rac1_config)下生成配置文件 dm.ini 和 dmmal.ini。
[dmdba@dmrac1 data]$ dminit control=/dm7/data/dminit.ini initdb V7.1.6.46-Build(2018.02.08-89107)ENT db version: 0x7000a file dm.key not found, use default license! License will expire on 2020-05-08 log file path: +DMLOG/log/rac0_log01.log log file path: +DMLOG/log/rac0_log02.log log file path: +DMLOG/log/rac1_log01.log log file path: +DMLOG/log/rac1_log02.log write to dir [+DMDATA/data/rac]. create dm database success. 2020-04-24 16:39:03
將節點一的配置文件復制到節點二:
[dmdba@dmrac1 data]$ scp -r rac1_config 10.18.13.162:`pwd` The authenticity of host '10.18.13.162 (10.18.13.162)' can't be established. RSA key fingerprint is 89:fc:3e:e3:2d:27:94:07:0e:6b:fc:c5:e8:89:44:1f. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '10.18.13.162' (RSA) to the list of known hosts. dmdba@10.18.13.162's password: sqllog.ini 100% 479 0.5KB/s 00:00 dm.ini 100% 40KB 39.8KB/s 00:00 dmmal.ini 100% 204 0.2KB/s 00:00 [dmdba@dmrac1 data]$
十四、啟動數據庫服務器
1、在2個節點分別注冊DM 數據庫服務:
節點一:
[root@dmrac1 init.d]# /dm7/script/root/dm_service_installer.sh -t dmserver -i /dm7/data/rac0_config/dm.ini -d /dm7/data/dmdcr.ini -p rac1 Move the service script file(/dm7/bin/DmServicerac1 to /etc/rc.d/init.d/DmServicerac1) Finished to create the service (DmServicerac1)
節點二:
[root@dmrac2 ~]# /dm7/script/root/dm_service_installer.sh -t dmserver -i /dm7/data/rac1_config/dm.ini -d /dm7/data/dmdcr.ini -p rac2 Move the service script file(/dm7/bin/DmServicerac2 to /etc/rc.d/init.d/DmServicerac2) Finished to create the service (DmServicerac2)
2、啟動數據庫
[root@dmrac1 init.d]# service DmServicerac1 start Starting DmServicerac1: [ OK ] [root@dmrac2 ~]# service DmServicerac2 start Starting DmServicerac2: [ OK ]
手工啟動命令如下,手工啟動后窗口不能關閉,所以
./dmserver /dm7/data/rac0_config/dm.ini dcr_ini=/dm7/data/dmdcr.ini ./dmserver /dm7/data/rac1_config/dm.ini dcr_ini=/dm7/data/dmdcr.ini
15 連接數據庫驗證
15.1 配置服務名文件
[dmdba@dmrac1 ~]$ vi /etc/dm_svc.conf TIME_ZONE=(480) rac=(10.18.13.161:5236,10.18.13.162:5236) SWITCH_TIME=(10000) SWITCH_INTERVAL=(10) TIME_ZONE=(480) LANGUAGE=(en) [dmdba@dmrac2 ~]$ vi /etc/dm_svc.conf TIME_ZONE=(480) rac=(10.18.13.161:5236,10.18.13.162:5236) SWITCH_TIME=(10000) SWITCH_INTERVAL=(10) TIME_ZONE=(480) LANGUAGE=(en)
15.2 連接RAC集群
節點一:
[dmdba@dmrac1 ~]$ disql SYSDBA/SYSDBA@rac
Server[10.18.13.161:5236]:mode is normal, state is open
login used time: 10.365(ms)
disql V7.1.6.46-Build(2018.02.08-89107)ENT
Connected to: DM 7.1.6.46
SQL> select instance_name from v$instance;
LINEID INSTANCE_NAME
---------- -------------
1 RAC0
used time: 18.248(ms). Execute id is 807.
SQL> select * from v$rac_ep_info;
LINEID EP_NAME EP_SEQNO EP_GUID EP_TIMESTAMP EP_MODE EP_STATUS
---------- ------- ----------- -------------------- -------------------- ------- ---------
1 RAC0 0 2067076818 2067077298 MASTER OK
2 RAC1 1 2067098084 2067098537 SLAVE OK
used time: 2.741(ms). Execute id is 808.
節點二:
[dmdba@dmrac2 ~]$ disql SYSDBA/SYSDBA@rac Server[10.18.13.162:5236]:mode is normal, state is open login used time: 16.835(ms) disql V7.1.6.46-Build(2018.02.08-89107)ENT Connected to: DM 7.1.6.46 SQL> select instance_name from v$instance; LINEID INSTANCE_NAME ---------- ------------- 1 RAC1 used time: 106.703(ms). Execute id is 1. SQL> select * from v$rac_ep_info; LINEID EP_NAME EP_SEQNO EP_GUID EP_TIMESTAMP EP_MODE EP_STATUS ---------- ------- ----------- -------------------- -------------------- ------- --------- 1 RAC0 0 2067076818 2067077305 MASTER OK 2 RAC1 1 2067098084 2067098544 SLAVE OK used time: 7.358(ms). Execute id is 2.
看完了這篇文章,相信你對“DM7如何使用DMASM安裝DMRAC”有了一定的了解,如果想了解更多相關知識,歡迎關注億速云行業資訊頻道,感謝各位的閱讀!
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。