Error ORA-12541 TNS: There is no listener

Navigation
0

I have problems connecting to the Oracle database from Visual Studio 2008, I get that error, but the funny thing is that when doing the TEST of this same connection in Orbit data odbc, the connection is successful. Check the tnsnames.ora file and it is the same one that I use in other machines and that works correctly.

Any ideas?

    
asked by Ween Montes 04.09.2017 в 16:54
source

1 answer

0

Follow these steps:

  • Do tnsping and check which route is getting the connection. If tnsping works, everything is configured correctly, it is VisualStudio the one that is using another connection.
  • If tnsping does not work for you: It may be because you have two tnsnames, one correctly configured and another not and you are using the one that is not correct, check it

    • Another thing you can do is check the system variable called ORACLE_SID, for this set it with set ORACLE_SID = tuSID and then do a tnsping.

    With the results we will continue to help you

        
    answered by 06.09.2017 / 14:07
    source
    Firebird connection problems with .ib database (Interbase) Display: column does not work in Safari