为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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> | <direct cmd> | <direct sql> run disql bash
/NOLOG option can run disql, while not connected to DM server
<`sql bash>::= `<filename>[<parameter> { <parameter>}...]"
<direct sql>::= -e "<SQL statement>[;<SQL statement>]"
<direct cmd>::= -c "<set command>"
/dmdb8/dmdbms/dsc_config/dminit.ini里面SYSDBA_PWD后面的内容是设置的密码
账号/密码 即 SYSDBA/SYSDBA,不是SYSDBA:SYSDBA