Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Unable to connect using Oracle database and ODBC

Hi team,   i have access to an oracle database but for some reason I cannot access the database and keep getting error message stating "Oralce: ORA-12541: TNS: No Listener". I have tried the follow...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous Apologies for getting back so late but I found a solution for this to work.

     

    New Query > connect to DB > Oracle Database > in the servername the syntax to use is "hostname:[port number] /SID" which I was using only as host ID. After this update, it all worked fine.

     

    Thanks again for the help.

     

    Kind regards,

    Anand

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous Apologies for getting back so late but I found a solution for this to work.

 

New Query > connect to DB > Oracle Database > in the servername the syntax to use is "hostname:[port number] /SID" which I was using only as host ID. After this update, it all worked fine.

 

Thanks again for the help.

 

Kind regards,

Anand

hesske's avatar
hesske
Regular Visitor
9 years ago

Thank you very much. This worked for me as well. One update I would make is that for me "hostname:[port number] /SID" didn't work, but "hostname:[port number] /[SERVICE_NAME]" is what worked. I had tried pulling the SID from the listener.ora on the server but still couldn't get connected. When I used the "[SERVICE_NAME]" it connected right away. Thanks again!

  • WilliamG's avatar
    WilliamG
    New Member
    5 years ago

    Nothing worked for me except your advice.  Thank you hesske from 3 years in the future!

     

    hostname:[port number] /[SERVICE_NAME]