环境是这样的,有一台服务器,安装着Oracle服务器端软件,并且有数据库名为cbsdb;还有一台客户端机器,安装了Oracle客户端程序,但是在使用ODBC或者OLEDB去连接服务器端的数据库的时候,弹出错误提示:“TNS:没有这样的适配器”服务器上的listener.ora文件如下:# LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sinomapss)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
)
客户端的tnsnames.ora内容如下:# C:\ORACLE\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\oracle\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
CBSDB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = 172.16.1.40))
)
(CONNECT_DATA =
(SERVICE_NAME =cbsdb)
)
)我是使用微软的SSIS,用来从Oracle里面把数据抽出到SQLServer数据库中。我没怎么用过Oracle,所以这个TNS的设置不明白,请教各位大侠看看这个TNS的设置是否有问题?
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sinomapss)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
)
客户端的tnsnames.ora内容如下:# C:\ORACLE\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\oracle\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
CBSDB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = 172.16.1.40))
)
(CONNECT_DATA =
(SERVICE_NAME =cbsdb)
)
)我是使用微软的SSIS,用来从Oracle里面把数据抽出到SQLServer数据库中。我没怎么用过Oracle,所以这个TNS的设置不明白,请教各位大侠看看这个TNS的设置是否有问题?
解决方案 »
- ASP.NET调用Oracle存储过程问题
- 看得懂执行计划的进来
- Enterprise management packs 大家用过吗
- 根据sql语句的字段名如何获取所属的表名????
- 两台服务器的ORACLE版本和初始化参数都配置的基本一样的, 但是同一条SQL的执行计划和效率相差很大(一个是HASH JOIN,一个是NESTED LOOP),不知为何?请看一下
- 简单数据库查询问题
- 请教一个问题
- 求: 一sql 语句, 可将oracle数据库中的表字段导入excel文件?
- 怎样让游标遍历定制的数据集合???用数组?集合?我不会写,请赐教
- 在ORACLE存储过程怎样返回动态执行语句产生的记录集
- 查询一个表的所有约束的名称、类型、状态、与约束相关联的列的名称、表所在的表空间。
- update order by 如何实现两个关联呢?
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
)
)test1 =
(description =
(address_list =
(address = (protocol = tcp)(host = IP)(port = 1521))
)
(connect_data =
(service_name = crmtest)
)
)
HOST = sinomapss 主机名称
改成
HOST = 172.16.1.40
试试。