Oracle11g安装agent,在Oracle 11g下安装配置Scheduler Agent

============2、对即将运行remote jobs的远程主机安装scheduler agent并进行配置============

###scheduler agent安装介质可以从已经安装有Oracle database的主机上提取，提取过程如下

cd $ORACLE_HOME\bin

extjobo -createagentzip /tmp/agent_install.zip

###将execution_agent.zip文件复制到准备安装scheduler agent的主机

scp /tmp/agent_install.zipsagent@10.10.141.206:/home/sagent/

###scheduler agent主机侧环境变量配置及目录创建

export ORACLE_HOME=/home/sagent

cd /home/sagent

mkdir scheduler

###scheduler agent主机解压

cd /home/sagent/scheduler/

unzip ../agent_install.zip

###进入scheduler agent所在目录修改schagent.conf文件里的端口号，这个是agent主机上的端口号，通过该端口和job主服务器进行通信

在$ORACLE_HOME/scheduler/execution_agent/schagent.conf文件里加入

PORT=30406

###以root用户执行root.sh

cd $ORACLE_HOME/scheduler/execution_agent/

./root.sh

###将scheduler agent注册到database

cd $ORACLE_HOME/scheduler/execution_agent/bin

./schagent -registerdatabase 10.10.141.209 30405

EXECUTION_AGENT_HOME is /oracle/app/oracle/product/11.2/scheduler/execution_agent

Agent Registration Password ? *********

Oracle Scheduler Agent Registration for 11.2 Agent

Agent Registration Successful!

注：scheduler agent也可以在安装oracle client的过程中选择"Custom"->"Oracle Scheduler Agent"来完成安装，截图如下

============3、在job主服务器上验证scheduler agent安装结果============

###通过dba_scheduler_external_dests视图查看已经注册上来的remote agent信息

col destination_name format a30

col hostname format a30

col ip_address format a20

col enabled format a10

col comments format a50

set linesize 180

select * from dba_scheduler_external_dests;

DESTINATION_NAME              HOSTNAME                            PORT IP_ADDRESS          ENABLED    COMMENTS

------------------------------ ------------------------------ ---------- -------------------- ---------- --------------------------------------------------

JQ570321A                      jq570321a                          30406 10.10.141.206        TRUE      Registered on 15-FEB-15 12.02.50.245870 PM +08:00

###通过GET_AGENT_VERSION探测scheduler agent的版本

set serveroutput on

DECLARE

versionnum VARCHAR2(30);

BEGIN

versionnum := DBMS_SCHEDULER.GET_AGENT_VERSION('10.10.141.206');

DBMS_OUTPUT.PUT_LINE(versionnum);

END;

/

11.2.0.3.1

PL/SQL procedure successfully completed.