test
此处你要修改tnsnames.ora文件,来添加:
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521)) )
(CONNECT_DATA = (SID = SID名) )
(HS=OK)
)
此处你要修改tnsnames.ora文件,来添加:
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521)) )
(CONNECT_DATA = (SID = SID名) )
(HS=OK)
)
tnsping TEST 有回复么?
然后再修改init.ora文件.
显示 未能分解名称
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aopen-d59bbef8a)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=pubs)
(ORACLE_HOME=C:\oracle\ora90) #用你的%ORACLE_HOME%
(PROGRAM=tg4msql)
)
)tnsnames.ora 文件TEST = #TEST是我起的,你可以选用其它
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST= 10.192.37.53)(PORT = 1433) )(CONNECT_DATA =(SID = tg4msql))
)
(HS = OK)
)
C:\oracle\ora90\tg4msql\admin 下 inittg4msql.ora 文件HS_FDS_CONNECT_INFO="SERVER = 10.192.37.45;DATABASE = test"
HS_DB_NAME=test
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER我已经这样配置啦 可还是不行