2012-11-9 11gR2 "ADMINISTRATOR'S GUIDE" page 848 - 904

最新推荐文章于 2019-04-16 19:03:22 发布

原创最新推荐文章于 2019-04-16 19:03:22 发布 · 656 阅读

0 ·

CC 4.0 BY-SA版权

oracle everyday 同时被 2 个专栏收录

62 篇文章

订阅专栏

oracle official docs

59 篇文章

订阅专栏

本文介绍如何为数据库配置远程作业调度功能，包括启用共享服务器、验证XMLDB选项、启用HTTP连接及设置注册密码等步骤。

Setting Up the Database for Remote Jobs -- 设置非本地的JOB（需要REMOTE端安装AGENT）

To set up a database to create and run remote jobs:
1. Ensure that shared server is enabled.

2. Using SQL*Plus, connect to the database as the SYS user.

3. Enter the following command to verify that the XML DB option is installed:
SQL> DESC RESOURCE_VIEW
If XML DB is not installed, this command returns an "object does not exist" error.

4. Enable HTTP connections to the database as follows:
a. Determine whether the Oracle XML DBM HTTP Server is enabled:
Issue the following command:
SQL> SELECT DBMS_XDB.GETHTTPPORT() FROM DUAL;
If this statement returns 0, Oracle XML DBM HTTP Server is disabled.

b. Enable Oracle XML DB HTTP Server on a nonzero port by logging in as SYS
and issuing the following commands:
SQL> EXEC DBMS_XDB.SETHTTPPORT (port);
SQL> COMMIT;
where port is the TCP port number on which you want the database to listen
for HTTP connections.
port must be an integer between 1 and 65536, and for UNIX and Linux must
be greater than 1023. Choose a port number that is not already in use.

5. Run the script prvtrsch.plb with following command:
SQL> @?/rdbms/admin/prvtrsch.plb

6. Set a registration password for the Scheduler agents using the SET_AGENT_
REGISTRATION_PASS procedure.
The following example sets the agent registration password to mypassword.
BEGIN
DBMS_SCHEDULER.SET_AGENT_REGISTRATION_PASS('mypassword');
END;
/