| help...listener and EM is not active (IM speak removed) [message #274361] |
Mon, 15 October 2007 17:00  |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
hi to everybody...
...help...our production server has malfunctioned...
we are running on HP-UX..
ystem: hisdbs06 Tue Oct 16 00:48:47 2007
oad averages: 0.01, 0.01, 0.01
00 processes: 174 sleeping, 25 running, 1 zombie
pu states:
PU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS
0 0.01 0.0% 0.0% 0.0% 100.0% 0.0% 0.0% 0.0% 0.0%
1 0.01 4.6% 0.0% 2.2% 93.2% 0.0% 0.0% 0.0% 0.0%
2 0.01 0.0% 0.0% 0.0% 100.0% 0.0% 0.0% 0.0% 0.0%
3 0.01 0.0% 0.0% 1.6% 98.4% 0.0% 0.0% 0.0% 0.0%
-- ---- ----- ----- ----- ----- ----- ----- ----- -----
vg 0.01 1.2% 0.0% 1.0% 97.8% 0.0% 0.0% 0.0% 0.0%
emory: 8779632K (7151344K) real, 9156284K (7417772K) virtual, 291436K free Pag
# 1/202
PU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND
1 ? 5114 oracle 154 20 8066M 5828K sleep 0:34 2.02 2.02 oracleor
2 ? 53 root 152 20 4536K 4032K run 565:47 1.70 1.70 vxfsd
2 ? 2091 root 152 20 189M 87536K run 161:56 0.52 0.52 coda
2 ? 1677 root 152 20 185M 73492K run 8:12 0.33 0.33 cimserve
1 ? 2098 root 152 20 112M 17068K run 2:46 0.18 0.18 vxsvc
1 ? 38 root 152 20 432K 384K run 27:49 0.14 0.14 schedcpu
0 ? 1920 root 152 20 46016K 6968K run 8:34 0.14 0.14 ovcd
0 ? 1670 root 152 20 25520K 5536K run 0:17 0.12 0.12 rpcd
0 ? 1990 root 152 20 39652K 6112K run 0:02 0.12 0.12 ovbbccb
ORACLE is SLEEP according to the server....
$ lsnrctl status
LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 16-OCT-2007 00:43:18
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
IT JUST STOP AT THIS POINT.....
THIS IS MY LISTENER.LOG
15-OCT-2007 19:19:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=hisdbs06)(USER=oracle)
)(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(PROTOCOL=TCP)(HOST=hisdbs06)(P
ORT=1521)))(VERSION=169869824)) * status * 0
15-OCT-2007 19:19:05 * service_update * orcl * 0
15-OCT-2007 19:19:12 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=perl@hisdbs06)(HOST
=hisdbs06)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.241.11.41)(PORT=6497
5)) * establish * orcl * 0
15-OCT-2007 19:19:15 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=\\Cc1001-h
isapp01\installer\CorTTex\corttex.exe)(HOST=M3A46-IPC02WI)(USER=hsemilla))(SERVE
R=dedicated)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.141.130.9)(PORT=2653)) * establi
sh * orcl * 0
15-OCT-2007 19:19:17 * service_update * orcl * 0
15-OCT-2007 19:19:53 * service_update * orcl * 0
15-OCT-2007 19:20:11 * service_update * orcl * 0
15-OCT-2007 19:20:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=hisdbs06)(USER=oracle)
)(COMMAND=services)(ARGUMENTS=64)(SERVICE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(H
OST=hisdbs06)(PORT=1521))))(VERSION=169869824)) * services * 0
WARNING: Subscription for node down event still pending
15-OCT-2007 19:20:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=hisdbs06)(USER=oracle)
)(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(PROTOCOL=TCP)(HOST=hisdbs06)(P
ORT=1521)))(VERSION=169869824)) * status * 0
THE ALERT LOG....
Mon Oct 15 20:53:21 2007
Starting control autobackup
Control autobackup written to DISK device
handle '/u01/app/oraarch/RMAN/bakup/c-1157779562-20071015-01'
Mon Oct 15 20:53:23 2007
alter database backup controlfile to '/u01/app/oraarch/RMAN/bakup/contol_file2.c
tl'
Mon Oct 15 20:53:23 2007
Completed: alter database backup controlfile to '/u01/app/oraarch/RMAN/bakup/con
tol_file2.ctl'
Tue Oct 16 00:12:42 2007
Starting ORACLE instance (normal)
[mod-edit] Oracle doesn't use IM speak - Why can't you do the same.
[Updated on: Tue, 16 October 2007 08:01] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: pls help...listener and EM is not active [message #274363 is a reply to message #274362] |
Mon, 15 October 2007 17:16  |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
/u01/app/oraarch (/dev/vg05/lvol1 ) : 60953139 total allocated Kb
28829577 free allocated Kb
32123562 used allocated Kb
52 % allocation used
/u01/app/oradata (/dev/vg04/lvol1 ) : 104665281 total allocated Kb
1411240 free allocated Kb
103254041 used allocated Kb
98 % allocation used
/u01/app/oraindex (/dev/vg03/lvol1 ) : 62228814 total allocated Kb
9671865 free allocated Kb
52556949 used allocated Kb
84 % allocation used
/u01/app/oralog (/dev/vg02/lvol1 ) : 9837395 total allocated Kb
9664141 free allocated Kb
173254 used allocated Kb
1 % allocation used
/home (/dev/vg00/lvol4 ) : 520408 total allocated Kb
498208 free allocated Kb
22200 used allocated Kb
4 % allocation used
/opt (/dev/vg00/lvol7 ) : 6856168 total allocated Kb
3190984 free allocated Kb
3665184 used allocated Kb
53 % allocation used
/tmp (/dev/vg00/lvol5 ) : 1048472 total allocated Kb
141864 free allocated Kb
906608 used allocated Kb
86 % allocation used
/u01/app/oracle (/dev/vg00/u01 ) : 19771732 total allocated Kb
11156801 free allocated Kb
8614931 used allocated Kb
43 % allocation used
/usr (/dev/vg00/lvol8 ) : 6327400 total allocated Kb
3770280 free allocated Kb
2557120 used allocated Kb
40 % allocation used
/var (/dev/vg00/lvol6 ) : 20434688 total allocated Kb
18331256 free allocated Kb
2103432 used allocated Kb
10 % allocation used
/stand (/dev/vg00/lvol1 ) : 326232 total allocated Kb
197144 free allocated Kb
129088 used allocated Kb
39 % allocation used
/ (/dev/vg00/lvol3 ) : 1042992 total allocated Kb
711600 free allocated Kb
331392 used allocated Kb
31 % allocation used
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: help...listener and EM is not active (IM speak removed) [message #275931 is a reply to message #274361] |
Tue, 23 October 2007 07:12 |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
guro's...
i could not determine the cause of sudden disconnection of listener
and EM.alert log could not give concrete answer to my question..after 1 hour of disconnection the regular daily backup process worked...it means nothing is wrong with the database...according to the alert log, deadlock error was registered 7 hours before listener disconnected...does this make sense?
pls. help so i could remedy this unexplainable disconnection in the
future....
master michel...thanks for the reminder...it will not happen again...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
