Oracle Cloud Login Issues

dgs!

Member³
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?
 
Last edited:
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.
 
Back
Top