在 /var/opt/oracle 下的tnsnames.ora文件 加入以下代码 heb687 =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=192.168.68.7)
(PORT=1521))
(CONNECT_DATE=(SID=ora7)))然后用DBA Studio 建立数据库链接
对象DLL为
CREATE PUBLIC DATABASE LINK "HEB687" CONNECT TO "OPS$STOREP" IDENTIFIED BY "********" USING 'heb687' SQL> select count(*) from tabs@heb687;
select count(*) from tabs@heb687
*
ERROR at line 1:
ORA-12504: TNS:listener was not given the SID in CONNECT_DATA我跟其他数据库都一一对照了 没有什么不同的啊 在DBA Studio里测试 提示我未处于活动状态。有没有遇到这种问题的 告诉我解决方案 谢谢!
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=192.168.68.7)
(PORT=1521))
(CONNECT_DATE=(SID=ora7)))然后用DBA Studio 建立数据库链接
对象DLL为
CREATE PUBLIC DATABASE LINK "HEB687" CONNECT TO "OPS$STOREP" IDENTIFIED BY "********" USING 'heb687' SQL> select count(*) from tabs@heb687;
select count(*) from tabs@heb687
*
ERROR at line 1:
ORA-12504: TNS:listener was not given the SID in CONNECT_DATA我跟其他数据库都一一对照了 没有什么不同的啊 在DBA Studio里测试 提示我未处于活动状态。有没有遇到这种问题的 告诉我解决方案 谢谢!
tnsping heb687
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=192.168.68.7)
(PORT=1521))
(CONNECT_DATE=(SID=ora7)))
开头是 heb687 ,连接串里的SID 是 ora7~~ 统一下
CS_JA:/home2/store01/maintain> tnsping heb687TNS Ping Utility for AT&T System 3000: Version 2.2.2.0.0 - Production on 08-DEC-11 18:32:05Copyright (c) Oracle Corporation 1995. All rights reserved.Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.68.7)(PORT=1521)) No Driver
TNS-12538: TNS:no such protocol adapter啥意思呢?
就是我之前说的问题呀,你SID里面写的ora7,开头写个heb687,肯定不识别呀。你把heb687改成ora7试试