ORA-12154: TNS:could not resolve the connect identifier specified
环境是winxp+oracle10g
用net configuration assistant配置好后可以测试成功
但是用sqlplus system/test@Test 时出现上述错误
用Enterprise Manager Console可以连接上
sqlnet.ora如下:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
tnsnames.ora如下:
Test=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = notexiao)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Test)
)
)