ORA-01034和ORA-27101错误的解决方法

sqlplus / as sysdba 进入

show parameter local_listener

value是空的

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)(SID=ORCL))';

alter system register;