Issue: Connecting Report Builder to Oracle database

[AsNa_92]

Hi ..

I'm trying to connect from Report Builder to Oracle database, however it throws error message.

I have installed ODAC 12.2 and 18 and I have added the connection to the tnsnames.ora file, but still facing below error message:

Please can someone help!

[AsNa_92]

any luck in this issue??

[Anonymous]

Hi @AsNa_92 

When connecting to an Oracle database from Report Builder, you appear to be experiencing an error with ORA-12154: TNS: unable to resolve the connection identifier specified. This usually indicates a problem with the TNS configuration. You can try the following steps:

Ensure that the entry for your database in the tnsnames. ora file is correct. It should look something like this:

YOUR_DB_ALIAS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = your_host)(PORT = your_port))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = your_service_name)
    )
  )

Make sure there are no typos in the alias name you are using in Report Builder.

Ensure that the TNS_ADMIN environment variable is set to the directory containing your tnsnames.ora file. This helps Oracle locate the configuration file.

Since you have installed both ODAC 12.2 and 18, ensure that the correct version is being used by Report Builder. Sometimes, having multiple versions can lead to conflicts.

Use the Oracle SQL*Plus or Oracle Net Manager to test the connection using the same TNS alias. This can help confirm whether the issue is with Report Builder or the TNS configuration itself.

Ensure that there are no firewall rules blocking the connection to the Oracle server. You might want to check if you can ping the database server from your machine.

Check the Oracle log files for any additional error messages that might provide more context on the issue.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AsNa_92]

Hi @Anonymous 

Thank you for your reply.

I have some questions regarding the steps you mentioned:

"Make sure there are no typos in the alias name you are using in Report Builder."

what do you mean no typos?

"Ensure that the TNS_ADMIN environment variable is set to the directory containing your tnsnames.ora file. This helps Oracle locate the configuration file."

How can I do that? and where is the TNS_ADMIN located??

"Since you have installed both ODAC 12.2 and 18, ensure that the correct version is being used by Report Builder."

I'm using Report Builder version v15.7.1811.11 is it the correct version?

"Use the Oracle SQL*Plus or Oracle Net Manager to test the connection using the same TNS alias."

could you please send me or show me how to do that? 

"Check the Oracle log files for any additional error messages that might provide more context on the issue."

where can I find the Oracle logs?