TOAD - 11.6 Issues Connecting to Oracle 12C Databases

For issues with TOAD not connecting to Oracle databases, please see instructions below.

When attempting to connect to a 12C Oracle database using TOAD 11.6, client receives an ORA-01031 error.

Problem:

Oracle made a change in 12C where sys.user$ is no longer included in the SELECT_ANY_DICTIONARY system privilege. Toad 11.6 checks for SELECT_ANY_DICTIONARY before trying to query SYS.USER$, which is fine for older versions of Oracle but not 12C.

Resolution:

TOAD 10.5 will still work, as will TOAD 12.10. Please use either of these when attempting to connect to a 12C database.

Please contact AITS Service Desk if you have any additional questions. 





Keywords:AITS, toad, oracle, 12, 11.6, 12.2, 10.5, connecting, ORA-01031 error   Doc ID:78236
Owner:Christopher N.Group:University of Illinois System
Created:2017-11-14 12:29 CDTUpdated:2018-04-17 10:40 CDT
Sites:University of Illinois System, University of Illinois Technology Services
Feedback:  1   0