Home » RDBMS Server » Enterprise Manager » help...listener and EM is not active (IM speak removed)
help...listener and EM is not active (IM speak removed) [message #274361] Mon, 15 October 2007 17:00 Go to next message
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 #274362 is a reply to message #274361] Mon, 15 October 2007 17:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
CUT & PASTE results from
df -k
Re: pls help...listener and EM is not active [message #274363 is a reply to message #274362] Mon, 15 October 2007 17:16 Go to previous messageGo to next message
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: pls help...listener and EM is not active [message #274364 is a reply to message #274363] Mon, 15 October 2007 17:30 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
the server status displays oracle as SLEEP....
Re: help...listener and EM is not active (IM speak removed) [message #274718 is a reply to message #274361] Tue, 16 October 2007 23:13 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member


Quote:

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))


What is host?
Re: help...listener and EM is not active (IM speak removed) [message #274742 is a reply to message #274361] Wed, 17 October 2007 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Regards
Michel
Re: help...listener and EM is not active (IM speak removed) [message #275233 is a reply to message #274742] Thu, 18 October 2007 22:50 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Quote:


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



I think he wrote not full!
Re: help...listener and EM is not active (IM speak removed) [message #275435 is a reply to message #275233] Sat, 20 October 2007 01:04 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
yes sir,host is hisdbs06
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 Go to previous messageGo to next message
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...
Re: help...listener and EM is not active (IM speak removed) [message #275936 is a reply to message #274361] Tue, 23 October 2007 07:43 Go to previous message
gunsbong
Messages: 44
Registered: May 2007
Member
oracle 10g release 2.0.2.0
Previous Topic: RMAN does not work from OEM
Next Topic: Cannnot open Enterprise Manager or connect after move
Goto Forum:
  


Current Time: Fri Mar 29 08:20:34 CDT 2024