listener was not given the SERVICE_NAME in CONNECT_DATA

[#1]

Hi,

I am trying to reload a qvw file on QMC and it fails. On generating the log file this is the error I get

Error: SQL##f - SqlState: S1000, ErrorCode: 12504, ErrorMsg: [Oracle][ODBC][Ora]ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

I installed Qlik desktop on the server and reload manually from qlik desktop and it ran fine. I have the service name in tnsnames.ora

[Anonymous]

How many servers do you have ?

Sounds like you tnsnames.ora file on the server the QMC does its reloads on is different to the one on the server that your manual reload ran on.

[#3]

Hi Bill,

I have only one server

[#4]

When I copied the tnsnames.ora file to the folder which contains qvw file, reload was successful.

Is that the correct location for that file?

[Emmanuelle__Bustos]

Hi Nishiant did you solve this issue? I'm having the same problem.

[#6]

Hi emmanuelle.bustos

I just copied the tnsnames.ora file to the same folder where I had my qvw saved. That solved the issue and reload was successful. I don't know if that is the right folder to save tnsnames.ora file though.

[#7]

Hi emmanuelle.bustos

I just copied the tnsnames.ora file to the same folder where I had my qvw saved. That solved the issue and reload was successful. I don't know if that is the right folder to save tnsnames.ora file though.

[Emmanuelle__Bustos]

Hi, It is weird as we isntall client components for Oracle 11g the tnsnames.ora is not present at the Windows directoris so we cannot move to the folder as you mentioned, we are still looking for a solution.

[Anonymous]

The Oracle Client install just installs the client binaries but needs to be told where the database resides.  This is done by manually created a suitable tnsnames.ora file.  Your dba should already have a suitable tnsnames.ora file [not least on the Oracle Database Server itself], so ask them to copy it into the correct folder within your Oracle Client folder.

Putting a tnsnames.ora file into the same folder as your qvw may well work, but is the wrong thing to do and will most likely cause confusion later as well as upsetting your dba's when it goes wrong and they have to fix it.

In summary:  Ask your dba for assistance.

[Emmanuelle__Bustos]

Thank you Bill for the tip, we are looking for the DBA admin help.