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.(ADDRESS = (PROTOCOL = TCP)(HOST = ITQALAB2)(PORT = 1521))
(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
- Log on to Server Administration Tool.
- In the physical layer, expand the appropriate database cylinder icon.
- Double-click the appropriate OLTP Connection Pool to open the Connection pool window.
- In the Connection Pool window, check that the following is true:
- In the Oracle folder, open the tnsnames.ora file.
- Check that a valid entry name exists:
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Installation and Configuration Guide Published: 09 September 2004 |