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建立一個專用的系統使用者。具體操作詳見
四、繫結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.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26015009/viewspace-2690090/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- DM7使用裸裝置搭建DMRAC
- DM8使用共享儲存DMASM搭建DMRACASM
- DM8 使用裸裝置搭建DMRAC
- Oracle Linux 7.1中安裝達夢資料庫DM7OracleLinux資料庫
- cocoapods安裝/解除安裝/使用
- DM7使用disql管理備份SQL
- JupyterLab安裝使用
- Nginx 安裝使用Nginx
- docker安裝使用Docker
- Anaconda 安裝、使用
- 安裝使用VUEVue
- kibana安裝使用
- tomcat安裝使用Tomcat
- jupyter安裝使用
- ElasticSearch的安裝和使用,Postman的安裝,Kibana的安裝,EShead外掛的安裝ElasticsearchPostman
- 安裝及使用RSSHub
- hydra 安裝和使用
- 3.13 truffle 安裝使用
- Docker安裝及使用Docker
- nvm 安裝及使用
- KubernetesNginxIngress安裝與使用Nginx
- Windows安裝使用OpensslWindows
- curl 安裝與使用
- Centos安裝使用ChromedriverCentOSChrome
- 使用kubeadm安裝kubernetes
- MITMF安裝與使用MIT
- ActiveMq安裝和使用MQ
- Supervisor 安裝與使用
- Samba安裝與使用Samba
- 使用docker安裝nginxDockerNginx
- Mac 安裝使用 NgrokMac
- nacos安裝與使用
- kafka 安裝到使用Kafka
- 安裝python並使用Python
- Mysql安裝使用教程MySql
- GitBook的安裝使用Git
- docker安裝和使用Docker
- Presto安裝與使用REST