USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
REMOTE_SCHEDULER_AGENT EXPIRED & LOCKED
###设置scheduler agent连接到主数据库的口令
exec dbms_scheduler.set_agent_registration_pass(registration_password=>'asdf3_14');
###设置shared_servers为非零,这一步很重要,否则会出现scheduler agent无法注册成功的问题
alter system set shared_servers=1 scope=both;
###job主服务器上的lnsrctl status输出里能看出PORT=30405的正在被侦听
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date 06-FEB-2015 07:49:08
Uptime 9 days 3 hr. 8 min. 14 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/jq570322b/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.141.209)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jq570322b)(PORT=30405))(Presentation=HTTP)(Session=RAW))
###/etc/hosts里加入即将安装scheduler agent的remote主机IP地址和主机名映射,这一步能避免后面注册时产生ORA-29257
10.10.141.206 jq570321a
至此job主数据库服务器侧的配置工作完毕