原因:数据库监听的配置文件中的 sid 和连接时填写的不一致(默认是orcl)
先找到 Oracle 数据库的 tnsnames.ora 文件,find / -name tnsnames.ora,找到一个是..../admin/tnsnames.ora 的文件
刚开始是这样的:
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
修改后(改了 SERVER 的值):
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = orcl)
(SERVICE_NAME = orcl)
)
然后重启监听服务:先停止:lsnrctl stop 再启动:lsnrctl start
然后按照 sid = orcl 来连接,可以了