使用PLSQL登录Oracle数据库,出现下面错误提示
ora-12538 tns no such protocol adapter
报错原因为tnsnames.ora文件的格式出现错误,按照下面正确格式排版之后,即可
ORCL = (DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
) )