env, Спасибо что откликнулись!
Статус листенера
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 01-JUN-2017 11:44:54
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ne037.mz.intra)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.4.0 - Production
Start Date 01-JUN-2017 10:29:57
Uptime 0 days 1 hr. 14 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File C:\oracle\diag\tnslsnr\ne037\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ne037.sdg.intra)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service...
Service "tc" has 1 instance(s).
Instance "tc", status READY, has 1 handler(s) for this service...
The command completed successfully
select * from v$version; выводит
1.
2.
3.
4.
5.
6.
BANNER
-------------------------------------------
Oracle Database 11g Enterprise Edition Rele
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for 64-bit Windows: Version 11.2.0.4.0
NLSRTL Version 11.2.0.4.0 - Production
В файле alert_sid.log постоянно повторяется
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
Fatal NI connect error 12560, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Time: 01-JUN-2017 11:35:53
Tracing to file:
Tns error struct:
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (5332) as a result of ORA-609
Я так понял это не совсем однозначная ошибка. UAC отключен, проверял порт 1521 через telnet, порт открыт. Все началось после недавнего обновления безопасности шиндовс.
