CONN => ora-12520, tnsping => OK

wertarez
Дата: 12.10.2015 16:24:05
Разбираюсь уже с преднастроенной БД.
Подскажите, какие настройки нужно сверить, чтобы удаленно можно было подключиться к БД с нестандартным LISTENER на 1522 порту? TNSPING с клиента не выдает ошибок, а при Connect получаю ORA-12520.

На сервере:

$ lsnrctl services LISTENER_RUNA

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 12-OCT-2015 16:09:47

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

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=hors.db.dev.tel)(PORT=1522))
Services Summary...
Service "runa.app.dev.valk" has 1 instance(s).
  Instance "runa", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:7134 refused:0 state:ready
         LOCAL SERVER
Service "runaXDB.app.dev.valk" has 1 instance(s).
  Instance "runa", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:1318 refused:0 current:1 max:20 state:ready
         DISPATCHER <machine: hors.db.dev.tel, pid: 5005>
         (ADDRESS=(PROTOCOL=tcp)(HOST=hors.db.dev.tel)(PORT=32534))
Service "hors.app.dev.valk" has 1 instance(s).
  Instance "r", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:7134 refused:0 state:ready
         LOCAL SERVER
Service "hors.db.dev.tel" has 1 instance(s).
  Instance "runa", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:7134 refused:0 state:ready
         LOCAL SERVER
The command completed successfully
wertarez
Дата: 12.10.2015 16:29:57
сори, затер при копировании Instance "runa":

$ lsnrctl services LISTENER_RUNA

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 12-OCT-2015 16:09:47

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

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=hors.db.dev.tel)(PORT=1522))
Services Summary...
Service "runa.app.dev.valk" has 1 instance(s).
  Instance "runa", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:7134 refused:0 state:ready
         LOCAL SERVER
Service "runaXDB.app.dev.valk" has 1 instance(s).
  Instance "runa", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:1318 refused:0 current:1 max:20 state:ready
         DISPATCHER <machine: hors.db.dev.tel, pid: 5005>
         (ADDRESS=(PROTOCOL=tcp)(HOST=hors.db.dev.tel)(PORT=32534))
Service "hors.app.dev.valk" has 1 instance(s).
  Instance "runa", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:7134 refused:0 state:ready
         LOCAL SERVER
Service "hors.db.dev.tel" has 1 instance(s).
  Instance "runa", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:7134 refused:0 state:ready
         LOCAL SERVER
The command completed successfully


пытаюсь подключиться как:

sqlplus /nolog
conn army/1111@runa


на клиенте tnsnames:

RUNA =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.18)(PORT = 1522))
    (CONNECT_DATA =
      (SERVICE_NAME = hors.db.dev.tel)
    )
  )
wertarez
Дата: 12.10.2015 18:44:43
Не актуально...разобрался сам.
Оказалось проблема в tnsnames.ora:

RUNA =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.18)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = hors.db.dev.tel)
    )
  )