After a program crash, the Tuning Lab tab is showing a blank screen only and no data is shown. The contents of the tab, where it would normally show the Tuning Lab, is empty.
Reinstalling SQL Optimizer also has no effect.
SQL Optimizer indicated Oracle_Home was invalid.
SOLUTION 1:
A. Make sure that the Oracle interface DLL file is in the BIN folder.
Do a search in the BIN folder of "ora*.dll". Make sure one of the following is returned, depending on what version of Oracle client you are using. Oracle 8i should have ORACLIENT8.dll, Oracle 9i should have ORACLIENT9.dll, and Oracle 10g should have ORACLIENT10.dll. Toad needs one of these Oracle interface DLL files to connect.
B. Make sure the OCI.DLL file is in the BIN folder. For example:
C:\oracle\product\10.2.0\client_1\BIN
SOLUTION 2:
Install\Reinstall a new Oracle_Home.
SOLUTION 3:
Reduce the amount of data in the tnsnames.ora file, to the smallest amount of data possible to make a connection.
