- 论坛徽章:
- 0
|
EM登录时提示错误:
Database Error
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyServer)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=firstDB)))
lsnrctl测试
C:\>lsnrctl services firstdb
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-6月 -2008 23:09:56
Copyright (c) 1991, 2005, Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyServer)(PORT=1523)))
监听程序不支持服务
命令执行成功
配置如下:
windows 32bit oracle10。2。0。1。0
istener.ora
FIRSTDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MyServer)(PORT = 1523))
)
)
tnsnames.ora
FIRSTDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MyServer)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = firstdb)
)
)
sqlplus连接都没有问题。怎么解析这个服务名呢?
菜鸟请大侠指教!
[ 本帖最后由 camham 于 2008-6-15 23:52 编辑 ] |
|