shut immediate 数据库遭遇 ORA-24324 ORA-24323 参考学习

小小码 • 2023-03-29 13:30 • 代码基础 • 阅读 114

大家好，我是考100分的小小码，祝大家学习进步，加薪顺利呀。今天说一说shut immediate 数据库遭遇 ORA-24324 ORA-24323 参考学习,希望您对编程的造诣更进一步.

SQL> shut immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 501 (oinstall), current egid = 504 (asmadmin)

—最直接的解决办法

shutdown abort

后面退出会话，然后登陆sqlplus，使用shutdown abort 才将数据库关闭。处理完成后，查了一下metal link官方文档，发现引起错误的原因为：

Background processes are hanging/not started correctly during the previous startup of this database.

Hence the semaphores and shared memory segments are not getting detached properly now during shutdown.

以后遇到这个问题，可以使用下面步骤处理：

1. Verify that there are no background processes owned by “oracle” , if there are kill them

$ ps -ef | grep ora_ | grep $ORACLE_SID

2. Remove shared memory and semaphores:

A) Check for shared memory and semaphores

$ ipcs -mt (if there is anything owned by oracle remove it)

$ ipcrm -m [ID] (to remove it)

B) Check and remove semaphores

$ ipcs -sbt (if there is anything owned by oracle remove it)

$ ipcrm -s [ID] (to remove it)

C) Remove sga and lk file

$ cd $ORACLE_HOME/dbs

$ rm sgadef<SID>.dbf (removing sga file)

$ORACLE_HOME/dbs/lk<sid> (removing lk… flies)

D) If database is down, try to bring up oracle one step at a time:

$ sqlplus /nolog

SQL> startup nomount pfile = …[path]

SQL> alter database mount;

SQL> alter database open;

Otherwise, exit current SQL*Plus session and verify the following environment variables are set.

echo $ORACLE_HOME

echo $ORACLE_SID (echo %ORACLE_SID% on Windows)

Then, Execute the following:

sqlplus / as sysdba

shutdown abort

exit

sqlplus / as sysdba

startup

如上官方资料所示，两种解决方案。关于第一种方案，简单梳理如下：

1：清理后台进程，一般找到相关进程后，使用kill命令杀掉。

2：清理共享内存段

3：清理信号集

注意，在RHEL 中， ipcs -sbt命令会报错”ipcs: invalid option — b”,这个是因为Linux上的ipcs命令，不支持UNIX上的-b，所以不能照本宣科，不要使用参数b. 具体参考官方文档ipcs man page describes invalid -b option in RHEL 5

4: 删除 sga and lk文件。

ipcs相关资料：

ipcs 命令往标准输出写入一些关于活动进程间通信设施的信息。如果没有指定任何标志，ipcs 命令用简短格式写入一些关于当前活动消息队列、共享内存段、信号量、远程队列和本地队列标题。

参考资料：

ORA-24324 During Startup or Shutdown (文档 ID 794293.1)

ORA-1089 During Shutdown Immediate (文档 ID 1014091.102)

shut immediate 数据库遭遇 ORA-24324 ORA-24323 参考学习

原文地址：https://www.cnblogs.com/daizhengyang/p/13396070.html

版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至举报，一经查实，本站将立刻删除。
转载请注明出处: https://daima100.com/6999.html

shut immediate 数据库遭遇 ORA-24324 ORA-24323 参考学习

相关推荐

发表回复