临下班时，随意执行一句sql，检查一下表里的数据，突然报错，大致是"No Shared Memory"，然后急忙telnet到主机，发现oracle已经Crash了，SGA也全部释放出来了。检查alert.logErrors in file /oracle/app/oracle/admin/custom/bdump/lgwr_6215_custom.trc:ORA-00313: open failed for members of log group 3 of thread 1ORA-00312: online log 3 thread 1: '/dev/vgqddata01/rredo_3'ORA-27086: skgfglk: unable to lock file - already in useHP-UX Error: 46: No locks availableAdditional information: 8Tue May 16 17:05:33 2006LGWR: terminating instance due to error 313Instance terminated by LGWR, pid = 6215
还有trc文件*** 2006-05-16 17:05:33.133*** SESSION ID:(3.1) 2006-05-16 17:05:33.111ORA-00313: open failed for members of log group 3 of thread 1ORA-00312: online log 3 thread 1: '/dev/vgqddata01/rredo_3'ORA-27086: skgfglk: unable to lock file - already in useHP-UX Error: 46: No locks availableAdditional information: 8error 313 detected in background processORA-00313: open failed for members of log group 3 of thread 1ORA-00312: online log 3 thread 1: '/dev/vgqddata01/rredo_3'ORA-27086: skgfglk: unable to lock file - already in useHP-UX Error: 46: No locks availableAdditional information: 8
试图重起数据库，失败ALTER DATABASE OPENTue May 16 17:08:55 2006Errors in file /oracle/app/oracle/admin/custom/bdump/dbw0_8764_custom.trc:ORA-01157: cannot identify/lock data file 157 - see DBWR trace fileORA-01110: data file 157: '/dev/vgqddata04/rlvqddata04_2000_13'ORA-27086: skgfglk: unable to lock file - already in useHP-UX Error: 46: No locks available
从表象上看，应该是主机对设备文件操作时，无法为设备文件分配新的lock，怀疑和nflocks参数有关。先未改参数，重起主机后，起数据库，正常。将nflocks参数改为1632后重起机器及数据库，正常，但是发现参数并未修改成功。
继续实验一下，后面再补。
2006.5.17 update
Moving the New Kernel into Place
对内核配置做了修改后，选择Process New Kernel，SAM将对所做的修改生成新的内核。新建的内核有3个组件：1.vmunix_test 静态可执行内核。2.dlkm.vmunix_test 经编译的新内核相关的DLKM模块。3.system.SAM 列出结合到新内核中的静态驱动程序，子系统、参数的一份文本文件。SAM在/stand/build目录中生成新的内核，然而，下一次重新引导时，系统将从/stand/vmunix目录中引导内核。因此，必须将新内核与相关文件移动到/stand，然后重新引导，使改变生效。需要保留一份当前系统的内核，防止新内核不可引导。选择Move Kernel into Palce and Shutdown/Reboot System Now后，SAM将立即对新内核进行备份，并将内核移动到指定位置。若需要稍后再移动并重新引导，执行以下命令：#cd /stand#cp /stand/system /stand/system.prev#cp /stand/build/system.SAM /stand/system#kmupdate /stand/build/vmunix_test#shutdown -ry 0使用kmupdate而不是cp或mv替代当前的vmunix文件或dlkm目录
作者: sopher | 可以转载, 转载时务必以超链接形式标明文章原始出处和作者信息及版权声明
网址: http://www.color-cc.com/2006/05/hp.html
Comments (2)
1
(Web)
Posted on May 16, 2006 20:05
AUTHOR:
EMAIL:
IP:
URL:
DATE: 05/16/2006 08:05:05 PM
AUTHOR:
EMAIL:
URL:
IP:
DATE: 05/16/2006 08:05:05 PM
2
(Web)
Posted on May 16, 2006 20:05
AUTHOR:
EMAIL:
IP:
URL:
DATE: 05/16/2006 08:05:05 PM
AUTHOR:
EMAIL:
URL:
IP:
DATE: 05/16/2006 08:05:05 PM
