Oracle Ora-12560: TNS: 协议适配器错误

我在窗口服务器2012R2上使用单个实例12.2c 64位Oracle数据库。突然出现此错误ORA-12560: TNS:protocol adapter error
当我尝试进入sqlplus时开始显示。无论我在互联网上搜索了很多解决方案，但没有得到任何解决方案。这是

lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 13-MAY-2019 10:18:30

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TST01)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Start Date                11-MAY-2019 11:13:21
Uptime                    1 days 23 hr. 5 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   E:\app\oracle\product\12.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         E:\app\oracle\diag\tnslsnr\TST01\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TST01)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=TST01)(PORT=5500))(Security=(my_wallet_directory=E:\APP\ORACLE\admin\ORCL\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service...
Service "ORCLXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl" has 2 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

这是

tnsping localhost 

TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 13-MAY-2019 10:22:51

Copyright (c) 1997, 2016, Oracle.  All rights reserved.

Used parameter files:
E:\app\oracle\product\12.2.0\dbhome_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (0 msec)

另外:

tnsping 192.168.0.13

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-MAY-2019 10:27:07

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
E:\app\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.13)(PORT=1521)))
OK (10 msec)

据说使用的一些解决方案sqlplus /nolog,使用此命令我可以输入，但在此命令中发出任何命令sqlplus /nolog(不是dbuser) 结果”not connected”，因此输入是没有用的nolog模式。顺便说一下，OracleServiceORCL service is running.

让我们确保您选择了合适的环境。

试试这个:

设置ORACLE_HOME = E:\ 应用程序 \ oracle \ 产品 \ 12.2.0 \ dbhome_1 \
设置路径 = E:\ app \ oracle \ product \ 12.2.0 \ dbhome_1 \ bin;% 路径 %
设置ORACLE_SID = orcl

然后尝试 “sqlplus myuser/mypass”

看看你怎么走。