CREATE CATALOG oracle failed to get database name list from jdbc

[woaixiaosunsun]

doris version:2.0.3

oracle version:11g,12C

jar: ojdbc8-19.23.0.0.jar

create catalog sql:
CREATE CATALOG oracle PROPERTIES (
"type"="jdbc",
"user"="BFBHDD8",
"password"="SKPBJORADHHZ",
"jdbc_url" = "jdbc:oracle:thin:@ip:1521:ERP",
"driver_url" = "ojdbc8-19.23.0.0.jar",
"driver_class" = "oracle.jdbc.driver.OracleDriver"
);

create catalog successed, but ’show databases from oracle;‘ , [HY000][1105] failed to get database name list from jdbc

[ixzc]

what if you firstly switch oracle catalog , and show your tables ?

[wi24rd]

Still can't get data.

[zy-kkk]

Sorry, 2.0.3 is a very old version. I may not be able to troubleshoot it on this version. You can upgrade to the latest release version of the 2.0 branch for testing. Of course, you can also try to check the context of this error in fe.log to see if you can find some detailed reasons, such as incorrect password or network failure.