linux下连接oracle数据库出错：ORA-12514 cannot...-Linux -idc中文资讯站-客观公证的IDC产业权威媒体,关注域名、虚拟主机、服务器、网络、开源技术资讯，整合运营商资源，客观评价各地机房带宽线路质量、IDC企业名录等信息

linux下连接oracle数据库出错：ORA-12514 cannot...

来源： ChinaUnix博客　作者： ChinaUnix博客　发布时间:2008-01-01 15:36:00

linux下连接oracle数据库出错：ORA-12514 cannot...

今天连接数据库时出了错，监听启动正常，/ 下启动数据库也正常，用sys连接时提示出错，

数据库名是oradb,sid是oradb:

$lsnrctl start

提示：成功！

$sqlplus "/ as sysdba"

sql>startup

提示：成功！

sql>conn
[email=sys/oracle@oradb]sys/oracle@oradb[/email]
as sysdba;

报错：

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect

descriptor！

我是这样解决的：以root身份登录，查看/oracle/product/9.2.0.4/network/admin目录

下的

listener.ora和tnsnames.ora两个配置文档的配置是否正确。

$vi tnsnames.ora

oradb =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))
)
(CONNECT_DATA =
      (SERVICE_NAME = orcl.oradb.localdomain)
)
)
修改SERVICE_NAME = orcl.oradb.localdomain为SERVICE_NAME = oradb

保存退出

$vi listener.ora

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
      (ADDRESS_LIST =
         (ADDRESS =(PROTOCOL=TCP)(HOST=192.168.0.101)(PORT= 1521))
      )
      (ADDRESS_LIST =
         (ADDRESS =(PROTOCOL=IPC)(KEY=EXTPROC))
      )
)
  )
SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /opt/u01/app/oracle/product/9.2.0.4)
   (PROGRAM = extproc)
)
  )
在SID_LIST_LISTENER 中增加下列内容：
(SID_DESC =
   (GLOBAL_DBNAME = oradb)
   (ORACLE_HOME = /opt/u01/app/oracle/product/9.2.0.4)
   (SID_NAME = oradb)
)
完整的listener.ora的内容是：
LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
   )
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))
   )
)
  )
SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /opt/u01/app/oracle/product/9.2.0.4)
   (PROGRAM = extproc)
)
(SID_DESC =
   (GLOBAL_DBNAME = oradb)
   (ORACLE_HOME = /opt/u01/app/oracle/product/9.2.0.4)
   (SID_NAME = oradb)
)
  )
再以oracle身份登录，启动监听和数据库，连接数据库都正常了。

本文来自ChinaUnix博客，假如查看原文请点：http://blog.chinaunix.net/u2/60453/showart_486934.html

喜欢本文，那就收藏到：