打开RAC后发现系统报错:ORA-00600: internal error code, arguments: [kffmAllocate_1], [26],[2], [], [],
查询metalink后发现是bug:
ORA-600 [kffmallocate_1] [ID 406799.1]
需要打补丁10.2.0.3查询数据库版本:
Oracle Database 10g Enterprise EditionRelease 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 -Production
NLSRTL Version 10.2.0.1.0 – Production
决定打补丁10.2.0.4,最新的是10.2.0.5
在metalink中输入10.2.0.4 patch set,找到文章
Patch 6810189 released 17-MAR-2008
下载补丁,导入到DBP虚机,节点1;
解压缩补丁包,并且停数据库和CRS以及asm服务;
[root@dbp ~]# cd Desktop/
[root@dbp Desktop]# ls
p6810189_10204_Linux-x86-64.zip
[root@dbp Desktop]# mv p6810189_10204_Linux-x86-64.zip /home/oracle/
[root@dbp Desktop]# cd /home/oracle/
[root@dbp oracle]# ls
Desktop ocrbak_votedisk p6810189_10204_Linux-x86-64.zip
[root@dbp oracle]# chown oracle.dba p6810189_10204_Linux-x86-64.zip
[root@dbp oracle]# su - oracle
[oracle@dbp ~]$ ls
Desktop ocrbak_votedisk p6810189_10204_Linux-x86-64.zip
[oracle@dbp ~]$ unzip p6810189_10204_Linux-x86-64.zip
查询CRS和数据库的版本是否相同:
[oracle@dbp ~]$ crsctl query crs softwareversion
CRS software version on node [dbp] is [10.2.0.1.0]
[oracle@dbp ~]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.1.0]
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 – Production
将数据库和CRS、ASM停掉
[oracle@dbp ~]$ srvctl stop database -d wxxrdb
[oracle@dbp ~]$ srvctl stop nodeapps -n dbp
[oracle@dbp ~]$ srvctl stop nodeapps -n dbs
[oracle@dbp ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE dbp
ora....BP.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbp.vip application 0/0 0/0 OFFLINE OFFLINE
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE dbs
ora....BS.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbs.vip application 0/0 0/0 OFFLINE OFFLINE
ora.wxxrdb.db application 0/1 0/1 OFFLINE OFFLINE
ora....b1.inst application 0/5 0/0 OFFLINE OFFLINE
ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE
[oracle@dbp ~]$ crs_stop -all
Attempting to stop `ora.dbp.ASM1.asm` on member `dbp`
Attempting to stop `ora.dbs.ASM2.asm` on member `dbs`
Stop of `ora.dbs.ASM2.asm` on member `dbs` succeeded.
Stop of `ora.dbp.ASM1.asm` on member `dbp` succeeded.
使用xmanager登陆DBP节点1,运行./runinstaller制定补丁程序,注意别忘记使用emctl stop dbconsole将em停掉,否则报java程序无法覆盖的错误(会在升级数据库的时候报错,升级CRS的时候不会报错);
在此贴出强行关闭em的调试命令行:
[root@dbp ~]# ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 4756 556 ? S 08:31 0:00 init [5]
root 2 0.0 0.0 0 0 ? SN 08:31 0:00 [ksoftirqd/0]
root 3 0.0 0.0 0 0 ? S< 08:31 0:06 [events/0]
root 4 0.0 0.0 0 0 ? S< 08:31 0:00 [khelper]
root 5 0.0 0.0 0 0 ? S< 08:31 0:00 [kacpid]
root 18 0.0 0.0 0 0 ? S< 08:31 0:00 [kblockd/0]
root 19 0.0 0.0 0 0 ? S 08:31 0:00 [khubd]
root 40 0.0 0.0 0 0 ? S 08:31 0:00 [pdflush]
root 41 0.0 0.0 0 0 ? S 08:31 0:03 [pdflush]
root 42 0.0 0.0 0 0 ? S 08:31 0:00 [kswapd0]
root 43 0.0 0.0 0 0 ? S< 08:31 0:00 [aio/0]
root 187 0.0 0.0 0 0 ? S 08:31 0:00 [kseriod]
root 416 0.0 0.0 0 0 ? S< 08:31 0:00 [ata/0]
root 417 0.0 0.0 0 0 ? S< 08:31 0:00 [ata_aux]
root 419 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_0]
root 420 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_1]
root 421 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_2]
root 422 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_3]
root 456 0.0 0.0 0 0 ? S 08:31 0:02 [kjournald]
root 1113 0.0 0.0 0 0 ? S< 08:31 0:00 [kauditd]
root 3567 0.0 0.0 3608 456 ? S<s 08:31 0:00 udevd
root 3753 0.0 0.0 0 0 ? S< 08:31 0:00 [iprt/0]
root 4282 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4283 0.0 0.0 0 0 ? S 08:31 0:02 [kjournald]
root 4284 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4285 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4742 0.0 0.0 3632 600 ? Ss 08:32 0:00 syslogd -m 0
root 4746 0.0 0.0 2540 372 ? Ss 08:32 0:00 klogd -x
rpc 4769 0.0 0.0 4756 564 ? Ss 08:32 0:00 portmap
rpcuser 4789 0.0 0.0 5808 744 ? Ss 08:32 0:00 rpc.statd
root 4818 0.0 0.0 20932 416 ? Ss 08:32 0:00 rpc.idmapd
root 5212 0.0 0.0 2544 448 ? Ss 08:32 0:00 /usr/sbin/acpid
root 5223 0.0 0.0 21936 1276 ? Ss 08:32 0:00 /usr/sbin/sshd
root 5288 0.0 0.0 8720 776 ? Ss 08:32 0:00 xinetd -stayalive
root 5311 0.0 0.0 4180 340 ? Ss 08:32 0:00 gpm -m /dev/input
root 5321 0.0 0.0 57064 940 ? Ss 08:32 0:00 crond
xfs 5341 0.0 0.0 10432 1968 ? Ss 08:32 0:00 xfs -droppriv -da
root 5360 0.0 0.0 8916 424 ? Ss 08:32 0:00 /usr/sbin/atd
dbus 5423 0.0 0.0 10700 852 ? Ss 08:32 0:00 dbus-daemon-1 --s
root 5436 0.0 0.0 10044 940 ? Ss 08:32 0:00 cups-config-daemo
root 5447 0.0 0.0 15240 2552 ? Ss 08:32 0:00 hald
root 5518 0.0 0.0 2528 404 tty1 Ss+ 08:32 0:00 /sbin/mingetty tt
root 5521 0.0 0.0 2528 404 tty2 Ss+ 08:32 0:00 /sbin/mingetty tt
root 5524 0.0 0.0 2528 404 tty3 Ss+ 08:32 0:00 /sbin/mingetty tt
root 5527 0.0 0.0 2528 404 tty4 Ss+ 08:32 0:00 /sbin/mingetty tt
root 5530 0.0 0.0 2528 404 tty5 Ss+ 08:32 0:00 /sbin/mingetty tt
root 5533 0.0 0.0 2528 404 tty6 Ss+ 08:32 0:00 /sbin/mingetty tt
root 5536 0.0 0.0 90136 2904 ? Ss 08:32 0:00 /usr/bin/gdm-bina
root 6346 0.0 0.0 105244 3048 ? S 08:32 0:00 /usr/bin/gdm-bina
root 6367 0.1 0.6 38416 24772 ? S 08:32 0:25 /usr/X11R6/bin/X
root 6742 0.0 0.0 37100 2628 ? Ss 08:33 0:01 sshd: root@pts/1
root 6744 0.0 0.0 53964 1568 pts/1 Ss 08:33 0:00 -bash
root 7874 0.0 0.0 6436 1124 ? Ss 14:34 0:00 /bin/sh /etc/init
root 7883 0.0 0.0 6580 1352 ? Ss 14:34 0:00 /bin/sh /etc/init
root 7892 0.0 0.0 6436 1140 ? Ss 14:34 0:00 /bin/sh /etc/init
root 8525 0.0 0.0 23884 1140 ? S 14:34 0:00 /bin/su -l oracle
oracle 8552 0.1 0.3 227052 15464 ? Ssl 14:34 0:01 /oracle/product/c
root 8641 0.5 0.6 530420 25696 ? Ssl 14:34 0:03 /oracle/product/c
root 8688 0.0 0.0 6580 1352 ? S 14:34 0:00 /bin/sh /etc/init
root 8701 0.0 0.0 6580 1344 ? S 14:34 0:00 /bin/sh /etc/init
root 8799 0.0 0.0 6580 1352 ? S 14:34 0:00 /bin/sh /etc/init
root 8963 0.0 0.0 5092 536 ? S 14:34 0:00 /sbin/runuser -l
oracle 8964 0.0 0.0 52748 1016 ? S 14:34 0:00 /bin/sh -c cd /or
oracle 8990 0.0 0.2 42600 9408 ? Ss 14:34 0:00 /oracle/product/c
root 9096 0.0 0.0 8456 2328 ? SL 14:34 0:00 /oracle/product/c
oracle 9221 0.1 4.6 201156 187900 ? SLl 14:34 0:01 /oracle/product/c
oracle 9361 0.0 0.2 58144 10900 ? S 14:34 0:00 /oracle/product/c
oracle 13337 0.0 0.2 134740 10964 ? Ss 14:12 0:00 /usr/bin/gnome-se
oracle 13467 3.0 1.5 569512 63896 pts/1 Sl 14:42 0:05 /oracle/product/d
oracle 13638 0.0 0.0 66708 1840 ? Sl 14:12 0:00 /usr/bin/VBoxClie
oracle 13646 0.0 0.0 66740 1588 ? Sl 14:12 0:00 /usr/bin/VBoxClie
oracle 13651 0.0 0.0 64604 1128 ? Sl 14:12 0:00 /usr/bin/VBoxClie
oracle 13656 0.0 0.0 66356 1616 ? Sl 14:12 0:00 /usr/bin/VBoxClie
oracle 13721 0.0 0.0 17340 800 ? Ss 14:12 0:00 /usr/bin/ssh-agen
oracle 13748 0.0 0.0 9944 528 ? S 14:12 0:00 /usr/bin/dbus-lau
oracle 13767 0.0 0.0 10704 1036 ? Ss 14:12 0:00 dbus-daemon-1 --f
oracle 13829 0.0 0.2 71800 9232 ? S 14:12 0:00 /usr/libexec/gcon
oracle 14112 0.0 0.0 5260 576 ? S 14:12 0:00 /usr/bin/gnome-ke
oracle 14114 0.0 0.0 69620 2892 ? Ss 14:12 0:00 /usr/libexec/bono
oracle 14116 0.0 0.1 137204 7664 ? S 14:13 0:00 /usr/libexec/gnom
oracle 14147 0.0 0.0 5404 1208 ? S 14:13 0:00 /usr/libexec/gam_
oracle 14156 0.0 0.0 24624 1992 ? S 14:13 0:00 xscreensaver -nos
oracle 14205 0.0 0.1 102860 7980 ? Ss 14:13 0:00 /usr/bin/metacity
oracle 14209 0.0 0.3 142136 12924 ? Ss 14:13 0:00 gnome-panel --sm-
oracle 14211 0.0 0.4 169692 17820 ? Ssl 14:13 0:00 nautilus --no-def
oracle 14213 0.0 0.1 132704 6664 ? Ss 14:13 0:00 gnome-volume-mana
oracle 14242 0.0 0.1 160212 7960 ? Ssl 14:13 0:00 eggcups --sm-clie
oracle 14244 0.0 0.1 99028 4652 ? Ss 14:13 0:00 pam-panel-icon --
oracle 14246 0.4 0.5 200728 21676 ? RNs 14:13 0:08 /usr/bin/python /
root 14249 0.0 0.0 6788 588 ? S 14:13 0:00 /sbin/pam_timesta
oracle 14252 0.0 0.0 101836 3928 ? Sl 14:13 0:00 /usr/libexec/gnom
oracle 14262 0.0 0.0 5168 704 ? S 14:13 0:00 /usr/libexec/mapp
oracle 14339 0.0 0.2 140264 11384 ? S 14:13 0:00 /usr/libexec/wnck
oracle 14341 0.0 0.2 144644 11924 ? S 14:13 0:00 /usr/libexec/mixe
oracle 14368 0.0 0.2 134736 8684 ? S 14:13 0:00 /usr/libexec/cloc
oracle 14370 0.0 0.1 131676 7240 ? S 14:13 0:00 /usr/libexec/noti
oracle 14397 0.0 0.3 169468 14688 ? Sl 14:13 0:00 /usr/bin/gnome-te
oracle 14424 0.0 0.0 6208 616 ? S 14:13 0:00 gnome-pty-helper
oracle 14426 0.0 0.0 53968 1568 pts/2 Ss+ 14:13 0:00 bash
oracle 14499 6.8 1.8 352140 73176 pts/2 Sl 14:44 0:06 /tmp/OraInstall20
oracle 15277 0.0 0.0 5372 904 pts/1 S 14:46 0:00 sh -c /oracle/pro
oracle 15278 0.0 0.1 26032 5056 pts/1 S 14:46 0:00 /oracle/product/d
root 15295 0.0 0.0 6324 476 ? S 14:46 0:00 /bin/sleep 1
root 15296 0.0 0.0 5448 792 pts/1 R+ 14:46 0:00 ps aux
oracle 20262 0.0 0.1 7752 6280 pts/1 S 08:41 0:00 /oracle/product/d
oracle 24145 0.0 0.4 67736 18200 pts/1 Sl 08:43 0:06 /oracle/product/d
[root@dbp ~]# ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 4756 556 ? S 08:31 0:00 init [5]
root 2 0.0 0.0 0 0 ? SN 08:31 0:00 [ksoftirqd/0]
root 3 0.0 0.0 0 0 ? S< 08:31 0:06 [events/0]
root 4 0.0 0.0 0 0 ? S< 08:31 0:00 [khelper]
root 5 0.0 0.0 0 0 ? S< 08:31 0:00 [kacpid]
root 18 0.0 0.0 0 0 ? S< 08:31 0:00 [kblockd/0]
root 19 0.0 0.0 0 0 ? S 08:31 0:00 [khubd]
root 40 0.0 0.0 0 0 ? S 08:31 0:00 [pdflush]
root 41 0.0 0.0 0 0 ? S 08:31 0:03 [pdflush]
root 42 0.0 0.0 0 0 ? S 08:31 0:00 [kswapd0]
root 43 0.0 0.0 0 0 ? S< 08:31 0:00 [aio/0]
root 187 0.0 0.0 0 0 ? S 08:31 0:00 [kseriod]
root 416 0.0 0.0 0 0 ? S< 08:31 0:00 [ata/0]
root 417 0.0 0.0 0 0 ? S< 08:31 0:00 [ata_aux]
root 419 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_0]
root 420 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_1]
root 421 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_2]
root 422 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_3]
root 456 0.0 0.0 0 0 ? S 08:31 0:02 [kjournald]
root 1113 0.0 0.0 0 0 ? S< 08:31 0:00 [kauditd]
root 3567 0.0 0.0 3608 456 ? S<s 08:31 0:00 udevd
root 3753 0.0 0.0 0 0 ? S< 08:31 0:00 [iprt/0]
root 4282 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4283 0.0 0.0 0 0 ? S 08:31 0:02 [kjournald]
root 4284 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4285 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4742 0.0 0.0 3632 600 ? Ss 08:32 0:00 syslogd -m 0
root 4746 0.0 0.0 2540 372 ? Ss 08:32 0:00 klogd -x
rpc 4769 0.0 0.0 4756 564 ? Ss 08:32 0:00 portmap
rpcuser 4789 0.0 0.0 5808 744 ? Ss 08:32 0:00 rpc.statd
root 4818 0.0 0.0 20932 416 ? Ss 08:32 0:00 rpc.idmapd
root 5212 0.0 0.0 2544 448 ? Ss 08:32 0:00 /usr/sbin/acpid
root 5223 0.0 0.0 21936 1276 ? Ss 08:32 0:00 /usr/sbin/sshd
root 5288 0.0 0.0 8720 776 ? Ss 08:32 0:00 xinetd -stayalive -pidfile /var/run/xinetd.pid
root 5311 0.0 0.0 4180 340 ? Ss 08:32 0:00 gpm -m /dev/input/mice -t imps2
root 5321 0.0 0.0 57064 940 ? Ss 08:32 0:00 crond
xfs 5341 0.0 0.0 10432 1968 ? Ss 08:32 0:00 xfs -droppriv -daemon
root 5360 0.0 0.0 8916 424 ? Ss 08:32 0:00 /usr/sbin/atd
dbus 5423 0.0 0.0 10700 852 ? Ss 08:32 0:00 dbus-daemon-1 --system
root 5436 0.0 0.0 10044 940 ? Ss 08:32 0:00 cups-config-daemon
root 5447 0.0 0.0 15240 2552 ? Ss 08:32 0:00 hald
root 5518 0.0 0.0 2528 404 tty1 Ss+ 08:32 0:00 /sbin/mingetty tty1
root 5521 0.0 0.0 2528 404 tty2 Ss+ 08:32 0:00 /sbin/mingetty tty2
root 5524 0.0 0.0 2528 404 tty3 Ss+ 08:32 0:00 /sbin/mingetty tty3
root 5527 0.0 0.0 2528 404 tty4 Ss+ 08:32 0:00 /sbin/mingetty tty4
root 5530 0.0 0.0 2528 404 tty5 Ss+ 08:32 0:00 /sbin/mingetty tty5
root 5533 0.0 0.0 2528 404 tty6 Ss+ 08:32 0:00 /sbin/mingetty tty6
root 5536 0.0 0.0 90136 2904 ? Ss 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 6346 0.0 0.0 105244 3048 ? S 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 6367 0.1 0.6 38416 24772 ? S 08:32 0:25 /usr/X11R6/bin/X :0 -audit 0 -auth /var/gdm/:0.Xauth -nolisten tcp vt7
root 6742 0.0 0.0 37100 2628 ? Rs 08:33 0:01 sshd: root@pts/1
root 6744 0.0 0.0 53964 1568 pts/1 Ss 08:33 0:00 -bash
root 7874 0.0 0.0 6436 1124 ? Ss 14:34 0:00 /bin/sh /etc/init.d/init.evmd run
root 7883 0.0 0.0 6580 1352 ? Ss 14:34 0:00 /bin/sh /etc/init.d/init.cssd fatal
root 7892 0.0 0.0 6436 1140 ? Ss 14:34 0:00 /bin/sh /etc/init.d/init.crsd run
root 8525 0.0 0.0 23884 1140 ? S 14:34 0:00 /bin/su -l oracle -c sh -c 'ulimit -c unlimited; cd /oracle/product/crs/log/dbp/evmd; exec /oracle/product/crs/b
oracle 8552 0.1 0.3 227052 15464 ? Ssl 14:34 0:01 /oracle/product/crs/bin/evmd.bin
root 8641 0.5 0.6 530420 25696 ? Ssl 14:34 0:03 /oracle/product/crs/bin/crsd.bin reboot
root 8688 0.0 0.0 6580 1352 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd oprocd
root 8701 0.0 0.0 6580 1344 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd oclsomon
root 8799 0.0 0.0 6580 1352 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd daemon
root 8963 0.0 0.0 5092 536 ? S 14:34 0:00 /sbin/runuser -l oracle -c /bin/sh -c 'cd /oracle/product/crs/log/dbp/cssd/oclsomon; ulimit -c unlimited; /oracl
oracle 8964 0.0 0.0 52748 1016 ? S 14:34 0:00 /bin/sh -c cd /oracle/product/crs/log/dbp/cssd/oclsomon; ulimit -c unlimited; /oracle/product/crs/bin/oclsomon
oracle 8990 0.0 0.2 42600 9408 ? Ss 14:34 0:00 /oracle/product/crs/bin/oclsomon.bin
root 9096 0.0 0.0 8456 2328 ? SL 14:34 0:00 /oracle/product/crs/bin/oprocd.bin run -t 1000 -m 500 -f
oracle 9221 0.1 4.6 201156 187900 ? SLl 14:34 0:01 /oracle/product/crs/bin/ocssd.bin
oracle 9361 0.0 0.2 58144 10900 ? S 14:34 0:00 /oracle/product/crs/bin/evmlogger.bin -o /oracle/product/crs/evm/log/evmlogger.info -l /oracle/product/crs/evm/l
oracle 13337 0.0 0.2 134740 10964 ? Ss 14:12 0:00 /usr/bin/gnome-session
oracle 13467 2.9 1.5 569512 63896 pts/1 Sl 14:42 0:05 /oracle/product/database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFr
oracle 13638 0.0 0.0 66708 1840 ? Sl 14:12 0:00 /usr/bin/VBoxClient --clipboard
oracle 13646 0.0 0.0 66740 1588 ? Sl 14:12 0:00 /usr/bin/VBoxClient --display
oracle 13651 0.0 0.0 64604 1128 ? Sl 14:12 0:00 /usr/bin/VBoxClient --seamless
oracle 13656 0.0 0.0 66356 1616 ? Sl 14:12 0:00 /usr/bin/VBoxClient --draganddrop
oracle 13721 0.0 0.0 17340 800 ? Ss 14:12 0:00 /usr/bin/ssh-agent /bin/sh -c exec -l /bin/bash -c "/usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xcli
oracle 13748 0.0 0.0 9944 528 ? S 14:12 0:00 /usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xclients
oracle 13767 0.0 0.0 10704 1036 ? Ss 14:12 0:00 dbus-daemon-1 --fork --print-pid 8 --print-address 6 --session
oracle 13829 0.0 0.2 71800 9232 ? S 14:12 0:00 /usr/libexec/gconfd-2 5
oracle 14112 0.0 0.0 5260 576 ? S 14:13 0:00 /usr/bin/gnome-keyring-daemon
oracle 14114 0.0 0.0 69620 2892 ? Ss 14:13 0:00 /usr/libexec/bonobo-activation-server --ac-activate --ior-output-fd=19
oracle 14116 0.0 0.1 137204 7664 ? S 14:13 0:00 /usr/libexec/gnome-settings-daemon --oaf-activate-iid=OAFIID:GNOME_SettingsDaemon --oaf-ior-fd=23
oracle 14147 0.0 0.0 5404 1208 ? S 14:13 0:00 /usr/libexec/gam_server
oracle 14156 0.0 0.0 24624 1992 ? S 14:13 0:00 xscreensaver -nosplash
oracle 14205 0.0 0.1 102860 7980 ? Ss 14:13 0:00 /usr/bin/metacity --sm-client-id=default1
oracle 14209 0.0 0.3 142136 12924 ? Ss 14:13 0:00 gnome-panel --sm-client-id default2
oracle 14211 0.0 0.4 169692 17820 ? Ssl 14:13 0:00 nautilus --no-default-window --sm-client-id default3
oracle 14213 0.0 0.1 132704 6664 ? Ss 14:13 0:00 gnome-volume-manager --sm-client-id default6
oracle 14242 0.0 0.1 160212 7960 ? Ssl 14:13 0:00 eggcups --sm-client-id default5
oracle 14244 0.0 0.1 99028 4652 ? Ss 14:13 0:00 pam-panel-icon --sm-client-id default0
oracle 14246 0.4 0.5 200728 21676 ? RNs 14:13 0:08 /usr/bin/python /usr/bin/rhn-applet-gui --sm-client-id default4
root 14249 0.0 0.0 6788 588 ? S 14:13 0:00 /sbin/pam_timestamp_check -d root
oracle 14252 0.0 0.0 101836 3928 ? Sl 14:13 0:00 /usr/libexec/gnome-vfs-daemon --oaf-activate-iid=OAFIID:GNOME_VFS_Daemon_Factory --oaf-ior-fd=29
oracle 14262 0.0 0.0 5168 704 ? S 14:13 0:00 /usr/libexec/mapping-daemon
oracle 14339 0.0 0.2 140264 11384 ? S 14:13 0:00 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:GNOME_Wncklet_Factory --oaf-ior-fd=31
oracle 14341 0.0 0.2 144644 11924 ? S 14:13 0:00 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID:GNOME_MixerApplet_Factory --oaf-ior-fd=33
oracle 14368 0.0 0.2 134736 8684 ? S 14:13 0:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:GNOME_ClockApplet_Factory --oaf-ior-fd=35
oracle 14370 0.0 0.1 131676 7240 ? S 14:13 0:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-ior-f
oracle 14397 0.0 0.3 169468 14688 ? Sl 14:13 0:00 /usr/bin/gnome-terminal
oracle 14424 0.0 0.0 6208 616 ? S 14:13 0:00 gnome-pty-helper
oracle 14426 0.0 0.0 53968 1568 pts/2 Ss+ 14:13 0:00 bash
oracle 14499 6.6 1.8 352140 73180 pts/2 Sl 14:44 0:06 /tmp/OraInstall2013-06-04_02-44-37PM/jre/1.4.2/bin/java -Doracle.installer.library_loc=/tmp/OraInstall2013-06-04
oracle 15277 0.0 0.0 5372 904 pts/1 S 14:46 0:00 sh -c /oracle/product/database/bin/emdctl status url http://dbp:1158/em/console/aboutApplication >/oracle/produc
oracle 15278 0.0 0.1 26032 5056 pts/1 S 14:46 0:00 /oracle/product/database/bin/emdctl status url http://dbp:1158/em/console/aboutApplication
root 15311 0.0 0.0 6324 476 ? S 14:46 0:00 /bin/sleep 1
root 15312 0.0 0.0 5448 792 pts/1 R+ 14:46 0:00 ps aux
oracle 20262 0.0 0.1 7752 6280 pts/1 S 08:41 0:00 /oracle/product/database/perl/bin/perl /oracle/product/database/bin/emwd.pl dbconsole /oracle/product/database/d
oracle 24145 0.0 0.4 67736 18200 pts/1 Sl 08:43 0:06 /oracle/product/database/bin/emagent
[root@dbp ~]# su - oracle
[oracle@dbp ~]$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://dbp:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
--- Failed to shutdown DBConsole Gracefully ---
failed.
[oracle@dbp ~]$ kill -9 15278
-bash: kill: (15278) - No such process
[oracle@dbp ~]$ ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 4756 556 ? S 08:31 0:00 init [5]
root 2 0.0 0.0 0 0 ? SN 08:31 0:00 [ksoftirqd/0]
root 3 0.0 0.0 0 0 ? S< 08:31 0:06 [events/0]
root 4 0.0 0.0 0 0 ? S< 08:31 0:00 [khelper]
root 5 0.0 0.0 0 0 ? S< 08:31 0:00 [kacpid]
root 18 0.0 0.0 0 0 ? S< 08:31 0:00 [kblockd/0]
root 19 0.0 0.0 0 0 ? S 08:31 0:00 [khubd]
root 40 0.0 0.0 0 0 ? S 08:31 0:00 [pdflush]
root 41 0.0 0.0 0 0 ? S 08:31 0:03 [pdflush]
root 42 0.0 0.0 0 0 ? S 08:31 0:00 [kswapd0]
root 43 0.0 0.0 0 0 ? S< 08:31 0:00 [aio/0]
root 187 0.0 0.0 0 0 ? S 08:31 0:00 [kseriod]
root 416 0.0 0.0 0 0 ? S< 08:31 0:00 [ata/0]
root 417 0.0 0.0 0 0 ? S< 08:31 0:00 [ata_aux]
root 419 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_0]
root 420 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_1]
root 421 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_2]
root 422 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_3]
root 456 0.0 0.0 0 0 ? S 08:31 0:02 [kjournald]
root 1113 0.0 0.0 0 0 ? S< 08:31 0:00 [kauditd]
root 3567 0.0 0.0 3608 456 ? S<s 08:31 0:00 udevd
root 3753 0.0 0.0 0 0 ? S< 08:31 0:00 [iprt/0]
root 4282 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4283 0.0 0.0 0 0 ? S 08:31 0:03 [kjournald]
root 4284 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4285 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4742 0.0 0.0 3632 600 ? Ss 08:32 0:00 syslogd -m 0
root 4746 0.0 0.0 2540 372 ? Ss 08:32 0:00 klogd -x
rpc 4769 0.0 0.0 4756 564 ? Ss 08:32 0:00 portmap
rpcuser 4789 0.0 0.0 5808 744 ? Ss 08:32 0:00 rpc.statd
root 4818 0.0 0.0 20932 416 ? Ss 08:32 0:00 rpc.idmapd
root 5212 0.0 0.0 2544 448 ? Ss 08:32 0:00 /usr/sbin/acpid
root 5223 0.0 0.0 21936 1276 ? Ss 08:32 0:00 /usr/sbin/sshd
root 5288 0.0 0.0 8720 776 ? Ss 08:32 0:00 xinetd -stayalive -pidfile /var/run/xinetd.pid
root 5311 0.0 0.0 4180 340 ? Ss 08:32 0:00 gpm -m /dev/input/mice -t imps2
root 5321 0.0 0.0 57064 940 ? Ss 08:32 0:00 crond
xfs 5341 0.0 0.0 10432 1968 ? Ss 08:32 0:00 xfs -droppriv -daemon
root 5360 0.0 0.0 8916 424 ? Ss 08:32 0:00 /usr/sbin/atd
dbus 5423 0.0 0.0 10700 852 ? Ss 08:32 0:00 dbus-daemon-1 --system
root 5436 0.0 0.0 10044 940 ? Ss 08:32 0:00 cups-config-daemon
root 5447 0.0 0.0 15240 2552 ? Ss 08:32 0:00 hald
root 5518 0.0 0.0 2528 404 tty1 Ss+ 08:32 0:00 /sbin/mingetty tty1
root 5521 0.0 0.0 2528 404 tty2 Ss+ 08:32 0:00 /sbin/mingetty tty2
root 5524 0.0 0.0 2528 404 tty3 Ss+ 08:32 0:00 /sbin/mingetty tty3
root 5527 0.0 0.0 2528 404 tty4 Ss+ 08:32 0:00 /sbin/mingetty tty4
root 5530 0.0 0.0 2528 404 tty5 Ss+ 08:32 0:00 /sbin/mingetty tty5
root 5533 0.0 0.0 2528 404 tty6 Ss+ 08:32 0:00 /sbin/mingetty tty6
root 5536 0.0 0.0 90136 2904 ? Ss 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 6346 0.0 0.0 105244 3048 ? S 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 6367 0.1 0.5 36988 23344 ? S 08:32 0:25 /usr/X11R6/bin/X :0 -audit 0 -auth /var/gdm/:0.Xauth -nolisten tcp vt7
root 6742 0.0 0.0 37236 2640 ? Ss 08:33 0:01 sshd: root@pts/1
root 6744 0.0 0.0 53964 1568 pts/1 Ss 08:33 0:00 -bash
root 7874 0.0 0.0 6436 1124 ? Ss 14:34 0:00 /bin/sh /etc/init.d/init.evmd run
root 7883 0.0 0.0 6580 1352 ? Ss 14:34 0:00 /bin/sh /etc/init.d/init.cssd fatal
root 7892 0.0 0.0 6436 1140 ? Ss 14:34 0:00 /bin/sh /etc/init.d/init.crsd run
root 8525 0.0 0.0 23884 1140 ? S 14:34 0:00 /bin/su -l oracle -c sh -c 'ulimit -c unlimited; cd /oracle/product/crs/log/dbp/evmd; exec /oracle/product/crs/b
oracle 8552 0.1 0.3 227052 15464 ? Ssl 14:34 0:01 /oracle/product/crs/bin/evmd.bin
root 8641 0.4 0.6 530420 25696 ? Ssl 14:34 0:04 /oracle/product/crs/bin/crsd.bin reboot
root 8688 0.0 0.0 6580 1352 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd oprocd
root 8701 0.0 0.0 6580 1344 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd oclsomon
root 8799 0.0 0.0 6580 1352 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd daemon
root 8963 0.0 0.0 5092 536 ? S 14:34 0:00 /sbin/runuser -l oracle -c /bin/sh -c 'cd /oracle/product/crs/log/dbp/cssd/oclsomon; ulimit -c unlimited; /oracl
oracle 8964 0.0 0.0 52748 1016 ? S 14:34 0:00 /bin/sh -c cd /oracle/product/crs/log/dbp/cssd/oclsomon; ulimit -c unlimited; /oracle/product/crs/bin/oclsomon
oracle 8990 0.0 0.2 42600 9408 ? Ss 14:34 0:00 /oracle/product/crs/bin/oclsomon.bin
root 9096 0.0 0.0 8456 2328 ? SL 14:34 0:00 /oracle/product/crs/bin/oprocd.bin run -t 1000 -m 500 -f
oracle 9221 0.1 4.6 201156 187900 ? SLl 14:34 0:01 /oracle/product/crs/bin/ocssd.bin
oracle 9361 0.0 0.2 58144 10900 ? S 14:34 0:00 /oracle/product/crs/bin/evmlogger.bin -o /oracle/product/crs/evm/log/evmlogger.info -l /oracle/product/crs/evm/l
oracle 13337 0.0 0.2 134740 10964 ? Ss 14:12 0:00 /usr/bin/gnome-session
oracle 13467 1.8 1.4 569512 57460 pts/1 Sl 14:42 0:06 /oracle/product/database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFr
oracle 13638 0.0 0.0 66708 1840 ? Sl 14:12 0:00 /usr/bin/VBoxClient --clipboard
oracle 13646 0.0 0.0 66740 1588 ? Sl 14:12 0:00 /usr/bin/VBoxClient --display
oracle 13651 0.0 0.0 64604 1128 ? Sl 14:12 0:00 /usr/bin/VBoxClient --seamless
oracle 13656 0.0 0.0 66356 1616 ? Sl 14:12 0:00 /usr/bin/VBoxClient --draganddrop
oracle 13721 0.0 0.0 17340 800 ? Ss 14:12 0:00 /usr/bin/ssh-agent /bin/sh -c exec -l /bin/bash -c "/usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xcli
oracle 13748 0.0 0.0 9944 528 ? S 14:12 0:00 /usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xclients
oracle 13767 0.0 0.0 10704 1036 ? Ss 14:12 0:00 dbus-daemon-1 --fork --print-pid 8 --print-address 6 --session
oracle 13829 0.0 0.2 71800 9232 ? S 14:12 0:00 /usr/libexec/gconfd-2 5
oracle 14112 0.0 0.0 5260 576 ? S 14:12 0:00 /usr/bin/gnome-keyring-daemon
oracle 14114 0.0 0.0 69620 2892 ? Ss 14:12 0:00 /usr/libexec/bonobo-activation-server --ac-activate --ior-output-fd=19
oracle 14116 0.0 0.1 137204 7664 ? S 14:13 0:00 /usr/libexec/gnome-settings-daemon --oaf-activate-iid=OAFIID:GNOME_SettingsDaemon --oaf-ior-fd=23
oracle 14147 0.0 0.0 5404 1208 ? S 14:13 0:00 /usr/libexec/gam_server
oracle 14156 0.0 0.0 24624 1992 ? S 14:13 0:00 xscreensaver -nosplash
oracle 14205 0.0 0.1 102860 7980 ? Ss 14:13 0:00 /usr/bin/metacity --sm-client-id=default1
oracle 14209 0.0 0.3 142136 12924 ? Ss 14:13 0:00 gnome-panel --sm-client-id default2
oracle 14211 0.0 0.4 169692 17820 ? Ssl 14:13 0:00 nautilus --no-default-window --sm-client-id default3
oracle 14213 0.0 0.1 132704 6664 ? Ss 14:13 0:00 gnome-volume-manager --sm-client-id default6
oracle 14242 0.0 0.1 160212 7960 ? Ssl 14:13 0:00 eggcups --sm-client-id default5
oracle 14244 0.0 0.1 99028 4652 ? Ss 14:13 0:00 pam-panel-icon --sm-client-id default0
oracle 14246 0.4 0.5 200728 21676 ? RNs 14:13 0:09 /usr/bin/python /usr/bin/rhn-applet-gui --sm-client-id default4
root 14249 0.0 0.0 6788 588 ? S 14:13 0:00 /sbin/pam_timestamp_check -d root
oracle 14252 0.0 0.0 101836 3928 ? Sl 14:13 0:00 /usr/libexec/gnome-vfs-daemon --oaf-activate-iid=OAFIID:GNOME_VFS_Daemon_Factory --oaf-ior-fd=29
oracle 14262 0.0 0.0 5168 704 ? S 14:13 0:00 /usr/libexec/mapping-daemon
oracle 14339 0.0 0.2 140264 11384 ? S 14:13 0:00 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:GNOME_Wncklet_Factory --oaf-ior-fd=31
oracle 14341 0.0 0.2 144644 11924 ? S 14:13 0:00 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID:GNOME_MixerApplet_Factory --oaf-ior-fd=33
oracle 14368 0.0 0.2 134736 8684 ? S 14:13 0:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:GNOME_ClockApplet_Factory --oaf-ior-fd=35
oracle 14370 0.0 0.1 131676 7240 ? S 14:13 0:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-ior-f
oracle 14397 0.0 0.3 169468 14688 ? Sl 14:13 0:00 /usr/bin/gnome-terminal
oracle 14424 0.0 0.0 6208 616 ? S 14:13 0:00 gnome-pty-helper
oracle 14426 0.0 0.0 53968 1568 pts/2 Ss+ 14:13 0:00 bash
root 15695 0.0 0.0 71272 1284 pts/1 S 14:47 0:00 su - oracle
oracle 15696 0.0 0.0 53960 1544 pts/1 S 14:47 0:00 -bash
root 16530 0.0 0.0 6580 440 ? R 14:48 0:00 /bin/sh /etc/init.d/init.cssd fatal
oracle 16531 0.0 0.0 5448 792 pts/1 R+ 14:48 0:00 ps aux
oracle 20262 0.0 0.1 7752 6280 pts/1 S 08:41 0:00 /oracle/product/database/perl/bin/perl /oracle/product/database/bin/emwd.pl dbconsole /oracle/product/database/d
oracle 24145 0.0 0.4 67740 18372 pts/1 Sl 08:43 0:06 /oracle/product/database/bin/emagent
[oracle@dbp ~]$ ps aux | grep em
xfs 5341 0.0 0.0 10432 1968 ? Ss 08:32 0:00 xfs -droppriv -daemon
dbus 5423 0.0 0.0 10700 852 ? Ss 08:32 0:00 dbus-daemon-1 --system
root 5436 0.0 0.0 10044 940 ? Ss 08:32 0:00 cups-config-daemon
root 5536 0.0 0.0 90136 2904 ? Ss 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 6346 0.0 0.0 105244 3048 ? S 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 8799 0.0 0.0 6580 1352 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd daemon
oracle 13467 1.8 1.4 569512 57460 pts/1 Sl 14:42 0:06 /oracle/product/database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/oracle/product/database -Doracle.home=/oracle/product/database/oc4j -Doracle.oc4j.localhome=/oracle/product/database/dbp_wxxrdb1/sysman -DEMSTATE=/oracle/product/database/dbp_wxxrdb1 -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/jazn.xml -Djava.security.policy=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/java2.policy -Djava.security.properties=/oracle/product/database/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/oracle/product/database/dbp_wxxrdb1 -Dsysman.md5password=true -Drepapi.oracle.home=/oracle/product/database -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /oracle/product/database/oc4j/j2ee/home/oc4j.jar -config /oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/server.xml
oracle 13767 0.0 0.0 10704 1036 ? Ss 14:12 0:00 dbus-daemon-1 --fork --print-pid 8 --print-address 6 --session
oracle 14112 0.0 0.0 5260 576 ? S 14:13 0:00 /usr/bin/gnome-keyring-daemon
oracle 14116 0.0 0.1 137204 7664 ? S 14:13 0:00 /usr/libexec/gnome-settings-daemon --oaf-activate-iid=OAFIID:GNOME_SettingsDaemon --oaf-ior-fd=23
oracle 14252 0.0 0.0 101836 3928 ? Sl 14:13 0:00 /usr/libexec/gnome-vfs-daemon --oaf-activate-iid=OAFIID:GNOME_VFS_Daemon_Factory --oaf-ior-fd=29
oracle 14262 0.0 0.0 5168 704 ? S 14:13 0:00 /usr/libexec/mapping-daemon
oracle 16612 0.0 0.0 51068 664 pts/1 R+ 14:48 0:00 grep em
oracle 20262 0.0 0.1 7752 6280 pts/1 S 08:41 0:00 /oracle/product/database/perl/bin/perl /oracle/product/database/bin/emwd.pl dbconsole /oracle/product/database/dbp_wxxrdb1/sysman/log/emdb.nohup
oracle 24145 0.0 0.4 67740 18396 pts/1 Sl 08:43 0:06 /oracle/product/database/bin/emagent
[oracle@dbp ~]$ kill -9 24145
[oracle@dbp ~]$ kill -9 20262
[oracle@dbp ~]$ ps aux | grep em
xfs 5341 0.0 0.0 10432 1968 ? Ss 08:32 0:00 xfs -droppriv -daemon
dbus 5423 0.0 0.0 10700 852 ? Ss 08:32 0:00 dbus-daemon-1 --system
root 5436 0.0 0.0 10044 940 ? Ss 08:32 0:00 cups-config-daemon
root 5536 0.0 0.0 90136 2904 ? Ss 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 6346 0.0 0.0 105244 3048 ? S 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 8799 0.0 0.0 6580 1352 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd daemon
oracle 13467 1.7 1.4 569512 57460 pts/1 Sl 14:42 0:06 /oracle/product/database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/oracle/product/database -Doracle.home=/oracle/product/database/oc4j -Doracle.oc4j.localhome=/oracle/product/database/dbp_wxxrdb1/sysman -DEMSTATE=/oracle/product/database/dbp_wxxrdb1 -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/jazn.xml -Djava.security.policy=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/java2.policy -Djava.security.properties=/oracle/product/database/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/oracle/product/database/dbp_wxxrdb1 -Dsysman.md5password=true -Drepapi.oracle.home=/oracle/product/database -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /oracle/product/database/oc4j/j2ee/home/oc4j.jar -config /oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/server.xml
oracle 13767 0.0 0.0 10704 1036 ? Ss 14:12 0:00 dbus-daemon-1 --fork --print-pid 8 --print-address 6 --session
oracle 14112 0.0 0.0 5260 576 ? S 14:12 0:00 /usr/bin/gnome-keyring-daemon
oracle 14116 0.0 0.1 137204 7664 ? S 14:13 0:00 /usr/libexec/gnome-settings-daemon --oaf-activate-iid=OAFIID:GNOME_SettingsDaemon --oaf-ior-fd=23
oracle 14252 0.0 0.0 101836 3928 ? Sl 14:13 0:00 /usr/libexec/gnome-vfs-daemon --oaf-activate-iid=OAFIID:GNOME_VFS_Daemon_Factory --oaf-ior-fd=29
oracle 14262 0.0 0.0 5168 704 ? S 14:13 0:00 /usr/libexec/mapping-daemon
oracle 16732 0.0 0.0 51068 664 pts/1 R+ 14:48 0:00 grep em
[oracle@dbp ~]$ ssh oracle@dbs
Last login: Tue Jun 4 14:32:32 2013 from 192.168.2.111
[oracle@dbs ~]$ ps aux | grep em
xfs 5353 0.0 0.0 10268 1780 ? Ss 08:32 0:00 xfs -droppriv -daemon
dbus 5435 0.0 0.0 10700 832 ? Ss 08:32 0:00 dbus-daemon-1 --system
root 5448 0.0 0.0 10044 940 ? Ss 08:32 0:00 cups-config-daemon
root 5547 0.0 0.0 90136 2884 ? Ss 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 6361 0.0 0.0 105192 2524 ? S 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 18014 0.0 0.0 6580 1352 ? S 14:40 0:00 /bin/sh /etc/init.d/init.cssd daemon
root 22457 0.0 0.0 27536 2612 ? S 14:49 0:00 /usr/sbin/sendmail -FCronDaemon -i -odi -oem -oi -t
oracle 23163 0.0 0.0 51068 660 pts/2 R+ 14:49 0:00 grep em
[oracle@dbs ~]$ exit
logout
Connection to dbs closed.
[oracle@dbp ~]$ ps aux | grep jav
oracle 13467 1.4 1.4 569512 57464 pts/1 Sl 14:42 0:06 /oracle/product/database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/oracle/product/database -Doracle.home=/oracle/product/database/oc4j -Doracle.oc4j.localhome=/oracle/product/database/dbp_wxxrdb1/sysman -DEMSTATE=/oracle/product/database/dbp_wxxrdb1 -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/jazn.xml -Djava.security.policy=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/java2.policy -Djava.security.properties=/oracle/product/database/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/oracle/product/database/dbp_wxxrdb1 -Dsysman.md5password=true -Drepapi.oracle.home=/oracle/product/database -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /oracle/product/database/oc4j/j2ee/home/oc4j.jar -config /oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/server.xml
oracle 17060 14.0 1.7 353000 72244 pts/2 Sl 14:49 0:05 /tmp/OraInstall2013-06-04_02-49-45PM/jre/1.4.2/bin/java -Doracle.installer.library_loc=/tmp/OraInstall2013-06-04_02-49-45PM/oui/lib/linux -Doracle.installer.oui_loc=/tmp/OraInstall2013-06-04_02-49-45PM/oui -Doracle.installer.bootstrap=TRUE -Doracle.installer.startup_location=/home/oracle/Disk1/install -Doracle.installer.jre_loc=/tmp/OraInstall2013-06-04_02-49-45PM/jre/1.4.2 -Doracle.installer.nlsEnabled="TRUE" -Doracle.installer.prereqConfigLoc=/tmp/OraInstall2013-06-04_02-49-45PM/prereq -Doracle.installer.unixVersion=2.6.9-67.EL -mx150m -cp /tmp/OraInstall2013-06-04_02-49-45PM:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/OraInstaller.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/oneclick.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/xmlparserv2.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/srvm.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/share.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/OraInstallerNet.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/xml.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/orai18n-collation.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/orai18n-mapping.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/emCfg.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/ojmisc.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstImages.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_de.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_es.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_fr.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_it.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_ja.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_ko.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_pt_BR.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_zh_CN.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_zh_TW.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/oracle_ice.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/help4.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/help4-nls.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/ewt3.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/ewt3-swingaccess.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/ewt3-nls.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/swingaccess.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/classes12.jar::/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/OraPrereq.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/jewt4.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/jewt4-nls.jar oracle.sysman.oii.oiic.OiicInstaller -scratchPath /tmp/OraInstall2013-06-04_02-49-45PM -sourceLoc /home/oracle/Disk1/install/../stage/products.xml -sourceType network -timestamp 2013-06-04_02-49-45PM
oracle 17517 0.0 0.0 51068 668 pts/1 R+ 14:50 0:00 grep jav
[oracle@dbp ~]$ pkill 13467
[oracle@dbp ~]$ ps aux | grep jav
oracle 13467 1.3 1.4 569512 57464 pts/1 Sl 14:42 0:06 /oracle/product/database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/oracle/product/database -Doracle.home=/oracle/product/database/oc4j -Doracle.oc4j.localhome=/oracle/product/database/dbp_wxxrdb1/sysman -DEMSTATE=/oracle/product/database/dbp_wxxrdb1 -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/jazn.xml -Djava.security.policy=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/java2.policy -Djava.security.properties=/oracle/product/database/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/oracle/product/database/dbp_wxxrdb1 -Dsysman.md5password=true -Drepapi.oracle.home=/oracle/product/database -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /oracle/product/database/oc4j/j2ee/home/oc4j.jar -config /oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/server.xml
oracle 17060 10.6 1.7 353000 72340 pts/2 Sl 14:49 0:05 /tmp/OraInstall2013-06-04_02-49-45PM/jre/1.4.2/bin/java -Doracle.installer.library_loc=/tmp/OraInstall2013-06-04_02-49-45PM/oui/lib/linux -Doracle.installer.oui_loc=/tmp/OraInstall2013-06-04_02-49-45PM/oui -Doracle.installer.bootstrap=TRUE -Doracle.installer.startup_location=/home/oracle/Disk1/install -Doracle.installer.jre_loc=/tmp/OraInstall2013-06-04_02-49-45PM/jre/1.4.2 -Doracle.installer.nlsEnabled="TRUE" -Doracle.installer.prereqConfigLoc=/tmp/OraInstall2013-06-04_02-49-45PM/prereq -Doracle.installer.unixVersion=2.6.9-67.EL -mx150m -cp /tmp/OraInstall2013-06-04_02-49-45PM:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/OraInstaller.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/oneclick.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/xmlparserv2.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/srvm.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/share.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/OraInstallerNet.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/xml.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/orai18n-collation.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/orai18n-mapping.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/emCfg.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/ojmisc.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstImages.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_de.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_es.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_fr.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_it.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_ja.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_ko.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_pt_BR.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_zh_CN.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/InstHelp_zh_TW.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/oracle_ice.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/help4.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/help4-nls.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/ewt3.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/ewt3-swingaccess.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/ewt3-nls.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/swingaccess.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/classes12.jar::/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/OraPrereq.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/jewt4.jar:/tmp/OraInstall2013-06-04_02-49-45PM/oui/jlib/jewt4-nls.jar oracle.sysman.oii.oiic.OiicInstaller -scratchPath /tmp/OraInstall2013-06-04_02-49-45PM -sourceLoc /home/oracle/Disk1/install/../stage/products.xml -sourceType network -timestamp 2013-06-04_02-49-45PM
oracle 17590 0.0 0.0 51068 672 pts/1 R+ 14:50 0:00 grep jav
[oracle@dbp ~]$ pkill java
[oracle@dbp ~]$ ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 4756 556 ? S 08:31 0:00 init [5]
root 2 0.0 0.0 0 0 ? SN 08:31 0:00 [ksoftirqd/0]
root 3 0.0 0.0 0 0 ? S< 08:31 0:06 [events/0]
root 4 0.0 0.0 0 0 ? S< 08:31 0:00 [khelper]
root 5 0.0 0.0 0 0 ? S< 08:31 0:00 [kacpid]
root 18 0.0 0.0 0 0 ? S< 08:31 0:00 [kblockd/0]
root 19 0.0 0.0 0 0 ? S 08:31 0:00 [khubd]
root 40 0.0 0.0 0 0 ? S 08:31 0:00 [pdflush]
root 41 0.0 0.0 0 0 ? S 08:31 0:03 [pdflush]
root 42 0.0 0.0 0 0 ? S 08:31 0:00 [kswapd0]
root 43 0.0 0.0 0 0 ? S< 08:31 0:00 [aio/0]
root 187 0.0 0.0 0 0 ? S 08:31 0:00 [kseriod]
root 416 0.0 0.0 0 0 ? S< 08:31 0:00 [ata/0]
root 417 0.0 0.0 0 0 ? S< 08:31 0:00 [ata_aux]
root 419 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_0]
root 420 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_1]
root 421 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_2]
root 422 0.0 0.0 0 0 ? S 08:31 0:00 [scsi_eh_3]
root 456 0.0 0.0 0 0 ? S 08:31 0:02 [kjournald]
root 1113 0.0 0.0 0 0 ? S< 08:31 0:00 [kauditd]
root 3567 0.0 0.0 3608 456 ? S<s 08:31 0:00 udevd
root 3753 0.0 0.0 0 0 ? S< 08:31 0:00 [iprt/0]
root 4282 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4283 0.0 0.0 0 0 ? S 08:31 0:03 [kjournald]
root 4284 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4285 0.0 0.0 0 0 ? S 08:31 0:00 [kjournald]
root 4742 0.0 0.0 3632 600 ? Ss 08:32 0:00 syslogd -m 0
root 4746 0.0 0.0 2540 372 ? Ss 08:32 0:00 klogd -x
rpc 4769 0.0 0.0 4756 564 ? Ss 08:32 0:00 portmap
rpcuser 4789 0.0 0.0 5808 744 ? Ss 08:32 0:00 rpc.statd
root 4818 0.0 0.0 20932 416 ? Ss 08:32 0:00 rpc.idmapd
root 5212 0.0 0.0 2544 448 ? Ss 08:32 0:00 /usr/sbin/acpid
root 5223 0.0 0.0 21936 1276 ? Ss 08:32 0:00 /usr/sbin/sshd
root 5288 0.0 0.0 8720 776 ? Ss 08:32 0:00 xinetd -stayalive -pidfile /var/run/xinetd.pid
root 5311 0.0 0.0 4180 340 ? Ss 08:32 0:00 gpm -m /dev/input/mice -t imps2
root 5321 0.0 0.0 57064 940 ? Ss 08:32 0:00 crond
xfs 5341 0.0 0.0 10432 1968 ? Ss 08:32 0:00 xfs -droppriv -daemon
root 5360 0.0 0.0 8916 424 ? Ss 08:32 0:00 /usr/sbin/atd
dbus 5423 0.0 0.0 10700 852 ? Ss 08:32 0:00 dbus-daemon-1 --system
root 5436 0.0 0.0 10044 940 ? Ss 08:32 0:00 cups-config-daemon
root 5447 0.0 0.0 15240 2552 ? Ss 08:32 0:00 hald
root 5518 0.0 0.0 2528 404 tty1 Ss+ 08:32 0:00 /sbin/mingetty tty1
root 5521 0.0 0.0 2528 404 tty2 Ss+ 08:32 0:00 /sbin/mingetty tty2
root 5524 0.0 0.0 2528 404 tty3 Ss+ 08:32 0:00 /sbin/mingetty tty3
root 5527 0.0 0.0 2528 404 tty4 Ss+ 08:32 0:00 /sbin/mingetty tty4
root 5530 0.0 0.0 2528 404 tty5 Ss+ 08:32 0:00 /sbin/mingetty tty5
root 5533 0.0 0.0 2528 404 tty6 Ss+ 08:32 0:00 /sbin/mingetty tty6
root 5536 0.0 0.0 90136 2904 ? Ss 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 6346 0.0 0.0 105244 3048 ? S 08:32 0:00 /usr/bin/gdm-binary -nodaemon
root 6367 0.1 0.5 36988 23344 ? S 08:32 0:26 /usr/X11R6/bin/X :0 -audit 0 -auth /var/gdm/:0.Xauth -nolisten tcp vt7
root 6742 0.0 0.0 37236 2640 ? Ss 08:33 0:01 sshd: root@pts/1
root 6744 0.0 0.0 53964 1568 pts/1 Ss 08:33 0:00 -bash
root 7874 0.0 0.0 6436 1124 ? Ss 14:34 0:00 /bin/sh /etc/init.d/init.evmd run
root 7883 0.0 0.0 6580 1352 ? Ss 14:34 0:00 /bin/sh /etc/init.d/init.cssd fatal
root 7892 0.0 0.0 6436 1140 ? Ss 14:34 0:00 /bin/sh /etc/init.d/init.crsd run
root 8525 0.0 0.0 23884 1140 ? S 14:34 0:00 /bin/su -l oracle -c sh -c 'ulimit -c unlimited; cd /oracle/product/crs/log/dbp/evmd; exec /oracle/product/crs/b
oracle 8552 0.1 0.3 227052 15464 ? Ssl 14:34 0:01 /oracle/product/crs/bin/evmd.bin
root 8641 0.4 0.6 530420 25696 ? Ssl 14:34 0:04 /oracle/product/crs/bin/crsd.bin reboot
root 8688 0.0 0.0 6580 1352 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd oprocd
root 8701 0.0 0.0 6580 1344 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd oclsomon
root 8799 0.0 0.0 6580 1352 ? S 14:34 0:00 /bin/sh /etc/init.d/init.cssd daemon
root 8963 0.0 0.0 5092 536 ? S 14:34 0:00 /sbin/runuser -l oracle -c /bin/sh -c 'cd /oracle/product/crs/log/dbp/cssd/oclsomon; ulimit -c unlimited; /oracl
oracle 8964 0.0 0.0 52748 1016 ? S 14:34 0:00 /bin/sh -c cd /oracle/product/crs/log/dbp/cssd/oclsomon; ulimit -c unlimited; /oracle/product/crs/bin/oclsomon
oracle 8990 0.0 0.2 42600 9408 ? Ss 14:34 0:00 /oracle/product/crs/bin/oclsomon.bin
root 9096 0.0 0.0 8456 2328 ? SL 14:34 0:00 /oracle/product/crs/bin/oprocd.bin run -t 1000 -m 500 -f
oracle 9221 0.1 4.6 201156 187900 ? SLl 14:34 0:01 /oracle/product/crs/bin/ocssd.bin
oracle 9361 0.0 0.2 58144 10900 ? S 14:34 0:00 /oracle/product/crs/bin/evmlogger.bin -o /oracle/product/crs/evm/log/evmlogger.info -l /oracle/product/crs/evm/l
oracle 13337 0.0 0.2 134740 10964 ? Ss 14:12 0:00 /usr/bin/gnome-session
oracle 13467 1.3 1.4 569512 57484 pts/1 Sl 14:42 0:06 /oracle/product/database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFr
oracle 13638 0.0 0.0 66708 1840 ? Sl 14:12 0:00 /usr/bin/VBoxClient --clipboard
oracle 13646 0.0 0.0 66740 1588 ? Sl 14:12 0:00 /usr/bin/VBoxClient --display
oracle 13651 0.0 0.0 64604 1128 ? Sl 14:12 0:00 /usr/bin/VBoxClient --seamless
oracle 13656 0.0 0.0 66356 1616 ? Sl 14:12 0:00 /usr/bin/VBoxClient --draganddrop
oracle 13721 0.0 0.0 17340 800 ? Ss 14:12 0:00 /usr/bin/ssh-agent /bin/sh -c exec -l /bin/bash -c "/usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xcli
oracle 13748 0.0 0.0 9944 528 ? S 14:12 0:00 /usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xclients
oracle 13767 0.0 0.0 10704 1036 ? Ss 14:12 0:00 dbus-daemon-1 --fork --print-pid 8 --print-address 6 --session
oracle 13829 0.0 0.2 71800 9232 ? S 14:12 0:00 /usr/libexec/gconfd-2 5
oracle 14112 0.0 0.0 5260 576 ? S 14:12 0:00 /usr/bin/gnome-keyring-daemon
oracle 14114 0.0 0.0 69620 2892 ? Ss 14:12 0:00 /usr/libexec/bonobo-activation-server --ac-activate --ior-output-fd=19
oracle 14116 0.0 0.1 137204 7664 ? S 14:13 0:00 /usr/libexec/gnome-settings-daemon --oaf-activate-iid=OAFIID:GNOME_SettingsDaemon --oaf-ior-fd=23
oracle 14147 0.0 0.0 5404 1208 ? S 14:13 0:00 /usr/libexec/gam_server
oracle 14156 0.0 0.0 24624 1992 ? S 14:13 0:00 xscreensaver -nosplash
oracle 14205 0.0 0.1 102860 7980 ? Ss 14:13 0:00 /usr/bin/metacity --sm-client-id=default1
oracle 14209 0.0 0.3 142136 12924 ? Ss 14:13 0:00 gnome-panel --sm-client-id default2
oracle 14211 0.0 0.4 169692 17820 ? Ssl 14:13 0:00 nautilus --no-default-window --sm-client-id default3
oracle 14213 0.0 0.1 132704 6664 ? Ss 14:13 0:00 gnome-volume-manager --sm-client-id default6
oracle 14242 0.0 0.1 160212 7960 ? Ssl 14:13 0:00 eggcups --sm-client-id default5
oracle 14244 0.0 0.1 99028 4652 ? Ss 14:13 0:00 pam-panel-icon --sm-client-id default0
oracle 14246 0.4 0.5 200728 21676 ? RNs 14:13 0:09 /usr/bin/python /usr/bin/rhn-applet-gui --sm-client-id default4
root 14249 0.0 0.0 6788 588 ? S 14:13 0:00 /sbin/pam_timestamp_check -d root
oracle 14252 0.0 0.0 101836 3928 ? Sl 14:13 0:00 /usr/libexec/gnome-vfs-daemon --oaf-activate-iid=OAFIID:GNOME_VFS_Daemon_Factory --oaf-ior-fd=29
oracle 14262 0.0 0.0 5168 704 ? S 14:13 0:00 /usr/libexec/mapping-daemon
oracle 14339 0.0 0.2 140264 11384 ? S 14:13 0:01 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:GNOME_Wncklet_Factory --oaf-ior-fd=31
oracle 14341 0.0 0.2 144644 11924 ? S 14:13 0:00 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID:GNOME_MixerApplet_Factory --oaf-ior-fd=33
oracle 14368 0.0 0.2 134736 8684 ? S 14:13 0:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:GNOME_ClockApplet_Factory --oaf-ior-fd=35
oracle 14370 0.0 0.1 131676 7240 ? S 14:13 0:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-ior-f
oracle 14397 0.0 0.3 169468 14688 ? Sl 14:13 0:00 /usr/bin/gnome-terminal
oracle 14424 0.0 0.0 6208 616 ? S 14:13 0:00 gnome-pty-helper
oracle 14426 0.0 0.0 53968 1568 pts/2 Ss+ 14:13 0:00 bash
root 15695 0.0 0.0 71272 1284 pts/1 S 14:47 0:00 su - oracle
oracle 15696 0.0 0.0 53964 1548 pts/1 S 14:47 0:00 -bash
root 17654 0.0 0.0 6324 476 ? S 14:50 0:00 /bin/sleep 1
oracle 17655 0.0 0.0 5448 792 pts/1 R+ 14:50 0:00 ps aux
[oracle@dbp ~]$ ps aux | grep java
oracle 13467 1.3 1.4 569512 57484 pts/1 Sl 14:42 0:06 /oracle/product/database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/oracle/product/database -Doracle.home=/oracle/product/database/oc4j -Doracle.oc4j.localhome=/oracle/product/database/dbp_wxxrdb1/sysman -DEMSTATE=/oracle/product/database/dbp_wxxrdb1 -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/jazn.xml -Djava.security.policy=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/java2.policy -Djava.security.properties=/oracle/product/database/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/oracle/product/database/dbp_wxxrdb1 -Dsysman.md5password=true -Drepapi.oracle.home=/oracle/product/database -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /oracle/product/database/oc4j/j2ee/home/oc4j.jar -config /oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/server.xml
oracle 17677 0.0 0.0 51068 664 pts/1 R+ 14:50 0:00 grep java
[oracle@dbp ~]$ ps aux | grep java
oracle 13467 1.2 1.4 569512 57484 pts/1 Sl 14:42 0:06 /oracle/product/database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/oracle/product/database -Doracle.home=/oracle/product/database/oc4j -Doracle.oc4j.localhome=/oracle/product/database/dbp_wxxrdb1/sysman -DEMSTATE=/oracle/product/database/dbp_wxxrdb1 -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/jazn.xml -Djava.security.policy=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/java2.policy -Djava.security.properties=/oracle/product/database/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/oracle/product/database/dbp_wxxrdb1 -Dsysman.md5password=true -Drepapi.oracle.home=/oracle/product/database -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /oracle/product/database/oc4j/j2ee/home/oc4j.jar -config /oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/server.xml
oracle 17744 0.0 0.0 51068 664 pts/1 R+ 14:51 0:00 grep java
[oracle@dbp ~]$ pkill -9 13467
[oracle@dbp ~]$ ps aux | grep java
oracle 13467 1.2 1.4 569512 57484 pts/1 Sl 14:42 0:06 /oracle/product/database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/oracle/product/database -Doracle.home=/oracle/product/database/oc4j -Doracle.oc4j.localhome=/oracle/product/database/dbp_wxxrdb1/sysman -DEMSTATE=/oracle/product/database/dbp_wxxrdb1 -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/jazn.xml -Djava.security.policy=/oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/java2.policy -Djava.security.properties=/oracle/product/database/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/oracle/product/database/dbp_wxxrdb1 -Dsysman.md5password=true -Drepapi.oracle.home=/oracle/product/database -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /oracle/product/database/oc4j/j2ee/home/oc4j.jar -config /oracle/product/database/oc4j/j2ee/OC4J_DBConsole_dbp_wxxrdb1/config/server.xml
oracle 17782 0.0 0.0 51068 664 pts/1 R+ 14:51 0:00 grep java
[oracle@dbp ~]$ crs_stat -v -f
Usage: crs_stat [resource_name [...]] [-v] [-l] [-q] [-c cluster_member]
crs_stat [resource_name [...]] -t [-v] [-q] [-c cluster_member]
crs_stat -p [resource_name [...]] [-q]
crs_stat [-a] application -g
crs_stat [-a] application -r [-c cluster_member]
crs_stat -f [resource_name [...]] [-q] [-c cluster_member]
crs_stat -ls [resource_name [...]] [-q]
[oracle@dbp ~]$ crs_stat -v -t
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 OFFLINE OFFLINE
ora....BP.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbp.vip application 0/0 0/0 OFFLINE OFFLINE
ora....SM2.asm application 0/5 0/0 OFFLINE OFFLINE
ora....BS.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbs.vip application 0/0 0/0 OFFLINE OFFLINE
ora.wxxrdb.db application 0/1 0/1 OFFLINE OFFLINE
ora....b1.inst application 0/5 0/0 OFFLINE OFFLINE
ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE
[oracle@dbp ~]$ kill --h
-bash: kill: -h: invalid signal specification
[oracle@dbp ~]$ kill --help
-bash: kill: -help: invalid signal specification
[oracle@dbp ~]$ kill -9 13467
[oracle@dbp ~]$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://dbp:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
[oracle@dbp ~]$ ps aux | grep java
oracle 18687 0.0 0.0 51068 660 pts/1 R+ 14:52 0:00 grep java
[oracle@dbp ~]$ exit
注意此处选择CRS的地址,我们先安装CRS的补丁,patch set是一个整体,包括CRS的补丁和数据库的补丁:
默认给整个cluster打补丁,两个节点都选;
只在DBP上运行orainstaRoot.sh,oraInventory1的解决权限问题;
[root@dbp oracle]# /oracle/oraInventory1/orainstRoot.sh
Changing permissions of /oracle/oraInventory1 to 770.
Changing groupname of /oracle/oraInventory1 to dba.
The execution of the script is complete
分别在节点1DBP和节点2DBS上运行命令crsctl stop crs和root102.sh
DBP上操作
[root@dbp oracle]# /oracle/product/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@dbp oracle]# /oracle/product/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /oracle/product/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/oracle/product' is not owned by root
WARNING: directory '/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
10204 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: dbp dbp-priv dbp
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
[root@dbs ~]# /oracle/product/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@dbs ~]# /oracle/product/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /oracle/product/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/oracle/product' is not owned by root
WARNING: directory '/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
10204 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 2: dbs dbs-priv dbs
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
安装结束后,会将所有的服务默认都起来,通过CRS_STAT检查;
[root@dbs ~]# crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE dbp
ora....BP.lsnr application 0/5 0/0 ONLINE ONLINE dbp
ora.dbp.gsd application 0/5 0/0 ONLINE ONLINE dbp
ora.dbp.ons application 0/3 0/0 ONLINE ONLINE dbp
ora.dbp.vip application 0/0 0/0 ONLINE ONLINE dbp
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE dbs
ora....BS.lsnr application 0/5 0/0 ONLINE ONLINE dbs
ora.dbs.gsd application 0/5 0/0 ONLINE OFFLINE
ora.dbs.ons application 0/3 0/0 ONLINE ONLINE dbs
ora.dbs.vip application 0/0 0/0 ONLINE ONLINE dbs
ora.wxxrdb.db application 0/1 0/1 ONLINE ONLINE dbp
ora....b1.inst application 0/5 0/0 ONLINE ONLINE dbp
ora....b2.inst application 0/5 0/0 ONLINE OFFLINE
将所有应用再次停掉;
[oracle@dbp ~]$ srvctl stop database -d wxxrdb
[oracle@dbp ~]$ srvctl stop nodeapps -n dbp
[oracle@dbp ~]$ srvctl stop nodeapps -n dbs
[oracle@dbp ~]$ crs_stop -all
Attempting to stop `ora.dbp.ASM1.asm` on member `dbp`
Attempting to stop `ora.dbs.ASM2.asm` on member `dbs`
Stop of `ora.dbs.ASM2.asm` on member `dbs` succeeded.
Stop of `ora.dbp.ASM1.asm` on member `dbp` succeeded.
[oracle@dbp ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 OFFLINE OFFLINE
ora....BP.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbp.vip application 0/0 0/0 OFFLINE OFFLINE
ora....SM2.asm application 0/5 0/0 OFFLINE OFFLINE
ora....BS.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbs.vip application 0/0 0/0 OFFLINE OFFLINE
ora.wxxrdb.db application 0/1 0/1 OFFLINE OFFLINE
ora....b1.inst application 0/5 0/0 OFFLINE OFFLINE
ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE
安装数据库补丁,打开xmanager登陆dbp节点1,运行./runInstaller脚本;
在此处选择数据库目录,升级数据库;
提示目录非空,是否继续安装,继续;
默认选择cluster安装双节点;
通过检查;
安装成功后,需要在节点1dbp和节点2dps上先后分别运行脚本/oracle/product/database/root.sh
[root@dbp ~]# /oracle/product/database/root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/product/database
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
[root@dbp ~]# ssh root@dbs
root@dbs's password:
Last login: Tue Jun 4 14:37:41 2013 from 192.168.2.111
[root@dbs ~]# /oracle/product/database/root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/product/database
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
之后将数据库启动的nomount,修改cluster_database参数,重新编译升级后对象;
[root@dbs ~]# crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 OFFLINE OFFLINE
ora....BP.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbp.vip application 0/0 0/0 OFFLINE OFFLINE
ora....SM2.asm application 0/5 0/0 OFFLINE OFFLINE
ora....BS.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbs.vip application 0/0 0/0 OFFLINE OFFLINE
ora.wxxrdb.db application 0/1 0/1 OFFLINE OFFLINE
ora....b1.inst application 0/5 0/0 OFFLINE OFFLINE
ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE
[root@dbs ~]# srvctl start nodeapps -n dbp
[root@dbs ~]# srvctl start nodeapps -n dbs
[root@dbs ~]# crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 OFFLINE OFFLINE
ora....BP.lsnr application 0/5 0/0 ONLINE ONLINE dbp
ora.dbp.gsd application 0/5 0/0 ONLINE ONLINE dbp
ora.dbp.ons application 0/3 0/0 ONLINE ONLINE dbp
ora.dbp.vip application 0/0 0/0 ONLINE ONLINE dbp
ora....SM2.asm application 0/5 0/0 OFFLINE OFFLINE
ora....BS.lsnr application 0/5 0/0 ONLINE ONLINE dbs
ora.dbs.gsd application 0/5 0/0 ONLINE ONLINE dbs
ora.dbs.ons application 0/3 0/0 ONLINE ONLINE dbs
ora.dbs.vip application 0/0 0/0 ONLINE ONLINE dbs
ora.wxxrdb.db application 0/1 0/1 OFFLINE OFFLINE
ora....b1.inst application 0/5 0/0 OFFLINE OFFLINE
ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE
[root@dbs ~]# srvctl start asm -n dbp
[root@dbs ~]# srvctl start asm -n dbs
[root@dbs ~]# srvctl start database -d wxxrdb -o nomount
[root@dbs ~]# crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE dbp
ora....BP.lsnr application 0/5 0/0 ONLINE ONLINE dbp
ora.dbp.gsd application 0/5 0/0 ONLINE ONLINE dbp
ora.dbp.ons application 0/3 0/0 ONLINE ONLINE dbp
ora.dbp.vip application 0/0 0/0 ONLINE ONLINE dbp
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE dbs
ora....BS.lsnr application 0/5 0/0 ONLINE ONLINE dbs
ora.dbs.gsd application 0/5 0/0 ONLINE ONLINE dbs
ora.dbs.ons application 0/3 0/0 ONLINE ONLINE dbs
ora.dbs.vip application 0/0 0/0 ONLINE ONLINE dbs
ora.wxxrdb.db application 0/1 0/1 ONLINE ONLINE dbs
ora....b1.inst application 0/5 0/0 ONLINE ONLINE dbp
ora....b2.inst application 0/5 0/0 ONLINE ONLINE dbs
[root@dbs ~]# su - oracle
[oracle@dbs ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 4 15:04:51 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
Connected.
SQL> alter system set cluster_database=false scope=spfile;
System altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@dbs ~]$ srvctl stop database
PRKO-2001 : Invalid command line syntax
[oracle@dbs ~]$ srvctl stop database -d wxxrdb
[oracle@dbs ~]$ srvctl status database -d wxxrdb
Instance wxxrdb1 is not running on node dbp
Instance wxxrdb2 is not running on node dbs
[oracle@dbs ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 4 15:06:14 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> startup upgrade
ORA-01031: insufficient privileges
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 771751936 bytes
Fixed Size 2087088 bytes
Variable Size 201328464 bytes
Database Buffers 562036736 bytes
Redo Buffers 6299648 bytes
Database mounted.
Database opened.
SQL> spool /home/oracle/patch.log;
SQL> @?/rdbms/admin/catupgrd.sql;
略去编译中间提示。。。
SQL> spool off
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 771751936 bytes
Fixed Size 2087088 bytes
Variable Size 255854416 bytes
Database Buffers 507510784 bytes
Redo Buffers 6299648 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/utlrp.sql;
TIMESTAMP
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2013-06-04 15:27:27
DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time is proportional to the
DOC> number of invalid objects in the database, so this command may take
DOC> a long time to execute on a database with a large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track recompilation progress:
DOC>
DOC> 1. Query returning the number of invalid objects remaining. This
DOC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or parallel recompilation
DOC> based on the number of CPUs available (parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC> recompilation. Jobs are created without instance affinity so that they
DOC> can migrate across RAC nodes. Use the following queries to verify
DOC> whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC> 1. Query showing jobs created by UTL_RECOMP
DOC> SELECT job_name FROM dba_scheduler_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC> 2. Query showing UTL_RECOMP jobs that are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2013-06-04 15:28:03
DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
OBJECTS WITH ERRORS
-------------------
1
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#
ERRORS DURING RECOMPILATION
---------------------------
0
SQL> alter system set cluster_database=true scope=spfile;
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
提示有一个对象有错,后面待查;
SQL> startup;
ORACLE instance started.
Total System Global Area 771751936 bytes
Fixed Size 2087088 bytes
Variable Size 255854416 bytes
Database Buffers 507510784 bytes
Redo Buffers 6299648 bytes
Database mounted.
Database opened.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@dbs ~]$ srvctl start database -d wxxrdb
[oracle@dbs ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 4 15:33:13 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sydsba
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
SQL> conn / as sysba
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
SQL> conn / as sysdba
Connected.
SQL> select * from dba_errors
2 ;
OWNER NAME TYPE
------------------------------ ------------------------------ ------------
SEQUENCE LINE POSITION
---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE MESSAGE_NUMBER
--------- --------------
MDSYS SDO_3GL PACKAGE BODY
1 1433 28
PLS-00302: component 'CONVERT_DISTANCE' must be declared
ERROR 302
OWNER NAME TYPE
------------------------------ ------------------------------ ------------
SEQUENCE LINE POSITION
---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE MESSAGE_NUMBER
--------- --------------
MDSYS SDO_3GL PACKAGE BODY
2 1433 7
PL/SQL: Statement ignored
ERROR 0
OWNER NAME TYPE
------------------------------ ------------------------------ ------------
SEQUENCE LINE POSITION
---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE MESSAGE_NUMBER
--------- --------------
MDSYS SDO_3GL PACKAGE BODY
3 1447 26
PLS-00302: component 'CONVERT_DISTANCE' must be declared
ERROR 302
OWNER NAME TYPE
------------------------------ ------------------------------ ------------
SEQUENCE LINE POSITION
---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE MESSAGE_NUMBER
--------- --------------
MDSYS SDO_3GL PACKAGE BODY
4 1447 9
PL/SQL: Statement ignored
ERROR 0
OWNER NAME TYPE
------------------------------ ------------------------------ ------------
SEQUENCE LINE POSITION
---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE MESSAGE_NUMBER
--------- --------------
MDSYS SDO_3GL PACKAGE BODY
5 1471 24
PLS-00302: component 'EXPAND_MULTI_POINT' must be declared
ERROR 302
OWNER NAME TYPE
------------------------------ ------------------------------ ------------
SEQUENCE LINE POSITION
---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE MESSAGE_NUMBER
--------- --------------
MDSYS SDO_3GL PACKAGE BODY
6 1471 7
PL/SQL: Statement ignored
ERROR 0
6 rows selected.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL> col status from a10
SP2-0158: unknown COLUMN option "from"
SQL> col status format a10
SQL> col version format a15
SQL> col comp_name format a30
SQL> select comp_name,version,status from dba_registry;
COMP_NAME VERSION STATUS
------------------------------ --------------- ----------
Oracle Enterprise Manager 10.2.0.4.0 VALID
Oracle interMedia 10.2.0.4.0 VALID
Oracle XML Database 10.2.0.4.0 VALID
Oracle Expression Filter 10.2.0.4.0 VALID
Oracle Rule Manager 10.2.0.4.0 VALID
Oracle Workspace Manager 10.2.0.4.3 VALID
Oracle Database Catalog Views 10.2.0.4.0 VALID
Oracle Database Packages and T 10.2.0.4.0 VALID
ypes
JServer JAVA Virtual Machine 10.2.0.4.0 VALID
COMP_NAME VERSION STATUS
------------------------------ --------------- ----------
Oracle XDK 10.2.0.4.0 VALID
Oracle Database Java Packages 10.2.0.4.0 VALID
Oracle Real Application Cluste 10.2.0.4.0 VALID
rs
12 rows selected.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@dbs ~]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
http://dbp:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control .... started.
------------------------------------------------------------------
Logs are generated in directory /oracle/product/database/dbs_wxxrdb2/sysman/log
[oracle@dbs ~]$ exit
logout
[root@dbs ~]# exit
logout
Connection to dbs closed.
[root@dbp ~]# su - oracle
[oracle@dbp ~]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
http://dbp:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control .................................... started.
------------------------------------------------------------------
Logs are generated in directory /oracle/product/database/dbp_wxxrdb1/sysman/log
[oracle@dbp ~]$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
http://dbp:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
[oracle@dbp ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE dbp
ora....BP.lsnr application 0/5 0/0 ONLINE ONLINE dbp
ora.dbp.gsd application 0/5 0/0 ONLINE ONLINE dbp
ora.dbp.ons application 0/3 0/0 ONLINE ONLINE dbp
ora.dbp.vip application 0/0 0/0 ONLINE ONLINE dbp
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE dbs
ora....BS.lsnr application 0/5 0/0 ONLINE ONLINE dbs
ora.dbs.gsd application 0/5 0/0 ONLINE ONLINE dbs
ora.dbs.ons application 0/3 0/0 ONLINE ONLINE dbs
ora.dbs.vip application 0/0 0/0 ONLINE ONLINE dbs
ora.wxxrdb.db application 0/1 0/1 ONLINE ONLINE dbp
ora....b1.inst application 0/5 0/0 ONLINE ONLINE dbp
ora....b2.inst application 0/5 0/0 ONLINE ONLINE dbs
[oracle@dbp ~]$ srvctl stop database -d wxxrdb
[oracle@dbp ~]$ srvctl stop nodeapps -n dbp
[oracle@dbp ~]$ srvctl stop nodeapps -n dbs
[oracle@dbp ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE dbp
ora....BP.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbp.vip application 0/0 0/0 OFFLINE OFFLINE
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE dbs
ora....BS.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbs.vip application 0/0 0/0 OFFLINE OFFLINE
ora.wxxrdb.db application 0/1 0/1 OFFLINE OFFLINE
ora....b1.inst application 0/5 0/0 OFFLINE OFFLINE
ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE
[oracle@dbp ~]$ srvctl stop asm -n dbp
[oracle@dbp ~]$ srvctl stop asm -n dbs
[oracle@dbp ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 OFFLINE OFFLINE
ora....BP.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbp.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbp.vip application 0/0 0/0 OFFLINE OFFLINE
ora....SM2.asm application 0/5 0/0 OFFLINE OFFLINE
ora....BS.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.dbs.ons application 0/3 0/0 OFFLINE OFFLINE
ora.dbs.vip application 0/0 0/0 OFFLINE OFFLINE
ora.wxxrdb.db application 0/1 0/1 OFFLINE OFFLINE
ora....b1.inst application 0/5 0/0 OFFLINE OFFLINE
ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE
[oracle@dbp ~]$ exit
logout
[root@dbp ~]# shutdown -h now
Broadcast message from root (pts/1) (Tue Jun 4 15:42:07 2013):
The system is going down for system halt NOW!
经过查询,MDSYS.SDO_3GL 是地理信息库中的对象,在此忽略
还有一种升级的方法dbua,后面的文章介绍;