When launching or starting SQL Optimizer from Toad for Oracle, or when trying to connect to the Optimize SQL tab, the following error message is received:
"The following unhandled error has occurred:
Object referenced not set to an instance of an object."
WORKAROUND 1
1. Fully exit Toad for Oracle (if you have it) and Quest SQL Optimizer for Oracle
4. Please re-test the issue
NOTE: Try to avoid force or abrupt closures of Toad and SQL Optimizer. Try to also avoid leaving the programs running overnight as Database or Windows Updates usually occur at night.
WORKAROUND 2
Completely un-install and re-install Quest SQL Optimizer for Oracle.
WORKAROUND 3
1. Open SQL Optimizer
2. Go to Options | General | Options | Click "Restore..." button | Select Restore All | Apply
3. Now try to connect and see if that helps
