Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Installation and Configuration Guide > Installing Siebel Analytics Software in the Windows Environment > Process of Installing Siebel Analytics on Separate Machines on Windows >

Configuring Oracle Databases for the Siebel Analytics Server Machine

---

This task is part of the Process of Installing Siebel Analytics on Separate Machines on Windows. It applies only if the native database you are running is Oracle.

If your native database is Oracle, the machine running Siebel Analytics Server must have the Siebel Analytics-supported Oracle Client installed. In the tnsnames.ora file, make sure the entry name matches the Siebel Analytics repository Data Source Names defined in the connection pools for all physical Oracle databases.

For example, in the following example of a tnsnames.ora entry, the corresponding Siebel Analytics repository connection pool Data Source Name is ITQA2.

ITQA2 =

 (DESCRIPTION =

  (ADDRESS_LIST =

   (ADDRESS = (PROTOCOL = TCP)(HOST = ITQALAB2)(PORT = 1521))

  )

 (CONNECT_DATA =

  (SERVICE_NAME = ITQALAB2.corp)

  )

 )

Confirming That Connection Pool Settings Refer to the Oracle Database

This task is part of the Process of Installing Siebel Analytics on Separate Machines on Windows. It applies only if the native database you are running is Oracle.

The following procedure shows how to check your repository connection pool settings against the Oracle tnsnames.ora settings.

To check that an Oracle database refers to the Siebel Analytics Server machine

1. Log on to Server Administration Tool.
2. In the physical layer, expand the appropriate database cylinder icon.
3. Double-click the appropriate OLTP Connection Pool to open the Connection pool window.
4. In the Connection Pool window, check that the following is true:
   • The Call Interface field displays the appropriate value for the release of Oracle being used.
   • The Data Source Name displays the Oracle alias that you have defined in the tnsnames.ora setting.

     NOTE:  This Data Source Name is not the DSN name defined in Settings > Control Panel > Data Sources (ODBC).

5. In the Oracle folder, open the tnsnames.ora file.
6. Check that a valid entry name exists:
   • The name matches the Siebel Analytics repository's connection pool settings for the Data Source Name.
   • The name specifies the targeted Oracle physical database.

Bookshelf Home | Contents | Index | Search | PDF