To be able execute external jobs on remote host Oracle Scheduler Agent should be installed.
It is coming as part of Oracle Database Gateways 11g installation and can be installed in silent mode.
Giving that, I decided to install the agent using silent mode: created response file under
temporary location and left only entries with defined parameters:
$ cat /tmp/schagent.rsp
RESPONSEFILE_VERSION=2.2.1.0.0
UNIX_GROUP_NAME="oinstall"
FROM_LOCATION="/u03/install/11gateways/gateways/stage/products.xml
ORACLE_HOME="/u01/app/oracle/product/11.1.0/scheduler"
ORACLE_HOME_NAME="OraScheduler_11"
SHOW_WELCOME_PAGE=false
SHOW_CUSTOM_TREE_PAGE=false
SHOW_SUMMARY_PAGE=false
SHOW_INSTALL_PROGRESS_PAGE=false
SHOW_CONFIG_TOOL_PAGE=false
SHOW_ROOTSH_CONFIRMATION=true
SHOW_END_SESSION_PAGE=false
SHOW_EXIT_CONFIRMATION=true
NEXT_SESSION=false
NEXT_SESSION_ON_FAIL=true
TOPLEVEL_COMPONENT={"oracle.rdbms.scheduler","11.1.0.6.0"}
SHOW_SPLASH_SCREEN=false
COMPONENT_LANGUAGES={"en"}
INSTALL_TYPE="Typical"
oracle.rdbms.scheduler:DEPENDENCY_LIST={"oracle.jdk:1.5.0.1.1"}
s_hostName="srv2"
s_port="1888"
$ ./runInstaller -silent -responseFile /tmp/schagent.rsp -noconfig
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 80 MB. Actual 2700 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1983 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-07-06_08-57-43PM. Please wait ...
[oracle@srv2 gateways]$ Oracle Universal Installer, Version 11.1.0.6.0 Production
Copyright (C) 1999, 2007, Oracle. All rights reserved.
You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2009-07-06_08-57-43PM.log
............................................................... 100% Done.
SEVERE:OUI-10133:Invalid staging area. There are no top level components for Linux available for installation in this staging area.
It failed even all variables that I defined in response file were shown in log file of installation.
I think I already I saw it for some of silent installations and resolution was to put
original response file for installer and add parameters for ORACLE_HOME,
ORACLE_HOME_NAME (all others seem to be unnecessary):
$ ./runInstaller -silent -responseFile /u03/install/11gateways/gateways/response/schagent.rsp \
> ORACLE_HOME="/u01/app/oracle/product/11.1.0/scheduler" \
> ORACLE_HOME_NAME="OraScheduler_11" -noconfig
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 80 MB. Actual 2700 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1983 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-07-06_09-02-46PM. Please wait ...
[oracle@srv2 gateways]$ Oracle Universal Installer, Version 11.1.0.6.0 Production
Copyright (C) 1999, 2007, Oracle. All rights reserved.
You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2009-07-06_09-02-46PM.log
.................................................................................................... 100% Done.
Loading Product Information
...................................................................................................................... 100% Done.
Analyzing dependencies
.......................................................................................................... 100% Done.
-----------------------------------------------------------------------------
Summary
Global Settings
Source: /u03/install/11gateways/gateways/stage/products.xml
Oracle Home: /u01/app/oracle/product/11.1.0/scheduler (OraScheduler_11)
Installation Type: Typical
Product Languages
English
Space Requirements
/ Required 177MB (includes 47MB temporary) : Available 2.51GB
New Installations (2 products)
Oracle Scheduler Agent 11.1.0.6.0
Sun JDK 1.5.0.1.1
-----------------------------------------------------------------------------
Installation in progress (Mon Jul 06 21:03:01 EST 2009)
........................................................................................... 91% Done.
Install successful
Linking in progress (Mon Jul 06 21:03:27 EST 2009)
Link successful
Setup in progress (Mon Jul 06 21:03:27 EST 2009)
.. 100% Done.
Setup successful
End of install phases.(Mon Jul 06 21:03:28 EST 2009)
WARNING:
The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root script to run
/u01/app/oracle/product/11.1.0/scheduler/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
The installation of Oracle Scheduler Agent was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2009-07-06_09-02-46PM.log' for more details.
[oracle@srv2 gateways]$ su -
Password:
[root@srv2 ~]# /u01/app/oracle/product/11.1.0/scheduler/root.sh
[root@srv2 ~]#
The agent had been installed and it had to be configured to communicate with database
which will execute remote external jobs.
Have a good day!
