CREATE CATALOG oracle failed to get database name list from jdbc #36546
Replies: 3 comments 1 reply
-
|
what if you firstly switch oracle catalog , and show your tables ? |
Beta Was this translation helpful? Give feedback.
-
|
Still can't get data. |
Beta Was this translation helpful? Give feedback.
-
|
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. |
Beta Was this translation helpful? Give feedback.
-
|
|
Beta Was this translation helpful? Give feedback.
-
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
Beta Was this translation helpful? Give feedback.
All reactions