Navicat连接Oracle时报错ORA-28547怎么办 plsqldev登陆时出现ora-28547:连接服务器失败...
Navicat\u8fde\u63a5Oracle\u65f6\u62a5\u9519ORA-28547\u600e\u4e48\u529e\u89e3\u51b3\u6848\uff1a
listener.ora\u670d\u52a1\u5668\u7aef\u914d\u7f6eoracle\u6587\u4ef6
listener.ora\u884c\u6ce8\u91ca\u6389\u884c (PROGRAM = extproc)
\u4fee\u6539\uff1a
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = prod)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
# (PROGRAM = extproc)
)
\u4f60\u597d\uff01
plsqldev
\u5de5\u5177-\u300b\u8bbe\u7f6e-\u300b\u52a0\u8f7d\u4f60\u8981\u8fde\u63a5\u7684oracle\u5b89\u88c5\u76ee\u5f55\u4e0b\u7684oci.dll
\u4ec5\u4ee3\u8868\u4e2a\u4eba\u89c2\u70b9\uff0c\u4e0d\u559c\u52ff\u55b7\uff0c\u8c22\u8c22\u3002
Navicat连接oracle数据库数据库需要设置oci.dll。
1、设置oci.dll，下载instantclient，解压；
2、设置oci后，从起Navicat，再打开，新建连接；
点击连接测试，要保证连接的上数据库；
绛旓細淇℃伅濉啓涓嶅叏锛氬湪鈥滀富鏈哄悕鍜宨p鈥濅笂瑕佸～鍐欐湇鍔″櫒鐨勪富鏈哄悕锛堥渶瑕佽В鏋愶級鎴栬卛p锛宻ervice name瑕佸～鍐檕rcl锛屽洜涓哄疄渚嬩笂鐨勬湇鍔℃敞鍐屽埌鐩戝惉涓婃槸orcl
绛旓細listener could not resolve SID given in connect descriptor? 绛旀鎻愮ず锛氭剰鎬濆氨鏄疭ID 鏁版嵁搴撶殑瀹炰緥ID鎵句笉鍒帮紝鏌ヨ鏁版嵁搴撳疄渚婭D锛歴elect name from v$database;NAME --- XE 寰楀埌浜哠ID锛 鎶奨E濉叆 鏈嶅姟鍚嶆垨SID 閭ｄ竴鏍忥紙榛樿涓篛RCL锛
绛旓細2銆佷娇鐢Navicat杩炴帴鏃朵綘鍙兘浼氱鍒颁互涓嬮棶棰橈細锛1锛塷ci.dll鐨勭増鏈笉瀵 浠 http://www.oracle.com/technology/software/tech/oci/instantclient/index.html 涓嬭浇client 閲岄潰寰堝锛屾牴鎹綘鐨勭増鏈潵涓嬶紝鎴戜笅杞界殑鏄痠nstantclient_11_1銆傚湪navicat鐨 宸ュ叿-閫夐」-鍏朵粬-OCI ,閫夋嫨鍒氫笅鐨刢lient涓殑 oci.dll 璁剧疆...
绛旓細浠ｈ〃鍑芥暟涓嶅彲鐢ㄣ傛湁鍙兘鏄嚱鏁板紩鐢ㄧ殑瀵硅薄鍙戠敓鍙樺寲瀵艰嚧鐨勶紝鍙抽敭閲嶆柊缂栬瘧灏卞ソ浜嗭紝杩欐椂涓嶄細褰卞搷浣跨敤锛屽洜涓Oracle鍦ㄨ皟鐢ㄥ嚱鏁版椂鍙戠幇鍑芥暟涓嶅彲鐢ㄤ細鑷姩閲嶆柊缂栬瘧銆備篃鍙兘鏄嚱鏁伴噷闈㈠瓨鍦ㄤ唬鐮侀敊璇紝杩欐椂鍙抽敭閲嶆柊缂栬瘧瑙ｅ喅涓嶄簡闂锛屽繀椤昏杩涘叆鎶婁唬鐮佽皟閫氥
绛旓細Navicat Premium鏄竴娆惧姛鑳藉己澶х殑鏁版嵁搴撶鐞嗗拰寮鍙戝伐鍏枫侼avicat Premium鎻愪緵浜嗙洿瑙備笖鐢ㄦ埛鍙嬪ソ鐨勭晫闈紝浣垮緱鐢ㄦ埛鍙互杞绘澗绠＄悊鍜屾搷浣滃悇绉嶆暟鎹簱锛屽寘鎷琈ySQL銆丳ostgreSQL銆Oracle绛夈傚叾鎿嶄綔鍜屼娇鐢ㄤ富瑕佸寘鎷杩炴帴鏁版嵁搴撱佺鐞嗘暟鎹簱瀵硅薄銆佹墽琛孲QL璇彞绛夈傞鍏堬紝鐢ㄦ埛闇瑕佷娇鐢∟avicat Premium寤虹珛涓庢暟鎹簱鐨勮繛鎺ャ傚湪杩炴帴鏃讹紝...
绛旓細濡傛灉鏄湰鏈虹殑鏁版嵁搴擄紝鐪嬩笅tns鏈嶅姟鏄笉鏄惎鍔ㄤ簡锛屽鏋滄槸杩滅▼鏁版嵁搴擄紝鐪嬩笅tns閰嶇疆鏄惁姝ｇ‘
绛旓細浣犲湪CMD杈撳叆鐢ㄦ埛鍚嶅瘑鐮佺殑鏃跺欒偗瀹氭病鏈夊姞杩炴帴绗︼紙姣斿scott/tiger@orcl锛屼綘搴旇娌℃湁@锛夈傝繖鏍疯蛋灏变細鏍规嵁浣犵殑鐜鍙橀噺閲岃缃殑ORACLE_SID鐧诲綍鏁版嵁搴撱傝屼綘鐢navicat杩欎簺杞欢鐨勬椂鍊欓渶瑕佹湁鐩戝惉鍚姩銆備綘鍙互鍦ㄤ綘鐨凜MD涓嬭緭鍏snrctl statu鐪嬬湅浣犳湁娌℃湁鐩戝惉绋嬪簭锛屽鏋滄病鏈変綘闇瑕侀厤缃竴涓嬬洃鍚▼搴忕劧鍚庡惎鍔紝CMD涓...
绛旓細navicat 濂藉儚涓嶈兘璁剧疆鑷姩鎻愪氦鐨勬ā寮忥紝璨屼技鍙兘鑷姩鎻愪氦锛堟湁涓涓缃紝浣嗘槸涓嶄細璧蜂綔鐢級銆傛墍浠ュ簲璇ユ槸涓嶈兘鍥炴粴鐨勩
绛旓細鏍规嵁涓嶅悓缃戠珯锛屼笉鍚岀殑鏁版嵁搴擄紝瀵瑰簲涓嶅悓鐨勭鐞嗘柟寮 asp缃戠珯绫伙紝澶ч儴鍒嗘槸鐩存帴鐨刟ccess鏁版嵁搴撳瓨鍌 鐩存帴鐢╫ffice access灏卞彲浠ユ墦寮缂栬緫 php绫荤綉绔欙紝澶氱敤mysql鏁版嵁搴擄紝杩欑搴撳彲浠ラ噰鐢ㄥ湪绾跨▼搴忕鐞嗙殑鏂瑰紡锛屾瘮濡俻hpmyadmin灏卞彲浠ワ紝涔熷彲浠ヤ娇鐢ㄧ數鑴戝鎴风绠＄悊锛屾瘮濡Navicat for MySQL灏卞緢涓嶉敊銆俷et绫荤綉绔欙紝澶氶噰鐢╩ssql...
绛旓細铏界劧鎴戠殑navicat涓嶄細杩欐牱锛屼絾浣跨敤to_char杞崲鎴愬瓧绗﹀瀷灏变笉浼氳繖鏍蜂簡
