在Linux系统上安装了64位oracle 11g,在Windows系统上用plsql和toad连接数据库,按之前的配置在本机上配置好了tnsnames.ora如下:
orcl-215 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.111.215)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
报ORA-12514 : TNS:监听程序当前无法识别连接描述符中请求的服务 错误!
使用sqlplus直接登陆
sqlplus user/password as sysdba 可以登陆