- 浏览: 961063 次
- 性别:
- 来自: 杭州
文章分类
最新评论
-
孤星119:
好熟悉的数据库字段啊, 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace:
quxiaoyong 写道遇到个问题,网上一搜,全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong:
遇到个问题,网上一搜,全他妈这篇文章。你转来转去的有意思吗?
数据库连接错误ORA-28547 -
hctech:
关于version count过高的问题,不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace:
invalid 写道写的不错,我根据这个来安装,有点理解错误了 ...
AIX 配置vncserver
某客户数据库于2010年4月26日早晨9点左右发生单节点故障,后台故障表现为一节点数据库(hisdb01)异常终止,进一步导致一节点主机重启。前台故障表现为部分业务不可用。由于没有部署主机性能跟踪脚本,只能根据现场日志描述初步推断为主机资源不足(如文件句柄没有释放)从而导致Oracle实例异常终止。2010年6月7日早晨9点再次发生单节点故障。
后台日志分析
查看发生故障前后各种日志
1、 操作系统日志
2、crs后台日志:
3、实例orcl1日志:
4、实例asm1后台日志:
5、查看故障发生前nfile使用情况
6、查看imon_orcl1.log
从以上日志可以看出(红色部分标出),很可能是Oracle受操作系统资源限制引发的故障。进一步查看故障发生前后操作系统资源利用情况。
1、 查看nfile使用情况
2、 查看主机内存,CPU资源
3、 查看磁盘io情况
从以上三项可以基本初步评估主机在故障发生前后的资源使用情况,可以明确的看到,在发生故障时,主机资源比较空闲。
基于此类故障,在主机资源充足的情况下,发生资源争夺(如不能获得文件句柄),很可能于Oracle bug有关。查阅Oracle 官方文档,又一未公布bug( unpublished Bug 6931689)与此故障极为类似,详见metalink doc 739557.1。
此bug主要发生的平台为:
数据库版本为:10.2.0.3 to 11.1.0.6
解决方法为:
在目前版本的基础上,打下列补丁之一
建议:
1、目前数据库版本为10.2.0.4,可以在此补丁基础上应用最新的psu patch(10.2.0.4.4)
2、调大参数nfile至131072。
后台日志分析
查看发生故障前后各种日志
1、 操作系统日志
引用
Jun 7 09:08:18 hisdb01 cmcld[7603]: Unable to accept a connection: File table overflow
Jun 7 09:08:18 hisdb01 cmclconfd[2878]: Unable to allocate a socket: File table overflow
Jun 7 09:08:18 hisdb01 cmclconfd[2878]: Unable to open /etc/cmcluster/cmclconfig, File table overflow
Jun 7 09:08:18 hisdb01 cmcld[7603]: Unable to accept a connection: File table overflow
Jun 7 09:08:18 hisdb01 cmclconfd[2878]: Unable to resolve local hostname hisdb01 to determine the domain name
Jun 7 09:08:18 hisdb01 cmclconfd[2878]: Unable to allocate a socket: File table overflow
Jun 7 09:08:19 hisdb01 cmcld[7603]: Sending file $SGRUN/frdump.cmcld.8 (167257 bytes) to file assistant daemon.
Jun 7 09:08:18 hisdb01 cmclconfd[2878]: Unable to open /etc/cmcluster/cmclconfig, File table overflow
Jun 7 09:08:19 hisdb01 above message repeats 3 times
Jun 7 09:08:19 hisdb01 cmfileassistd[2894]: Updated file /var/adm/cmcluster/frdump.cmcld.8 (length = 167257).
Jun 7 09:09:00 hisdb01 inetd[1018]: hacl-cfg/tcp: accept: File table overflow
Jun 7 09:09:19 hisdb01 cmcld[7603]: Service cmfileassistd terminated due to an exit(0).
Jun 7 09:12:16 hisdb01 syslog: Unable to open the /etc/utmpx file, to sync the records from file->/usr/sbin/utmpd
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 above message repeats 13576 times
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 syslogd: utmp database: Bad file number
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 above message repeats 10 times
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 above message repeats 17 times
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:08:18 hisdb01 cmclconfd[2878]: Unable to allocate a socket: File table overflow
Jun 7 09:08:18 hisdb01 cmclconfd[2878]: Unable to open /etc/cmcluster/cmclconfig, File table overflow
Jun 7 09:08:18 hisdb01 cmcld[7603]: Unable to accept a connection: File table overflow
Jun 7 09:08:18 hisdb01 cmclconfd[2878]: Unable to resolve local hostname hisdb01 to determine the domain name
Jun 7 09:08:18 hisdb01 cmclconfd[2878]: Unable to allocate a socket: File table overflow
Jun 7 09:08:19 hisdb01 cmcld[7603]: Sending file $SGRUN/frdump.cmcld.8 (167257 bytes) to file assistant daemon.
Jun 7 09:08:18 hisdb01 cmclconfd[2878]: Unable to open /etc/cmcluster/cmclconfig, File table overflow
Jun 7 09:08:19 hisdb01 above message repeats 3 times
Jun 7 09:08:19 hisdb01 cmfileassistd[2894]: Updated file /var/adm/cmcluster/frdump.cmcld.8 (length = 167257).
Jun 7 09:09:00 hisdb01 inetd[1018]: hacl-cfg/tcp: accept: File table overflow
Jun 7 09:09:19 hisdb01 cmcld[7603]: Service cmfileassistd terminated due to an exit(0).
Jun 7 09:12:16 hisdb01 syslog: Unable to open the /etc/utmpx file, to sync the records from file->/usr/sbin/utmpd
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 above message repeats 13576 times
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 syslogd: utmp database: Bad file number
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 above message repeats 10 times
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 above message repeats 17 times
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
Jun 7 09:12:17 hisdb01 vmunix: file: table is full
2、crs后台日志:
引用
2010-06-06 21:15:09.225: [ CRSEVT][167223] CAAMonitorHandler :: 0:Could not execute /oracle/app/product/db10g/bin/racgwrap(check) for ora.orcl.orcl1.inst
category: 1234, operation: scls_process_spawn, loc: out_pipe, OS error: 23, other: out of memory
2010-06-06 21:15:09.225: [ CRSAPP][167223] CheckResource error for ora.orcl.orcl1.inst error code = -1
2010-06-06 21:15:19.211: [ CRSEVT][167224] CAAMonitorHandler :: 0:Could not execute /oracle/app/product/crs/bin/racgwrap(check) for ora.hisdb01.ons
category: 1234, operation: scls_process_spawn, loc: out_pipe, OS error: 23, other: out of memory
2010-06-06 21:15:19.211: [ CRSAPP][167224] CheckResource error for ora.hisdb01.ons error code = -1
2010-06-06 21:16:18.020: [ CRSEVT][167225] CAAMonitorHandler :: 0:Could not execute /oracle/app/product/db10g/bin/racgwrap(check) for ora.hisdb01.ASM1.asm
category: 1234, operation: scls_process_spawn, loc: out_pipe, OS error: 23, other: out of memory
2010-06-06 21:16:18.021: [ CRSAPP][167225] CheckResource error for ora.hisdb01.ASM1.asm error code = -1
category: 1234, operation: scls_process_spawn, loc: out_pipe, OS error: 23, other: out of memory
2010-06-06 21:15:09.225: [ CRSAPP][167223] CheckResource error for ora.orcl.orcl1.inst error code = -1
2010-06-06 21:15:19.211: [ CRSEVT][167224] CAAMonitorHandler :: 0:Could not execute /oracle/app/product/crs/bin/racgwrap(check) for ora.hisdb01.ons
category: 1234, operation: scls_process_spawn, loc: out_pipe, OS error: 23, other: out of memory
2010-06-06 21:15:19.211: [ CRSAPP][167224] CheckResource error for ora.hisdb01.ons error code = -1
2010-06-06 21:16:18.020: [ CRSEVT][167225] CAAMonitorHandler :: 0:Could not execute /oracle/app/product/db10g/bin/racgwrap(check) for ora.hisdb01.ASM1.asm
category: 1234, operation: scls_process_spawn, loc: out_pipe, OS error: 23, other: out of memory
2010-06-06 21:16:18.021: [ CRSAPP][167225] CheckResource error for ora.hisdb01.ASM1.asm error code = -1
3、实例orcl1日志:
引用
Sun Jun 6 21:08:42 2010
Errors in file /oracle/app/product/admin/orcl/udump/orcl1_ora_2915.trc:
ORA-00603: Message 603 not found; No message file for product=RDBMS, facility=ORA
ORA-27544: Message 27544 not found; No message file for product=RDBMS, facility=ORA
ORA-27300: Message 27300 not found; No message file for product=RDBMS, facility=ORA; arguments: [socket] [23]
ORA-27301: Message 27301 not found; No message file for product=RDBMS, facility=ORA; arguments: [File table overflow]
ORA-27302: Message 27302 not found; No message file for product=RDBMS, facility=ORA; arguments: [sskgxpcre1]
…
Sun Jun 6 21:40:52 2010
WARNING: kfk failed to open a disk[/dev/vgdata/rasm_disk5]
Sun Jun 6 21:40:52 2010
Errors in file /oracle/app/product/admin/orcl/udump/orcl1_ora_4809.trc:
ORA-15025: could not open disk '/dev/vgdata/rasm_disk5'
ORA-27041: unable to open file
HPUX-ia64 Error: 23: File table overflow
Additional information: 3
Sun Jun 6 21:40:52 2010
WARNING: kfk failed to open a disk[/dev/vgdata/rasm_disk5]
Sun Jun 6 21:40:52 2010
Errors in file /oracle/app/product/admin/orcl/udump/orcl1_ora_4809.trc:
ORA-15025: could not open disk '/dev/vgdata/rasm_disk5'
ORA-27041: unable to open file
HPUX-ia64 Error: 23: File table overflow
Additional information: 3
Errors in file /oracle/app/product/admin/orcl/udump/orcl1_ora_2915.trc:
ORA-00603: Message 603 not found; No message file for product=RDBMS, facility=ORA
ORA-27544: Message 27544 not found; No message file for product=RDBMS, facility=ORA
ORA-27300: Message 27300 not found; No message file for product=RDBMS, facility=ORA; arguments: [socket] [23]
ORA-27301: Message 27301 not found; No message file for product=RDBMS, facility=ORA; arguments: [File table overflow]
ORA-27302: Message 27302 not found; No message file for product=RDBMS, facility=ORA; arguments: [sskgxpcre1]
…
Sun Jun 6 21:40:52 2010
WARNING: kfk failed to open a disk[/dev/vgdata/rasm_disk5]
Sun Jun 6 21:40:52 2010
Errors in file /oracle/app/product/admin/orcl/udump/orcl1_ora_4809.trc:
ORA-15025: could not open disk '/dev/vgdata/rasm_disk5'
ORA-27041: unable to open file
HPUX-ia64 Error: 23: File table overflow
Additional information: 3
Sun Jun 6 21:40:52 2010
WARNING: kfk failed to open a disk[/dev/vgdata/rasm_disk5]
Sun Jun 6 21:40:52 2010
Errors in file /oracle/app/product/admin/orcl/udump/orcl1_ora_4809.trc:
ORA-15025: could not open disk '/dev/vgdata/rasm_disk5'
ORA-27041: unable to open file
HPUX-ia64 Error: 23: File table overflow
Additional information: 3
4、实例asm1后台日志:
引用
Sun Jun 6 21:14:26 2010
Errors in file /oracle/app/product/admin/+ASM/udump/+asm1_ora_3254.trc:
ORA-00603: Message 603 not found; No message file for product=RDBMS, facility=ORA
ORA-27504: Message 27504 not found; No message file for product=RDBMS, facility=ORA
ORA-27300: Message 27300 not found; No message file for product=RDBMS, facility=ORA; arguments: [ioctl] [23]
ORA-27301: Message 27301 not found; No message file for product=RDBMS, facility=ORA; arguments: [File table overflow]
ORA-27302: Message 27302 not found; No message file for product=RDBMS, facility=ORA; arguments: [skgxpvaddr1]
Errors in file /oracle/app/product/admin/+ASM/udump/+asm1_ora_3254.trc:
ORA-00603: Message 603 not found; No message file for product=RDBMS, facility=ORA
ORA-27504: Message 27504 not found; No message file for product=RDBMS, facility=ORA
ORA-27300: Message 27300 not found; No message file for product=RDBMS, facility=ORA; arguments: [ioctl] [23]
ORA-27301: Message 27301 not found; No message file for product=RDBMS, facility=ORA; arguments: [File table overflow]
ORA-27302: Message 27302 not found; No message file for product=RDBMS, facility=ORA; arguments: [skgxpvaddr1]
5、查看故障发生前nfile使用情况
引用
root@hisdb01:/sbin/init.d # kcusage nfile
Tunable Usage / Setting
=============================================
nfile 51795 / 65536
Tunable Usage / Setting
=============================================
nfile 51795 / 65536
6、查看imon_orcl1.log
引用
2010-06-17 17:38:17.168: [ RACG][30] [9233][30][ora.orcl.orcl1.inst]: GIMH: GIM-00104: Health check failed to connect to instance.
GIM-00090: OS-dependent operation:mmap failed with status: 12
GIM-00091: OS failure message: Not enough space
GIM-00092: OS failure occurred at: sskgmsmr_13
2010-06-17 17:39:17.178: [ RACG][30] [9233][30][ora.orcl.orcl1.inst]: GIMH: GIM-00104: Health check failed to connect to instance.
GIM-00090: OS-dependent operation:mmap failed with status: 12
GIM-00091: OS failure message: Not enough space
"/oracle/app/product/db10g/log/hisdb01/racg/imon_orcl.log" 158031 lines, 9229057 characters
GIM-00090: OS-dependent operation:mmap failed with status: 12
GIM-00091: OS failure message: Not enough space
GIM-00092: OS failure occurred at: sskgmsmr_13
GIM-00090: OS-dependent operation:mmap failed with status: 12
GIM-00091: OS failure message: Not enough space
GIM-00092: OS failure occurred at: sskgmsmr_13
2010-06-17 17:39:17.178: [ RACG][30] [9233][30][ora.orcl.orcl1.inst]: GIMH: GIM-00104: Health check failed to connect to instance.
GIM-00090: OS-dependent operation:mmap failed with status: 12
GIM-00091: OS failure message: Not enough space
"/oracle/app/product/db10g/log/hisdb01/racg/imon_orcl.log" 158031 lines, 9229057 characters
GIM-00090: OS-dependent operation:mmap failed with status: 12
GIM-00091: OS failure message: Not enough space
GIM-00092: OS failure occurred at: sskgmsmr_13
从以上日志可以看出(红色部分标出),很可能是Oracle受操作系统资源限制引发的故障。进一步查看故障发生前后操作系统资源利用情况。
1、 查看nfile使用情况
引用
root@hisdb02:/ # kcusage nfile
Tunable Usage / Setting
=============================================
nfile 12089 / 65536
Tunable Usage / Setting
=============================================
nfile 12089 / 65536
2、 查看主机内存,CPU资源
引用
zzz ***Sun Jun 6 21:17:20 EAT 2010
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
1 0 0 2311458 1996119 172 18 0 0 0 0 0 2620 21313 834 0 1 99
1 0 0 2311458 1996103 191 21 0 0 0 0 0 2408 16170 709 0 1 99
1 0 0 2311458 1995210 166 18 0 0 0 0 0 2403 14823 700 1 0 99
zzz ***Sun Jun 6 21:17:30 EAT 2010
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
1 0 0 2285994 1996297 172 18 0 0 0 0 0 2620 21313 834 0 1 99
1 0 0 2285994 1996297 171 20 0 0 0 0 0 2426 11112 710 1 1 98
1 0 0 2285994 1995404 150 17 0 0 0 0 0 2398 10711 694 0 1 99
zzz ***Sun Jun 6 21:17:40 EAT 2010
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
2 0 0 2196419 1996297 172 18 0 0 0 0 0 2620 21313 834 0 1 99
2 0 0 2196419 1995404 170 19 0 0 0 0 0 2372 10075 698 0 1 99
2 0 0 2196419 1995386 149 17 0 0 0 0 0 2380 10401 715 0 0 100
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
1 0 0 2311458 1996119 172 18 0 0 0 0 0 2620 21313 834 0 1 99
1 0 0 2311458 1996103 191 21 0 0 0 0 0 2408 16170 709 0 1 99
1 0 0 2311458 1995210 166 18 0 0 0 0 0 2403 14823 700 1 0 99
zzz ***Sun Jun 6 21:17:30 EAT 2010
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
1 0 0 2285994 1996297 172 18 0 0 0 0 0 2620 21313 834 0 1 99
1 0 0 2285994 1996297 171 20 0 0 0 0 0 2426 11112 710 1 1 98
1 0 0 2285994 1995404 150 17 0 0 0 0 0 2398 10711 694 0 1 99
zzz ***Sun Jun 6 21:17:40 EAT 2010
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
2 0 0 2196419 1996297 172 18 0 0 0 0 0 2620 21313 834 0 1 99
2 0 0 2196419 1995404 170 19 0 0 0 0 0 2372 10075 698 0 1 99
2 0 0 2196419 1995386 149 17 0 0 0 0 0 2380 10401 715 0 0 100
3、 查看磁盘io情况
引用
zzz ***Sun Jun 6 21:06:37 EAT 2010
device bps sps msps
c1t0d0 0 0.0 1.0
c6t0d1 0 0.0 1.0
c6t0d2 0 0.0 1.0
c6t0d3 0 0.0 1.0
c6t0d4 0 0.0 1.0
c6t0d5 0 0.0 1.0
c8t0d1 0 0.0 1.0
c8t0d2 0 0.0 1.0
c8t0d3 0 0.0 1.0
c8t0d4 0 0.0 1.0
c8t0d5 0 0.0 1.0
c10t0d1 0 0.0 1.0
c10t0d2 0 0.0 1.0
c10t0d3 0 0.0 1.0
c10t0d4 0 0.0 1.0
c10t0d5 0 0.0 1.0
c12t0d1 0 0.0 1.0
c12t0d2 0 0.0 1.0
c12t0d3 0 0.0 1.0
c12t0d4 0 0.0 1.0
c12t0d5 0 0.0 1.0
c6t0d6 0 0.0 1.0
c6t0d7 0 0.0 1.0
c6t1d0 0 0.0 1.0
c6t1d1 0 0.0 1.0
c6t1d2 0 0.0 1.0
c6t1d3 0 0.0 1.0
c8t0d6 0 0.0 1.0
c8t0d7 0 0.0 1.0
c8t1d0 0 0.0 1.0
c8t1d1 0 0.0 1.0
c8t1d2 0 0.0 1.0
c8t1d3 0 0.0 1.0
c10t0d6 0 0.0 1.0
c10t0d7 0 0.0 1.0
c10t1d0 0 0.0 1.0
c10t1d1 0 0.0 1.0
c10t1d2 0 0.0 1.0
c10t1d3 0 0.0 1.0
device bps sps msps
c1t0d0 0 0.0 1.0
c6t0d1 0 0.0 1.0
c6t0d2 0 0.0 1.0
c6t0d3 0 0.0 1.0
c6t0d4 0 0.0 1.0
c6t0d5 0 0.0 1.0
c8t0d1 0 0.0 1.0
c8t0d2 0 0.0 1.0
c8t0d3 0 0.0 1.0
c8t0d4 0 0.0 1.0
c8t0d5 0 0.0 1.0
c10t0d1 0 0.0 1.0
c10t0d2 0 0.0 1.0
c10t0d3 0 0.0 1.0
c10t0d4 0 0.0 1.0
c10t0d5 0 0.0 1.0
c12t0d1 0 0.0 1.0
c12t0d2 0 0.0 1.0
c12t0d3 0 0.0 1.0
c12t0d4 0 0.0 1.0
c12t0d5 0 0.0 1.0
c6t0d6 0 0.0 1.0
c6t0d7 0 0.0 1.0
c6t1d0 0 0.0 1.0
c6t1d1 0 0.0 1.0
c6t1d2 0 0.0 1.0
c6t1d3 0 0.0 1.0
c8t0d6 0 0.0 1.0
c8t0d7 0 0.0 1.0
c8t1d0 0 0.0 1.0
c8t1d1 0 0.0 1.0
c8t1d2 0 0.0 1.0
c8t1d3 0 0.0 1.0
c10t0d6 0 0.0 1.0
c10t0d7 0 0.0 1.0
c10t1d0 0 0.0 1.0
c10t1d1 0 0.0 1.0
c10t1d2 0 0.0 1.0
c10t1d3 0 0.0 1.0
从以上三项可以基本初步评估主机在故障发生前后的资源使用情况,可以明确的看到,在发生故障时,主机资源比较空闲。
基于此类故障,在主机资源充足的情况下,发生资源争夺(如不能获得文件句柄),很可能于Oracle bug有关。查阅Oracle 官方文档,又一未公布bug( unpublished Bug 6931689)与此故障极为类似,详见metalink doc 739557.1。
此bug主要发生的平台为:
引用
HP-UX PA-RISC (64-bit)
HP-UX Itanium
HP IA64 HPUNIXHP 9000 Series HP-UX (64-bit)
HP-UX Itanium
HP IA64 HPUNIXHP 9000 Series HP-UX (64-bit)
数据库版本为:10.2.0.3 to 11.1.0.6
引用
- 10.2.0.3, 10.2.0.3 + CRS Bundle Patch #2 or CRS Bundle Patch #3
- 10.2.0.4
- 11.1.0.6
- 10.2.0.4
- 11.1.0.6
解决方法为:
在目前版本的基础上,打下列补丁之一
引用
- CRS 10.2.0.4 Bundle Patch #2 (Patch 7493592) or above. See Note 405820.1
- Latest 10.2.0.4 CRS PSU Patch as per Note 756671.1
The fix has to be applied to both CRS and RAC Database home to fix the problem.
The BUG is fixed in 11.1.0.7 and will be fixed in 10.2.0.5.
- Latest 10.2.0.4 CRS PSU Patch as per Note 756671.1
The fix has to be applied to both CRS and RAC Database home to fix the problem.
The BUG is fixed in 11.1.0.7 and will be fixed in 10.2.0.5.
建议:
1、目前数据库版本为10.2.0.4,可以在此补丁基础上应用最新的psu patch(10.2.0.4.4)
2、调大参数nfile至131072。
发表评论
-
buffer cache 的内部结构
2020-03-18 14:21 524BUFFER CACHE作为数据块的 ... -
Oracle OMC介绍
2020-03-18 13:19 443Oracle管理云服务(OMC)的大数据平台,自动收集的企业 ... -
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 4252019年7月22日,受邀参加Oracle勒索病毒防范专题培训 ... -
记一次内存换IO的Oracle优化
2019-09-27 16:50 788某客户数据库从P595物理 ... -
如何定位Oracle SQL执行计划变化的原因
2019-07-03 14:49 1368性能优化最难的是能够 ... -
如何定位Oracle SQL执行计划变化的原因
2018-10-30 09:24 1185性能优化最难的是能够 ... -
数据库性能优化目标
2018-10-08 10:59 480从数据库性能优化的场 ... -
数据库无法打开的原因及解决办法
2018-10-05 20:45 1929数据库的启动是一个相当复杂的过程。比如,Oracle在启动之前 ... -
怎么样彻底删除数据库?
2018-09-18 11:10 558Oracle提供了drop database命令用来删除数据库 ... -
Oracle减少日志量的方法
2018-09-10 10:17 817LGWR进程将LOG BUFFER中的 ... -
如何快速关闭数据库
2018-09-09 13:14 1199“一朝被蛇咬,十年怕井绳”。在没被“蛇”咬之前,很多DBA喜欢 ... -
关于《如何落地智能化运维》PPT
2018-05-17 10:19 1093在DTCC 2018发表《如何落地智能化运维》演讲,主要内容如 ... -
记录在redhat5.8平台安装oracle11.2容易忽视的几个问题
2018-05-11 19:58 535问题一:ping不通问题 在虚拟机上安装好linux系统后, ... -
《Oracle DBA实战攻略》第一章
2018-05-11 10:42 896即日起,不定期更新《OracleDBA实战攻略》一书电子版,请 ... -
Oracle 12c新特性
2018-05-11 10:33 861查询所有pdb [oracle@gj4 ~]$ sqlplu ... -
关于修改memory_target的值后数据库无法启动的问题
2017-02-28 12:24 3932操作系统:RHEL6.5 数据库版本:11.2.0.4 ... -
10g rac安装error while loading shared libraries libpthread.so.0 问题
2017-02-28 12:22 63711g rac安装在二节点跑脚本一般会报此错误: 解决这个问 ... -
记一次Oracle会话共享模式故障处理过程
2017-02-27 19:16 762故障简述 XXX第八人民医院HIS数据库7月13日11点左右从 ... -
RESMGR:cpu quantum等待事件处理过程
2017-02-27 18:23 2492由于数据库上线过程中出现大量的RESMGR:cpu quant ... -
谈谈log file sync
2014-03-19 14:18 1682数据库中的log file sync等待事件指的是,当user ...
相关推荐
RAC-1 宕机,RAC-2正常,在RAC-2节点上,删除RAC-1节点步骤。
ORACLE RAC 节点有关的操作 srvctl crs_stop crs_stat crsctl
资源名称:深入理解Oracle RAC 12c内容简介:《深入理解Oracle RAC 12c》介绍了Oracle RAC 12c技术的方方面面,涵盖了与RAC技术相关的集群件知识、数据库知识、存储知识、网络知识,并在基于RAC的应用软件设计、优化...
Oracle 11GR2 RAC节点crash故障分析
现在的RAC环境是2节点的RAC,节点是RAC1和RAC2,在本文档中,我们要添加一个节点:RAC3。
Oracle RAC 19c集群搭建指南:实现高可用、高性能的数据库集群(超详细),一看就会的那种
实测oracle两节点rac11.2.0.1.0升级到11.2.0.4.0,能力有限,欢迎执指正
在多数业务中,Oracle 真正应用集群 (RAC) 配置的主要业务要求是整个系统中数据库层的可伸缩性 — 这样,当用户数增加时,可将额外实例...在本文中,我将讨论将节点添加到现有 Oracle RAC 10g 第 2 版集群所需的步骤。
4 节点 ORACLE RAC 安装和配置
Oracle RAC 删除节点配置手册
运维Oracle RAC 如果遇到故障,如何删除节点再添加节点,资源不足如何扩容,本篇文章告诉你。
这个文档详细的记录了重启Oracle rac的每一个步骤,重启的方法很多,这个可能不是最适合你的,但这个是有效的,这个文档是我给外行看的
由重启引起的Oracle RAC节点宕机分析及追根溯源.docx
Oracle12c双节点RAC在Linux7环境下的部署,本文档适用对象为 DBA 或具备一定 Linux/Oracle 基础知识的人员, 对 Oracle Enterprise Linux 操作系统下的 Oracle12.2.0.1 双节点 RAC 在 OEL 7.4 环境下的部署及初始化...
oracle rac (veritas)双机集群,一套机器挂了没发现,等两套都挂了才发现都是主板坏。。。
oracleRAC9 单节点安装文档
Linux 常用命令 oracle rac 中文手册 官网翻译 oracle rac
基于阿里云ECS环境及CentOS-linux 7.6系统环境下,安装部署Oracle 19C RAC双节点集群,每一步都很详细的说明了配置的方法和原因,白话文表述,小白也能轻松按照文档部署完成;
yum源配置 Oracle RAC部署环境
ORACLE RAC 磁盘无法mount,集群服务无法启动解决方案。