今天遇到一位网友,配置的dblink无法使用,报错:
ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE_NAME
其创建dblink的语句是:
create
public
database
link
nems
connect
to
heuser
identified
by
mypasswd
using
'
nems_123.456.78.99
'
;
其tnsnames.ora的配置是:
NEMS_123
.456.78.99
=
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS = ( PROTOCOL = TCP )( HOST = 123.456.78.99 )( PORT = 1521 ))
)
( CONNECT_DATA =
( SERVER = DEDICATED )
( SERVICE_NAME = NEMS )
)
)
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS = ( PROTOCOL = TCP )( HOST = 123.456.78.99 )( PORT = 1521 ))
)
( CONNECT_DATA =
( SERVER = DEDICATED )
( SERVICE_NAME = NEMS )
)
)
通过tnsping和sqlplus手工登录来进行检查,比较奇怪的是tnsping能ping通,但是用通过这个tns用sqlplus登录则报错:
[
oracle
@
buptnu
admin
]$
tnsping
nems_123
.456.78.99
TNS Ping Utility for Linux : Version 9.2.0.4.0 - Production on 25
TNS Ping Utility for Linux : Version 9.2.0.4.0 - Production on 25