сори, затер при копировании 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)
)
)