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 needoraclepki.jar
,osdt_cert.jar
andosdt_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 !