TOAD - 11.6 Issues Connecting to Oracle 12C Databases
When attempting to connect to a 12C Oracle database using TOAD 11.6, client receives an ORA-01031 error.Problem:
For issues with TOAD not connecting to Oracle databases, please see instructions below.
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.
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.