Analytics Software

Hi there,

I'm experiencing trouble with the Oracle Data Warehouse Administration Console (DAC) server connection hanging in my Oracle BI Apps 7.9.6 install.

Architecture*

Applications Server - Machine A (Oracle Connection Services 10g R2 + Informatica 8.6.0 & HotFix 4.0 + DAC 10.1.3.4.1 services) = Linux RHEL 64-bit

Database Server - Machine B (Oracle BI Apps Data Warehouse OBAW + DAC Repository + Informatica Repository) = Linux RHEL 64-bit

Client - Machine C (BI Apps 7.9.6 + Informatica 8.6.0 & HotFix 4.0 client + DAC 10.1.3.4.1 client) = Windows x86 32-bit)

Issue*

After successfully following the Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users Version 7.9.6 (E14217-01) documentation I get to section 4.13 Configuring the DAC Server and I cannot create a successful connection to the DAC Server from the Data Warehouse Administration Console on my client machine.

I can confirm that I have started the DAC services on the Linux server with the . ./startserver.sh command. The icon on the Data Warehouse Administration Console turns Orange (Idle), but when I double click the icon a message box appears with the title "Server Log" but seems to hang.

If I stop the DAC services on the Linux server with the . ./stopserver.sh command the Server Log message box closes and a new message box appears stating:

*"Error: can't establish connection to DAW Server!"*

I have tried using the IP address and the actual server name as defined in the Hosts file as the DAC Server Host in the DAC System Properties but I receive the same error message.

I can also confirm that I ran the serverSetupPrompt.sh shell script successto configure the connection between the DAC Server and the DAC Repository.

Any suggestions or help greatly appreciated.

Kind Regards,
Gary.