[nQSError: 17014] Could not connect to Oracle database

Question

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)

Gianni Ceresa · Answer

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.

User_S35K3 · Answer

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 · Answer

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.