监听程序服务启动后停止/连接超时/监听程序无法识别
![watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70](https://img-blog.csdnimg.cn/20210509104558691.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70)
监听程序当前无法识别连接描述符中请求的服务
![watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70](https://img-blog.csdnimg.cn/20210509104734288.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70)
监听程序服务启动后停止
![watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70](https://img-blog.csdnimg.cn/20210509105633317.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70)
连接超时
解决方式:
(1)检查监听器配置是否正确
![watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70](https://img-blog.csdnimg.cn/20210509104926998.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70)
listener.ora
![20210509105002531.png](https://img-blog.csdnimg.cn/20210509105002531.png)
tnsnames.ora
正确的监听文件的配置应该是这样的
![watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70](https://img-blog.csdnimg.cn/20210509105047356.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70)
listeners.ora 的配置
![watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70](https://img-blog.csdnimg.cn/20210509105435246.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70)
tnsname.ora的配置
(2)重!新!启动服务
![watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70](https://img-blog.csdnimg.cn/20210509105849929.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70)
服务
启动OracleJobScheduleORCL->启动OracleOra11g_home1TNSListener->启动OracleServiceORCL
![watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70](https://img-blog.csdnimg.cn/20210509110003544.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Njc2Njc4OA==,size_16,color_FFFFFF,t_70)
OracleJobScheduleORCL 注册表/ OracleOra11g_home1TNSListener 监听程序/OracleServiceORCL 数据库服务
(3)成功登录Oracle