As part of a standard installation of Oracle Business Intelligence (OBI), a file called tnsnames.ora is installed. The tnsnames.ora file is an Oracle database configuration file that contains network service names mapped either to connect descriptors for the local naming method or to listener protocol addresses. This means that the tnsnames.ora file is responsible for resolving the connection between the OBI server and any database server and instance to which OBI needs to connect, including the Primavera Data Warehouse instance and server. Therefore, the tnsnames.ora file requires an entry for the Primavera Data Warehouse schema in order to make this connection. See https://docs.oracle.com/database/121/NETRF/tnsnames.htm#NETRF007 for details on the tnsnames.ora file.
To create an entry in the OBI tnsnames.ora file for Primavera Data Warehouse, complete the following steps on the server where OBI is installed:
- Go to <BI Domain>\config\fmwconfig\bienv\core where <BI Domain> is the path to your OBI domain (for example, c:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi).
- Open TNSNAMES.ora in a text editor.
If tnsnames.ora does not exist, create or copy it from another location into this directory.
- Create the following entry for the Primavera Data Warehouse connection:
<STARDW> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <port number>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <Service Name>))
)
where:
<STARDW> is the net_service_name for this connection. This name can be any name you choose. You will need this name later to configure the database connection name in the repository.
<hostname> is the IP address or name where the Primavera Data Warehouse database is installed.
<portnumber> is the port number where the Primavera Data Warehouse database is installed.
<ServiceName> is the service name you used when you installed the Primavera Data Warehouse database.
- Save tnsnames.ora and close it.