Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

6

积分

0

好友

0

主题
1#
发表于 2012-6-19 10:13:49 | 查看: 3748| 回复: 1
在创建用户表空间时,提示
ERROR at line 1:
ORA-03113: end-of-file on communication channel


ERROR at line 1:
ORA-03114: not connected to ORACLE


ps -ef |grep oracle 进程自动退出

请各位高手分析分析是什么问题造成的,和kernel.shmmax及kernel.shmall 有关系吗?谢谢了

日志
Jun 19 09:55:37 db1 kernel: Free pages:    44766276kB (44752880kB HighMem)
Jun 19 09:55:37 db1 kernel: Active:37431 inactive:4784295 dirty:838920 writeback:0 unstable:0 free:11190453 slab:88405 mapped-file:22552 mapped-anon:17029 pagetables:1465
Jun 19 09:55:37 db1 kernel: DMA free:4796kB min:68kB low:84kB high:100kB active:8kB inactive:36kB present:16384kB pages_scanned:0 all_unreclaimable? no
Jun 19 09:55:37 db1 kernel: lowmem_reserve[]: 0 0 880 65520
Jun 19 09:55:37 db1 kernel: DMA32 free:0kB min:0kB low:0kB high:0kB active:0kB inactive:0kB present:0kB pages_scanned:0 all_unreclaimable? no
Jun 19 09:55:37 db1 kernel: lowmem_reserve[]: 0 0 880 65520
Jun 19 09:55:37 db1 kernel: Normal free:7980kB min:3756kB low:4692kB high:5632kB active:1540kB inactive:1984kB present:901120kB pages_scanned:0 all_unreclaimable? no
Jun 19 09:55:37 db1 kernel: lowmem_reserve[]: 0 0 0 517120
Jun 19 09:55:37 db1 kernel: HighMem free:44699188kB min:512kB low:69552kB high:138592kB active:148216kB inactive:19188964kB present:66191360kB pages_scanned:0 all_unreclaimable? no
Jun 19 09:55:37 db1 kernel: lowmem_reserve[]: 0 0 0 0
Jun 19 09:55:37 db1 kernel: DMA: 303*4kB 0*8kB 0*16kB 0*32kB 0*64kB 0*128kB 0*256kB 1*512kB 1*1024kB 1*2048kB 0*4096kB = 4796kB
Jun 19 09:55:37 db1 kernel: DMA32: empty
Jun 19 09:55:37 db1 kernel: Normal: 649*4kB 52*8kB 17*16kB 2*32kB 7*64kB 1*128kB 1*256kB 1*512kB 0*1024kB 1*2048kB 0*4096kB = 6740kB
Jun 19 09:55:37 db1 kernel: HighMem: 0*4kB 1*8kB 1*16kB 0*32kB 1*64kB 1*128kB 1*256kB 0*512kB 1*1024kB 1*2048kB 10904*4096kB = 44666328kB
Jun 19 09:55:37 db1 kernel: 4828777 pagecache pages
Jun 19 09:55:37 db1 kernel: Swap cache: add 0, delete 0, find 0/0, race 0+0
Jun 19 09:55:37 db1 kernel: Free swap  = 33599936kB
Jun 19 09:55:37 db1 kernel: Total swap = 33599936kB
Jun 19 09:55:37 db1 kernel: Free swap:       33599936kB
Jun 19 09:55:37 db1 kernel: 16777216 pages of RAM
Jun 19 09:55:37 db1 kernel: 16547840 pages of HIGHMEM
Jun 19 09:55:37 db1 kernel: 662349 reserved pages
Jun 19 09:55:37 db1 kernel: 4838909 pages shared
Jun 19 09:55:37 db1 kernel: 0 pages swap cached
Jun 19 09:55:37 db1 kernel: 837620 pages dirty
Jun 19 09:55:37 db1 kernel: 0 pages writeback
Jun 19 09:55:37 db1 kernel: 22568 pages mapped
Jun 19 09:55:37 db1 kernel: 89931 pages slab
Jun 19 09:55:37 db1 kernel: 1410 pages pagetables
Jun 19 09:55:37 db1 kernel: Out of memory: Killed process 25664, UID 800, (oracle).
2#
发表于 2012-6-19 21:26:24
请上传压缩后完整的alert.log

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 01:08 , Processed in 0.046739 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569