Hello...
I'm running Oracle 10g (10.2.0.1) on RHEL4. My listener, database and Oracle HTTP Server are up and running. The sole purpose of this database is to run Oracle Application Express applications. The oracle apex applications are all running fine.
However, I cannot for the life of me get Oracle EM (dbconsole) running. I've tried everything but obviously not the right thing. I can't console to my running database? It keeps failing everytime I start it. I've looked at some logs but I don't know what I'm looking for. Oracle EM was running just fine on Friday, but wouldn't come up Monday morning.
My url for EM is
http://172.23.183.169:1158/emAt the terminal session prompt I type >emctl start dbconsole
It comes back after a 5 minute timeout saying it failed. It appears that the agent (3938) does not want to start.
Here is some log info further below...
Please let me know what direction I should go on to resolve this. Thx!
Regards,
Ken
ENV VARIABLES:
[oracle@clthcmmb03 ~]$ env|sort
COLORTERM=gnome-terminal
DBUS_SESSION_BUS_ADDRESS=u
nix:abstra
ct=/tmp/db
us-uEKexk6
EGd
DESKTOP_SESSION=default
DESKTOP_STARTUP_ID=
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
GDMSESSION=default
GNOME_DESKTOP_SESSION_ID=D
efault
GNOME_KEYRING_SOCKET=/tmp/
keyring-uF
au6k/socke
t
GTK_RC_FILES=/etc/gtk/gtkr
c:/home/or
acle/.gtkr
c-1.2-gnom
e2
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=clthcmmb03
INPUTRC=/etc/inputrc
KDEDIR=/usr
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/home/orac
le/oracle/
product/10
.2.0/db_1/
lib:/home/
oracle/ora
cle/produc
t/10.2.0/d
b_2/opmn/l
ib:
LESSOPEN=|/usr/bin/lesspip
e.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=0
0;34:ln=00
;36:pi=40;
33:so=00;3
5:bd=40;33
;01:cd=40;
33;01:or=0
1;05;37;41
:mi=01;05;
37;41:ex=0
0;32:*.cmd
=00;32:*.e
xe=00;32:*
.com=00;32
:*.btm=00;
32:*.bat=0
0;32:*.sh=
00;32:*.cs
h=00;32:*.
tar=00;31:
*.tgz=00;3
1:*.arj=00
;31:*.taz=
00;31:*.lz
h=00;31:*.
zip=00;31:
*.z=00;31:
*.Z=00;31:
*.gz=00;31
:*.bz2=00;
31:*.bz=00
;31:*.tz=0
0;31:*.rpm
=00;31:*.c
pio=00;31:
*.jpg=00;3
5:*.gif=00
;35:*.bmp=
00;35:*.xb
m=00;35:*.
xpm=00;35:
*.png=00;3
5:*.tif=00
;35:
MAIL=/var/spool/mail/oracl
e
ORACLE_HOME=/home/oracle/o
racle/prod
uct/10.2.0
/db_1
ORACLE_SID=apex
PATH=/home/oracle/oracle/p
roduct/10.
2.0/db_1/b
in:/home/o
racle/orac
le/product
/10.2.0/db
_2/opmn/bi
n:/home/or
acle/oracl
e/product/
10.2.0/db_
1/bin:/hom
e/oracle/o
racle/prod
uct/10.2.0
/db_2/opmn
/bin:/usr/
kerberos/b
in:/usr/lo
cal/bin:/u
sr/bin:/bi
n:/usr/X11
R6/bin
PWD=/home/oracle
SESSION_MANAGER=local/clth
cmmb03:/tm
p/.ICE-uni
x/6580
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=6632
SSH_ASKPASS=/usr/libexec/o
penssh/gno
me-ssh-ask
pass
SSH_AUTH_SOCK=/tmp/ssh-dyb
iGw6580/ag
ent.6580
TERM=xterm
USER=oracle
_=/usr/bin/env
WINDOWID=39845962
XAUTHORITY=/home/oracle/.X
authority
TERMINAL SESSION:
[oracle@clthcmmb03 ~]$ emctl start dbconsole
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://clthcmmb03:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ..........................
..........
..........
..........
..........
..........
..........
....... failed.
--------------------------
----------
----------
----------
----------
Logs are generated in directory /home/oracle/oracle/produc
t/10.2.0/d
b_1/clthcm
mb03_apex/
sysman/log
EMDCTL.TRC:
2007-08-13 15:08:39 Thread-3086911712 WARN
http: snmehl_connect: connect failed to (clthcmmb03:3938): Connection refused (error = 111)
2007-08-13 15:08:45 Thread-3086911712 WARN
http: snmehl_connect: connect failed to (clthcmmb03:1158): Connection refused (error = 111)
EMAGENT.TRC:
2007-08-13 14:40:34 Thread-3086911712 ERROR
http: snmehl_allocateListenerPor
t: failed to bind socket: Address already in use (errno=98)
2007-08-13 14:40:34 Thread-3086911712 ERROR
http: nmehl_startHttpListener: failed to listen to HTTP port for
http://clthcmmb03:3938/emd/main2007-08-13 14:40:34 Thread-3086911712 ERROR main: nmehl_startHttpListener failed starting http listener
2007-08-13 15:10:12 Thread-3086911712 ERROR
http: snmehl_allocateListenerPor
t: failed to bind socket: Address already in use (errno=98)
2007-08-13 15:10:12 Thread-3086911712 ERROR
http: nmehl_startHttpListener: failed to listen to HTTP port for
http://clthcmmb03:3938/emd/main2007-08-13 15:10:12 Thread-3086911712 ERROR main: nmehl_startHttpListener failed starting http listener
EMOMS.TRC:
2007-08-12 02:00:36,607 [NotificationMgrThread] ERROR jdbc.ConnectionWrapper _applySessionParams.2980 - SQLException message: ORA-01089: immediate shutdown in progress - no operations are permitted
java.sql.SQLException: ORA-01089: immediate shutdown in progress - no operations are permitted
at oracle.jdbc.driver.Databas
eError.thr
owSqlExcep
tion(Datab
aseError.j
ava:111)
at oracle.jdbc.driver.T4CTTIo
er.process
Error(T4CT
TIoer.java
:330)
at oracle.jdbc.driver.T4CTTIo
er.process
Error(T4CT
TIoer.java
:287)
at oracle.jdbc.driver.T4C8Oal
l.receive(
T4C8Oall.j
ava:742)
at oracle.jdbc.driver.T4CCall
ableStatem
ent.doOall
8(T4CCalla
bleStateme
nt.java:21
4)
at oracle.jdbc.driver.T4CCall
ableStatem
ent.execut
eForRows(T
4CCallable
Statement.
java:953)
at oracle.jdbc.driver.OracleS
tatement.d
oExecuteWi
thTimeout(
OracleStat
ement.java
:1260)
at oracle.jdbc.driver.OracleP
reparedSta
tement.exe
cuteIntern
al(OracleP
reparedSta
tement.jav
a:3290)
at oracle.jdbc.driver.OracleP
reparedSta
tement.exe
cuteQuery(
OraclePrep
aredStatem
ent.java:3
334)
at oracle.sysman.util.jdbc.Co
nnectionWr
apper._app
lySessionP
arams(Conn
ectionWrap
per.java:2
971)
at oracle.sysman.util.jdbc.Co
nnectionWr
apper.<ini
t>(Connect
ionWrapper
.java:181)
at oracle.sysman.emSDK.svc.co
nn.FGAConn
ection.<in
it>(FGACon
nection.ja
va:115)
at oracle.sysman.emSDK.svc.co
nn.FGAConn
ectionCach
e.getFGACo
nnection(F
GAConnecti
onCache.ja
va:192)
at oracle.sysman.emSDK.svc.co
nn.Connect
ionService
.getSystem
Connection
(Connectio
nService.j
ava:683)
at oracle.sysman.emdrep.notif
ication.No
tification
Mgr.getCon
nection(No
tification
Mgr.java:2
52)
at oracle.sysman.emdrep.notif
ication.No
tification
Mgr.resetC
onnection(
Notificati
onMgr.java
:298)
at oracle.sysman.emdrep.notif
ication.No
tification
Mgr.run(No
tification
Mgr.java:1
190)
Start Free Trial