Upgrading the remote job agent

It's a good idea to apply any new updates published by Oracle. If you are still using the 11.1.0.6 agent, you will see some problems that are fixed by the 11.1.0.7 upgrade. The upgrade of the agent is not very difficult once you know that the same patch set should be applied as that for the database server installation. This is not very well documented, but this is how it works—start the installer found in the patch set, and then select the agent's ORACLE_HOME to upgrade.

The upgrade process is quick and easy till the last part—the execution of the root shell. In the 11.1.0.7 patch, you are asked to run the root.sh. Run it as root and check the properties of ${ORACLE_HOME}/bin/jssu. This file should have the setuid root privileges to function correctly. The root.sh that we are requested to run contains the following:

#!/bin/sh
/data/app/oracle/schagent/11.1.0.7.0/install/root_schagent.sh

Note

The root_schagent.sh file contains an error that prevents the setting...