ORA-12514: TNS:listener does not currently know of service requested in connect

SambaGao 2010-03-04 02:00:42
listener.oar

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle)
(PROGRAM = extproc)
)
(SID_DESC =

(GLOBAL_DBNAME =lsnode2)

(ORACLE_HOME = /u01/oracle)

(SID_NAME = dgdemo)


)

)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)

)


tnsnames.ora

LSNODE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.189)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dgdemo)
)
)

LSNODE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.188)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dgdemo)
)
)

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




[oracle@node2 admin]$ sqlplus system/oracle@lsnode1

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 3 11:30:32 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name:
...全文
395 6 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
laojsp 2012-03-22
  • 打赏
  • 举报
回复
listener does not currently know kf service requested in connect descrintor

我也出现了这个问题
angellaopo112 2011-06-13
  • 打赏
  • 举报
回复
来学习学习
SambaGao 2010-03-05
  • 打赏
  • 举报
回复
起了。。。.............
iqlife 2010-03-04
  • 打赏
  • 举报
回复
你的服务没有启动吧,数据库实例启动了?
SambaGao 2010-03-04
  • 打赏
  • 举报
回复
node1

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
suiziguo 2010-03-04
  • 打赏
  • 举报
回复
DG环境?


sqlplus system/oracle@lsnode1


LSNODE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.188)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dgdemo)
)
)


贴出node1上的listen.ora

17,382

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