Oracle TNS问题？

Question

我有错误吗？我的pl/Sql开发人员说我的oracle数据库找不到服务描述符，但是当我检查侦听器时，我得到了这个错误。

LSNRCTL> start
Starting tnslsnr: please wait...

Service OracleOraDb10g_home1TNSListener already running.
TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error



LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 61: Unknown error

我的listener.ora的内容是

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = Oracle10g)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (SID_NAME = ORCL)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )

tnsnames.ora的内容是这样的

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

VMOBILE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

VMOBILEMASTER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = ORCL)
    )
  )

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

请告诉我今天晚上的截止日期。请帮帮忙。

Answer 1

这可能是一个配置问题，这意味着我们很难远程解决。您需要检查的两件事是

1. LISTENER.ORA文件中的条目与TNSNAMES.ORA文件匹配
2. hosts文件中的信息是正确的。

这是您尝试连接到的本地数据库还是远程数据库？

编辑

hosts文件(在windows环境中)位于如下位置

C:\WINDOWS\system32\drivers\etc

显然，这取决于您的环境是如何设置的(不同的驱动器号或其他)。

编辑

您需要侦听器文件中的GLOBAL_DBNAME与tnsnsames文件中的SERVICE_NAME匹配

Answer 2

错误可能在listener.ora文件中。尝试将(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))行中的localhost替换为运行监听程序的服务器的名称或ip号。

Answer 3

我会用ipconfig告诉您的IP地址替换localhost。