I’m using TOAD 12.10.0.30 and get the same error when connecting to Oracle 11.2.0.4-Databases. But what i’ve found out:
If I’m trying to connect to a RAC-database with 2 instances, i’ll get the ORA-1031 while connecting. And i don’t see other users in Schema-browser. In the spool-SQL there is the only Select on user$:
– Timestamp: 15:14:30.484
SELECT u.NAME
FROM sys.USER$ u
WHERE u.TYPE# = 1
ORDER BY 1;
Error: ORA-01031: Nicht ausreichende Berechtigungen
But when i’m connecting a single-instance database, the error won’t show up (even if there is one in spool sql)! And there is another select on user$ (select null instead of u.name) and a second select on dba_users, which wasn’t there on the other database:
– Session: xxxx
– Timestamp: 15:17:51.225
SELECT null
FROM SYS.USER$
WHERE 0=1
Error: ORA-00942: Tabelle oder View nicht vorhanden
– Session: xxxxx
– Timestamp: 15:17:51.271
Select username
from sys.DBA_USERS
order by username;
(even there is another error - ora-00942 instead of ora-1031). There must be a difference if there are more than one instance. If i should test something else, just let me know.
Regards,
Gerd