不知道为什么老是不行,网上这方面的帖子很多找了但都没有用,和我的设置一样但不知道为什么就是不行,高手给看一下,我把的配置文件能帖出来
listener.ora文件里这样设置
(SID_DESC =
(SID_NAME = HsSql)
(ORACLE_HOME = d:\oracle\ora90)
(PROGRAM = HsSql) )
tnsnames.ora文件里这样设置
HSODBC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID_NAME = HsSql))
(HS=OK)
)
inittg4msql.ora文件里这样设置
HS_FDS_CONNECT_INFO=192.168.0.10.puds
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
sqlnet.ora里这样设置
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
当TNSPING HSODBC时出现NTS-03505 未能分解名称,这是为什么呀,是不是跟机子的设置有关呀
listener.ora文件里这样设置
(SID_DESC =
(SID_NAME = HsSql)
(ORACLE_HOME = d:\oracle\ora90)
(PROGRAM = HsSql) )
tnsnames.ora文件里这样设置
HSODBC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID_NAME = HsSql))
(HS=OK)
)
inittg4msql.ora文件里这样设置
HS_FDS_CONNECT_INFO=192.168.0.10.puds
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
sqlnet.ora里这样设置
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
当TNSPING HSODBC时出现NTS-03505 未能分解名称,这是为什么呀,是不是跟机子的设置有关呀
解决方案 »
- 遍历部门表问题
- 数据库表被锁定
- 如何在linux上自动备份oracle数据库,备份后,自动把备份文件拷到磁带机上。
- 现在ORACLE 的DEVELOPER开发工具还用的多吗
- 我建的DBLINK为什么总是报”ORA-12154: TNS: 无法处理服务名“的错呢?代码如下:
- 简单的SQL语句(两个字段合并后显示)
- oracle连接问题求助
- 求救,无法在分布式事务处理中ROLLBACK ORA-06512.
- 请教ORACLE的绝顶高手?一般开发者此贴不必看了!
- 关于Mysql联合查询使用别名问题
- 长沙招聘PB开发实施人员
- 要考试了。急哭了。ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询
HS_FDS_CONNECT_INFO=192.168.0.10;database=puds
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
listener.ora文件里这样设置
(SID_DESC =
(SID_NAME = tg4msql)
(ORACLE_HOME = d:\oracle\ora90)
(PROGRAM = tg4msql) )
tnsnames.ora文件里这样设置
HSODBC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID_NAME = tg4msql))
(HS=OK)
)
真想不起来是那里出错啦
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID_NAME = HsSql))——>(SERVICE_NAME = HsSql)
(HS=OK)
)
本机ORALCE IP 192.168.0.10 端口1521
别台机SQL SERVER IP 192.168.0.3 端口1521
listener.ora文件里这样设置
(SID_DESC =
(SID_NAME = HsSql)
(ORACLE_HOME = d:\oracle\ora90)
(PROGRAM = HsSql) )
tnsnames.ora文件里这样设置
HSODBC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID_NAME = HsSql))
(HS=OK)
)
inittg4msql.ora文件里这样设置
HS_FDS_CONNECT_INFO="Server=192.168.0.3; Database=Raudit"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
sqlnet.ora里这样设置
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
防火墙也关啦,还是不能打开SQL SERVER数据库 我用ODBC建连接就能打开SQL数据库,不知道为什么