Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 Oracle 10g EMConsole не работает  [new]
Nuku Bukui
Member

Откуда: Moscow
Сообщений: 46
Не запускается EM. Перерыл кучу онторнетов - все подкрутил. Результата нет.

Лог emctl:
[root@erection ~]# tail -f /opt/oracle/product/10.2.0/db_1/erection_r39gzk77/sysman/log/emdctl.trc 

2010-08-23 14:28:18 Thread-4135806656 WARN  http: snmehl_connect: connect failed to (erection:3938): Connection refused (error = 111)
2010-08-23 14:28:19 Thread-4135532224 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:21 Thread-4135429824 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:24 Thread-4135196352 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:27 Thread-4135605952 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:30 Thread-4135843520 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:33 Thread-4135540416 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:35 Thread-4135454400 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:38 Thread-4135773888 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:41 Thread-4135315136 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:44 Thread-4135773888 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:47 Thread-4135782080 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:28:48 Thread-4135687872 WARN  http: snmehl_connect: connect failed to (erection:5500): Connection refused (error = 111)
2010-08-23 14:28:58 Thread-4135118528 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 14:29:02 Thread-4134995648 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)

По логу выходит, что порт закрыт, но:
[root@erection ~]# system-config-securitylevel
setenforce: SELinux is disabled

[root@erection ~]# /usr/sbin/sestatus 
SELinux status: disabled

[root@erection ~]# /etc/init.d/iptables status
Firewall is stopped.

Стартуем DBConsole:
[oracle@erection ~]$ emctl start dbconsole
TZ set to Europe/Kaliningrad
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0  
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
http://erection:1158/em/console/aboutApplication
Agent Version     : 10.1.0.5.1
OMS Version       : Unknown
Protocol Version  : 10.1.0.2.0
Agent Home        : /opt/oracle/product/10.2.0/db_1/erection_r39gzk77
Agent binaries    : /opt/oracle/product/10.2.0/db_1
Agent Process ID  : 10892
Parent Process ID : 8377
Agent URL         : http://erection:3938/emd/main
Started at        : 2010-08-23 14:28:32
Started by user   : oracle
Last Reload       : 2010-08-23 14:28:32
Last successful upload                       : (none)
Last attempted upload                        : (none)
Total Megabytes of XML files uploaded so far :     0.00
Number of XML files pending upload           :      120
Size of XML files pending upload(MB)         :     9.79
Available disk space on upload filesystem    :    34.56%
Agent is already started. Will restart the agent 
Stopping agent ... stopped.
Starting Oracle Enterprise Manager 10g Database Control ........................................ started. 
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/product/10.2.0/db_1/erection_r39gzk77/sysman/log 

И сразу проверяем статус:
[oracle@erection ~]$ emctl status dbconsole
TZ set to Europe/Kaliningrad
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0  
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
http://erection:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running. 
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/product/10.2.0/db_1/erection_r39gzk77/sysman/log 

Проверяем доступность хоста erection:
[oracle@erection ~]$ ping erection
PING erection (127.0.0.1) 56(84) bytes of data.
64 bytes from erection (127.0.0.1): icmp_seq=1 ttl=64 time=0.015 ms
64 bytes from erection (127.0.0.1): icmp_seq=2 ttl=64 time=0.005 ms
64 bytes from erection (127.0.0.1): icmp_seq=3 ttl=64 time=0.005 ms
64 bytes from erection (127.0.0.1): icmp_seq=4 ttl=64 time=0.010 ms

--- erection ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3000ms
rtt min/avg/max/mdev = 0.005/0.008/0.015/0.005 ms

Сетевой интерфейс один:
[root@erection ~]# ifconfig 
eth0      Link encap:Ethernet  HWaddr 00:26:55:4B:5F:8C  
          inet addr:10.39.143.77  Bcast:10.39.143.255  Mask:255.255.240.0
          inet6 addr: fe80::226:55ff:fe4b:5f8c/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:1199164 errors:0 dropped:0 overruns:0 frame:0
          TX packets:1143584 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:289913874 (276.4 MiB)  TX bytes:575348682 (548.6 MiB)
          Interrupt:169 Memory:f4000000-f4012800 

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:35585 errors:0 dropped:0 overruns:0 frame:0
          TX packets:35585 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:7446344 (7.1 MiB)  TX bytes:7446344 (7.1 MiB)

Проверяю доступность агента по адресу http://erection:3938/emd/main:
EMAgent10.1.0.5.1

Congratulations, EMAgent is working!

Куда рыть дальше?
23 авг 10, 15:43    [9309676]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 10g EMConsole не работает  [new]
koshach
Member

Откуда:
Сообщений: 29
Nuku Bukui,

