17,377
社区成员
发帖
与我相关
我的任务
分享oracle服务已启动怎么还找不到监听？
OracleServiceORCL11和ORacleOraDB11g_home1TNSListener在服务中以显示启动了，但是当plsql连接时还是 报找不到监听的错误，而且我用sqlplus连接时还报ora-01034和ora-27101的两个错误，这两个错误时不时说oracle服务程序没有启动啊？。
在线等着帮助，谢谢各位，帮下忙吧
在线等着帮助，谢谢各位，帮下忙吧
...全文
请发表友善的回复…
发表回复
wj0728 2010-09-09
- 打赏
- 举报
你的监听应该是动态监听的，你是不是把服务设置为手动了？这样的话，你就只有重启一下数据库了
ojuju10 2010-09-09
- 打赏
- 举报
没有监听，数据库一样可以起来，只是不能用tnsname连接
xuesongliu 2010-09-09
- 打赏
- 举报
楼主的操作系统是windows吧，我遇到过这样的情况。有两个情况你需要确认，数据库是不是确实启动了，我遇到过服务起来了，但数据库是没有打开的；第二个情况是你的监听文件中缺少实例的内容，这样也是不能连接的。
ojuju10 2010-09-09
- 打赏
- 举报
楼上的意思是把服务删除后，再重新创建一个
kwp131 2010-09-09
- 打赏
- 举报
楼上的，什么意思啊 ？
ngx20080110 2010-09-09
- 打赏
- 举报
ORA-01034 and Ora-27101 after rebooting the server [ID 238073.1]
Symptom(s)
~~~~~~~~~~
Database has been configured to start automatically whenever the server
is rebooted. But the database does not start and any query to the database
fails with Ora-27101 and Ora-1034 errors. Same errors are reported in
the Oradim.log.
ORA-01034 ORACLE not available
ORA-27101 "Shared Memory Realm Does Not Exist"
Change(s)
~~~~~~~~~~
DBAs are trying to automate the startup of the database when
server reboots. The Registry key ORA_<SID>_AUTOSTART is set to
TRUE and ORA_<SID>_PFILE is pointing to correct location. The "startmode"
of Oracle service ORACLESERVICE<SID> has been set to AUTOMATIC.
Cause
~~~~~~~
The Oracle service ORACLESERVICE<SID> get corrupted for some unknown
reasons and does not start the database successfully
Fix
~~~~
recreate the Oracle service using ORADIM utility
a) delete the current service -
c:\> oradim -delete -sid <sid_name>
b) make sure the service has status DISABLED in Service Windows and it
does not appear after refreshing the Service Windows. If the service
still appears, reboot the server.
c) create the service
c:\> oradim -new -sid <sid> -startmode auto -pfile <absolute path of init.ora>
Symptom(s)
~~~~~~~~~~
Database has been configured to start automatically whenever the server
is rebooted. But the database does not start and any query to the database
fails with Ora-27101 and Ora-1034 errors. Same errors are reported in
the Oradim.log.
ORA-01034 ORACLE not available
ORA-27101 "Shared Memory Realm Does Not Exist"
Change(s)
~~~~~~~~~~
DBAs are trying to automate the startup of the database when
server reboots. The Registry key ORA_<SID>_AUTOSTART is set to
TRUE and ORA_<SID>_PFILE is pointing to correct location. The "startmode"
of Oracle service ORACLESERVICE<SID> has been set to AUTOMATIC.
Cause
~~~~~~~
The Oracle service ORACLESERVICE<SID> get corrupted for some unknown
reasons and does not start the database successfully
Fix
~~~~
recreate the Oracle service using ORADIM utility
a) delete the current service -
c:\> oradim -delete -sid <sid_name>
b) make sure the service has status DISABLED in Service Windows and it
does not appear after refreshing the Service Windows. If the service
still appears, reboot the server.
c) create the service
c:\> oradim -new -sid <sid> -startmode auto -pfile <absolute path of init.ora>
