When connecting getting error Failed to connect to the Performance Repository message.
The problem is caused by uninstalling a previous Oracle client to the one being used the PA GUI without using the Oracle Universal Installer.
Please make sure any previous Oracle clients have been uninstalled using the Oracle Universal Installer and make sure that the Oracle client you are currently using on your desktop is at the beginning of the PATH setting on your desktop PC.
The following details will help you make sure your Oracle environment on your desktop is setup properly:
1. Make sure ORACLE_HOME\bin is in PATH
ORACLE_HOME\bin must be in the user's PATH environment variable. Go to a DOS prompt, type "PATH" and see what your path is. It could look like this:
You could either go through the Control Panel to alter the PATH, or edit AUTOEXEC.BAT in the root c:\ folder.
If you are having trouble connecting with Spotlight, put the Oracle Home the first thing in the path, before any other tools or variables.
2. Determine your ORACLE_HOME value.
Check the ORACLE_HOME value. Look in your windows registry, via Start|Run|Regedit, drill down to HKEY_LOCAL_MACHINE\Software\ORACLE. There should be an entry for ORACLE_HOME, as well as many other entries. Like this:
In this case, my ORACLE_HOME on this Windows 95 box is "c:\orawin95".
If you have Oracle8i or a Oracle product called the "Home Switcher" which gives you the option of changing ORACLE_HOME settings to reconfigure your computer for access to several different types of Oracle Databases, then your registry settings will look like this:
When Oracle connects, it will look in ALL_HOMES for the "LAST_HOME" value, which in this case is zero "0". It appends zero to "HOME" to produce "HOME0", then it looks in HKEY\Software\ORACLE\HOME0 for the ORACLE_HOME value.
*LAST_HOME should point to the correct Oracle Home in the path (step 1).
3. Make sure the Oracle interface DLL is in the BIN folder.
Spotlight requires an Oracle interface DLL to connect. Depending on the database version you are connecting to, it is called ORAxy.DLL, where xy is the database version, e.g., for 7.0 it is called ORA70.DLL, 7.1 it is called ORA71.DLL, etc. For Net8/Oracle8i, the DLL is called ORACLIENT8.DLL. If this file is not in the BIN folder, then SPOTLIGHT cannot connect.
4. Check for TNS_ADMIN value
Check the registry again for:
"TNS_ADMIN" should equal something like "c:\orawin95\network\admin" for Windows 95 machines, and "c:\orant\network\admin" for Windows NT machines. TNS_ADMIN can be blank, in which case it will default to the ORACLE_HOME\network\admin folder.
Look in the tnsnames.ora file. Make sure you have an entry for the database alias you are using. After this has been checked, reboot the machine.
SQL*Plus is NOT a good test of a correct SQL*Net install, as SQL*Plus does NOT use all of the infrastructure and components of a good SQL*Net install.
Use TNSPING or TNSPING80 in a DOS prompt.
Force the Oracle Home: Right Click on the shortcut on the desktop, select Properties, go to Shortcut Tab and modify the Start In: Value. Replace the original text with path to the oracle home e.g. c:\orant\bin