ORA-12154: TNS: 无法解析指定的连接标识符
在配置新的数据库时,出现 ORA-12154: TNS: 无法解析指定的连接标识符 的问题。
我遇到的这个问题是由于在ora9idb前面有空格。
PL/SQL的配置文件tnsnames.ora中
ora9idb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ora9i)
(SERVICE_NAME = ora9i)
(SERVER = DEDICATED)
)
)
我遇到的这个问题是由于在ora9idb前面有空格。
PL/SQL的配置文件tnsnames.ora中
ora9idb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ora9i)
(SERVICE_NAME = ora9i)
(SERVER = DEDICATED)
)
)