PL/SQL developer simultaneous connection to OCI db with two difrerent wallets

[Tomas Vlk]

Hi,

I was trying to find solution for this problem for a while, but no success yet..So I would like to ask here.

I have two different oracle OCI db (which is minimum as standard) - dev and prod. If I need to user built in feature "compare user objects", I cannot, because I got this error - ORA-12529: TNS:connect request rejected based on current filtering rules.

Basically it seems like PL/SQL developer cannot handle multiple connections using db wallet (each connection different wallet). (for example, Oracle SQL developer can do that with ease)...

Is there any solution pls? We are using 15.0.4 version in our company.

Thank you

 

[Marco Kalter]

PL/SQL Developer uses a single TNS_ADMIN directory, which can only point to one wallet configuration at a time. However, there’s a way to overcome this limitation by leveraging the MY_WALLET_DIRECTORY parameter in the tnsnames.ora file for each connection.

 

[Tomas Vlk]

yes, thats exactly, how I have it. There is no global wallet location in sqlnet.ora, but each connection in tnsnames.ora has its own separate my_wallet_directory. But behavior is still the same and throwing same error.

 

[Frank Huijbreghs]

I have also 2 OCI databases and ran into the same problem. What I have done is combine the tnsnames.ora files in both wallets so both tnsnames.ora files are equal and contains the same database entries.
This fixed the "ORA-12529: TNS:connect request rejected based on current filtering rules." error for me.