京东6.18大促主会场领京享红包更优惠

 找回密码
 立即注册

QQ登录

只需一步,快速开始

oracle异常关闭,启动:ORA-24324: service handle not initialized

2020-10-29 10:11| 发布者: zhaojun917| 查看: 3982| 评论: 0

摘要: oracle关闭异常,再次启动时错误信息如下:SQL shutdown immediate; ORA-24324: service handle not initialized ORA-24323: value not allowed ORA-01089: immediate shutdown in progress - no operations are per ...

oracle关闭异常,再次启动时错误信息如下:

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> startup mount;
ORA-01031: insufficient privileges

SQL> conn xxx;  
Enter password: 
ERROR:
ORA-01089: immediate shutdown in progress - no operations are permitted
Process ID: 0
Session ID: 0 Serial number: 0


Warning: You are no longer connected to ORACLE.
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17

解决办法:

[oracle@localhost ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 17 15:44:52 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2438529024 bytes
Fixed Size          2255672 bytes
Variable Size         671089864 bytes
Database Buffers     1744830464 bytes
Redo Buffers           20353024 bytes
Database mounted.
Database opened.
关闭

站长推荐上一条 /6 下一条

QQ|手机版|小黑屋|梦想之都-俊月星空 ( 粤ICP备18056059号 )|网站地图

GMT+8, 2025-7-2 05:49 , Processed in 0.027805 second(s), 19 queries .

Powered by Mxzdjyxk! X3.5

© 2001-2025 Discuz! Team.

返回顶部