论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2008-05-03 17:26 |只看该作者 |倒序浏览

数据库启动后一段时间后又停了

shutdown后提示
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
Linux Error:2:No such file or directory

然后直接startup,数据库启动了
但是过了一段时间后，数据库又停了
不知道怎么回事

请教各位了！

文库|博客

zhen917

家境小康

论坛徽章:: 0

2楼 [报告]

发表于 2008-05-03 17:29 |只看该作者

把最近出问题的ALERT_LOG贴出来看看

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

sewocig

白手起家

论坛徽章:: 0

3楼 [报告]

发表于 2008-05-03 18:15 |只看该作者

回复 #2 zhen917 的帖子

alert_NH.log

Memory Notification: Library Cache Object loaded into SGA

Errors in file /home/oracle/admin/ODSKF/bdump/odskf_ckpt_1880172.trc:
ORA-00600: internal error code, arguments: [3751], [1], [253], [16777217], [17387], [26337], [], []

Errors in file /home/oracle/admin/ODSKF/bdump/odskf_pmon_1630266.trc:
ORA-27300: OS system dependent operation:invalid_process failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgpstime3
ORA-27144: attempt to kill process failed
ORA-00469: CKPT process terminated with error
************************************************
odskf_pmon_1630266.trc：

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /home/oracle/product/10.2.0
System name: AIX
Node name:    test1
Release:       3
Version:       5
Machine:       00001768D700
Instance name: ODSKF
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 1630266, image: oracle@test1 (PMON)

*** 2008-05-03 15:55:38.732
*** SERVICE NAME

SYS$BACKGROUND) 2008-05-03 15:55:38.671
*** SESSION ID

1105.1) 2008-05-03 15:55:38.671
Background process CKPT found dead
Oracle pid = 7
OS pid (from detached process) = 1880172
OS pid (from process state) = 1880172
dtp = 700000010019660, proc = 70000005cb898a8
Dump of memory from 0x0700000010019660 to 0x07000000100196A8
700000010019660 00000076 00000000 07000000 5CB898A8  [...v........\...]
700000010019670 00000000 00000000 00000000 434B5054  [............CKPT]
700000010019680 00020000 00000000 001CB06C 00000000  [...........l....]
700000010019690 00000000 481C1162 00000001 2AF6CA9D  [....H..b....*...]
7000000100196A0 00040081 00000000                   [........]
Dump of memory from 0x070000005CB898A8 to 0x070000005CB8A088
70000005CB898A0                02010000 00000000       [........]
70000005CB898B0 00000000 00000000 00000000 00000000  [................]
70000005CB898C0 00000000 00000000 07000000 580E7248  [............X.rH]
70000005CB898D0 07000000 5ABF2D70 07000000 5A443BF0  [....Z.-p....ZD;.]
70000005CB898E0 07000000 5ABF1668 00000000 00000000  [....Z..h........]
70000005CB898F0 07000000 5ABF16F0 07000000 5ABF16F0  [....Z.......Z...]
70000005CB89900 07000000 5ABF2D60 01060900 00000000  [....Z.-`........]
70000005CB89910 07000000 5A3B7D68 07000000 5A443BF0  [....Z;}h....ZD;.]
70000005CB89920 00000007 00000000 07000000 5A446750  [............ZDgP]
70000005CB89930 07000000 5A446A00 00000000 00000000  [....ZDj.........]
70000005CB89940 07000000 5A83D1C0 07000000 5A83E730  [....Z.......Z..0]
70000005CB89950 00000000 00000000 00000000 00000000  [................]