| 2017.11.23 | oracle |
C:\app\01\product\11.2.0\dbhome_1\BIN>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 23 17:04:47 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> startup nomount ORA-12560: TNS: 协议适配器错误
一番搜索，解决办法如下
SQL> exit
C:\app\01\product\11.2.0\dbhome_1\BIN>set oracle_sid=orcl
C:\app\01\product\11.2.0\dbhome_1\BIN>oradim -startup -sid orcl
如果提示:
DIM-00015: Cannot start already-running ORACLE - shut it down first.
先停掉,再启动:
oradim -shutdown -sid orcl
C:\app\01\product\11.2.0\dbhome_1\BIN>sqlplus /nolog
SQL> connect / as sysdba
已连接.
更新列表：
参考文章：