我创建了一个名为PRACTICE的数据库,tnsnames.ora的配置是
PRACTICE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.20.84)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PRACTICE)
)
)
在服务器端 sqlplus /nolog
connect sys/pass@PRACTICE
报ora_12514的错误
请问是什么原因,怎么解决呢?
PRACTICE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.20.84)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PRACTICE)
)
)
在服务器端 sqlplus /nolog
connect sys/pass@PRACTICE
报ora_12514的错误
请问是什么原因,怎么解决呢?
1、tns配置不对
2、网络问题
3、服务器端tns监听没起来
看看监听有没有起来:lsnrctl stat
Inthirties关注Oracle数据库 优化,安全,备份,恢复,迁移,故障处理如果你需要帮助或想和我一起学习的请联系
联系方式QQ:370140387
QQ群: 85837884(注明:数据库)
电子邮件:[email protected]
网站: http://www.inthirties.com