#47 don't get connection

Future
closed
nobody
None
5
2016-12-22
2012-03-21
Yuriy
No

Completed the OragleXE (10.2.0 - 32bit) client install. I installed
SQL Tools 1.6. and the program cannot find my tnsnames.ora.
After I copied tnsnames.ora to SQL Tools folder it find tnsnames.ora
When connection with tnsnames.ora using -
ORA-12154: TNS:could not resolve the connect identifier specified
When direct connection -
ORA-06413: Connection not open.
I've verified connectivity to my databases via SQLPlus.
I tried some previous SQL Tools version, their behavior is similar
OS - Windows7

Discussion

  • Aleksey Kochetov

    I don't think it is sqltools bug.

    Most likely any other 3d party tool will have the same problem on your PC. However TOAD might work because it uses unconventional way to initialize oracle client.

    I suggest to add TNS_ADMIN variable to your environment to resolve this problem

     
  • Aleksey Kochetov

    Actually my first post was how to resolve the problem with tnsnames.ora

    If you cannot connect then check if you have orcale listener configured and running

    then try tnsping <YOUR DB>

    sql*plus might use BEQ protocol that is not available for sqltools by default but it will work if you add a corresponding entry in tnsnames.ora explicitly

     
  • ratse

    ratse - 2012-04-04

    I had a similar problem when application was installed in "Program files (x86)" directory. Try to install sqltools in other location (without parentheses in path - e.g. "Program files").

     
  • Yuriy

    Yuriy - 2012-04-05

    ratse, thanks. I removed SQL Tools from "Program files (x86)" to another directory. And now all OK.

     
  • Aleksey Kochetov

    • status: open --> closed
    • Group: --> Future
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks