sample app obiee 12c RPD online — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

sample app obiee 12c RPD online

Received Response
53
Views
11
Comments
Sunny86
Sunny86 Rank 6 - Analytics Lead

Dear All,

I am trying to open the sample app 12c RPD online from windows. Can somebody help me to configure the ODBC for it. I have tried local host - weblogic - Admin123 - 7792 and 127.0.0.1 - weblogic - Admin123-7792 as server username  password and port respectively. But it is throwing socket communication error.

Thank you

TN

«1

Answers

  • Hi,

    localhost or 127.0.0.1 will not get you anywhere because SampleApp isn't on your Windows environment.

    First thing: find the IP address of the vm and test it to make sure it works (so open your browser in the Windows session and open the <ip>:7780/analytics page of SampleApp by using the IP address).

    The IP depends on how you configured the network of your VM.

    Second thing double check which port to use. If you open Enterprise Manager inside SampleApp (the <ip>:7001/em) you can see which port is the BI Server component is listening to. That one will be the port.

    Username and password are right

    Also keep in mind the Windows firewall can give you issues, so if you can ping the IP but not open the pages in your browser check the Windows firewall ...

    (I guess the firewall of the VM is off by default, can't remember actually :s )

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    The documents included with SampleApp VM give the instructions to set up networking and connect you client tools to the VM.

    http://www.oracle.com/technetwork/topics/virtualization/whatsnew/sav607p-deploymentguide-3122964.pdf

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    THank you both. Let me check and revert to you.. I couldnt check it last week because of hectic working days.

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    Dear All,

    This is how I was trying to open RPD. I am very new to OBIEE 12c and sample app. Any help will be highly appreciated.

    Error Message.JPG

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Are you running your VM with NAT and port forwarding as the document linked by Thomas states?

    If that doesn't work maybe go for host-only

    pastedImage_0.png

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    I was trying to configure port forwarding as the video. What should be the port number to be provided? ..

    pastedImage_1.png

  • Why not adopt a "keep it simple solution" ?

    No port forwarding required, you can keep your first network adapter as NAT but you add a second one as host-only.

    SampleApp will have end up having a second IP like 192.168.56.101 (it's DHCP starting at 101 on the 192.168.56.1/24 network).

    SampleApp keep access to internet if needed via the NAT interface, but you can connect to it using the "host only" IP. Ports will be normal ones without having to play with port forwarding.

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    I am able to view obiee analytics and em in my windows after setting port forwarding with  correct port number.  But RPD not yet.

    pastedImage_0.png

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    But how can I open my RPD online from my windows machine ...

  • https://en.wikipedia.org/wiki/KISS_principle

    It has been said few times: use a host-only connection (as main or 2nd network adapter).

    No need of any port mapping, no NAT, no nothing, no issues.

    Your VM will have a new IP (probably 192.168.56.101) and that's the IP you will use to connect.