透明网关在本机 oracle 在192.0.0.7 数据库名upms 账号apms 密码apms
sql server2005在192.0.0.13 数据库名apms 账号apms 密码apms123
在命令行下tnsping sp 出现TNS-03505错误 未能分解名称
在tg4msql/admin 目录下 我已新建initsongkai.ora
HS_FDS_CONNECT_INFO="SERVER=192.0.0.13;DATABASE=apms"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER在network/admin目录下 listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = song_kai)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = PLSExtProc)
(ORACLE_HOME = F:\oracle\ora92)
(SID_NAME = extproc)
)
(SID_DESC =
(SID_NAME = songkai)
(ORACLE_HOME = F:\oracle\ora92)
(PROGRAM = tg4msql)
)
)
在tnsnames.ora里
EXTPROC_CONNECTION_DATA.GW.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)UPMS.GW.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.7)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =upms)
)
)SONGKAI_127.0.0.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = songkai)
(SERVER = DEDICATED)
)
)
sp =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.7)(PORT = 1521))
)
(CONNECT_DATA =
(SID = songkai)
)
(HS=ok)
)在sqlnet.ora文件里
NAMES.DEFAULT_DOMAIN=GW.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)请问我哪里写错了 在线急等
sql server2005在192.0.0.13 数据库名apms 账号apms 密码apms123
在命令行下tnsping sp 出现TNS-03505错误 未能分解名称
在tg4msql/admin 目录下 我已新建initsongkai.ora
HS_FDS_CONNECT_INFO="SERVER=192.0.0.13;DATABASE=apms"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER在network/admin目录下 listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = song_kai)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = PLSExtProc)
(ORACLE_HOME = F:\oracle\ora92)
(SID_NAME = extproc)
)
(SID_DESC =
(SID_NAME = songkai)
(ORACLE_HOME = F:\oracle\ora92)
(PROGRAM = tg4msql)
)
)
在tnsnames.ora里
EXTPROC_CONNECTION_DATA.GW.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)UPMS.GW.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.7)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =upms)
)
)SONGKAI_127.0.0.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = songkai)
(SERVER = DEDICATED)
)
)
sp =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.7)(PORT = 1521))
)
(CONNECT_DATA =
(SID = songkai)
)
(HS=ok)
)在sqlnet.ora文件里
NAMES.DEFAULT_DOMAIN=GW.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)请问我哪里写错了 在线急等
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货