We upgraded our databases from Oracle 9i to 10g. Now, the Performance Analysis Oracle 6.2 client shows that the database instance is down.
How do we update the agent?
Oracle Home changed
On the middleware host, go to <installDir>/agents/StealthCollect/6.0/<host-sid>/quest_sc_mw/config and verify the Oracle Home is correct in the quest_sc_mw.cfg file?
In the quest_sc_mw.cfg file, find the following string: collector_oracle_home="/u01/app/oracle/product/9.2.0" (or something similar).
Please verify the Oracle Home is correct as you may need to update the collector Oracle Home,
Next, restart the agents (on windows, stop/start the QAM Launcher service; on Unix issue <installDir>/agents/bin/quest_launcher_deamon [shutdown | start]