开启关闭数据提示Oracle ORA-24324 ORA-01041 ORA-01089错误及个人的解决方法。SQL> conn / as sysdba
Connected to an idle instance.SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permittedSQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn"t exist网上找了半天说直接shutdown abort就好了,但是我执行shutdown abort时出现下列错误SQL> shutdown abort
ORA-01031: insufficient privileges
最终解决方法:在root下vi /etc/host# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6删除上面红色一行,然后重新进入oracle用户,进sqlplus 执行shutdown abot 可行SQL> shutdown abort
ORACLE instance shut down.有可能也许不是上面红色那句话的原因,也需exit出去,然后重新进入oracle用户就好了,不明白,反正就这样稀里糊涂的就解决了非常诡异的错误,不知为什么?Oracle调用存储过程ORA-01033:ORACLE initialization or shutdown in progress小记相关资讯 ORA-24324 ORA-01041 ORA-01089
- Oracle故障分析ORA-01089 (07/20/2015 21:22:24)
- ORA-24324错误的解决方法 (05/20/2013 20:46:11)
| - ORA-24324&ORA-01041重启数据库报 (05/26/2015 10:17:45)
- Oracle连接超限修改,ORA-00064, (11/09/2012 06:12:11)
|
本文评论 查看全部评论 (0)