на каком юнихе поднимаешь?
23 авг 10, 17:51    [9310456]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 10g EMConsole не работает  [new]
Nuku Bukui
Member

Откуда: Moscow
Сообщений: 46
[root@erection ~]# cat /etc/issue
CentOS release 5.4 (Final)
23 авг 10, 18:03    [9310560]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 10g EMConsole не работает  [new]
Андрей Панфилов
Member

Откуда: Москва > Melbourne
Сообщений: 3778
Nuku Bukui
[oracle@erection ~]$ ping erection
PING erection (127.0.0.1) 56(84) bytes of data.
64 bytes from erection (127.0.0.1): icmp_seq=1 ttl=64 time=0.015 ms
64 bytes from erection (127.0.0.1): icmp_seq=2 ttl=64 time=0.005 ms
64 bytes from erection (127.0.0.1): icmp_seq=3 ttl=64 time=0.005 ms
64 bytes from erection (127.0.0.1): icmp_seq=4 ttl=64 time=0.010 ms

--- erection ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3000ms
rtt min/avg/max/mdev = 0.005/0.008/0.015/0.005 ms
уберите дурь из /etc/hosts которая hostname на 127.0.0.1 целит
23 авг 10, 18:56    [9310891]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 10g EMConsole не работает  [new]
Nuku Bukui
Member

