Your connectString is not right. It should look like this :
connectString : 'IP_ADDRESS/service_name'
service_name could be orcl or any value present in tnsnames.ora file. The above one will work in all scenarios.
I see that you can connect through SQL Developer. There is another way to make connection, create an environment variable path called TNS_ADMIN and point it to the location of folder location of tnsnames.ora file. Now, you can just specify the entry in tnsnames.ora file in connectString.
Thanks for the suggestion! I was able to resolve it using a modified version of the connection string provided by janguianof, but this approach seems like it might be useful when moving into a production environment. Thank you!
I've been banging my heads on the walls for a way to access my oracle db without the wallet, and your reply is the closest I've came to finding what I need.
Except whenever I try to access it I get a "ORA-12537: TNS:connection closed".
I tried a lots of things, and here is what my string look like :
"db.eu-zurich-1.oraclecloud.com/service_name.atp.oraclecloud.com"
What am I doing wrong ? Some configuration perhaps ? Any help would be greatly appreciated.
Thanks in advance,
Marc.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Hi Brian,
Your connectString is not right. It should look like this :
connectString : 'IP_ADDRESS/service_name'
service_name could be orcl or any value present in tnsnames.ora file. The above one will work in all scenarios.
I see that you can connect through SQL Developer. There is another way to make connection, create an environment variable path called TNS_ADMIN and point it to the location of folder location of tnsnames.ora file. Now, you can just specify the entry in tnsnames.ora file in connectString.
Thanks for the suggestion! I was able to resolve it using a modified version of the connection string provided by janguianof, but this approach seems like it might be useful when moving into a production environment. Thank you!
Hello nigilan,
I've been banging my heads on the walls for a way to access my oracle db without the wallet, and your reply is the closest I've came to finding what I need.
Except whenever I try to access it I get a "ORA-12537: TNS:connection closed".
I tried a lots of things, and here is what my string look like :
"db.eu-zurich-1.oraclecloud.com/service_name.atp.oraclecloud.com"
What am I doing wrong ? Some configuration perhaps ? Any help would be greatly appreciated.
Thanks in advance,
Marc.