Oracle TNS问题？ [英] Oracle TNS problems?

问题描述

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

  LSNRCTL> start 
启动tnslsnr：请稍候... 
 
服务OracleOraDb10g_home1TNSListener已在运行。 
 TNS-12560：TNS：协议适配器错误
 TNS-00530：协议适配器错误
 
 
 
 LSNRCTL>状态
连接到（DESCRIPTION =（ADDRESS =（PROTOCOL = TCP 
 TNS-12541：TNS：无监听器
 TNS-12560：TNS：协议适配器错误
 TNS-00511：没有侦听器
 32位Windows错误：61：未知错误
  

.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网络配置文件：D：\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora 
＃由Oracle配置工具生成。
 
 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） = 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）
）
）
  
请给我这个晚上的截止日期。请帮助。
解决方案
这可能是一个配置问题，这意味着我们很难远程解决。您需要检查的两件事是
 
 
您的 LISTENER.ORA 文件匹配 TNSNAMES.ORA 文件
 
 
  hosts 文件中的信息
 
 
 
这是您尝试连接的本地或远程数据库吗？
 
 
 
 编辑 
 
 
 
 hosts文件（在Windows环境中）位于
  C：\WINDOWS\ systemystem \drivers \etc 
  
显然，这取决于您的环境是如何设置的（不同的驱动器号或任何）。
 
 
 
  > 
 
 
 
您需要侦听器文件中的 GLOBAL_DBNAME 才能匹配 SERVICE_NAME 在tnsnsames文件，即ORCL 
 
I have an error ? My pl/Sql Developer says my oracle database cannot find the service descriptor But when I Do a check the listener I get this error.
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
the content of my listener.ora is 
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))
  )
and 
the tnsnames.ora content is this
# 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)
    )
  )
Please I have a deadline for these evening. Please help.
解决方案
This is probably a configuration issue, which means it is difficult for us to solve remotely.  The two things you need to check are

The entries in your LISTENER.ORA file match your TNSNAMES.ORA file  
The information in your hosts file is correct.
Is this a local or a remote database you're attempting to connect to?

edit

The hosts file (in a windows environment) is in somewhere like 
C:\WINDOWS\system32\drivers\etc
Obviously it depends on how your environment is set up (different drive letter or whatever).

edit

You need the GLOBAL_DBNAME in the listener file to match the SERVICE_NAME in the tnsnsames file i.e. ORCL

                        
这篇关于Oracle TNS问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！