Dump file d:\oracle\product\10.2.0\admin\ora\bdump\ora_j000_2988.trc
Thu May 19 22:00:01 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2962M/4085M, Ph+PgF:5047M/5964M, VA:1162M/2047M
Instance name: oraRedo thread mounted by this instance: 1Oracle process number: 88Windows thread id: 2988, image: ORACLE.EXE (J000)
*** SERVICE NAME:(SYS$USERS) 2011-05-19 22:00:01.058
*** SESSION ID:(48.3041) 2011-05-19 22:00:01.058
*** 2011-05-19 22:00:01.058
ORA-12012: 自动执行作业 8887 出错
ORA-02248: 无效的 ALTER SESSION 选项
Thu May 19 22:00:01 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2962M/4085M, Ph+PgF:5047M/5964M, VA:1162M/2047M
Instance name: oraRedo thread mounted by this instance: 1Oracle process number: 88Windows thread id: 2988, image: ORACLE.EXE (J000)
*** SERVICE NAME:(SYS$USERS) 2011-05-19 22:00:01.058
*** SESSION ID:(48.3041) 2011-05-19 22:00:01.058
*** 2011-05-19 22:00:01.058
ORA-12012: 自动执行作业 8887 出错
ORA-02248: 无效的 ALTER SESSION 选项
解决方案 »
- alter database rename file命令
- SQL中 什么时候用匿名块,什么时候用命名块呢?
- 表记录拼凑问题
- 有2个数据库A、B;分布在不同的地点;当在A数据库进行事务处理时,数据能够自动流向B数据库的实现技术。
- 如何用java开发oracle数据库的逻辑备份与恢复
- oracle 存储过程并发问题~
- oracle备份的问题
- java.io.filenotfoundexception: /etc/oratab错误!!!!
- 我新装的9iR2数据库密码好像老是自动变的
- !!在这月圆之夜,祝大家中秋快乐。。。万事顺心。。!!!
- ORACLE表空间问题
- oracle 语法问题 10g---11g
KILL进程的语句。。出错。。
ORA-12012
是自定义收集统计数据的存储过程吗?
查看一下这个作业执行的具体代码,是否有alter session set xxxx之类的语句
进入 EM 中,查看,job->GATHER_STATS_JOB,就可以看到代码了
Tue Aug 11 22:00:00 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2820M/4085M, Ph+PgF:4866M/5964M, VA:1234M/2047M
Instance name: oraRedo thread mounted by this instance: 1我也有相同问题,求高手解答!!!Oracle process number: 60Windows thread id: 1764, image: ORACLE.EXE (J001)
*** SERVICE NAME:(SYS$USERS) 2009-08-11 22:00:00.859
*** SESSION ID:(57.49082) 2009-08-11 22:00:00.859
*** 2009-08-11 22:00:00.859
ORA-12012: 自动执行作业 8886 出错
ORA-02248: 无效的 ALTER SESSION 选项
怎么查看具体代码呀???先从DBA_JOBS.WHAT字段查处是那个过程
SELECT * FROM DBA_JOBS;
EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();
然后从DBA_SOURCE就可以看到是那个用户的代码了
SELECT * FROM DBA_SOURCE T WHERE UPPER(T.TEXT) LIKE '%EMD_MAINTENANCE%'