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.
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 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!
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.
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.
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!