OBIEE 12c DSN Configuration — Oracle Analytics

Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

OBIEE 12c DSN Configuration

Received Response
21
Views
5
Comments
3066492
3066492 Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

I'm running into issues trying to Add a User DSN. When creating a DSN, I continue receiving an error after entering in my Login ID and password. Has anyone ran into this issue and know how to resolve it?

Answers

  • rmoff
    rmoff Rank 6 - Analytics Lead 
     I continue receiving an error

    How To Ask Questions The Smart Way

  • 3066492
    3066492 Rank 3 - Community Apprentice

    I receive a [nQSError:12017] Unexpected socket read timeout: connection terminated by network. I also receive a [nQSError:12008] Unable to connect to port on machine.

  • rmoff
    rmoff Rank 6 - Analytics Lead

    Your OBIEE server isn't running, or you've not put the correct server details in for your DSN.

  • Anjum Ara
    Anjum Ara Rank 4 - Community Specialist

    Make sure your Oracle DB is running on the specified port. You can always check by running following command on cmd prompt

    TELNET <DBSERVERNAME> <DBPORT>

    This shows first if the port is open between the machine you are trying to setup DSN to the Oracle DB.

    If it enters a blank page that means the DB is up and running and ports are connecting.

  • rmoff
    rmoff Rank 6 - Analytics Lead

    If you're setting up an Oracle BI DSN, you don't want to be putting the Oracle DB port in there - that *will* throw an error