使用SQL Plus登陆的时候,总是显示登陆不上,报提示 ora-12154tns无法解析指定的连接标识符。 经过上网的搜索发现配置文件里定义的描述文件名含有空格,见(**),去掉空格解决问题。
# tnsnames.ora Network Configuration File: D:\oracle\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
**ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =Jason)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
**oracle =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.10.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
)
)
# tnsnames.ora Network Configuration File: D:\oracle\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
**ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =Jason)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
**oracle =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.10.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
)
)