拳皇2013手机版官方:Linux下Oracle數據庫建立Informix的DBlink的步驟(三)
七、測試網絡連通否
[oracle@test admin]$ tnsping hsminf
TNS
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/oracle/product/
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
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/oracle/product/
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 “abc
using ‘hsminf’
注意：帳號密碼即為INFORMIX中所開的ODBC帳號,
服務名稱為tnsnames.ora文件中自行定的services名稱.
測試LINK的可用性:
select * from zx_file@test
九、以上，在linux系統下配置INFORMIX ODBC的驅動，
通過ORACLE數據庫建立相應LINK服務。
為了安全起見，我們可在ORACLE中新開一使用帳號，
立INFORMIX中個別TABLE的VIEW，然後再把這些VIE
賦權給特定用戶使用.
相關SQL如下:
createorreplaceviewimg_fileas
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"fromimg_file@test;
grant select on img_file to sfc;
select * from scott.img_file;