When using a non-default TNS_ADMIN path for Forms (set by either registry or environment variable), Reports Builder will still read from the default TNS_ADMIN path. This results in an error saying that Reports Builder or Reports server will not be able to open a database connection.
This is because ‘%ORACLE_INSTANCE%\config\reports\bin\reports.bat’ overrides any environment configurations made.
To edit this, open the above file in a text editor, change TNS_ADMIN…
From:
set TNS_ADMIN=%ORACLE_INSTANCE%\config
To:
set TNS_ADMIN=%TNS_ADMIN% (If you’re using an environment variable to set TNS_ADMIN)
OR
set TNS_ADMIN=location_of_tnsnames
Restart WLS_REPORTS for the changes to take effect.
