1ãå©ç¨Net Managerå建æå¡ï¼å ·ä½æ¥éª¤å¦ä¸å¾çæ示ï¼
æå¼Oracleå®è£ 客æ·ç«¯çæ¶åæè£ å¥½çNet Manager
è¾å ¥ç½ç»æå¡åï¼å¯ä»¥é便è¾å ¥
éæ©TCP/IPï¼Internetåè®®ï¼
å¨è¿éï¼ä¸»æºåå¯ä»¥è¾å ¥IPå°åï¼ä¸è¿å¦æIPä¸ç¡®å®ï¼ä¸å¯è½ä¼ç»å¸¸åå¨çè¯ï¼è¾å ¥ä¸»æºçååä¹å¯ä»¥ï¼è¾å ¥å®ä¸»æºåååï¼è¾å ¥oracleç端å£å·ï¼å¦ä¸æ示ï¼
è¾å ¥SIDï¼
ç¨oracleçç¨æ·ååå¯ç è¿è¡æµè¯
å¦ææµè¯æåï¼åå ³éå½åç»é¢ï¼æ³¨æè¦ä¿åå¦ï¼
å®æè¿ä¸ªæ¥éª¤ï¼ä¼å¨tnsnames.oraä¸äº§çè¿æ¥æéè¦çä¿¡æ¯ï¼ä¾å¦æå¡å¨IPãSIDï¼ç«¯å£å·çã
2ãæ¤æ¶ï¼oracleçä¿¡æ¯å·²ç»åºæ¬ä¸OKäºï¼æ¤æ¶éè¦åçå°±æ¯å»ºç«DBlinkäºãå ·ä½æ¥éª¤å¦ä¸æ示ï¼
æå¼SQL Management Studioï¼å¦ä¸æ示æ¥å»ºç«Link Serverï¼
ç¹å»ä¸å¾ä¸çNew Linked Serverï¼åºç°ä»¥ä¸ç»é¢ï¼
æç §ä¸å¾ä¸çä¿¡æ¯è¾å ¥ï¼å ¶ä¸Linked serverå¯ä»¥é便填åï¼Providerååºå®éæå¾ä¸çOLE DBï¼Product Nameå¤å¡«å ¥ä¹åå¨OracleçNet Managerä¸è¾å ¥çååï¼Data Sourceä¹å¡«å ¥Net Managerä¸è¾å ¥çååãå®æååæ¢å°Security页ç¾ï¼å¦ä¸å¾æ示ï¼
注æå¨ä¸å¾ä¸çæä¸é¢éæ©âBe made using this security contextâï¼ç¶åå¨remote loginå¤è¾å ¥oracleçç¨æ·åï¼å¨with passwordä¸è¾å ¥è¯¥ç¨æ·å对åºçpasswordï¼å®æåä¿åå³å¯ã
3ãä¸é¢ç设å®é½å·²ç»å®æ好ä¹åï¼ä¸é¢å°±æ¯éªè¯æ¯å¦æåäºãéªè¯çæ¶åï¼åªè¦ç´æ¥åä¸ä¸ªsqlæ¥è¯¢oracleä¸çèµæå³å¯ï¼å¦ä¸æ示ï¼
注æå¨ä¸å¾ä¸ï¼fromçåé¢ï¼tableçååè¦å¨åé¢å ä¸linked serverçååï¼ç¶ååé¢æ两个å°ç¹ï¼åç¶åææ¯oracleä¸ç¨æ·çååï¼æåå°±æ¯è¡¨çååäºãå ¶ä¸ç¹å«éè¦æ³¨æçæ¶åï¼ç¨æ·çååå表çååé½æ¯è¦å ¨é¨å¤§åçã
å ³äºç¬¬äºæ¥ä¸ï¼å¨SQLå¯è§åå·¥å ·ä¸çæä½ä¹å¯ä»¥éè¿ä»¥ä¸SQLæ¥è¿è¡ï¼
EXEC master.dbo.sp_addlinkedserver @server = N'link_peter_oracle',
@srvproduct = N'peter_oracle', @provider = N'MSDAORA', @datasrc = N'peter_oracle',
@provstr = N'User ID=scott;Password=tiger'
--å
¶ä¸@srvproductã@datasrcåå®ä¾åï¼@provstr为oracleçç¨æ·ååå¯ç