|
各位帮忙看看,这是啥问题,tnsping没有问题。但sqlplus连接时指定tnsname就报错,不指定就可以。
C:\Documents and Settings\Administrator>tnsping orcl
TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 25-11月-
2010 15:47:11
Copyright (c) 1997, 2007, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = F472BD49
3CA0462)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL
)))
OK (10 毫秒)
C:\Documents and Settings\Administrator>sqlplus hr/hr@orcl
SQL*Plus: Release 10.1.0.3.0 - Production on 星期四 11月 25 15:47:31 2010
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS: 无法解析指定的连接标识符
请输入用户名: |
|