昨天Oracle数据库还能连接，今天突然就出现问题了，该怎么办呀，我的毕业论文！ oracle数据库今天突然无法进入，ora-12514：TN...
\u5728Linux\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u8fdc\u7a0b\u8fde\u63a5Oracle\u6570\u636e\u5e93\uff0c\u6628\u5929\u8fd8\u597d\u597d\u7684\uff0c\u4eca\u5929\u7a81\u7136\u51fa\u73b0\u4e86ora\u62a5\u9519\u6ca1\u5199\u6e05\u695a\u554a\u3002\u6700\u597d\u628a\u9519\u8bef\u4ee3\u7801\u8d34\u51fa\u6765
ORA-12154: TNS: \u65e0\u6cd5\u89e3\u6790\u6307\u5b9a\u7684\u8fde\u63a5\u6807\u8bc6\u7b26,\u89e3\u51b3\u601d\u8def\uff1a
\u8fd9\u79cd\u60c5\u51b5\u6211\u9047\u5230\u8fc7\u51e0\u6b21\uff0c\u4e00\u822c\u662f\u56e0\u4e3a\u752832\u4f4d\u7684\u5ba2\u6237\u7aef\u53bb\u94fe\u63a564\u4f4d\u7684oracle\u670d\u52a1\u7aef\u5230\u8d26\u7684\u4e0d\u517c\u5bb9\u95ee\u9898\uff0c\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6211\u4eec\u9700\u8981\u5728\u672c\u673a\u4fee\u65392\u5904\u73af\u5883\u53d8\u91cf\u3002
\u4fee\u6539\u4e00\uff1a\u4fee\u6539\u73af\u5883\u53d8\u91cfORACLE_HOME\u5f97\u503c\u914d\u7f6e\uff0c\u8981\u6307\u5411oracle\product\10.2.0\client_1
\u4fee\u6539\u4e8c\uff1a
\u5728\u76d1\u542c\u6587\u4ef6listener.ora\u4e2d\u6dfb\u52a0\uff1a
(SID_DESC =
(GLOBAL_DBNAME = \u5b9e\u4f8b\u540d)
(ORACLE_HOME = oracle\product\10.2.0\client_1 )
(SID_NAME = \u5b9e\u4f8b\u540d)
)
\u4ee5\u4e0a\u95ee\u9898\uff0c\u4e3b\u8981\u662foracle10g\u7248\u672c\u5bb9\u6613\u51fa\u73b0\uff0c11g\u7248\u672c\u76ee\u524d\u6682\u65f6\u6ca1\u9047\u5230\u8fc7\u3002
ip有没有改过？重新配置个
绛旓細4,杩樻湁涓姝ヨ鍋氾紝鍒杩炴帴鐨Oracle鏁版嵁搴鐩綍涓嬫壘鍒皌nsnames.ora鏂囦欢锛屼竴鑸矾寰勫湪D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN涓嬶紝灏嗚鏂囦欢鎷疯礉鍒颁綘瀹夎鐨刼racle瀹㈡埛绔洰褰曚笅锛屽D:\app\Administrator\product\11.2.0\client_1\Network\Admin\tnsnames.ora,鍦ㄨ繛鎺ユ椂灏鍙互鐩存帴鐢═NS鏂瑰紡杩炴帴浜嗭紝绋嬪簭浼...
绛旓細涓銆佹墦寮宸茬粡瀹夎濂界殑pb9.0锛屼富鐣岄潰鑿滃崟鏍忔湁涓袱涓渾鏌卞舰灏辫鏁版嵁搴撹繛鎺锛岀偣鍑籨atabase銆備簩銆侀夋嫨oracle鐗堟湰锛岀敱浜庢暟鎹簱鐗堟湰鏄9i锛鍙互浣跨敤084 oracle8/8i.鍙抽敭--閫夋嫨new profile銆傚綋鐒朵綘涔熷彲浠ヨ缃ソ鐨刾rofile瀵煎叆杩涘幓銆備篃鍙互鎶婅缃ソprofile瀵煎嚭鏉ャ備笁銆佸脊鍑篸atabase profile setup鐣岄潰锛屾垜浠偣鍑...
绛旓細鎭,浣犵殑鏁版嵁搴鍚姩浜嗕箞锛岀幇鍦ㄧ殑鐘舵佹槸浠涔堬紵鎬庝箞鎰熻濂借薄鏄暟鎹簱娌″惎鍔ㄥ憿锛屼笂闈㈢殑鎶ラ敊璇寸殑鏄1034杩欎釜灏辨槸鏁版嵁搴撴病鍚姩鎴栬呭惎鍔ㄧ姸鎬佷笉鏄痮pen瀵艰嚧鐨勩傚鏋滀笉鏄紝閭ｄ箞鏈夊彲鑳芥槸sqlnet.ora绂佹浜嗘湰鍦扮櫥闄嗭紝浣犳壘鎵撅紝鎴戣寰楀ソ璞℃湁杩欎箞涓涓弬鏁扮殑銆
绛旓細濡傛灉涓鑳借繛鎺鍒鏁版嵁搴,鍒欏湪tnsname.ora鏂囦欢涓殑test缃戠粶鏈嶅姟鍚(net service)鍚庨潰鍔犱笂sqlnet.ora鏂囦欢涓璑AMES.DEFAULT_DOMAIN鍙傛暟鐨勫,姝ゅ鎴戠殑鍙傛暟鍊间负testserver.com,灏嗗叾鍔犲埌缃戠粶鏈嶅姟鍚嶅悗闈,淇敼鍚庣殑tnsname.ora涓叧浜庤缃戠粶鏈嶅姟鍚嶇殑鍐呭涓: 浠涔堟儏鍐典笅浼氬紩璧oracle鑷姩璁剧疆NAMES.DEFAULT_DOMAIN鍙傛暟? 鍑虹幇杩欑鎯呭喌...
绛旓細鎬讳箣锛孫racle 12514閿欒閫氬父鏄敱浜庢湇鍔″悕閰嶇疆閿欒銆佺洃鍚櫒鏈惎鍔ㄦ垨鏈纭厤缃互鍙婄綉缁滈棶棰樺鑷寸殑銆傝В鍐宠繖涓棶棰樼殑鍏抽敭鏄鏌ヨ繖浜涙柟闈紝骞惰繘琛岀浉搴旂殑璋冩暣銆傞氳繃浠旂粏妫鏌ュ拰閰嶇疆锛岄氬父鍙互鎴愬姛杩炴帴鍒Oracle鏁版嵁搴骞惰В鍐砄racle 12514閿欒銆備负浜嗘洿鍏蜂綋鍦拌鏄庤繖浜涘師鍥犲拰瑙ｅ喅鏂规硶锛岃鎴戜滑閫氳繃涓涓疄闄呮渚嬫潵杩涜鍒嗘瀽銆傚亣璁...
绛旓細Oracle杩炴帴杩滅▼鏁版嵁搴閰嶇疆杩滄柟娉曪細1銆佹壘鍒$ORACLE_HOME/client_1/network/admin鐩綍涓嬬殑tnsnames.ora鏂囦欢锛屽苟鐢ㄦ枃鏈ā寮忔墦寮銆2銆佹坊鍔犱互涓嬪唴瀹癸細鏈湴瀹炰緥鍚= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 鏁版嵁搴揑P鍦板潃)(PORT = 绔彛鍙)) (CONNECT_DATA = (SERVER = DEDICATED...
绛旓細璁剧疆鏂规硶濡備笅锛1銆佹壘鍒$ORACLE_HOME/client_1/network/admin鐩綍涓嬬殑tnsnames.ora鏂囦欢锛屽苟鐢ㄦ枃鏈ā寮忔墦寮銆2銆佹坊鍔犱互涓嬪唴瀹癸細鏈湴瀹炰緥鍚= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 鏁版嵁搴IP鍦板潃)(PORT = 绔彛鍙)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME ...
绛旓細杩欎釜鏄oracle 涓婇潰甯︾殑绛栫暐銆傚鏋滄槸鐢熶骇鐜杩樻槸涓嶈璋冩暣鐨勫ソ銆傚鏋滄槸娴嬭瘯鐜浣鍙互璁ヾba璋冩暣涓涓嬮粯璁ょ殑绌洪棽鏂紑鏃堕棿銆傞粯璁ょ殑璨屼技娌℃湁闄愬埗锛屼及璁℃槸浣犱滑鐨刼racle璋冩暣杩囥
绛旓細oracle 11g 瀹㈡埛绔鍙互杩炴帴oracle 10g鏁版嵁搴銆傛棤闇璁剧疆浠讳綍涓滆タ锛屽彧瑕侀厤缃繛鎺ユ枃浠跺嵆鍙細濡 ora11 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )ora11涓烘湰鍦版墍...
绛旓細鍦鏁版嵁搴涓, 甯哥敤鐨勪竴涓祦姘寸紪鍙烽氬父浼氫娇鐢 identity 鏍忎綅鏉ヨ繘琛岃缃, 杩欑缂栧彿鐨勫ソ澶勬槸涓瀹氫笉浼氶噸瑕, 鑰屼笖涓瀹氭槸鍞竴鐨, 杩欏table涓殑鍞竴鍊肩壒鎬у緢閲嶈, 閫氬父鐢ㄦ潵鍋氬鎴风紪鍙, 璁㈠崟缂栧彿绛夊姛鑳, 浠ヤ笅浠嬬粛鍏充簬姝ょ鏍忎綅甯哥敤鏂瑰紡鍙婄浉鍏虫妧鏈.CREATE TABLE products (id int IDENTITY PRIMARY KEY, product ...
