本人用vs2005连接oracle 10g 但老是有异常,捕获到异常为:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
服务里面的监听服务已经启动我的计算机名为chjf
下面我贴出
listener.ora# 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 = hfyd)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = chjf)(PORT = 1521))
)还有tnsnames.ora文件
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.HFYD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chjf)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hfyd)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)还有一个sqlnet.ora# sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
已经搞了一天了,没辙了。请高手指点。
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
服务里面的监听服务已经启动我的计算机名为chjf
下面我贴出
listener.ora# 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 = hfyd)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = chjf)(PORT = 1521))
)还有tnsnames.ora文件
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.HFYD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chjf)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hfyd)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)还有一个sqlnet.ora# sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
已经搞了一天了,没辙了。请高手指点。
解决方案 »
- tnsping 的延时问题
- Oracle 中JOB可以修改,但删除它就提示正在运行,请问怎样删除掉,
- sqlplus能登陆,但是pl/sql developer却不能!
- 一条简单的update或者delete语句要执行100多秒
- 一个CDC的问题
- 一个比较复杂的时间查询
- 在使用sql*loader时,中文乱码导致的一个错误,请教大家是否遇到过同样的问题
- sql 问题,在线等候!!急呀!!
- 送分,急求Oracle数据库设计书
- 各位老大,操作系统是xp,安装ora8.1总是报错!
- 出现ORA-12545:连接因对象主机或对象不存在而失败这样的问题,请专家指点
- 我更换了一台新的服务器,该机上现只有操作系统,如何把旧服务器上的oracle 10g迁移到新的服务器上,请高人赐教,谢谢!
先不用连接串登录数据库,如sqlplus user/pwd,不用sqlplus user/pwd@HFYD
然后alter system register;
用户名:system
密码:111
错误信息为:
tns:no listener;但用plsql 能登录。
listener.ora
----------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = chjf)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chjf)(PORT = 1521)) 红线部分改为IP地址试一下。
)
(CONNECT_DATA =
(SERVICE_NAME = hfyd)
)
)
谢谢楼上的,我去试试。