- 论坛徽章:
- 0
|
sqlnet.log里
***********************************************************************
Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/usr/lib/oracle/10.2.0.1/client/bin/oracle)(ARGV0=oracleSMSDB02)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=tora)(HOST=localhost.localdomain)(USER=shi))))
VERSION INFORMATION:
TNS for Linux: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
Time: 23-DEC-2005 18:11:45
Tracing not turned on.
Tns error struct:
ns main err code: 12545
TNS-12545: Message 12545 not found; No message file for product=network, facility=TNS
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Message 515 not found; No message file for product=network, facility=TNS
nt secondary err code: 2
nt OS err code: 0
***********************************************************************
我的配置文件
#sqlnet.ora
NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME)
***********************************************************************
#tnsnames.ora
SMSDB02=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.1.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SID = smsdb02)
(SERVER = DEDICATED)
)
)
***********************************************************************
环境变量
TNS_ADMIN=/usr/lib/oracle/10.2.0.1/client/network/admin
ORACLE_HOME=/usr/lib/oracle/10.2.0.1/client
同样这个db用sqlplus就可以连
但是用tora就不行
报 ora-12545:connect failed because target host or object does not exist
在oracle论坛里看到一个和我情况一模一样的
http://forums.oracle.com/forums/thread.jspa?threadID=300594
也没有办法解决
在这里请教各位大侠
谢谢 |
|