OBIEE 12C On virtual server...

Question

Hi there

I have been running OBIEE 12.2.1.1 on virtual windows 2012 64bit R2 servers, with a static IP. Everything appears to work except one thing. OVA can't connect to our Exadata or anything other kind of Oracle DB. I can connect and use the subject areas available to answers, but not a direct DB connection. I have a SR with Oracle, and they suspect that it might be because of my virtual servers. Just wondering in anybody have any luck connecting to an Oracle DB not residing on the same server as the OBIEE installation, on a virtual server? If yes, did you do anything to make this work?

/Jacob

user10657778 · Answer

Hello,

Any update on this? I am facing the same issue.

Jonni

Thomas Dodds · Answer

What does TNSPing tell you when you try from the VM across the wire to your Oracle DB?  If it time-out, then it might be a firewall issue ... I've run into similar when using a cloud BI tool against a remote Oracle DB.

rmoff · Answer

Can you get netcat (or similar) on Windows, and try connecting to the Oracle listener port directly from your windows server? That way you can at least isolate the problem to within OBIEE or within the virtualisation platform

Can you ping unknownhost.example.com from your Windows machine? What about accessing it with SQL Developer from the Windows machine?

Does it work if you use the IP instead of hostname?