Posted By: dgs! Oracle Cloud Login Issues - 12/26/23 09:14 PM
I am struggling to login to our oracle database located in the cloud. Oracle's SQL Developer is using a WALLET to connect. As far as I know, PL/SQL Developer does not have this capability.
I installed an instant Oracle Client and extracted the TNSNAMES.ora info from the wallet. I added a TNS_ADMIN environment variable and hard coded the Oracle home into the preferences. The error I'm currently getting is:

ORA_12506 TNS: Listener rejected connection based on service ACL filtering.

Oracle's SQL Developer can connect fine, but I'd rather use this tool instead.

Is it possible to use a connection type of CLOUD WALLET instead of TNS?
Posted By: dgs! Re: Oracle Cloud Login Issues - 12/28/23 03:24 PM
Solved.....
Oracle's SQL Developer was referencing a ZIP file. I unzipped it, then fully qualified the path to the unzipped wallet information. Then I added WALLET_LOCATION to my SQLNET.ora file.
Posted By: gremonesi Re: Oracle Cloud Login Issues - 02/20/24 07:17 PM
place the system in a directory whose name does not have a space, for example:
C:\Program Files
Place
C:\ProgramFiles
Posted By: dgs! Re: Oracle Cloud Login Issues - 02/20/24 09:42 PM
thx
© Allround Automations forums