Нет соеденения с сервером Oracle.

Добрый день,

Возникла проблема - нет связи с сервером Oracle Database

тест с клиента tnsping

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.34)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl))) TNS-12541: TNS:no listener

на сервере listener

автор

LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ ction Start Date 02-OCT-2015 10:22:31 Uptime 0 days 0 hr. 4 min. 6 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File c:\oracle\network\admin\listener.ora Listener Log File d:\oradata\diag\tnslsnr\bdtest\listener\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Services Summary... Service "ORCL" has 1 instance(s). Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully LSNRCTL> services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) Services Summary... Service "ORCL" has 1 instance(s). Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER The command completed successfully

TNSping на сервере - OK

rooman_
Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Services Summary... TNSping на сервере - OK

Не мудрено.

rooman_,

ваш листенер local host слушает:

(HOST=127.0.0.1)

вероятно, надо слушать HOST = 192.168.0.34

Благодарю, исправил файл hosts. TNSping прошёл.