ORA-24324: service handle not initialized

最新推荐文章于 2022-06-01 14:54:43 发布

叽哩古哩

最新推荐文章于 2022-06-01 14:54:43 发布

阅读量1.2w

点赞数 3

CC 4.0 BY-SA版权

分类专栏： bug总结

本文链接：https://blog.youkuaiyun.com/cuiyan1982/article/details/45246803

bug总结专栏收录该内容

11 篇文章

订阅专栏

本文详细记录了一次SQL Plus环境异常退出导致的数据库实例崩溃问题，通过退出并重新启动SQL Plus环境成功解决。同时，文章介绍了使用SQL*Plus进行数据库维护操作，包括启动、恢复数据库及调整系统全局区大小的过程。此经验对于数据库管理员在遇到类似问题时提供了解决思路。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

我做了个实验，破环了在线当前日志组，实例崩溃。我在网上查了半天，最后决定先退出sqlplus环境再重新启动sqlplus。结果问题解决了。

SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@cuiyan ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 24 14:58:20 2015

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

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 608174080 bytes
Fixed Size 1220844 bytes
Variable Size 201330452 bytes
Database Buffers 402653184 bytes
Redo Buffers 2969600 bytes
Database mounted.
SQL> recover database until cancel;
ORA-00279: change 488525 generated at 04/24/2015 12:58:35 needed for thread 1
ORA-00289: suggestion : /home/oracle/arch/1_1_877869001.dbf
ORA-00280: change 488525 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;

Database altered.