7.9.4 Configuring ORACLE ANALYTIC SERVER (OAS) 5.9 Connection Pool

ORACLE ANALYTIC SERVER (OAS) 5.9:

To configure the Connection Pool of the repository, follow these steps:
  1. Open the same Repository (as in the previous step) on the Windows machine. The Oracle BI Administration Tool - TF80810.rpd windows is displayed.
  2. Expand the FSI_TF folder in the Physical section.
  3. Double-click Connection Pool to open the Connection Pool Properties window.
  4. Enter the following in the Data Source Name text box of the Connection Pool Properties window after modifying <Database Server Host Name> and <Database Name> Data Source Name = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<Database Server HostName>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED) (SERVICE_NAME=<Database Name>)))
  5. Enter the Atomic Schema user in the User name text box.
  6. Enter the Atomic Schema user password in the Password text box.
  7. Click OK.
  8. Expand the folder and test connection for any one table name by Right Click > view data.
  9. Perform similar changes in the Connection Pools for all remaining folders in the Physical Layer by providing the following schema details for all Connection Pools:
    • FSI_TF >Atomic Schema
  10. Select Save option from the File menu. The following message is displayed: Do you want to check global consistency?.
  11. Click Yes. The following message is displayed: Consistency check didn’t find any errors, warning or best practices violations.
  12. Click OK.