ORA-12170: TNS:使用sql plus在oracle 10g中发生连接超时

Question

我是甲骨文的新手，我用sql +安装了oracle 10g。我昨天使用了sql，但现在它给了我这个错误，ORA-12170: TNS:连接超时在登录时发生了。我使用SCOTT用户登录。

我使用这些凭据登录：

用户名: Scott

密码: tiger

主机: orcl

我已经在谷歌上搜索过了，并尝试了一些解决方案，但它不起作用：

下面是有关我的配置的一些详细信息：

sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
  (PROGRAM = extproc)
 )
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1521))
)
)

tnsnames.ora

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1521))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
  (SID = PLSExtProc)
  (PRESENTATION = RO)
)
)

Answer 1

试着平192.168.1.9。如果成功的话，试试

tnsping orcl

从命令行。也许有防火墙阻止您的网络访问Oracle DB？