Откуда: Moscow
Сообщений: 46
[root@erection ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.reg.gkn.cor localhost

[root@erection ~]# ping erection
PING erection.reg.gkn.cor (10.39.143.77) 56(84) bytes of data.
64 bytes from erection.reg.gkn.cor (10.39.143.77): icmp_seq=1 ttl=64 time=0.013 ms
64 bytes from erection.reg.gkn.cor (10.39.143.77): icmp_seq=2 ttl=64 time=0.011 ms
64 bytes from erection.reg.gkn.cor (10.39.143.77): icmp_seq=3 ttl=64 time=0.011 ms

--- erection.reg.gkn.cor ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 1999ms
rtt min/avg/max/mdev = 0.011/0.011/0.013/0.004 ms

Разворачивает из внутреннего днса:
[root@erection ~]# cat /etc/resolv.conf 
search reg.gkn.cor
nameserver 10.39.143.230

Все по старому:
2010-08-23 18:18:53 Thread-4135720640 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 18:18:56 Thread-4135765696 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
2010-08-23 18:18:59 Thread-4135081664 WARN  http: snmehl_connect: connect failed to (erection:1158): Connection refused (error = 111)
23 авг 10, 19:21    [9311023]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 10g EMConsole не работает  [new]
stdio
Member

Откуда:
Сообщений: 4524
посмотри сниффером
23 авг 10, 23:55    [9311876]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 10g EMConsole не работает  [new]
Alexander Ryndin
Member

Откуда:
Сообщений: 4917
Блог
что говорит?
с сервера: telnet localhost 1158
удаленно: telnet server 1158
24 авг 10, 00:05    [9311897]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 10g EMConsole не работает  [new]
Nuku Bukui
Member

Откуда: Moscow
Сообщений: 46
Alexander Ryndin
что говорит?
с сервера: telnet localhost 1158
удаленно: telnet server 1158


[root@erection ~]# telnet localhost 1158 
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
telnet: Unable to connect to remote host: Connection refused

root@alien:~# telnet erection 1158
Trying 10.39.143.77...
telnet: Unable to connect to remote host: Connection refused
24 авг 10, 10:12    [9312814]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 10g EMConsole не работает  [new]
Nuku Bukui
Member

Откуда: Moscow
Сообщений: 46
stdio
посмотри сниффером


Стартую dbc:
[oracle@erection ~]$ emctl start dbconsole
Палаллельно смотрю трекером:
[root@erection ~]# tcptrack -i lo port 1158

 Client                Server                State        Idle A Speed         
 10.39.143.77:23461    10.39.143.77:1158     RESET        19s    0 B/s
 10.39.143.77:23459    10.39.143.77:1158     RESET        19s    0 B/s
 10.39.143.77:23460    10.39.143.77:1158     RESET        19s    0 B/s
 10.39.143.77:23462    10.39.143.77:1158     RESET        19s    0 B/s
24 авг 10, 10:52    [9313197]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 10g EMConsole не работает  [new]
sOliver
Member

Откуда:
Сообщений: 3
Nuku Bukui,

1 dbConsole не работала или перестала работать?
2 Хотелось бы увидеть журналы "чистого" запуска:
 $ORACLE_HOME/bin/emctl stop dbconsole
 rm -rf $ORACLE_HOME/`hostname -f`_$ORACLE_SID/sysman/log/*
 $ORACLE_HOME/bin/emctl start dbconsole

Интересуют файлы:
  • emdb.nohup
  • emdctl.log
  • emdctl.trc
  • emoms.log
  • emoms.trc
  • 24 авг 10, 15:05    [9315826]     Ответить | Цитировать Сообщить модератору
     Re: Oracle 10g EMConsole не работает  [new]
    Nuku Bukui
    Member

    Откуда: Moscow
    Сообщений: 46
    sOliver, и все-все-все!

    Соррь за долгое молчание. Все оказалось совсем просто и банально.

    Возникла мысль переустановить EM через Universal Installer
    [oracle@erection database]$ ./runInstaller
    Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/OraInstall2010-09-02_04-11-32PM/jre/1.4.2/lib/i386/libawt.so: libXtst.so.6: cannot open shared object file: No such file or directory
    at java.lang.ClassLoader$NativeLibrary.load(Native Method)
    at java.lang.ClassLoader.loadLibrary0(Unknown Source)
    at java.lang.ClassLoader.loadLibrary(Unknown Source)

    Проверим зависимости у libawt.so
    [oracle@erection database]$ ldd /tmp/OraInstall2010-09-02_04-11-32PM/jre/1.4.2/lib/i386/libawt.so 
    	linux-gate.so.1 =>  (0xffffe000) 
    	libmlib_image.so => not found 
    	libjvm.so => not found 
    	libXp.so.6 => /usr/lib/libXp.so.6 (0xf7be3000) 
    	libXt.so.6 => /usr/lib/libXt.so.6 (0xf7b8b000) 
    	libXext.so.6 => /usr/lib/libXext.so.6 (0xf7b7b000) 
    	libXtst.so.6 => not found 
    	libX11.so.6 => /usr/lib/libX11.so.6 (0xf7a72000) 
    	libm.so.6 => /lib/libm.so.6 (0xf7a49000) 
    	libdl.so.2 => /lib/libdl.so.2 (0xf7a44000) 
    	libjava.so => not found 
    	libc.so.6 => /lib/libc.so.6 (0xf78eb000) 
    	libXau.so.6 => /usr/lib/libXau.so.6 (0xf78e8000) 
    	libSM.so.6 => /usr/lib/libSM.so.6 (0xf78df000) 
    	libICE.so.6 => /usr/lib/libICE.so.6 (0xf78c5000) 
    	libXdmcp.so.6 => /usr/lib/libXdmcp.so.6 (0xf78be000) 
    	/lib/ld-linux.so.2 (0x00bc0000) 

    Помимо всего прочего не хватает libXtst.so.6 (см. выше: libawt.so: libXtst.so.6: cannot open shared object file: No such file or directory)
    [root@erection ~]# yum install libXtst.i386
    32х битную версию ставим по этой причине: The installer uses the 32 bit, and the 32 bit version of libXp.so.6. The error message states it found the 64 bit version. (взято из отседа)

    Еще раз проверяем зависимости у libawt.so
    [oracle@erection database]$ ldd /tmp/OraInstall2010-09-02_04-11-32PM/jre/1.4.2/lib/i386/libawt.so 
    	linux-gate.so.1 =>  (0xffffe000) 
    	libmlib_image.so => not found 
    	libjvm.so => not found 
    	libXp.so.6 => /usr/lib/libXp.so.6 (0xf7be0000) 
    	libXt.so.6 => /usr/lib/libXt.so.6 (0xf7b88000) 
    	libXext.so.6 => /usr/lib/libXext.so.6 (0xf7b78000) 
    	libXtst.so.6 => /usr/lib/libXtst.so.6 (0xf7b72000) 
    	libX11.so.6 => /usr/lib/libX11.so.6 (0xf7a6f000) 
    	libm.so.6 => /lib/libm.so.6 (0xf7a46000) 
    	libdl.so.2 => /lib/libdl.so.2 (0xf7a41000) 
    	libjava.so => not found 
    	libc.so.6 => /lib/libc.so.6 (0xf78e8000) 
    	libXau.so.6 => /usr/lib/libXau.so.6 (0xf78e5000) 
    	libSM.so.6 => /usr/lib/libSM.so.6 (0xf78dc000) 
    	libICE.so.6 => /usr/lib/libICE.so.6 (0xf78c2000) 
    	libXdmcp.so.6 => /usr/lib/libXdmcp.so.6 (0xf78bb000) 
    	/lib/ld-linux.so.2 (0x00bc0000) 

    Не успели запустить Universal Installer как волшебным образом завелся EM - ему не хватало этой библиотечки.

    Всем спасибо.
    2 сен 10, 18:09    [9374349]     Ответить | Цитировать Сообщить модератору
    Все форумы / Oracle Ответить