Господа, что бы не плодить темы, спрошу и я.
Проблема также самая, ORA-12560: TNS:protocol adapter error.
Прошу помочь.
Поставил на виртуалку Oracle Database 11g Express Edition Release 11.2.0.2.0. Сервер запущен, работает.
lsnrctl status на сервере
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
C:\Users\IEUser>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 22-DEC-2017 23:00
:05
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
ction
Start Date 22-DEC-2017 22:10:19
Uptime 0 days 0 hr. 49 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\IE11Win7\listener\
alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IE11Win7)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IE11Win7)(PORT=8080))(Presentation=H
TTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, 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 "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
С клиента к серверу цепляюсь через SQL Developer и PLSQL Developer без всяких проблем, через SID=XE.
С SQLPlus такое не выходит:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
C:\Users\user>sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Sat Dec 23 00:03:11 2017
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Enter user-name: Alex
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Через изи коннект всё работает:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
C:\Users\user>sqlplus /nolog
SQL*Plus: Release 12.2.0.1.0 Production on Sat Dec 23 00:04:54 2017
Copyright (c) 1982, 2017, Oracle. All rights reserved.
SQL> conn Alex/pass@xe
Connected.
SQL>
Делаю тнспинг с клиента, всё ок.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
C:\Users\localuser>tnsping xe 5
TNS Ping Utility for 32-bit Windows: Version 12.2.0.1.0 - Production on 23-DEC-2
017 00:07:24
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
C:\oracleclient_12\product\12.2.0\client_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.
219.98)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xe)))
OK (10 msec)
OK (20 msec)
OK (10 msec)
OK (20 msec)
OK (20 msec)
tnsnames.ora на клиенте:
1.
2.
3.
4.
5.
6.
7.
8.
9.
xe =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.219.98 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xe)
)
)
sqlnet.ora на клиенте
1.
2.
3.
SQLNET.AUTHENTICATION_SERVICES= (ALL)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = C:\oracleclient_12\product\12.2.0\client_1\log
listener.ora на клиенте:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = XE)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.219.98)(PORT = 1521))
)
ADR_BASE_LISTENER = C:\oracleclient_12\product\12.2.0\client_1\log
Переменную установил:
В реестре везде также поставил ORACLE_SID=XE
Куда ещё глянуть?
