Print Thread
Oracle Cloud Login Issues
#65221 12/26/23 09:14 PM
Joined: Feb 2010
Posts: 129
Shallotte NC
dgs! Offline OP
Member
OP Offline
Member
Joined: Feb 2010
Posts: 129
Shallotte NC
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 by dgs!; 12/28/23 02:39 PM.
Re: Oracle Cloud Login Issues
dgs! #65229 12/28/23 03:24 PM
Joined: Feb 2010
Posts: 129
Shallotte NC
dgs! Offline OP
Member
OP Offline
Member
Joined: Feb 2010
Posts: 129
Shallotte NC
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.

Re: Oracle Cloud Login Issues
dgs! #65411 02/20/24 07:17 PM
Joined: Dec 2012
Posts: 46
G
Member
Offline
Member
G
Joined: Dec 2012
Posts: 46
place the system in a directory whose name does not have a space, for example:
C:\Program Files
Place
C:\ProgramFiles

Re: Oracle Cloud Login Issues
gremonesi #65412 02/20/24 09:42 PM
Joined: Feb 2010
Posts: 129
Shallotte NC
dgs! Offline OP
Member
OP Offline
Member
Joined: Feb 2010
Posts: 129
Shallotte NC
thx


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.073s Queries: 14 (0.010s) Memory: 2.5086 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-30 14:33:05 UTC
Valid HTML 5 and Valid CSS