In Oracle BI 12c version 184.108.40.206.0 you may notice an error when trying to export to Excel using the Export Link at the bottom of a report on a dashboard.
First you see the following popup depending on the size of the report you Export to Excel:
You receive the below error:
Look at the Oracle BI Java Host (OBIJH) config.xml file located:
and see if you see the below:
Change the snippet of code to the below:
Bounce the OBIJH1 service and try to run the export again and it should be successful.
The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.