重庆思庄Oracle、Redhat认证学习论坛

标题: 开启关闭数据提示Oracle ORA-24324 ORA-01041 ORA-01089 [打印本页]

作者: jiawang 时间: 2019-3-15 17:24
标题: 开启关闭数据提示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 permitted

SQL> 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/hosts

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
#::1 test localhost6.localdomain6 localhost6

删除上面红色一行，然后重新进入oracle用户，进sqlplus 执行shutdown abot就可以了

SQL> shutdown abort
ORACLE instance shut down.

oracle对操作系统的环境变量很敏感。不要随意修改操作系统的参数。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)