oracle失效job,oracle job不运行 解决方案

oracle job不运行 解决方案

1) Instance in RESTRICTED SESSIONS mode?

Check if the instance is in restricted sessions mode:

select instance_name,logins from v$instance;

If logins=RESTRICTED, then:

alter system disable restricted session;

^-- Checked!

2) JOB_QUEUE_PROCESSES=0

Make sure that job_queue_processes is > 0

show parameter job_queue_processes

^-- Checked!

3) _SYSTEM_TRIG_ENABLED=FALSE

Check if _system_enabled_trigger=false

col parameter format a25

col value format a15

select a.ksppinm parameter,b.ksppstvl value from x$ksppi a,x$ksppcv b

Where a.indx=b.indx and ksppinm=’_system_trig_enabled’;

^-- Checked!

4) Is the job BROKEN?

select job,broken from dba_jobs where job=;

If broken, then check the alert log and trace files to diagnose the issue.

^-- Checked! The job is not broken.

相关文档：

oracle表空间操作详解

1

2

3作者：   来源：    更新日期：2006-01-04

5

6

7建立表空间

8

9CREATE TABLESPACE data01

10DATAFILE '/ora ......

SQL> select * from emp where sal=800;

EMPNO ENAME      JOB         MGR HIREDATE          SAL      COMM DEPTNO

----- ---------- --------- ----- ----------- ----- ......

1. 创建 Sequence

使用如下命令新建sequence(用户需要有CREATE SEQUENCE 或者CREATE ANY SEQUENCE权限):

CREATE  SEQUENCE test_sequence

INCREMENT  BY   1   --  每次加的个数据

START  WITH   1   --  从1开始计数

NOMAXVALUE& ......

SQL

insert into   table_name(colum1,colum2)

select  colum1,colum2

from  opendatasource('sqloledb','data source=服务器名;user id=用户名 ;password=密码 ').database_name.dbo.table_name

如执行出现以下错误”sql server 阻止了对组件 \'ad hoc distributed queries\' 的访问&l ......