做了一个DBLINK的实验出了点问题

显示全部楼层 · 2005-10-30 17:05:33

SQL> create public database link shi_DMCPHE01 connect to system identified by
2system using 'DMCPHE01'
3;
数据库链接已创建。
SQL> select * from v$logs @DMCPHE01
2;
select * from v$logs @DMCPHE01

*
ERROR 位于第 1 行:
ORA-02019: 未找到远程数据库的连接说明

SQL> select * from v$logs@DMCPHE01
2;
select * from v$logs@DMCPHE01

*
ERROR 位于第 1 行:
ORA-02019: 未找到远程数据库的连接说明

SQL> select * from v$instance@DMCPHE01
2;
select * from v$instance@DMCPHE01

*
ERROR 位于第 1 行:
ORA-02019: 未找到远程数据库的连接说明

SQL> select * from pe_dic.app_cord_trfm@DMCPHE01;
select * from pe_dic.app_cord_trfm@DMCPHE01

*
ERROR 位于第 1 行:
ORA-02019: 未找到远程数据库的连接说明

SQL> select owner,object_name from dba_objects where object_type='DATABASE LINK'
;
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
PUBLIC
SHI_DMCPHE01

SQL>
还有我怎么拷贝远程数据库的表

千问 · 2005-10-30 17:05:33

tns配对了?

千问 · 2005-10-30 17:05:33

select * from v$logs@shi_DMCPHE01

千问 · 2005-10-30 17:05:33

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
OEMREP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yjy-xxs-shil)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP)
)
)
10.217.109.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.217.109.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DMCPHE01)
(SERVER = DEDICATED)
)
)
DMCPHE01_10.217.109.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.217.109.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DMCPHE01)
(SERVER = DEDICATED)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yjy-xxs-shil)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
TESTSHI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.217.36.109)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testshi)
)
)

千问 · 2005-10-30 17:05:33

SQL> select * from v$logs@shi_DMCPHE01;
select * from v$logs@shi_DMCPHE01

*
ERROR 位于第 1 行:
ORA-12154: TNS: 无法处理服务名

SQL>

千问 · 2005-10-30 17:05:33

最初由 luckysea 发布
[B]select * from v$logs@shi_DMCPHE01 [/B]
SQL> select * from v$logs@shi_DMCPHE01;
select * from v$logs@shi_DMCPHE01

*
ERROR 位于第 1 行:
ORA-12154: TNS: 无法处理服务名

SQL>

千问 · 2005-10-30 17:05:33

tnsping DMCPHE01

千问 · 2005-10-30 17:05:33

最初由 luckysea 发布
[B]tnsping DMCPHE01 [/B]
请再详细些没明白什么意思

千问 · 2005-10-30 17:05:33

最初由 shilei1 发布
[B]
请再详细些没明白什么意思 [/B]
就是在OS上执行这条命令，类似windows的ping，测试你dblink所使用的service name是否正确

千问 · 2005-10-30 17:05:33

最初由 feibiao1 发布
[B]
就是在OS上执行这条命令，类似windows的ping，测试你dblink所使用的service name是否正确 [/B]
C:\Documents and Settings\Administrator>tnsping DMCPHE01
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 09-1月 -2
007 18:36:39
Copyright (c) 1997 Oracle Corporation.All rights reserved.
已使用的参数文件:
D:\oracle\ora92\network\admin\sqlnet.ora
TNS-03505: 未能分解名称
C:\Documents and Settings\Administrator>