Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

[nQSError: 17014] Could not connect to Oracle database

Received Response
253
Views
3
Comments
User_S35K3
User_S35K3 Rank 4 - Community Specialist
edited Aug 13, 2024 5:24PM in Oracle Analytics Forum

Hi,

I am working on OBIEE 12.2.1.3.0. I am using oracle DB version "Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production" as source. I am able to import tables in RPD and can create schema. But when I create any report from these tables I am facing the below error.

State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 12170, message: ORA-12170: TNS:Connect timeout occurred at OCI call OCIServerAttach. (HY000)
State: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle database. (HY000)

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    You are having a database issue, not an OBIEE issue: ORA-12170: TNS:Connect timeout occurred

    Your database can't be reached from the OBIEE server with the parameters your provided.

    When you import tables in the RPD, this is done on the client on which you work. If your client knows where to find the database you defined it will import tables.

    But can the OBIEE server connect to this same database? Often firewalls rules are different, or the OBIEE server just has no idea of the TNS settings you uses even if those worked on your desktop/laptop.

    Debug the database connectivity from the OBIEE server, check it's accessible, check if the TNS name you used is known to OBIEE etc.

  • User_S35K3
    User_S35K3 Rank 4 - Community Specialist

    Hi,

    Yes there was an issue from OBIEE server that some IP of DB was blocked from OBIEE server, after opening these IPs issue is resolved.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Good for you.

    Could you please mark and close the thread now? This will help others with same/similar requests to easily find useful information.

    At the moment it's still This question is Not Answered.