{"rsdb":{"rid":"157251","subhead":"","postdate":"0","aid":"117967","fid":"57","uid":"1","topic":"1","content":"

Windows 10\u4e0b\u9700\u8981\u7684\u64cd\u4f5c<\/p>

1\u3001\u5fae\u8f6f\u5b98\u7f51\u4e0b\u8f7dinstantclient,\u7136\u540e\u63a5\u5230\u5230\u672c\u5730\u4e00\u4e2a\u6587\u4ef6\u5939\uff0c\u6ce8\u610f\u8def\u5f84\u4e0d\u8981\u53c8\u7a7a\u683c\uff0c\u4e2d\u6587\u548c\u62ec\u53f7\u4e4b\u7c7b\u7684\u5b57\u7b26\u3002<\/p>

2\u3001\u5728instantclient\u89e3\u538b\u5305\u7684\u6839\u76ee\u5f55\u4e0b\u65b0\u5efa\/NETWORK\/ADMIN\u6587\u4ef6\u5939\uff0c\u5e76\u5728ADMIN\u6587\u4ef6\u5939\u4e0b\u65b0\u5efa\u6587\u4ef6tnsnames.ora\uff0c\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>

# TNSNAMES.ORA Network Configuration File:%ORACLE_HOME%\\network\\admin\\tnsnames.ora<\/span>
# Generated by Oracle configuration tools.<\/span>
orcl<\/span> =<\/span>
  (DESCRIPTION =<\/span>
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.128<\/span>)(PORT = 1521<\/span>))<\/span>
    (CONNECT_DATA =<\/span>
      (SERVER = DEDICATED)<\/span>
      (SERVICE_NAME = orcl<\/span>)<\/span>
    )<\/span>
  )<\/span><\/p>

\u7b2c\u4e00\u4e2aorcl\u662foracle\u6570\u636e\u5e93listener.ora\u4e2d\u914d\u7f6e\u7684\u8fde\u63a5\u6807\u8bc6\u3002<\/span><\/p>

\u7b2c\u4e8c\u4e2aorcl\u662foracle\u7684\u5b9e\u4f8b\u540d\u3002\u5728\u7ec8\u7aef\u901a\u8fc7\uff1aecho $ORACLE_SID\u547d\u4ee4\u67e5\u770b<\/span><\/p>

3\u3001\u914d\u7f6e\u73af\u5883\u53d8\u91cf\uff08\u753b\u7ea2\u7ebf\u76843\u4e2a\uff09<\/p>

\"\"<\/p>

4\u3001\u4e0b\u8f7dPLSQL Developer\u8f6f\u4ef6\uff0c\u6253\u5f00\u5e76\u914d\u7f6e<\/p>

\"\"<\/p>

Ubuntu\u4e0b\u9700\u8981\u7684\u914d\u7f6e<\/strong><\/p>

1\u3001\u5728oracle\u76ee\u5f55\u4e0b\u627e\u5230listener.ora\u6587\u4ef6\u3002\u53ef\u4ee5\u4f7f\u7528\u547d\u4ee4\uff1afind .\/ -name 'listener.ora'\u3002\u8fd9\u91cc\u53ef\u80fd\u627e\u5230\u4e24\u4e2a\u3002\u6ce8\u610f\u8bf7\u4f7f\u7528\/network\/admin\/\u4e0b\u7684\u3002<\/p>

\u6253\u5f00\u5b83\u3002\u9ed8\u8ba4\u5185\u5bb9\u662f\uff1a<\/p>

# listener.ora Network Configuration File: \/home\/fybing\/tools\/oracle11g\/product\/11.2.0\/dbhome_1\/network\/admin\/listener.ora
# Generated by Oracle configuration tools.<\/p>

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )<\/p>

ADR_BASE_LISTENER = \/home\/fybing\/tools\/oracle11g<\/p>

\u5728\u540e\u9762\u52a0\u5165\uff1a<\/p>

SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=orcl<\/span>)
      (ORACLE_HOME=\/home\/fybing\/tools\/oracle11g\/product\/11.2.0\/dbhome_1<\/span>)
      (SID_NAME=orcl<\/span>))
    (SID_DESC=
      (SID_NAME=PLSExtProc)
      (ORACLE_HOME=\/home\/fybing\/tools\/oracle11g\/product\/11.2.0\/dbhome_1<\/span>)
      (PROGRAM=extproc)))<\/p>

\u4fdd\u6301\u6587\u4ef6\u7136\u540e\u91cd\u542f\u670d\u52a1<\/p>

lsnrctl stop<\/p>

lsnrctl start<\/p>

\u8fde\u63a5\uff1a<\/p>

\"\"<\/p>

\u622a\u56fe\u4e2d\u7684orcl\u5bf9\u4e8elistener.ora\u914d\u7f6e\u4e2dSID_NAME=orcl<\/span>\u7684\u5185\u5bb9\u3002<\/p>

\u800cGLOBAL_DBNAME=orcl\u7684orcl\u5bf9\u5e94tnsnames.ora\u7b2c\u4e00\u4e2a\u51fa\u73b0\u7684orcl<\/p>","orderid":"0","title":"Windows 10\u4e0bPLSQL Developer \u8fde\u63a5Ubuntu\u4e0a\u5b89\u88c5\u7684Oracle 11g","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"7545","pages":"1","comments":"0","posttime":"2017-05-27 17:35:57","list":"1495877757","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"Windows<\/A> PLSQL<\/A> Developer<\/A> \u8fde\u63a5<\/A> Ubuntu<\/A> \u5b89\u88c5<\/A> Oracle<\/A> 11g<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"218.17.197.194","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"Windows 10\u4e0bPLSQL Developer \u8fde\u63a5Ubuntu\u4e0a\u5b89\u88c5\u7684Oracle 11g","lastview":"1702479946","digg_num":"3989","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}