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.
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.
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.
