databaseoracle-databasecatalogwarehouseapache-doris

"ONS configuration failed" when creating Oracle Catalog in Apache Doris

When I use Apache Doris to create Oracle catalog then query Oracle data via my catalog, I get an error: ONS configuration failed.

Can anyone help me resolve this error?

Steps to reproduce are:

  1. Create Oracle catalog in Apache Doris:
CREATE CATALOG oracle_catalog PROPERTIES (
    'type' = 'jdbc',
    'user' = 'my_oracle_user_name',
    'password'='my_oracle_upassword',
    'jdbc_url' = 'jdbc:oracle:thin:@example.net:1521:orcl',
    'driver_url' = 'ojdbc8.jar',
    'driver_class' = 'oracle.jdbc.driver.OracleDriver'
)
  1. Then use catalog to query Oracle:
switch oracle_catalog; 
show databases; 
select * from my_db_name.my_table_name;
  1. The I encounter this error:
ONS configuration failed

What should I do to fix this error?

I have asked this question in the Apache Doris community, but I can't find a solution. I just want to query Oracle via Doris catalog.

Solution

  • Add -Doracle.jdbc.fanEnabled=false to JAVA_OPTS in your BE config(be.conf)，then restart BE, or upgrade the driver to ojdbc8-19.23.0.0.jar.