Verifying a TNSNAMES.ora File Exists

Previous TopicNext TopicContents

You will need a TNSNAMES.ora file for the Star Schema to function properly:

  1. Browse to <OBI_Home>\Oracle_BI1\network\admin (the default OBI_Home is \Oracle\Middleware).
  2. Locate the TNSNAMES.ora file.

    If it exists, you can continue to the next section.

    If it does not exist, you will need to create it.

  3. To create a TNSNAMES file:
    1. Copy it from any existing Oracle Home.
    2. Place it in the <OBI_Home>\Oracle_BI1\network\admin location mentioned above.
    3. Edit the file you copied with a text editor.
    4. Add the following reference to the TNSNAMES.ora file:

      STARDW =

      (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <portnumber>))

      (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = <ServiceName>)

      )

      )

      where hostname is the IP address or name where the Star database is installed, portnumber is the port number where the Star database is installed, and ServiceName is the service name you used when you installed the Star database

Related Topics

Configuring P6 Analytics with OBI

Overview of OBI

Installing OBI

Prerequisites for Upgrading P6 Analytics

Resolving Multiple Oracle Homes to Work with OBI

Verifying the STARDW Alias

Updating the OraclePrimaveraAnalytics.rpd with the Correct Staruser Name and Password

Updating the OraclePrimaveraAnalytics.rpd for P6

Configuring OBI 11.1.1.6 to Use the P6 Analytics Repository Definition (.rpd) and Catalog

Configuring OBI 11.1.1.7 to Use the P6 Analytics Repository Definition (.rpd) and Catalog



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014