-
Title
Error during launch or startup of SQL Optimizer from Toad for Oracle: 'Object reference not set t -
Description
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." -
Resolution
WORKAROUND 1
1. Fully exit Toad for Oracle (if you have it) and Quest SQL Optimizer for Oracle
2. Go to:XP:
C:\Documents and Settings\<user name>\Application Data\Quest Software\Quest SQL Optimizer for Oracle\Vista or 7:
C:\Users\<your_user>\AppData\Roaming\Quest Software\Quest SQL Optimizer for Oracle\
3. Rename the version number folder. e.g. 11.0 rename to 11.0_OLD4. 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