query reporter and ORA-12154

[Ed_G]

I would very grateful if you could help us with the following issue.

Our DBA and development teams use the full Pl/Sql developer which works fine. We are trying to roll out some pl/sql developer reports (.rep) to end users which will use the QueryReporter to run them

The functioning of QueryReporter seems to be a very frustrating hit and miss issue with the TNS. It works fine on some PCs but for most part we are getting ORA-12154 TNS:Could not resolve the connect identifier.

Interestingly
1- The tnsping to the same connect string works fine
2- sqlplus successfully connects to the same connect string
3- Even though QueryReporter complains with ORA-12154, the drop down window for the connect string in fact shows all the connect strings defined in the tnsname.ora file including the failed connect string (by the way all connect strings in tnsnsmae.ora are failing) So the QueryReporter is finding the correct tnsnames.ora file!
Any help would be greatly appreciated.

Thanks
Ed

 

[Marco Kalter]

This will happen if you install Query Reporter in a directory with parentheses (e.g. C:\Program Files (x86)) when using an Oracle 10.2 or earlier client. You will run into an Oracle bug as described in Oracle Note 334528.1. It is recommended to upgrade to an Oracle11g client.