Chat2DB icon indicating copy to clipboard operation
Chat2DB copied to clipboard

Bug: options for conncet to Oracle database as SYSDBA or SYSOPER

Open phanxlee opened this issue 2 years ago • 0 comments

Chat2DB Version

2.0.1

Describe the bug

连接Oracle的时候,如果用sys用户连接,没有以 SYSDBA 或者 SYSOPER 的选项。

023-07-07 03:15:54.453  INFO 1 --- [io-10824-exec-1] a.chat2db.server.start.log.EasyLogSink  .67 : e1bf1a66-d577-4594-8443-84e9ec407a0b | http : POST|/api/connection/datasource/pre_connect|643|{"ssh":{"use":"false","host":"","port":"","userName":"","localPort":"","password":""},"alias":"[email protected]","host":"1.1.1.1","port":"1521","sid":"orcl","driver":"thin","authentication":1,"user":"sys","password":"sys","url":"jdbc:oracle:thin:@1.1.1.1:1521:orcl","extendInfo":[],"ConnectionEnvType":"DAILY","type":"ORACLE"}|{"success":false,"errorCode":"ORA-28009: connection as SYS should be as SYSDBA or SYSOPER\n","errorMessage":null,"traceId":null}

phanxlee avatar Jul 07 '23 03:07 phanxlee