Process J000 is dead 报错

1

Posted on by

今天数据库后台报错:

Thu Dec 26 02:00:00 2013
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Thu Dec 26 02:06:36 2013
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_21975.trc:
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_21975.trc:
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_21975.trc:
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_21975.trc:
Thu Dec 26 02:06:46 2013
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/d[......]

查看全文

USE Udev for Oracle ASM

0

Posted on by

   下面说明RHEL5和RHEL6通过UUID来绑udev

 

RHEL5:

1.检查一下要绑那几块盘

ll /dev/sd*

 

2.生成脚本

for i in b c d e ;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id -g -u -s %p\", RESULT==\"`scsi_id -g -u -s /block/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /tmp/99-oracle-asmdevices.rules
done

 

3.检查一下99-oracle-asmdevices.rules

cat /tmp/99-oracle-asmdevices.rules

 

4.copy到udev目录下(rac的话直接copy这个文件到另一个节点上)

cp /tmp/99-oracle-asmdevices.rules /etc/udev/rules.d/99-oracle-asmdevices.rules

 

重启udev

start_udev

 

 

RHEL6:

1.检查一下要绑那几块盘

ll /dev/sd*

 

 

2.生成脚本

for i in b c d e ;
do
echo "KERNEL==\"sd*\", BUS==\&[......]

查看全文

ASM discovered an insufficient number of disks for diskgroup “DATA” 错误

0

Posted on by

在asmca的时候在一边mount了,另一边没有mount:

[grid@rac1 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576      4094     3988                0            1994              0             N  ARCH/
MOUNTED  EXTERN  N         512   4096  1048576      6141     4106                0            4106              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576      2047     1651                0            1651              0             Y  OCR/
[grid@rac1 ~]$ 
[grid@rac2 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576      2047     1651                0            1651              0             Y  OCR/

 

手动mount:

SQL> alter diskgroup data mount[......]

查看全文

拼出加分区表脚本

0

Posted on by

下面的脚本为新建2014年一年的分区。可根据不同的需求修改下。

sql:

select 'alter table ' || b.table_name || ' add partition PA_' ||
       TO_CHAR(a - 1, 'YYYYMM') ||
       
       ' values less than (TO_DATE( ''' ||
       TO_CHAR(a, 'YYYY-MM-DD HH24:MI:SS') || ''',''YYYY-MM-DD HH24:MI:SS'');'

  from (select add_months(trunc(DATE '2014-01-01', 'month'), level) a
          from dual
        connect by level < 13),
       (select owner || '.' || table_name table_name
          from dba_tables
         where table_name in ('T_WCP_FRZ_CREDENTIAL', 'T_WCP_ACCT_QUERY_CREDENTIAL')) b
union all
select 'alter table ' || c.owner||'.'||c.table_name
        ||
       ' add partition PA_MAX values less than (MAXVALUE);'
       
  from dual,(select owner, table_name
          from dba_tables
         where table_name in ('T_WCP_FRZ_CREDENTIA[......]

查看全文

大量update导致的逻辑dataguard延迟

1

Posted on by

处理过程:

 1.关闭apply

alter database stop logical standby apply;

停止不掉可以强制关闭

alter database abort logical standby apply;

 

2.排除表

EXEC DBMS_LOGSTDBY.SKIP('DML','ORADBCA','T_TRANSACTION_ORDER');

update system.logstdby$skip
set esc = '\'
where esc is NULL;
commit;

 

3.重新应用

alter database start logical standby apply immediate;

 

4.关闭应用

alter database stop logical standby apply;

 

5.把排除的表,重新恢复同步

EXEC DBMS_LOGSTDBY.UNSKIP('DML','ORADBCA','T_TRANSACTION_ORDER');

 

6.表初始化

exec dbms_logstdby.instantiate_table('ORADBCA','T_TRANSACTION_ORDER','Pridb');

 

7.起同步进程

alter database start logical standby apply immediate;

 

8.check check

 

 

–附检查s[……]

查看全文

第 7 页,共 12 页« 最新...5678910...最旧 »