plsqldev登陆时出现ora-28547:连接服务器失败 可能是oracle net管理错误怎么解决 如何写SQL获得Oracle 服务器的IP地址
\u5982\u4f55\u914d\u7f6epl/sql \u8fde\u63a5\u8fdc\u7a0boracle\u670d\u52a1\u56681\u3001\u627e\u5230PL/SQL Developer\u7a0b\u5e8f\u7684\u542f\u52a8\u5feb\u6377\u65b9\u5f0f\u3002
2\u3001\u6211\u4eec\u53cc\u51fb\u684c\u9762\u5feb\u6377\u65b9\u5f0f\uff0c\u51fa\u73b0\u754c\u9762\u7684\u5bf9\u8bdd\u6846\u3002
3\u3001\u5b89\u88c5oracle client\u4e4b\u540e\uff0c\u6211\u4eec\u5230oracle client\u7684\u5b89\u88c5\u76ee\u5f55\u4e0b\uff0c\u8fdb\u5165\u5230network/ADMIN\u76ee\u5f55\u4e0b\uff0c\u770b\u5230\u6709\u4e2atnsnames.ora\u6587\u4ef6\u3002
4\u3001\u6253\u5f00\u8fd9\u4e2a\u6587\u4ef6\u8fdb\u884c\u7f16\u8f91\u3002
5\u3001\u7f16\u8f91\u5b8c\u8fd9\u4e2a\u6587\u4ef6\u540e\u4fdd\u5b58\uff0c\u6211\u4eec\u518d\u6b21\u53cc\u51fbPL/SQL Developer\u7a0b\u5e8f\uff0c\u6211\u4eec\u770b\u5230\u6211\u4eec\u8fd9\u4e2a\u65f6\u5019\u53ef\u4ee5\u9009\u62e9database\u3002
6\u3001\u786e\u5b9a\u4e4b\u540e\uff0c\u8fd4\u56de\u4e86\u4e00\u4e2a\u5bf9\u8bdd\u6846\uff0cORA-12541\u3002\u8fd9\u4e2a\u8868\u793aoracle\u670d\u52a1\u5668\u4e0a\u6ca1\u6709\u6253\u5f00\u76d1\u542c\u3002
7\u3001\u6211\u4eec\u8fde\u63a5\u5230\u8fd9\u53f0\u670d\u52a1\u5668\u4e0a\uff0c\u5207\u6362\u5230oracle\u7528\u6237\uff0c\u4f7f\u7528\u4e0b\u9762\u547d\u4ee4\u67e5\u770b\u4e0b\u76d1\u542c\u72b6\u6001\u3002
8\u3001\u6211\u4eec\u5728\u4f7f\u7528\u5982\u4e0b\u56fe\u6240\u793a\u6253\u5f00\u76d1\u542c\u3002
9\u3001\u6253\u5f00\u76d1\u542c\u540e\uff0c\u6211\u4eec\u5728\u8fd4\u56de\u672c\u5730\u673a\u5668\uff0c\u518d\u6b21\u542f\u52a8\u586b\u5199\u4fe1\u606f\u540e\uff0c\u70b9\u51fb\u786e\u5b9a\u8fdb\u884c\u8fde\u63a5\u3002\u5982\u679c\u8fde\u63a5\u6210\u529f\u7684\u8bdd\uff0c\u4f1a\u51fa\u73b0\u5982\u4e0b\u56fe\u6240\u793a\u3002
\u8f6c\uff1a
\u5177\u4f53\u6b65\u9aa4\u5982\u4e0b\uff1a
1. \u5230\u672c\u673aoracle\u5b89\u88c5\u76ee\u5f55\u4e0b\u7684tns\u914d\u7f6e\uff0c$HOME/network/admin/tnsnames.ora\u3002\u627e\u5230\u4f60\u9700\u8981\u8bbf\u95ee\u7684\u5e93\uff1a
PRIMARY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.xx)(PORT = xxx))
) www.2cto.com
(CONNECT_DATA =
(SERVICE_NAME = xxx)
)
)
host\u540d\u79f0\u5c31\u662f\u670d\u52a1\u5668Ip,\u5982\u679c\u662f\u673a\u5668\u540d\u5c31ping\u3002
2. select sys_context('userenv'\uff0c'ip_address') from dual\uff0c\u5982\u679c\u8fde\u63a5\u65f6\u6ca1\u6709\u52a0\u8f7dtns\u662f\u67e5\u4e0d\u5230\u7684\uff1b
3. sqlplus\u8fde\u63a5\u4e0a\u540e\uff0c\u901a\u8fc7\u63a7\u5236\u53f0\u8f93\u5165netstat -a -o\u770b\u6240\u6709\u8fde\u63a5\u4fe1\u606f\uff0c\u627e\u5230\u5bf9\u5e94pid\u7684\u8fde\u63a5\u4fe1\u606f\u3002
plsqldev
工具-》设置-》加载你要连接的oracle安装目录下的oci.dll
仅代表个人观点，不喜勿喷，谢谢。
PL/SQL Developer tools->Preferences-> 指定下 Oracle Home 和 OCI library 试试。
plsqldev 工具-》设置-》加载你要连接的oracle安装目录下的oci.dll
绛旓細瑙ｅ喅鏂规硶1锛歱lsql.exe 鍚岀骇鐩綍寤虹珛涓涓 plsql.bat 鍐呭涓猴細set ORACLE_HOME=H:\instantclient_12_1锛堣鐩綍涓轰綘鐨刼racle瀹㈡埛绔嵆iclient锛塻tart plsqldev.exe 浠ュ悗灏遍氳繃杩欎釜bat鏉 鎵撳紑plsql 瑙ｅ喅鏂规硶2锛氭墦寮plsql鍚庣偣鍙栨秷杩涘叆 鍦ㄥ伐鍏>棣栭夐」 oracle 涓荤洰褰曪紙鑷姩妫娴嬶級璁剧疆鎴 H:\instantclient_12...
绛旓細绗竴涓槸鍥犱负锛 鏈湴鐨 sysdba 鏉冮檺鐧诲綍锛屼細蹇界暐杈撳叆鐨勭敤鎴峰悕鍜屽瘑鐮侊紝鑰屼娇鐢ㄥ綋鍓嶇櫥褰曟搷浣滅郴缁熺殑鎿嶄綔绯荤粺鐢ㄦ埛鐨勬潈闄愩傛潯浠舵槸褰撳墠鎿嶄綔绯荤粺鐢ㄦ埛灞炰簬 DBA 缁勶紙unix锛夋垨 oradba 缁勶紙windows锛夈傜浜屼釜鏄甯哥殑鎯呭喌銆
绛旓細灏嗕笅杞界殑鏂囦欢瑙ｅ帇鍒皁racle鐨勫畨瑁呯洰褰曚腑锛屼緥濡傦細D:\oracle\product鐩綍涓紝姝ょ洰褰曚腑杩樻湁涓涓枃浠跺す11.2.0锛屽皢鏂囦欢澶瑰懡鍚嶄负instantclient锛岋紝骞跺皢璇ョ洰褰曞姞鍏ュ埌绯荤粺鐨勭幆澧冨彉閲弍ath涓2銆佹墦寮plsql锛屽彇娑鐧诲綍锛屽湪绋嬪簭鐨勯閫夐」涓壘鍒癱onnection璁剧疆锛岃缃甇RACLE_HOME鍜孫CI_LIBRARY锛孫RACLE_HOME璁剧疆涓篿nstantclient...
绛旓細搴旇鏄紪鐮佷笉缁熶竴 echo off set path=C:\dev\oracle\instantclient_11_2 set ORACLE_HOME=C:\dev\oracle\instantclient_11_2 set TNS_ADMIN=C:\dev\oracle\instantclient_11_2 set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK start plsqldev.exe 淇敼璺緞淇濆瓨涓簆lsql.bat ...
绛旓細PlSqlDev 鍜宮ysql涓嶅悓锛屽緢澶氱殑鏍囩ず绗﹂兘涓嶈瘑鍒紝姣斿鍙屽紩鍙风瓑锛屽綋鍑虹幇杩欎簺绗﹀彿鏄氨浼氭彁绀烘爣璇嗙鏃犳晥
绛旓細鏇挎崲鍏跺揩鎹锋柟寮忥紝鍚姩PLSQL Developer锛歟cho off set path=C:\instantclient-basic-nt-11.2.0.2.0 set ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0 set TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0 set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK start plsqldev.exe ...
绛旓細涓嬮潰鐨 鈥滄暟鎹簱鈥濅笅鎷夐夋涓嶅氨鏄夋嫨鍝竴涓簱鐨勪箞銆備綘鏈濂界偣鍑诲彇娑堬紝鐒跺悗鍦plsql dev閲岄潰tools=銆媝references =銆媍onnection 閲岄潰閰嶇疆涓涓媜racle璺緞銆傞厤缃畬閲嶅惎涓涓媝lsql dev灏卞ソ浜嗐傝繕鏄病鏈夌殑璇濓紝鐪嬬湅tnsname.ora杩欎釜鏂囦欢鏈夋病鏈夛紝娌℃湁灏眃own涓涓
绛旓細璇峰湪棣栭夐」涓厤缃甇CI.dll鐨勮矾寰勶紝浣犺繖涓槸鎵句笉鍒癘CI.dll鏂囦欢锛屾鏂囦欢鍦ㄤ綘鏈哄櫒涓妎racle瀹㈡埛绔畨瑁呯洰褰曚笅鐨刡in鐩綍涓嬶紝宸ュ叿->棣栧厛椤->oracle->杩炴帴 閰嶇疆oci.dll鐨勮矾寰 渚嬪鎴戠殑鍐 D:\Oracle\bin\oci.dll 鎵惧埌浣犵殑鏂囦欢鎶婅矾寰勫姞杩涘幓OK浜 浠ュ墠甯悓浜嬭В鍐宠繃锛岃В鍐充笉浜嗚鍙戠櫨搴︽秷鎭 ...
绛旓細铏氭嫙鏈虹敤PLSQL鍙互杩炴帴oracle鏁版嵁搴,璇存槑鏈嶅姟鍣ㄧ鐨凞B鏈嶅姟鍜岀洃鍚湇鍔￠兘鏄纭殑 闂搴旇鏄湪瀹㈡埛绔繖杈,鍙兘鏄鎴风鐨PLSQLDEV鐗堟湰涓巓racle瀹㈡埛绔吋瀹规ч棶棰.浣犲彲浠ュ湪瀹㈡埛绔洿鎺ヤ娇鐢╫racle鑷甫鐨sqlplus宸ュ叿杩炴帴铏氭嫙鏈虹殑DB,鐪嬫槸鍚﹀彲浠.
绛旓細鏇挎崲鍏跺揩鎹锋柟寮忥紝鍚姩PLSQL Developer锛歟cho off set path=C:\instantclient-basic-nt-11.2.0.2.0 set ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0 set TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0 set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK start plsqldev.exe ...
