oracle 11g init.ora 位置,oracle 11g gateway

在tdg4msql\admin新建一个init+[sid].ora文件，命名为initetest.ora,实例名为test(数据库实例名)。编辑文件内容如下：

HS_FDS_CONNECT_INFO=10.6.41.39//master

HS_FDS_TRACE_LEVEL=OFF

HS_FDS_RECOVERY_ACCOUNT=RECOVER

HS_FDS_RECOVERY_PWD=RECOVER

其中172.19.1.36为sqlserver所在的host，master为sqlserver databasename。

HS_FDS_CONNECT_INFO=10.6.41.39//master需要默认端口是1433

HS_FDS_CONNECT_INFO=kevingypeng-PC1:1433//master

HS_FDS_CONNECT_INFO=10.6.41.39:1433//master

HS_FDS_CONNECT_INFO=KEVINGYPENG-PC1:1433//master

HS_FDS_CONNECT_INFO=[KEVINGYPENG-PC1]:1433//master

HS_FDS_CONNECT_INFO=[10.6.41.39]:1433//master

LISTENER=

(DESCRIPTION_LIST=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)(HOST=http://www.doczj.com/doc/78c6ea6e7e21af45b307a88d.html)(PORT= 1522))

(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522))

)

)

安装完gateway后，会自动建立一个11g的listener。編輯內容如下(文件位置在安装GATEWARY目录下的netwrok/admin下例如F:\app\kevingypeng\NETWORK\ADMIN)SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(SID_NAME=PLSExtProc)

(ORACLE_HOME=F:\app\kevingypeng)

(PROGRAM=extproc)

)

(SID_DESC=

(SID_NAME=test)---对应透明网关安装目录tg4msql\admin下的inittest.ora文件名。

(ORACLE_HOME=F:\app\kevingypeng)

(PROGRAM=dg4msql)

)