Linux下Oracle數據庫建立Informix的DBlink的步驟(三)

七、測試網絡連通否

[oracle@test admin]$ tnsping hsminf

 

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 21-MAR-2008 10:59:34

 

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

 

Used parameter files:

/u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 10.182.4.65)(PORT = 1521)) (CONNECT_DATA = (SERV

ICE_NAME = infuse01)) (HS = OK))

OK (0 msec)

[oracle@test admin]$ tnsping hsninf

 

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 21-MAR-2008 10:59:39

 

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

 

Used parameter files:

/u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 10.182.4.65)(PORT = 1521)) (CONNECT_DATA = (SERV

ICE_NAME = infuse02)) (HS = OK))

OK (0 msec)

隨後進行lsnrctl restart.

八、在ORACLE中創建DBLink

create public database link test

connect to FKPCB identified by “abc123”

using ‘hsminf’

注意：帳號密碼即為INFORMIX中所開的ODBC帳號,

服務名稱為tnsnames.ora文件中自行定的services名稱.

測試LINK的可用性:

select * from zx_file@test

九、以上，在linux系統下配置INFORMIX ODBC的驅動，

通過ORACLE數據庫建立相應LINK服務。

為了安全起見，我們可在ORACLE中新開一使用帳號，

立INFORMIX中個別TABLE的VIEW，然後再把這些VIE

賦權給特定用戶使用.

相關SQL如下:

create or replace view img_file as
select "img01","img02","img03","img04","img05","img06","img07","img08","img09","img10","img11","img12","img13","img14","img15","img16","img17","img18","img19","img20","img21","img22","img23","img24","img25","img26","img27","img28","img30","img31","img32","img33","img34","img35","img36","img37" from img_file@test;

grant select on img_file to sfc;

select * from scott.img_file;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7836221/viewspace-214890/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7836221/viewspace-214890/