{"id":1567,"date":"2010-11-24T01:56:39","date_gmt":"2010-11-24T05:56:39","guid":{"rendered":"http:\/\/www.killtest.hk\/index.php\/oracle\/%e6%9c%89%e9%97%9coracle%e9%80%8f%e6%98%8e%e7%b6%b2%e9%97%9c%e7%9a%84%e8%8b%a5%e5%b9%b9%e4%bd%bf%e7%94%a8%e6%96%b9%e6%b3%95%e4%bb%8b%e7%b4%b9\/"},"modified":"2010-11-24T01:58:15","modified_gmt":"2010-11-24T05:58:15","slug":"oracle-362","status":"publish","type":"post","link":"https:\/\/www.killtest.hk\/index.php\/oracle\/oracle-362\/","title":{"rendered":"\u6709\u95dcOracle\u900f\u660e\u7db2\u95dc\u7684\u82e5\u5e79\u4f7f\u7528\u65b9\u6cd5\u4ecb\u7d39"},"content":{"rendered":"<p>Oracle \u6578\u64da\u5eab\u7684\u900f\u660e\u7db2\u95dc\uff08 transparent gateway \uff09\u662f\u9019\u6a23\u7684\u58f9\u500b\u63a5\u53e3\uff1a\u901a\u904e\u5b83\uff0c\u6211\u5011\u53ef\u4ee5 sqlplus \u64cd\u7e31\u5176\u4ed6\u6578\u64da\u5eab\uff0c\u5982 ms sqlserver \u3001 sybase \u3001 infomix \u7b49\uff0c\u5be6\u73fe\u6578\u64da\u5eab\u7684\u7570\u69cb\u670d\u52d9\u3002\u6211\u58f9\u76f4\u5728\u627e 8i \u7684\u900f\u660e\u7db2\u95dc\uff0c\u4f46\u662f\u6c92\u6709\uff1b 9i \u5c31\u6709\u4e86\uff0c 9 i \u9023\u63a5 sqlserver \u7684\u900f\u660e\u7db2\u95dc\u5728 9i for nt\/2000 \u7684\u5b89\u88dd\u76e4\u4e0a\u3002<\/p>\n<p>\u3000\u3000\u672c\u6587\u4ee5 oracle \u9023\u63a5 sqlserver \u70ba\u4f8b\uff0c\u6558\u8ff0\u58f9\u4e0b\u914d\u7f6e\u7684\u4e3b\u8981\u6b65\u9a5f\u3002<\/p>\n<p>\u3000\u3000\u7db2\u7d61\u7d50\u69cb<\/p>\n<p>\u3000\u3000\u670d\u52d9\u5668\u58f9\uff1a sqlserver \uff0c ip \u70ba 147.25.8.1 \uff0c port \u70ba 1433 \uff1b<\/p>\n<p>\u3000\u3000\u670d\u52d9\u5668\u4e8c\uff1a oracle 9i server \u548c\u900f\u660e\u7db2\u95dc\uff0c ip \u70ba 147.25.8.11 \uff0c port \u70ba 1521 \uff1b<\/p>\n<p>\u3000\u3000\u670d\u52d9\u5668\u4e09\uff1a oracle server \uff0c ip \u70ba 147.25.8.111 \uff0c port \u70ba 1521 \uff1b<\/p>\n<p>\u3000\u3000\u5ba2\u6236\u6a5f\uff1a sqlnet + sqlplus \uff0c\u6216\u5176\u4ed6\u5ba2\u6236\u7aef\u8edf\u4ef6\u3002<\/p>\n<p>\u3000\u3000\u5b89\u88dd \/ \u914d\u7f6e oracle 9i server \u548c\u900f\u660e\u7db2\u95dc<\/p>\n<p>\u3000\u3000\u5b89\u88dd\uff1a \u5728\u670d\u52d9\u5668\u4e8c\u4e0a\u5b89\u88dd 9i server for nt\/2000 \uff0c\u5fc5\u9808\u9078\u64c7\u900f\u660e\u7db2\u95dc\uff08 transparent gateway for ms sqlsvr \uff09\u3002<\/p>\n<p>\u3000\u3000\u5728\u670d\u52d9\u5668\u4e8c\u4e0a\u5b89\u88dd sqlsvr \u7684\u5ba2\u6236\u7aef\u7a0b\u5e8f\u3002<\/p>\n<p>\u3000\u3000\u914d\u7f6e\uff1a \u5728\u670d\u52d9\u5668\u4e8c\u4e0a\u6b63\u5e38\u914d\u7f6e listener \uff0c port \u53e3\u70ba 1521 \uff1b<\/p>\n<p>\u3000\u3000\u5728\u670d\u52d9\u5668\u4e8c\u4e0a\u914d\u7f6e listener.ora \uff0c\u5728 SID_LIST \u4e2d\u52a0\u5165\uff1a<\/p>\n<p>\u3000\u3000\uff08 SID_NAME = SID_NAME \uff09 &#8212;&#8212;&#8212; \u81ea\u5df1\u4fee\u6539<\/p>\n<p>\u3000\u3000\uff08 ORACLE_HOME = \u300a ORACLE_HOME \u300b\uff09<\/p>\n<p>\u3000\u3000\uff08 PROGRAM = tg4msql \uff09 &#8212;&#8212;&#8212;- \u9019\u662f\u900f\u660e\u7db2\u95dc\u7684\u76ee\u9304<\/p>\n<p>\u3000\u3000\u5728\u670d\u52d9\u5668\u4e8c\u4e0a\u914d\u7f6e\u900f\u660e\u7db2\u95dc\u7684\u914d\u7f6e\u6587\u4ef6\uff08\u300a ORACLE_HOME \u300b \\tg4msql\\admin\\initSID_NAME.ora \uff09\uff0c\u660e\u78ba\uff1a<\/p>\n<p>\u3000\u3000HS_FDS_CONNECT_INFO = \u201cSERVER = 147.25.8.1;DATABASE = pubs\u201d<\/p>\n<p>\u3000\u3000\u5728\u670d\u52d9\u5668\u4e8c\u4e0a\u914d\u7f6e sqlsvr \u7684\u5ba2\u6236\u9023\u63a5\uff1a<\/p>\n<p>\u3000\u3000SERVER NAME = SERVER NAME &#8212;&#8212;&#8211; \u81ea\u5df1\u4fee\u6539<\/p>\n<p>\u3000\u3000SERVER = 147.25.8.1<\/p>\n<p>\u3000\u3000PORT = 1433<\/p>\n<p>\u3000\u3000PROTOCOL = TCP\/IP SOCKET<\/p>\n<p>\u3000\u3000\u5728\u670d\u52d9\u5668\u4e09\u4e0a\u914d\u7f6e tnsnames.ora \uff0c\u52a0\u5165\u58f9\u500b tns \uff1a<\/p>\n<p>\u3000\u3000MSSQL =<\/p>\n<p>\u3000\u3000(DESCRIPTION =<\/p>\n<p>\u3000\u3000(ADDRESS_LIST =<\/p>\n<p>\u3000\u3000(ADDRESS =<\/p>\n<p>\u3000\u3000(PROTOCOL = TCP)<\/p>\n<p>\u3000\u3000(HOST = 147.25.8.11)<\/p>\n<p>\u3000\u3000(PORT = 1521)))<\/p>\n<p>\u3000\u3000(CONNECT_DATA =<\/p>\n<p>\u3000\u3000(SID = SID_NAME)) &#8212;&#8212;&#8211;SID \u81ea\u5df1\u4fee\u6539\uff08\u8207\u4e0a\u6587\u58f9\u81f4\uff09<\/p>\n<p>\u3000\u3000(HS = OK)<\/p>\n<p>\u3000\u3000)<\/p>\n<p>\u3000\u3000\u6e2c\u8a66<\/p>\n<p>\u3000\u3000\u670d\u52d9\u5668\u58f9\uff1a \u555f\u52d5 sqlserver \uff0c\u78ba\u8a8d\u7528\u6236 sa \u53ca\u5176\u5bc6\u78bc\uff08\u6216\u53e6\u5916\u5efa\u7528\u6236\u3001\u5efa\u8868\uff09\u3002<\/p>\n<p>\u3000\u3000\u670d\u52d9\u5668\u4e8c\uff1a \u555f\u52d5 listener \u3002 oracle \u6578\u64da\u5eab\u4e0d\u9700\u8981\u555f\u52d5\u3002<\/p>\n<p>\u3000\u3000\u670d\u52d9\u5668\u4e09\uff1a sqlplus scott\/tiger<\/p>\n<p>\u3000\u3000create database link mssql connect to sa identified by password using \u2018mssql&#8217;;<\/p>\n<p>\u3000\u3000select * from <a href=\"mailto:sales@mssql\">sales@mssql<\/a>;<\/p>\n<p>\u3000\u3000\u5982\u679c\u7121\u8aa4\uff0c\u914d\u7f6e\u900f\u660e\u7db2\u95dc\u6210\u529f\u3002<\/p>\n<p>\u3000\u3000\u5176\u4ed6<\/p>\n<p>\u3000\u3000\u4f7f\u7528\u900f\u660e\u7db2\u95dc\u53ea\u53ef\u4ee5\u7528\u6a19\u6e96\u7684 DML \uff1b<\/p>\n<p>\u3000\u3000\u670d\u52d9\u5668\u58f9\u4e8c\u4e09\u9084\u53ef\u4ee5\u662f\u58f9\u500b\u670d\u52d9\u5668\uff0c\u4e5f\u53ef\u4ee5\u4efb\u610f\u7d44\u5408\u6210\u5169\u500b\u670d\u52d9\u5668\uff1b\u4f46\u662f\u670d\u52d9\u5668\u4e8c\u6240\u5728\u7684\u670d\u52d9\u5668\u5fc5\u9808\u662f windows nt\/2000 server \u5e73\u81fa\uff1b<\/p>\n<p>\u3000\u3000\u900f\u660e\u7db2\u95dc\u53ef\u4ee5\u540c\u6642\u9023\u63a5\u591a\u500b sqlsvr \uff0c\u65b9\u6cd5\u662f\u52a0\u5165\u591a\u500b SID_LIST \u548c\u76f8\u61c9\u7684 initSID_NAME.ora \u914d\u7f6e\u6587\u4ef6\uff1b<\/p>\n<p>\u3000\u3000\u53ef\u80fd\u6703\u9047\u5230\u4e2d\u6587\u5b57\u7b26\u986f\u793a\u6210\u4e82\u78bc\u7684\u60c5\u6cc1\uff0c\u9019\u53ef\u80fd\u662f\u7531\u65bc sqlsvr \u7684\u670d\u52d9\u5668\u548c\u5ba2\u6236\u7aef\u7684\u7a0b\u5e8f\u4e0d\u662f\u58f9\u500b\u7248\u672c\u5f15\u8d77\u7684\u3002\u6211\u6b63\u5728\u6e2c\u8a66\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle \u6578\u64da\u5eab\u7684\u900f\u660e\u7db2\u95dc\uff08 transparent gateway \uff09\u662f\u9019\u6a23\u7684\u58f9\u500b\u63a5\u53e3\uff1a\u901a\u904e\u5b83\uff0c\u6211\u5011\u53ef\u4ee5 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[624,622,623],"class_list":["post-1567","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-624","tag-oracle","tag-623"],"_links":{"self":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1567","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/comments?post=1567"}],"version-history":[{"count":0,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1567\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/media?parent=1567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/categories?post=1567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/tags?post=1567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}