#

HS_FDS_CONNECT_INFO=migration_serv.tax

HS_FDS_TRACE_LEVEL=OFF

HS_FDS_RECOVERY_ACCOUNT=RECOVER

HS_FDS_RECOVERY_PWD=RECOVER

#

# Environment variables required for Sybase

#

set SYBASE=d:\sybase

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

上例中

server_name是migration_serv

database_name是tax

5.

配置oracle網路服務的listener,配置文件是：listener.ora

默認路徑：ORACLE_HOME\network\admin

加入如下

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(SID_NAME= gateway_sid)

(ORACLE_HOME= oracle_home_directory)

(PROGRAM=tg4sybs)

)

)

gateway_sid就是3選擇的sid字串

oracle_home_directory是ORACLE_HOME

tg4sybs若是SYBASE是特定的。如果是其他資料庫，會不同。

例子如下：

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

(SID_DESC=

(SID_NAME=tg4sybs)

(ORACLE_HOME = D:\oracle\ora92)

(PROGRAM=tg4sybs)

)

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

6.

停止監聽

lsnrctl stop

重新啓動監聽程式

lsnrctl start

7.

配置oracle server的tnsnames.ora使其能夠訪問sybase

connect_descriptor=

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST= host_name)

(PORT= port_number)

)

(CONNECT_DATA=

(SID= gateway_sid))

(HS=OK))

connect_descriptor是連接串，任取，一般爲sybs

host_name：oracle server的name

port_number：oracle監聽埠

gateway_sid就是3選擇的sid字串

例子如下：

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

sybs=

(DESCRIPTION=

(ADDRESS_LIST =

(ADDRESS=(PROTOCOL=TCP)(HOST= dw-server1)(PORT= 1521))

)

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ...  下一页 >>