ITPub博客

[oracle@dm10db04 trace]$ srvctl start instance -d haiermdm -i haiermdm4<br />PRCR-1013 : Failed to start resource ora.haiermdm.db<br />PRCR-1064 : Failed to start resource ora.haiermdm.db on node dm10db04<br />CRS-5017: The resource action "ora.haiermdm.db start" encountered the following error:...

<p style="margin-top:0px;margin-bottom:16px;font-size:16px;font-family:微软雅黑, Tahoma;line-height:25.59375px;white-space:normal;background-color:#FFFFFF;">1.最近客户系统在执行ETL时，出现异常宕机</p><p style="margin-top:0px;margin-bottom:16px;font-size:16px;font-family:微软雅黑, Tahoma;line-hei...

客户系统alert log中出现大量的分布式延时信息：Wed Jun 03 20:05:44 2015DISTRIB TRAN HAIERMDM.f905907b.355.1.7544  is local tran 355.1.7544 (hex=163.01.1d78)  insert pending committed tran, scn=13510368365236 (hex=c49.a0b50ab4)Wed Jun 03 20:05:44 2015DISTRIB TRAN HAIERMDM.f905907b.355.1...

Thu May 21 23:26:00 2015Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F167EC05000] [PC:0x49E0CF0, __intel_new_memcpy()+5424] [flags: 0x0, count: 1]Errors in file /u01/app/oracle/diag/rdbms/oms/OMS3/trace/OMS3_j001_10768.trc  (incident=1635086):ORA-07445: exception...

Errors in file /u01/app/oracle/diag/rdbms/oms/OMS3/trace/OMS3_j001_13961.trc:ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_47429"ORA-01426: numeric overflowORA-06512: at "SYS.DBMS_ADVISOR", line 201ORA-06512: at "SYS.DBMS_SPACE", line 2480ORA-06512: at "SYS.DBMS_SPACE", line 2553

waring 1： WARNINGASM CheckLinux Disk I/O Scheduler should be configured to [Deadline]All ASM InstancesView做了如下修改：[root@bcc1 ~]# echo 'deadline' > /sys/block/sda/queue/scheduler[root@bcc1 ~]# cat...

[grid@bcc2 ~]$ sqlSQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 7 15:26:21 2015Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to an idle instance.SQL> exitDisconnected[grid@bcc2 ~]$ vi .bash_profile # .bash_profile# Get the aliases and functionsi...

在导出过程中遇到：ORA-01691: unable to extend lob segment SYS.SYS_LOB0001625349C00044$$ by 61446 in tablespace SYSTEM  很明显是表空间空间不够了，无法导出对象。随后扩展了表空间大小alter tablespace system add datafile '/../../rlv1_system12' size 10g;顺利导出总结：      ...

MAN> restore database from tag "TAG20141120T184440";Starting restore at 26-NOV-14allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=316 device type=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: SID=315 device type=DISKallocated channel: ORA_DISK_3channel ORA_DISK_3: SID=317 device ...

发现告警信息Wed Nov 19 07:16:18 2014Dumping diagnostic data indirectory=[cdmp_20141119071618], requested by (instance=1, osid=125680 (J000)),summary=[abnormal process termination].Non critical errorORA-48913 caught while writing to trace file"/u01/app/oracle/diag/rdbms/ed...

1、今天在测试库做实验时遇到了一个关于listener报错。问题如下Oracle Restart enable database creation requries Default listener configured and running in Grid Infrastructure home，Use NETCA in Grid Infra...

错误描述,在DBCA创建ASM单实例数据库到86%进度时，报错PRCR-1079 : Failed to start resource .testdb.dbORA-12547: TNS:lost contact在网上查了一下多是grid用户下$ORACLE_HOME/bin/oracle 和 oracle用户下 $OR...

在DBCA 单实例 创建过程中报错如下由于我是ASM单实例数据库创建，所以我使用grid用户创建的 listener 结果导致如上报错 在EM创建资料库的时候，需要记录listener的home 目录对于oracle用户来说，listener的home...

在安装GI，第一个节点的root.sh一般不易出错，但是第二个节点就遇到了下面的错误Start of resource “ora.asm -init” failedFailed to start ASMFailed to start Oracle Clusterware stack检查错误日志grid@znod...

Enterprise manager configuration failed due to the following error -Failed to allocate prot(s) in the specified range(s) for the follow process(es) : JMS [5540-5559],RMI [5520-5539],Database...