sqlplus / as sysdba在windows中不工作，错误: ORA-12560: TNS:协议适配器错误

Question

我试图在Oracle11g中使用sqlplus / as sysdba登录，但它要求输入密码。所以我尝试使用sqlplus "/ as sysdba"登录，因为我使用的是Windows。但它显示了以下错误：

sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 22 12:51:22 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:

ORA-12560: TNS:protocol adapter error

我在谷歌上搜索了同样的问题，但没有什么能帮到我。

Answer 1

好像数据库还没打开。这可能是由于重新启动机器和

1. Go to the windows machine that hosts the Oracle database server
2. Go to Start -> Run -> Services.msc in windows. Locate OracleService (here OracleServiceORCL) and click on "Start" to start the oracle database service (if not already running)

3. Once it is up and running, from the command prompt run the following:

   tnsping < tnsalias >

   (tnsalias entry you can find it in tnsnames.ora file)