用PL/SQL能正常连接,就是用WEBSERVICE(.net)不能访问,提示“TNS:监听进程不能解析在连接描述符中给出的SERVICE_NAME”
另外,用SQLPLUS也连接不上提示同样的错误tnsnames.ora文件:
qqq =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = qqq)
)
)listener.ora文件
# listener.ora Network Configuration File: D:\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 = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = qqq)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = qqq)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)sqlnet.ora文件
# sqlnet.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
另外,用SQLPLUS也连接不上提示同样的错误tnsnames.ora文件:
qqq =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = qqq)
)
)listener.ora文件
# listener.ora Network Configuration File: D:\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 = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = qqq)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = qqq)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)sqlnet.ora文件
# sqlnet.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
2 看看,对方的监听程序监听的是这个SERVICE_NAME吗?
3 SERVICE_NAME写对了吗?
登录到服务器上
sqlplus /nolog
conn /as sysdba
startup先这样看看,如果有问题再说了。
先startup看看
也可能是你在创建Schema的时候,有错误出现。仔细检查拉...
datasource=192.168.0.123..............
可这次只能用
datasource=qqq..............
不知道为什么?oracle服务器和WEBSERVICE应用在一个机器上
net mangager启动正常,肯定就可以连接了
WEBSERVICE(.net)我用过,我也发现过类似的问题,
我当时的环境上安装了10g客户端和odac,结构PLSQL Developer好用,
dotnet就是数据库管理工具也可以,但是使用在程序里就是不能连接,
最后把10g客户端卸载掉就没有问题了,你先暂时试试吧。