我配置了一个sqlserver的透明网关,用tnsping都可以,但我登陆时总是出现“tns:监听器无法处理连接描述符中所给出的SID”这个错误,为什么,谢谢了initpubs.ora:
HS_FDS_CONNECT_INFO = "SERVER=WWH207;DATABASE=pubs"
HS_DB_NAME = pubs
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_RECOVERY_ACCOUNT = RECOVER
HS_FDS_RECOVERY_PWD = RECOVERlistener.ora:
SID_LIST_WWH =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = wwh)
(ORACLE_HOME = E:\oracle\ora92)
(SID_NAME = wwh)
)
(SID_DESC =
(SID_NAME = pubs)
(ORALCE_NAME = E:\oracle\ora92)
(PROGRAM = pubs
)
)
WWH =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
tnsnames.ora:
pubs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL =TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = pubs)
)
HS_FDS_CONNECT_INFO = "SERVER=WWH207;DATABASE=pubs"
HS_DB_NAME = pubs
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_RECOVERY_ACCOUNT = RECOVER
HS_FDS_RECOVERY_PWD = RECOVERlistener.ora:
SID_LIST_WWH =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = wwh)
(ORACLE_HOME = E:\oracle\ora92)
(SID_NAME = wwh)
)
(SID_DESC =
(SID_NAME = pubs)
(ORALCE_NAME = E:\oracle\ora92)
(PROGRAM = pubs
)
)
WWH =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
tnsnames.ora:
pubs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL =TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = pubs)
)
解决方案 »
- 存储过程中如何拆分一个字符串,使拆分的字符串可作为字段名使用?
- 数据库中to_dec()函数
- 存储过程中 变量列名,变量表名,把数据存放到变量的问题
- 救命!数据库导入下级用户的时候出错
- 在procedure中使用select into 变量 from table where 参数 变量没有值
- 救救我吧
- 急!orcale中的clob字段内容如何取到??在线等.....
- 菜鸟请大家帮忙看看这个语句怎么写
- CrystalReport的数据导出有什么注意事项么?点击报表的导出按钮,没有反应
- 求大神
- 求救oracle调用出错的问题,急急!!!
- 关于通过DbLink调用函数或存储过程的问题?????????
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL =TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(service_name = pubs)
)
(SID_NAME = pubs)
(ORALCE_NAME = E:\oracle\ora92)
(PROGRAM = tg4msql)
)