Updating the tnsnames.ora File With OAS

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

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

Related Topics