日期:2014-05-17  浏览次数:20871 次

ORA-12154问题
我用SQL登陆数据库时报了ORA-12154的问题,在网上看了一些解决方法,看不懂。希望大侠们给指点一下!
这个是监听:
# listener.ora Network Configuration File: d:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
 # Generated by Oracle configuration tools.
 
 SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = d:\oracle\product\10.1.0\Db_1)
  (PROGRAM = extproc)
  )
  )
 
 LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  )
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = PC-201206131517)(PORT = 1521))
  )
  )
  )
 
 这个是tns:
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
 # Generated by Oracle configuration tools.
 
 ZLSJDBP =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.97)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = ZLSJDBP)
  )
  )
 
 TE =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.224)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = TE)
  )
  )
 
 
 GHMESQ =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.85)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = ghmesq)
  )
  )
 
 GHMESP =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.82)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = ghmesp)
  )
  )
 
 COMM23 =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.94)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = COMM23)
  )
  )
 
 QGREPORT =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.193)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = qgreport)
  )
  )
 
 QGMESP2160 =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.220)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = QGMESP)
  )
  )
 
 TEST =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = test)
  )
  )
 
 ORCL =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = DELL-91011216)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
  )
  )
  <