我的xp机器上安装了oracle10g数据库建好了,监听也是正常,用oracle自带的sql*plus可以正常访问数据库可是用 pl/sql developer 和 toad8.0 一直访问不了数据库啊老是提示
ORA-12154: TNS: 无法解析制定的连接标识符以下是我 tnsnames.ora 的配置
demo =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zhengxp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = demo)
)
)
listener.ora 配置
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)请哪位高手大侠解答一下
ORA-12154: TNS: 无法解析制定的连接标识符以下是我 tnsnames.ora 的配置
demo =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zhengxp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = demo)
)
)
listener.ora 配置
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)请哪位高手大侠解答一下
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
为什么 上面两个开发工具连部上呢
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
在plsql developer里要选择oracle_home为你配置了tns的那个oracle_home
toad也类似