oracle关闭异常,报错:ORA-24324: service handle not initialized
oracle数据库关闭异常,报错如下:

oracle@ app]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 23 07:25:03 2018

Copyright © 1982, 2009, Oracle. All rights reserved.

Connected.
SQL> startup
ORA-01012: not logged on
SQL> shutdown
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01090: shutdown in progress - connection is not permitted

解决办法:

1.使用exit退出sqlplus。

2.使用sqlplus / as sysdba登录sqlplus,具体操作如下:

SQL> exit
Disconnected
[oracle@ app]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 23 07:29:55 2018

Copyright © 1982, 2009, Oracle. All rights reserved.

Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address ‘(ADDRESS=(PROTOCOL=TCP)(HOST=.)(PORT=1521))’

ORA-00600: internal error code, arguments: [4194], [53], [41], [], [], [], [], []
真的不动,关闭同事开发测试IBM 3650server它直接关系到电源插头行???

第二天加点重新启动之后oracle 打开报错ORA-00600: internal error code, arguments: [4194], [53], [41], [], [], [], [], []

求助DBA

决绝办法。启用undo手动管理。重建undo表空间

过程例如以下:
SQL> alter system set undo_management=MANUAL scope=spfile;

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database open;

SQL> create undo tablespace undotbs2 datafile ‘/data/oracle/app/oradata/ipf/undotbs3.dbf’ size 1g;

SQL> alter system set undo_management=AUTO scope=spfile;

SQL> alter system set undo_tablespace=undotbs2 scope=spfile;

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database open;

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