Установка EM

AlexGru
Дата: 09.03.2011 15:40:53
Почему такое может быть.
Устанавливал так:

emca -repos create
emca -config dbcontrol db

Установка прошла успешно. Но вот ведь...
Спасибо.
лист энер
Дата: 09.03.2011 15:47:49
Зайти на хост и проверить все запущенные листенеры:

ps -ef | grep tnslsnr
Brass
Дата: 10.03.2011 08:37:41
вывод
lsnrctl status LISTENER_1
покажи
AlexGru
Дата: 10.03.2011 09:08:50
Поковырял файл конфига листенера.
Теперь так. Привожу вывод команд. Конфиги.

listener.ora
#============================================================================

LISTENER_1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ora1-mz-msk.smnp)(PORT = 1521))
    )
  )

SID_LIST_LISTENER_1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
    )
  )

#============================================================================

LISTENER_2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ora1-mz-msk.smnp)(PORT = 1522))
    )
  )

SID_LIST_LISTENER_2 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
    )
  )

#============================================================================

LISTENER_3 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ora1-mz-msk.smnp)(PORT = 1523))
    )
  )

SID_LIST_LISTENER_3 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
    )
  )

#============================================================================


tnsnames.ora
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST=
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.22.11)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.22.11)(PORT = 1522)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.22.11)(PORT = 1523))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )


команды/вывод
================================================================================================================
oracle@ora1-mz-msk:~/product/10.2.0/db_1/network/admin> ps -ef |grep tnslsnr
oracle    2765  1708  0 08:39 pts/4    00:00:00 grep tnslsnr
oracle   21671     1  1 08:30 ?        00:00:06 /opt/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_1 -inherit
oracle   21690     1  0 08:30 ?        00:00:00 /opt/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_2 -inherit
oracle   21703     1  0 08:30 ?        00:00:00 /opt/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_3 -inherit

================================================================================================================

oracle@ora1-mz-msk:~/product/10.2.0/db_1/network/admin> tnsping ORCL

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 10-MAR-2011 08:40:01

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST= (
ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.22.11)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.22.11)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.22.11)(PORT = 1523)))
(CONNECT_DATA = (SERVICE_NAME = ORCL)))
OK (0 msec)
================================================================================================================

LSNRCTL> show current_listener
Current Listener is LISTENER

================================================================================================================

> lsnrctl status LISTENER

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 10-MAR-2011 08:43:50

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_1
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                10-MAR-2011 08:30:16
Uptime                    0 days 0 hr. 13 min. 33 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /opt/oracle/product/10.2.0/db_1/network/log/listener_1.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora1-mz-msk.smnp)(PORT=1521)))
Services Summary...
Service "ORCL_XPT" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

================================================================================================================

> lsnrctl status LISTENER_1

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 10-MAR-2011 08:44:36

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora1-mz-msk.smnp)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_1
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                10-MAR-2011 08:30:16
Uptime                    0 days 0 hr. 14 min. 19 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /opt/oracle/product/10.2.0/db_1/network/log/listener_1.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora1-mz-msk.smnp)(PORT=1521)))
Services Summary...
Service "ORCL_XPT" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully


================================================================================================================

И при этом окно EM (во вложении) выглядит так.
dmitry7
Дата: 10.03.2011 09:25:13
Пользователь sysman не заблокирован?
AlexGru
Дата: 10.03.2011 09:34:10
dmitry7,

Был заблокирован. Только что разблкировал, перезапустил dbconsole,
тоже самое всё.
dmitry7
Дата: 10.03.2011 09:44:23
Еще раз посмотри не заблокировался ли. Что в логах?
AlexGru
Дата: 10.03.2011 10:15:11
dmitry7,
Спасибо.

Посмотрел, всё ок. Но так же не может подключиться к базе.
Попробую эту рекомендацию
лист энер
Дата: 10.03.2011 10:20:08
У тебя ни в одном из листенеров не указано конкретно прослушивание экземпляра OCRL.
Соответственно, БД будет прослушиваться неявно на порту 1521 для листенера LISTENER.

Поэтому укаказание в TNSNAMES.ORA портов 1522, 1523 безсмысленно, так как никто эту базу не прослушивает на этих портах.

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.22.11)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.22.11)(PORT = 1523))


Поэтому, что бы избежать путаницы, для всех листенеров явно укажи прослушивание для ORCL и всё будет нормально.
AlexGru
Дата: 10.03.2011 11:09:29
лист энер,
Спасибо.

Ну я конечно ж...й чувствовал, что что-то подобное.
Как это сделать? Или где прочитать?