用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)
解决方案 »
- 设计数据库
- orcale 安装
- plsql连接远程oracle,查询完就卡死,如何解决?
- 现有一个字段数据为1到N不等,是主键数据,还有个空的字符字段 我想修改空字符字段里的数据要求格式如下V0000001后面的那个1就是主键修改数据必须保持在8位
- 关于UPDATE
- 数据库报错,如何清除监听日志???
- [求助]数据库导入时遇到的问题,急
- 怎样用JDBC返回查询中第十万条到第十万两千条的记录?
- 请问如果查看ORACLE创建表空间的语句,急,谢谢
- sos:oracle 8 ora-01562 等错误,请指教.
- 如何进行数据库的版本控制,有哪些工具来实现??谢谢
- 求助,如何用select实现同列不同行的字符串合并?
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客户端卸载掉就没有问题了,你先暂时试试吧。