开启关闭数据提示Oracle ORA-24324 ORA-01041 ORA-01089

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:278

[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]开启关闭数据提示[color=#b32bd5]Oracle ORA-24324 ORA-01041 ORA-01089错误及个人的解决方法。[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]SQL> conn / as sysdba
Connected to an idle instance.[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]网上找了半天说直接shutdown abort就好了,但是我执行shutdown abort时出现下列错误[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]SQL> shutdown abort
ORA-01031: insufficient privileges[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]最终解决方法:[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]在root下vi /etc/host[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]# 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[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]删除上面红色一行,然后重新进入oracle用户,进sqlplus 执行[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]shutdown abot 可行[backcolor=rgb(250, 250, 252)][font=tahoma, 宋体]SQL> shutdown abort
ORACLE instance shut down

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】