I was just about to ask for a complete SQL Spool output of when you connect, and this answered my question. I don’t think there is anything wrong with your installation of Toad.
This package, DBMS_APPLICATION_INFO, is granted to PUBLIC by default. It seems that someone has revoked this from PUBLIC. If you can get your DBA to grant you the EXECUTE privilege on this package, that will get us past this hurdle. Hopefully there won’t be any more, but if other things have been revoked from PUBLIC, there could be more problems.
In the office I usually work with an older version of Toad but with the same Oracle account. There I have no problems. Currently I’m in home office and I have not got I license key yet. That’s why I use the trial version in the meantime. Maybe the access to the DB has changed with the new version, so that I need more rights that are not granted to the Oracle account I have to use. Since it is a production database it will be difficult to get other privileges. But I think that are problems you cannot help.
The connection code did change several versions back. We used to run about 20 separate queries, and to improve connection time, they were combined into a big PL/SQL block. It’s possible that when we ran the separate queries, we were tolerant of lack of privileges on DBMS_APPLICATION_INFO and when we changed to the big pl/sql block, that detail was lost. I’ve made a change for the next beta so that we will again be tolerant of lack of privileges on DBMS_APPLICATION_INFO.
If there is anything else I can help with, just holler.
Check your Toad terms of use license, you may well be OK to use your work license at both locations. Dell Software licenses by user - so assumption is that many will need to have a desktop copy for while at office and say a laptop copy or home office copy while working from at home on the same job. So you may be OK using your one license for both locations. as long as it’s for the same job. When in doubt - check with your sales rep.