一个关于PSP0 进程悬而未决的问题
[oracle@zeng ~]$ sql
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 5 22:03:54 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00443: background process "PSP0" did not start
SQL> host
[oracle@zeng ~]$ oerr ora 00443
00443, 00000, "background process \"%s\" did not start"
// *Cause: The specified process did not start.
// *Action: Ensure that the executable image is in the correct place with
// the correct protections, and that there is enough memory.
说确保你数据库的可执行文件受到保护没有损坏，保证有足够的内存提供给oracle数据库。
不过我觉得应该不会是上述两个问题，因为这台虚拟机只有我一个人使用，而且我还很爱护他，而且以前都好好的，甚至更少内存的时候都好好的。再去看看alert.log
adrci> show alert -tail 5
2012-04-05 22:04:11.132000 +08:00
VKTM started with pid=3, OS id=4953 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
GEN0 started with pid=4, OS id=4957
DIAG started with pid=5, OS id=4959
DBRM started with pid=6, OS id=4961
2012-04-05 22:04:14.806000 +08:00
Process PSP0 died, see its trace file
USER (ospid: 4900): terminating the instance due to error 443
2012-04-05 22:04:16.488000 +08:00
Instance terminated by USER, pid = 4900
没有有用的信息，不过有问题查看 alert.log 是个好习惯。
我们来看看那个PSP0 ，这个进程好陌生，赶紧找资料弄明白。
PSP0 进程翻译成中文就是进程产生程序或者叫进程孵化程序。关键是他是怎么产生进程的？
产生什么进程？
套用操作系统的原理：
PSP0应该作为父进程向系统请求创建子进程。而子进程创建的过程是：
1、申请空白的PCB（进程控制块）。
2、为进程分配所需的资源。
3、初始化进程控制块，比如填写父进程id。
4、如果就绪队列能够容纳新的进程，便把进程插入就绪队列。
在这里根据一些提示，应该是第二步出现了问题。不过错误出现很多时候既有不可再现性。
我再次startup 本想再现一次错误的，结果启动了oracle 数据库，并且没有报错。另外一个问题时PSP0 产生了什么进程。既然系统启动了，那就来看看PSP0 之后有那些进程产生，把这些在PSP0 创建的进程，归功于PSP0 的进程的创建吗？没有明确的理由。这个问题限于本人的水平，到此就打住了，希望本篇博文能起到抛砖引玉的作用，大家一起来
研究研究这个PSP0 进程。
adrci> show alert -tail 60
2012-04-05 23:14:33.810000 +08:00
diagnostic_dest = "/opt/oracle11g"
PMON started with pid=2, OS id=5561
VKTM started with pid=3, OS id=5563 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
2012-04-05 23:14:34.903000 +08:00
GEN0 started with pid=4, OS id=5567
DIAG started with pid=5, OS id=5569
DBRM started with pid=6, OS id=5571
PSP0 started with pid=7, OS id=5573 #PSP0在这里。
DIA0 started with pid=8, OS id=5575
2012-04-05 23:14:36.162000 +08:00
MMAN started with pid=9, OS id=5577
DBW0 started with pid=10, OS id=5579
LGWR started with pid=11, OS id=5581
CKPT started with pid=12, OS id=5583
SMON started with pid=13, OS id=5585
RECO started with pid=14, OS id=5587
2012-04-05 23:14:37.506000 +08:00
MMON started with pid=15, OS id=5589
MMNL started with pid=16, OS id=5591
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26110315/viewspace-720481/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
位图索引（bitmap-index）
请登录后发表评论
登录
全部评论
