DOA connecting problem while PLSQL developer connects

[Valgar]

Trying to run an application developed using DOA with Delphi 10.1 on a different machine but I get "ORA-12154 TNS: could not resolve the connect identifier specified".

However, on my machine I have "PLSQL Developer" that connects to the same database without a problem.

The only difference I can detect is that the Oracle client on the developing machine is 12_1 while I am running 11_2.. but as far as I can remember this should not be a problem.

PS. found a lot regarding ORA-12154 on the forums, but nothing similar to this.

 

[Marco Kalter]

Can you connect to the same database with sqlplus.exe from the same Oracle Home that Direct Oracle Access is using?

 

[Valgar]

Thanks, but my task is to define the minimal possible setup for the application in question, SQLPLUS.EXE is not a part of that..

Should it not be sufficient test to be able to connect in "PLSQL Developer"?

 

[Marco Kalter]

Yes, that should be sufficient. Are PL/SQL Developer and your application both 32 bit or 64 bit?

 

[Valgar]

Both 32 bit. Could the different versions be a problem (11.2 and 12.1)? I really need to be able to make it work with on both versions.

Any minimal requirements guidelines for DOA?

I haven't "diassembled" the application though, hoping to get, "oh, you just need to..." advice here, before starting tedious task

 

[Marco Kalter]

On both client versions is should work just fine. It would be a good idea to install SQL*Plus and tnsping available in the problematic Oracle Client, so that you can validate it.

 

[Valgar]

Thanks, I understand, but I need guidelines for a minimal setup, so if I install SQLPlus on this one, I will probably face the same problems on the next machine.

Anyway, thanks.

 

[Valgar]

Problem solved, conflicting references in Registry.. thanks, closed.