I am unable to logon to the database as proxy dba from TOAD, but I can login using the SQLPLUS (with 12c client).
Below are the details of the SQLPLUS connection which allows SCOTT to connect as proxy dba.
$ sqlplus scott[pdbdba]@orcl
SQL*Plus: Release 188.8.131.52.0 Production on Thu Sep 1 06:05:00 2016
Copyright © 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Thu Sep 01 2016 06:03:35 +01:00
Oracle Database 12c Enterprise Edition Release 184.108.40.206.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options
Below are the details of the TOAD connection which is failing to connect SCOTT as proxy dba.
TOAD Version 220.127.116.11
Oracle DB version 18.104.22.168
Oracle Client version 11gR2
Note that, I can successfully login via TOAD as scott (normal user) but not as scott[pdbdba] , it returns the following error ORA-28058: login is allowed only through a proxy
Please advise the way forward. TIA.