Set Up Database Connectivity Using OCI

Create an entry in the BI Server's tnsnames.ora file with the name and connection details of the LSH database server.

Test the connection by trying to connect to the Oracle Life Sciences Data Hub database using SQL*Plus as apps.