Query Reporter

[Raghu]

Hello ALl,
I am not able to login to/connect to data base through query reporter.when i try to connect it throws oracle error could not resolve TNS service name.I have checked TNS service name and it is fine.Through Oracle SQL plus I am able to connect to database but not through Query reprter.Can any one tell me what will be the problem.

Thanks in advance

 

[Marco Kalter]

The Query Reporter will use the Oracle Net version from the Primay Oracle Home. If you have Multiple Oracle Homes, it may be that tools like SQL*Plus reside in a different Oracle Home. In that case you can use the Oracle Home Selector (a standard Oracle utility), to define the Primary Oracle Home.

------------------
Marco Kalter
Allround Automations

 

[Tonka]

I'm having the same problem as well. I can connect to the Oracle database on the UNIX Oracle server from my Windows desktop using SQL*Plus, but not Query Reporter. I'm getting this error:
ORA-12541: TNS:no listener
I have verified Listener is running and the listener.ora file is configured correctly.
My database connection parameter is:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=(SID=)))
host name, port number, and SID name are correct.

Any Suggestions on how to get connected?
Thank for any replies

 

[Marco Kalter]

Do you have multiple oracle homes? That might explain why SQL*Plus connects, and QueryReporter does not, assuming that you are running SQL*Plus from a secondary oracle home.