作者：北极圈 文章来源：本站整理 点击数： 更新时间：2008-6-25 16:44:21

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_si

d))
(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))
)
(CONNECT_DATA=
(SID= tg4sybs)
)
(HS=OK)
)

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

8.建立database link

如：
CREATE DATABASE LINK sybs CONNECT TO sa
IDENTIFIED BY prient
USING 'SBYS' ；

即可访问sybase 数据库。

需要注意的是，sybase数据库的表名，字段名，如果是小写的，那么在oracle里访问的时候要加上双引号""

如：
SQL〉select "a" from "b"@sybs;

上一页  [1] [2]