ORA-12504:oracle连接错误 PL/SQL连接Oracle,提示ORA-12504:TNS...
sqlplus\u8fde\u63a5\u8fdc\u7a0b\u6570\u636e\u5e93\u62a5\u9519 ORA-12504: TNS: \u76d1\u542c\u7a0b\u5e8f\u5728 CONNECT_DATA \u4e2d\u672a\u83b7\u5f97 SERVICE_NAME\u5ba2\u6237\u7aef\u914d\u7f6e\u597d\u670d\u52a1\u540d\u540e\uff0c\u7528PL/SQL Developer\u8fde\u63a5\u6570\u636e\u5e93\u65f6\uff0c\u62a5\u9519\uff1aORA-12504\uff1aTNS\uff1a\u76d1\u542c\u7a0b\u5e8f\u5728CONNECT_DATA\u4e2d\u672a\u83b7\u5f97SERVICE_NAME\u3002\u4e00\u822c\u8fd9\u79cd\u60c5\u51b5\u8bf7\u68c0\u67e5tnsnames.ora\u6587\u4ef6\u4e2dTNS\u662f\u5426\u914d\u7f6e\u6b63\u786e\uff0c\u5982\u4e0b\u6240\u793a\uff0cSERVICE_NAME \u540d\u5b57\u5f04\u9519\u4e86\uff0c\u7ed3\u679c\u62a5\u5982\u4e0a\u9519\u8bef\uff1a
GSP =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST = 172.20.36.79)(PORT = 1521))
(CONNECT_DATA=
(SERVER = DEDICATED)
(SERVER_NAME = gsp)
)
)
\u4fee\u6539\u4e3a
GSP =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST = 172.20.36.79)(PORT = 1521))
(CONNECT_DATA=
(SERVER = DEDICATED)
(SERVICE_NAME = gsp)
)
)
\u4f60\u53ef\u4ee5\u5148\u5728net manage\u91cc\u9762\u914d\u7f6e\u4e00\u4e0b\u4f60\u7684\u76d1\u542c\u5c31\u53ef\u4ee5\u8bbf\u95ee\u4e86\u3002\u6216\u8005\u76f4\u63a5\u4fee\u6539\u4f60\u7684\u76d1\u542c\u914d\u7f6e\u6587\u4ef6\u3002NETWORK\ADMIN\tnsnames\u6587\u4ef6\u5373\u53ef\u3002
这个是我的tnsnames.ora的配置，参考下：SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = sidb26)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = sidb26)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain.com)(PORT = 1521))
)
)
检查监听端口是否正常，telnet host 1521
如果监听端口正常，一般都是你的tnsnames.ora文件配置的问题。（不懂配置，可追问。）
你这是tnsnames.ora的内容吗？
我看了几遍 ，也没有找到 本地网络服务名 啊，都是示例。
你的数据库service_name是什么？
本地网络服务名又是什么？
绛旓細杩欎釜鏄垜鐨則nsnames.ora鐨勯厤缃紝鍙傝冧笅锛歋ID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc)(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)(PROGRAM = extproc))(SID_DESC = (GLOBAL_DBNAME = sidb26)(ORACLE_HOME = /u01/app/oracle/product/11.2.0...
绛旓細net manager閲嶆柊涓轰綘鐨勬暟鎹簱閰嶄釜listner鍚с傚儚鎴戠殑listner鐨勬牸寮忎负:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))(ADDRESS = (PROTOCOL = TCP)(HOST = 7NQARM2O3BV7R51)(PORT = 1521)))ipc鍗忚鏄笉鏄綘鎵闇瑕佺殑锛7NQARM2O3BV7R51涓烘垜鐨...
绛旓細閭ｅ氨鏄湪vs2005涓缓绔嬬殑杩炴帴娌″紕濂斤紝鐩戝惉绋嬪簭鏃犳硶浠庤繛鎺ユ弿杩颁腑鑾峰緱鎵瑕佽繛鎺ョ殑鏁版嵁搴撶殑鏈嶅姟鍚
绛旓細浣犺繛鎺ユ暟鎹簱浣跨敤鐨凾NS杩炴帴涓叉湁闂鍝.璇曡瘯: sqlplus system/Oracledb@ORCL
绛旓細鍋氫负瀹㈡埛绔繛鎺ヨ繙绋嬫湇鍔″櫒锛屼綘闇瑕佸憡璇塸lsql浣犺杩炴帴鍝彴鏈嶅姟鍣(ip)銆佹暟鎹簱娉ㄥ唽鍒版湇鍔″櫒鐩戝惉鍣ㄤ笂鐨剆ervice_name鍜岀鍙ｆ槸浠涔堬紵鍥犳浣犻渶瑕侀厤缃繛鎺ュ埌杩滅▼鏈嶅姟鍣ㄧ殑杩炴帴涓诧紝杩炴帴涓插畾涔夊湪鏂囦欢e:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora 涓紝浣犲彲浠ユ墜宸ヤ慨鏀癸紝涔熷彲浠ョ敤netca淇敼锛屽畬鏁寸殑...
绛旓細sqlplus / as sysdba select name from v$database; /*鏌ヨ瀹炰緥鍚*/ 濡傛灉涓嶆槸ora11g闇瑕佷慨鏀圭洃鍚枃浠躲備綘鐨則nsnames.ora杩欎釜鏂囦欢閲屾牴鏈氨鏄┖鐨勶紝瑕侀厤缃
