Updating the tnsnames.ora File With Oracle Analytics Server

As part of a standard installation of Oracle Analytics Server, 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 Oracle Analytics Server and any database server and instance to which Oracle Analytics Server 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 Oracle Analytics Server tnsnames.ora file for Primavera Data Warehouse, complete the following steps on the server where Oracle Analytics Server is installed:

Go to <BI Domain>\config\fmwconfig\bienv\core where <BI Domain> is the path to your Oracle Analytics Server domain.
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.

Related Topics