Metabase deployed on Oracle Cloud Free Tier. using wallet Connect to free Oracle Autonomous Database

Steps

1 download metabase

wget https://downloads.metabase.com/v0.44.3/metabase.jar

2、run

java -jar metabase.jar

After running and exiting, you can see plugins in directory,We need to save the downloaded ojdbc driver in this directory.

3、download oracle jdbc driver

from https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html download ojdbc11-full.tar.gz

Remember, be sure to download the ojdbcxx-full driver file, because we need not only ojdbc11.jar, also need oraclepki.jar, osdt_cert.jar and osdt_core.jar using wallet

4、run metabase with jvm parameters

java -classpath ./plugins/oraclepki.jar:./plugins/osdt_cert.jar:./plugins/osdt_core.jar:. \
-Doracle.net.tns_admin=/data/instantclient_19_10/network/admin \
-Doracle.net.wallet_location="(SOURCE=(METHOD=file)(METHOD_DATA=(DIRECTORY=/data/instantclient_19_10/network/admin)))" \
-Doracle.net.ssl_server_dn_match=true -jar metabase.jar

参数：

• Doracle.net.tns_admin : instantclient directory
• Doracle.net.wallet_location : wallet file directory

5、Add Database Connect

Open the tnsnames.ora file in the wallet package, and check the configuration of any one of high, low, and medium, and take the values:

• host
• service_name

Metabase Config panel Add Oracle Database ，as the picture shows：

Save config ！