6 Replies Latest reply: Jul 30, 2013 8:52 AM by ziusudra RSS

    BI Server DSN Configuration Issue

    Rudoph Wang
      Hi, All

      I am configuring BI server administration tool and come across issue.
      The BI server is installed on VM Oracle Linux 5.9. The installation is successful, e. g. AdminServer, bi_server1 are up. BIEE home and be opened and login from client machine. After installing biee_client_install_x64, and configuring ODBC, I got problem.

      The setup is like:

      On Oracle BI server DSN Configuration wizard,
      Name: BIvmOracle64
      Clustered DSN is select.
      Primary Controller: vmOracle64 (hostname of vm box, which can ping from client computer.
      Port: 9704

      After clicking Test Cluster Connect, I got error message

      [nQSError: 12017] Unexpected socket read timeout: connection terminated by network, e. g. by the firewall
      [nQSError: 12008] Unable to connect to port 9704 on machine vmOralce64
      [nQSError: 69018] Connection Succeeded but vmOracle64:9704 failed to respond
      [nQSError: 69006] Test connection to both the primary and secondary Cluster Controller failed.

      Any help will be appreciated.

      Thanks.
      Rudoph W
        • 1. Re: BI Server DSN Configuration Issue
          Catch 22
          The available networking options in VirtualBox depend on your selected network adapter type and firewall configuration. The default NAT adapter, for instance, cannot be used to respond to incoming connections unless you configure port forwarding. Since you aren't providing any information about your network configuration, I'm afraid no further help is possible. You can disable the firewall of Oracle Linux to see if it is the culprit using the command "service iptables stop". For questions about VirtualBox I suggest to post at forums.virtualbox.org or check the manual, which explains the networking options in detail.
          • 2. Re: BI Server DSN Configuration Issue
            EdStevens
            Rudoph Wang wrote:
            Hi, All

            I am configuring BI server administration tool and come across issue.
            The BI server is installed on VM Oracle Linux 5.9. The installation is successful, e. g. AdminServer, bi_server1 are up. BIEE home and be opened and login from client machine. After installing biee_client_install_x64, and configuring ODBC, I got problem.

            The setup is like:

            On Oracle BI server DSN Configuration wizard,
            Name: BIvmOracle64
            Clustered DSN is select.
            Primary Controller: vmOracle64 (hostname of vm box, which can ping from client computer.
            Port: 9704

            After clicking Test Cluster Connect, I got error message

            [nQSError: 12017] Unexpected socket read timeout: connection terminated by network, e. g. by the firewall
            [nQSError: 12008] Unable to connect to port 9704 on machine vmOralce64
            [nQSError: 69018] Connection Succeeded but vmOracle64:9704 failed to respond
            [nQSError: 69006] Test connection to both the primary and secondary Cluster Controller failed.

            Any help will be appreciated.

            Thanks.
            Rudoph W
            If, as Dude suggests, you are running this under VirtualBox, you will have some networking challenges. The best solution I've come up with (for general use, not your specific question) is to create my virtual machines with two nics. the first is the default of NAT (which in VBox also means it has to be dhcp) is bound to eth0. the second is 'host-only', is bound to eth1, and given a proper fixed IP address. You can read more detail [url http://edstevensdba.wordpress.com/category/personal-test-systems/]here
            • 3. Re: BI Server DSN Configuration Issue
              Rudoph Wang
              Thanks, Dude, for response.

              The vm net work setup as Bridged Adapter and vm Linux uses static IP. Window host file has entry for IP, host, and alias. I do stopped the firewall on vm Linux and the same error message comes.
              • 4. Re: BI Server DSN Configuration Issue
                Rudoph Wang
                Hi, Steven
                Thanks for response. When using Bridged Adapter and static IP on VM, my network works. I can ping from VM to host and VM to another physical linux server with static IP. When using your approach, vm can neither ping host Window 7 and Linux server with static IP.
                After installing OBIEE, Browser based Enterprise Manager and BI page can open from all workstations in the network. My issue is when setting up ODBC from host window trying to connect vmOracle64:9704, which can be opened successfully from all workstation.

                Any idea?
                • 5. Re: BI Server DSN Configuration Issue
                  Rudoph Wang
                  Thanks all. Issue is resolved.
                  • 6. Re: BI Server DSN Configuration Issue
                    ziusudra

                    Please write the solution