查看监听文件
locate listener.ora
切换到数据库用户
su - ora11g
查看监听状态
状态显示，监听没有打开
开启监听，start后面加上你需要启动的监听名字（因为listener.ora中可以配置很多监听）。不指明名字的话，默认就是LISTENER的名字
修改完成后连接成功
相关文章
- 09-16ORA-12541:TNS:无监听程序
- 09-16ORA-12505, TNS:listener does not currently know of SID given in connect desc
- 09-16ORA-12528: TNS:listener: all appropriate instances are blocking new connections
- 09-16ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
- 09-16ORA-12528: TNS:listener: all appropriate instances are blocking new connections
- 09-16PL/SQL Developer登录提示 ORA-12541:TNS:无监听程序
- 09-16ORA-12514 TNS listener does not currently know of service re
- 09-16TNS-01190: The user is not authorized to execute the requested listener command
- 09-16Kettle Spoon 数据源连接中报ORA-12505, TNS:listener does not currently know of SID given in connect descript
- 09-16Oracle LISTENER 主机名修改为IP地址后LISTENER无法监听到实例 oracle监听错误与hosts文件配置