在Oracle 11g下安装配置Scheduler Agent(3)

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主数据库服务器侧的配置工作完毕

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/0e13121ae16a62398a38002ebac7da93.html