17,378
社区成员
发帖
与我相关
我的任务
分享SQL*Plus登陆不进去:ora-12514
在登录SQL*Plus时，在“主机字符串”中录入服务器计算机名还是IP地址，都有出现错误：
ora-12514：TNS： 监听进程不能解析在连接描述符中给出的 Servive_Name
thx
ora-12514：TNS： 监听进程不能解析在连接描述符中给出的 Servive_Name
thx
...全文
请发表友善的回复…
发表回复
zwj0712 2004-09-12
- 打赏
- 举报
就是的啊,就是你的连接名吧!!!
liuyi8903 2004-09-12
- 打赏
- 举报
楼上的兄弟：)总在啊!
zhpsam109 2004-09-12
- 打赏
- 举报
同意 drabit(square) !
chanet 2004-09-12
- 打赏
- 举报
(SERVICE_NAME = DBName.Robert.com)
-----------------
这里填上实例名
-----------------
这里填上实例名
fightintokyo 2004-09-12
- 打赏
- 举报
DBNAME 或 DBName.Robert.com
ROBOT 2004-09-12
- 打赏
- 举报
我的tnsnames.ora是这样的，主机字符串应该是什么？
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 888-88)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
DBNAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 888-88)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBName.Robert.com)
)
)
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 888-88)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
DBNAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 888-88)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBName.Robert.com)
)
)
drabit 2004-09-11
- 打赏
- 举报
<在登录SQL*Plus时，在“主机字符串”中录入服务器计算机名还是IP地址>
录入的既不应该是计算机名也不应该是IP地址，而是TNS服务名(在tnsnames.ora中设置）
zwj0712（阿张）显然缺乏对oracle*net的基本概念的理解。
录入的既不应该是计算机名也不应该是IP地址，而是TNS服务名(在tnsnames.ora中设置）
zwj0712（阿张）显然缺乏对oracle*net的基本概念的理解。
ROBOT 2004-09-11
- 打赏
- 举报
是“OracleOraHome92TNSListener”吗？已经启动了啊。
zwj0712 2004-09-11
- 打赏
- 举报
你的TNS服务没有起啊!!!
