-
编辑 删除
Oracle11gR2 RAC 使用scan IP无法连接数据库（ORA-12545）问题解决
现象：在windows客户端sqlplus工具使用scan的IP无法连接，报错如下：C:\Users\WJW>sqlplus system/qweasd@192.168.100.200:1521/orclSQL*Plus: Release 11.2.0.1.0 Production on Thu May 17 12:35:28 2012Copyr...
-
编辑 删除
10G ocr损坏的故障的恢复
群里朋友新装的RAC,CRS出现问题启动不了 [root@rac1 bin]# ps -ef | grep -i crsroot 470 22001 0 09:...
-
编辑 删除
shmmax,shmall 参数调优案例
看如下案例,sga大小为10G,而包含key为0x00000000的关于sga的segment有好多个,根据oracle官方文档,SHMMAX Available physical memory Defines the maximum allowable size of one shared memo...
-
编辑 删除
Thread 1 cannot allocate new log, sequence 586 Private strand flush not complete
查看alert日志：Private strand flush not completeThe following message may be seen in the Oracle alert log on the primary server:Thread 1 cannot allocate new log, sequence 586 Private strand flus...
-
编辑 删除
IMP时数据库的IO性能监控,并提供IOPS的计算方法
[root@ntkdb oradata]# iostat -x 1 10 Linux 2.6.9-67.ELlargesmp (ntkdb) 07/15/2011 &nbs...
-
编辑 删除
ORA-29558: JAccelerator (NCOMP) not installed报错分析
1 问题描述当给已创建好的数据库安装oracle10.2.0.4或oracle10.2.0.5补丁，运行catupgrd.sql脚本时会出现 ORA-29558: JAccelerator (NCOMP) not installed报错。select dbms_java.full_ncomp_enabled from dual*ERRO...
-
编辑 删除
undo损坏的数据库非常规的恢复
报错日志如下: cat lion_smon_7022.trc | more/u01/admin/lion/bdump/lion_smon_7022.trcOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and D...
