注册

共享集群的每个节点如何单独访问

董小姐 2023/11/20 559 8 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
共享集群的每个节点如何单独访问,登录提示如下报错

[dmdba@localhost ~]$ disql SYSDBA:SYSDBA@192.168.40.180:5236
 USAGE:CONN[ECT] <logon>

 <logon> ::= {<username>[/<password>] | /}[@<connect_identifier>][<option>] [<os_auth>]
 <connect_identifier> ::= [<svc_name> | Host[:Port] | <unixsocket_file>]
 Host ::= if ipv6 address,[] is needed. For example [fe80::1e6f:65ff:fed1:3724%6]
 <unixsocket_file> ::= If INET_TYPE is UNIXSOCKET, then <connect_identifier> must be unixsocket file path name. For example, /data/sdb/DAMENG/foo.sock
 <option> ::= #{<extend_option>=<value>[,<extend_option>=<value>]...}
 <os_auth> ::= AS {SYSDBA|SYSSSO|SYSAUDITOR|USERS|AUTO}

 <extend_option>            <value>
 MPP_TYPE                    GLOBAL/LOCAL
 INET_TYPE                   UDP/TCP/IPC/RDMA/UNIXSOCKET
 SSL_PATH                    <path_str>
 SSL_PWD                     <pwd_str>
 PROXY_CLIENT                <user_str>
 GWDSN                       <GATEWAY DSN>
 UKEY_NAME                   <ukey_name_str>
 UKEY_PIN                    <ukey_pin_str>
 SHAKE_CRYPTO                <shake_crypto_str>
 USER_NEW_PWD                <new_pwd>
version: 03134284044-20230417-187846-20040
DISQL usage1:disql -h|help  show disql version and help message

DISQL usage2:disql [ [<option>] [<logon> | {/NOLOG}] [<start>] ]

 <option> ::= [-L] [-S]

  -L only try to login once
  -S set no show model, hidden disql flag

 <logon> ::= {<username>[/<password>] | /}[@<connect_identifier>][<option>] [<os_auth>]
 <connect_identifier> ::= [<svc_name> | Host[:Port] | <unixsocket_file>]
 Host ::= if ipv6 address,[] is needed. For example [fe80::1e6f:65ff:fed1:3724%6]
 <unixsocket_file> ::= If INET_TYPE is UNIXSOCKET, then <connect_identifier> must be unixsocket file path name. For example, /data/sdb/DAMENG/foo.sock
 <option> ::= #{<extend_option>=<value>[,<extend_option>=<value>]...}
 <os_auth> ::= AS {SYSDBA|SYSSSO|SYSAUDITOR|USERS|AUTO}

 <extend_option>            <value>
 MPP_TYPE                    GLOBAL/LOCAL
 INET_TYPE                   UDP/TCP/IPC/RDMA/UNIXSOCKET
 SSL_PATH                    <path_str>
 SSL_PWD                     <pwd_str>
 PROXY_CLIENT                <user_str>
 GWDSN                       <GATEWAY DSN>
 UKEY_NAME                   <ukey_name_str>
 UKEY_PIN                    <ukey_pin_str>
 SHAKE_CRYPTO                <shake_crypto_str>
 USER_NEW_PWD                <new_pwd>

 <start> ::= <`sql bash> | &lt;direct cmd> | &lt;direct sql> run disql bash

 /NOLOG option can run disql, while not connected to DM server

 &lt;`sql bash>::= `&lt;filename>[&lt;parameter> { &lt;parameter>}...]"

 &lt;direct sql>::= -e "&lt;SQL statement>[;&lt;SQL statement>]"

 &lt;direct cmd>::= -c "&lt;set command>"

回答 0
暂无回答
扫一扫
联系客服