Oracle Communication: Failed to connect to server or failed to parse connect string

[chauhannaman98]

Hi all,

I am using Oracle (MDA) VBO to connect with Oracle DB.

On set connection, it generates the connection string: Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST="hostname(not IP address)")(PORT=1521))(CONNECT_DATA=(SERVICE_NAME="DB name")));User Id="username";Password="passsword";

But, on running Get Collection action after this, it is throwing me an error: Oracle Communication: Failed to connect to server or failed to parse connect string.

I am able to connect with SQL developer and execute queries but it's failing here.

What can be done for this?

[chauhannaman98]

Update: I tried using IP address instead of hostname in ConnectionName. It's still failing.

[LeonardoSQueiroz]

Hello,

Is the ODAC driver installed?

Regards,

[chauhannaman98]

Hi @LeonardoSQueiroz ,

Thanks for replying!

I think I haven't installed anything like that.

How do I check and install ODAC driver on the machine?

Thanks!

[faheemsd]

Dear @chauhannaman98 

Please check with ORACLE MDA connection details with the respective db team such as connection name, hostname (Ip address) , Port number and Password.

Used those values that are available in the Oracle MDA configuration.
Test this connection with Set connection.
Requesting you to get the Oracle MDA queries from the respective team because normal SQL queries doesn't support with the ORACLE MDA SQL VBO.