Home Database Mysql Tutorial 在Oracle 11g下安装配置Scheduler Agent

在Oracle 11g下安装配置Scheduler Agent

Jun 07, 2016 pm 04:08 PM

Oracle Scheduler是功能强大的定时调度程序,不但能调度job在本地数据库上运行,还能在远程主机上发起这些job,远程主机上不一定

Oracle Scheduler是功能强大的定时调度程序,不但能调度job在本地数据库上运行,还能在远程主机上发起这些job,远程主机上不一定要安装Oracle数据库,但必须安装有Scheduler Agent,下面是完整的安装过程

安装过程中涉及到以下两部分操作:

1、对于存放remote job信息、负责发起调度的主数据库进行配置

2、在运行remote job的远程主机上安装Scheduler Agent,如果这台远程主机上不安装Oracle Database,那么仅可以运行remote external job,如果安装了Oracle Database那么还可以运行remote database job

完整的安装过程如下,在11.2.0.3版本下测试通过

============1、对存放remote job信息的主数据库进行配置============
///////////////////////////////////
///  步骤1:安装XDB组件
///////////////////////////////////
###安装前检测库里是否已经安装过XDB,,如果安装过XDB,需要确认XDB的组件是否均处于有效状态;
---以下方法检查XDB组件,如果是VALID那么XDB组件处于正常状态
col comp_name format a30
set linesize 130
select comp_name,status from dba_registry where comp_name='Oracle XML Database';

COMP_NAME                      STATUS
------------------------------ ----------------------
Oracle XML Database            VALID

---如果状态不是VALID,那么需要运行以下脚本,根据脚本的输出来决定是否要重新安装
set serveroutput on

DECLARE
    v_xdb_installation_trigger number;
    v_dropped_xdb_instll_trigger number;
    v_dropped_xdb_instll_tab number;

BEGIN
    select count(*) into v_xdb_installation_trigger
    from dba_triggers
    where trigger_name = 'XDB_INSTALLATION_TRIGGER' and owner = 'SYS';

    select count(*) into v_dropped_xdb_instll_trigger
    from dba_triggers
    where trigger_name = 'DROPPED_XDB_TRIGGER' and owner = 'SYS';

    select count(*) into V_dropped_xdb_instll_tab
    from dba_tables
    where table_name = 'DROPPED_XDB_INSTLL_TAB' and owner = 'SYS';

  IF v_xdb_installation_trigger > 0 OR v_dropped_xdb_instll_trigger > 0 OR v_dropped_xdb_instll_tab > 0 then

  IF v_xdb_installation_trigger > 0 THEN

dbms_output.put_line('Please proceed to run the command SQL> drop trigger sys.xdb_installation_trigger');
--  drop trigger sys.xdb_installation_trigger;
  END IF;

  IF v_dropped_xdb_instll_trigger > 0 THEN
  dbms_output.put_line('Please proceed to run the command SQL> drop trigger sys.dropped_xdb_instll_trigger');
--  drop trigger sys.dropped_xdb_instll_trigger;
  END IF;

  IF v_dropped_xdb_instll_tab > 0 THEN
  dbms_output.put_line('Please proceed to run the command SQL> drop table sys.dropped_xdb_instll_tab');
--  drop table sys.dropped_xdb_instll_tab;
  END IF;

  ELSE
  dbms_output.put_line('Please proceed to run the XDB install or upgrade');

  END IF;

END;
/


###安装XDB的方法归纳如下

---创建XDB专用的表空间,如果要使用SecureFile Lobs必须使用segment space management auto
create tablespace xdbts datafile '/oradata06/testaaaaa/xdbts1.dbf' size 500m extent management local segment space management auto;

---运行@?/rdbms/admin/catqm.sql
参数值含义如下:
:XDB user password
:XDB user default tablespace
:XDB user temporary tablespace
:YES or NO(YES->使用SecureFile lobs;NO->使用BasicFile Lobs)


---运行catqm.sql脚本

spool xdb_install.log
set echo on;
@?/rdbms/admin/catqm.sql asdf3_14 xdbts temp YES
@?/rdbms/admin/utlrp.sql
set echo off;
spool off;

---安装完成后再确认一下XDB组件的状态
col comp_name format a30
set linesize 130
select comp_name,status from dba_registry where comp_name='Oracle XML Database';

COMP_NAME                      STATUS
------------------------------ ----------------------
Oracle XML Database            VALID

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Reduce the use of MySQL memory in Docker Reduce the use of MySQL memory in Docker Mar 04, 2025 pm 03:52 PM

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

How to solve the problem of mysql cannot open shared library How to solve the problem of mysql cannot open shared library Mar 04, 2025 pm 04:01 PM

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

How do you alter a table in MySQL using the ALTER TABLE statement? How do you alter a table in MySQL using the ALTER TABLE statement? Mar 19, 2025 pm 03:51 PM

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

Run MySQl in Linux (with/without podman container with phpmyadmin) Run MySQl in Linux (with/without podman container with phpmyadmin) Mar 04, 2025 pm 03:54 PM

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

What is SQLite? Comprehensive overview What is SQLite? Comprehensive overview Mar 04, 2025 pm 03:55 PM

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

Running multiple MySQL versions on MacOS: A step-by-step guide Running multiple MySQL versions on MacOS: A step-by-step guide Mar 04, 2025 pm 03:49 PM

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

How do I configure SSL/TLS encryption for MySQL connections? How do I configure SSL/TLS encryption for MySQL connections? Mar 18, 2025 pm 12:01 PM

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)? What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)? Mar 21, 2025 pm 06:28 PM

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

See all articles