ORA-01092 ORA-12432: LBAC error: zllegnp:OCIStmtExecute 故障一例

悠悠 2022-03-29 06:27 349阅读 0赞

最近由于数据库hang住，无奈之下直接干掉了pmon进程，再次启动的时候收到了ORA-01092: ORACLE instance terminated. Disconnection forced以及ORA-12432: LBAC error: zllegnp:OCIStmtExecute。这下好了，有的整了，是个从来没有遇见的错误。下面是对这个错误的描述与解决。

1、故障描述  
idle> startup  
ORACLE instance started.

Total System Global Area  238530560 bytes  
Fixed Size                  1335724 bytes  
Variable Size             167775828 bytes  
Database Buffers           62914560 bytes  
Redo Buffers                6504448 bytes  
Database mounted.  
ORA-01092: ORACLE instance terminated. Disconnection forced  
ORA-12432: LBAC error: zllegnp:OCIStmtExecute  
Process ID: 10704  
Session ID: 125 Serial number: 5

2、故障分析  
\--首先看看提示的几个ORA说什么  
\[oracle@linux1 ~\]$ oerr ora 1092  
01092, 00000, "ORACLE instance terminated. Disconnection forced"  
// \*Cause:  The instance this process was connected to was terminated  
//          abnormally, probably via a shutdown abort. This process  
//          was forced to disconnect from the instance.  
// \*Action: Examine the alert log for more details. When the instance has been  
//          restarted, retry action.  
\--上面的 ora 1092通常由于shutdown abort导致，需要查看alert日志

\[oracle@linux1 ~\]$ oerr ora 12432  
12432, 00000, "LBAC error: %s"  
// \*Cause:  LBAC enforcement resulted in an error.  
// \*Action: Correct the problem identified in the error message.  
\--上面ora 12432是关于LBAC的错误

\--下面查看alert日志及其产生的trace文件  
$ tail -fn 50 /u02/database/usbo/diag/rdbms/usbo/usbo/trace/alert\_usbo.log  
Tue Sep 03 14:58:39 2013  
ARC3 started with pid=29, OS id=10716  
SMON: enabling cache recovery  
Archived Log entry 53 added for thread 1 sequence 57 ID 0xcde7041e dest 1:  
Successfully onlined Undo Tablespace 2.  
Verifying file header compatibility for 11g tablespace encryption..  
Verifying 11g file header compatibility for tablespace encryption completed  
SMON: enabling tx recovery  
Database Characterset is AL32UTF8  
No Resource Manager plan active  
Errors in file /u02/database/usbo/diag/rdbms/usbo/usbo/trace/usbo\_ora\_10704.trc:  
ORA-12432: LBAC error: zllegnp:OCIStmtExecute  
Errors in file /u02/database/usbo/diag/rdbms/usbo/usbo/trace/usbo\_ora\_10704.trc:  
ORA-12432: LBAC error: zllegnp:OCIStmtExecute  
Error 12432 happened during db open, shutting down database  
USER (ospid: 10704): terminating the instance due to error 12432  
Instance terminated by USER, pid = 10704  
ORA-1092 signalled during: ALTER DATABASE OPEN...  
opiodr aborting process unknown ospid (10704) as a result of ORA-1092  
Tue Sep 03 14:58:40 2013  
ORA-1092 : opitsk aborting process

$ tail -10 /u02/database/usbo/diag/rdbms/usbo/usbo/trace/usbo\_ora\_10704.trc  
Avg compares per lookup = 173/173 = 1.0  
\----------------------------------------------  
Recovery sets nab of thread 1 seq 57 to 72 with 8 zeroblks

\*\*\* 2013-09-03 14:58:39.830  
ORA-12432: LBAC error: zllegnp:OCIStmtExecute  
ORA-12432: LBAC error: zllegnp:OCIStmtExecute

\*\*\* 2013-09-03 14:58:39.830  
USER (ospid: 10704): terminating the instance due to error 12432  
\--上面的这些信息比较笼统，有些不好确认，查询metalink，找到了解决方案  
\--ORA-01092 ORA-12432 LBAC ERROR ZLLEGNP While Starting Up An Instance (Doc ID 735801.1)  
\--尽管其版本范围是Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.6 \[Release 11.1\]，我的11.2版本依旧适用  
\--Oracle给出的无法启动的原因  
The issue happens because the OLS metadata is incomplete as a result of a shutdown abort executed while the script catnools.sql (or catols.sql)  was running.

3、故障解决  
\--Oracle给出的解决方案  
\--To solve this situation the LBAC option has to be disabled:  
Step 1  
  cd $ORACLE\_HOME/rdbms/lib  
  make -f ins\_rdbms.mk lbac\_off ioracle

\-- Author   : Robinson Cheng  
\-- Blog     : [http://blog.csdn.net/robinson\_0612][http_blog.csdn.net_robinson_0612]  
\-- DB Forum : [http://bbs.dbsupport.cn][http_bbs.dbsupport.cn]

Step 2  
$ sqlplus "/ as sysdba"  
SQL> startup migrate  
SQL> @?/rdbms/admin/catnools.sql  
SQL> shutdown immediate  
SQL> startup  
SQL> select \* from v$version where rownum<2;

BANNER  
\--------------------------------------------------------------------------------  
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

[![Oracle&nbsp;牛鹏社][Oracle_nbsp]][Oracle_nbsp_Oracle_nbsp]     专业数据库论坛：[http://bbs.dbsupport.cn][http_bbs.dbsupport.cn]

更多参考

有关Oracle RAC请参考  
     [使用crs\_setperm修改RAC资源的所有者及权限  
][crs_setperm_RAC_]     [使用crs\_profile管理RAC资源配置文件  
][crs_profile_RAC_]     [RAC 数据库的启动与关闭  
][RAC _]     [再说 Oracle RAC services  
][Oracle RAC services]     [Services in Oracle Database 10g  
][Services in Oracle Database 10g]     [Migrate datbase from single instance to Oracle RAC  
][Migrate datbase from single instance to Oracle RAC]     [Oracle RAC 连接到指定实例  
][Oracle RAC _]     [Oracle RAC 负载均衡测试(结合服务器端与客户端)  
][Oracle RAC _ 1]     [Oracle RAC 服务器端连接负载均衡(Load Balance)  
][Oracle RAC _Load Balance_]     [Oracle RAC 客户端连接负载均衡(Load Balance)  
][Oracle RAC _Load Balance_ 1]     [ORACLE RAC 下非缺省端口监听配置(listener.ora tnsnames.ora)][ORACLE RAC _listener.ora tnsnames.ora]  
     [ORACLE RAC 监听配置 (listener.ora tnsnames.ora)  
][ORACLE RAC _ _listener.ora tnsnames.ora_]     [配置 RAC 负载均衡与故障转移  
][RAC _ 1]     [CRS-1006 , CRS-0215 故障一例][CRS-1006 _ CRS-0215]   
     [基于Linux (RHEL 5.5) 安装Oracle 10g RAC][Linux _RHEL 5.5_ _Oracle 10g RAC]  
     [使用 runcluvfy 校验Oracle RAC安装环境][runcluvfy _Oracle RAC]

有关Oracle 网络配置相关基础以及概念性的问题请参考：  
     [配置非默认端口的动态服务注册][Link 1]  
     [配置sqlnet.ora限制IP访问Oracle  
][sqlnet.ora_IP_Oracle]     [Oracle 监听器日志配置与管理][Oracle]  
     [设置 Oracle 监听器密码(LISTENER)  
][Oracle _LISTENER_]     [配置ORACLE 客户端连接到数据库][ORACLE]

有关基于用户管理的备份和备份恢复的概念请参考  
     [Oracle 冷备份  
][Oracle _]     [Oracle 热备份  
][Oracle _ 1]     [Oracle 备份恢复概念  
][Oracle _ 2]     [Oracle 实例恢复  
][Oracle _ 3]     [Oracle 基于用户管理恢复的处理  
][Oracle _ 4]     [SYSTEM 表空间管理及备份恢复  
][SYSTEM _]     [SYSAUX表空间管理及恢复  
][SYSAUX_]     [Oracle 基于备份控制文件的恢复(unsing backup controlfile)][Oracle _unsing backup controlfile]

有关RMAN的备份恢复与管理请参考  
     [RMAN 概述及其体系结构  
][RMAN _]     [RMAN 配置、监控与管理  
][RMAN _ 1]     [RMAN 备份详解  
][RMAN _ 2]     [RMAN 还原与恢复  
][RMAN _ 3]     [RMAN catalog 的创建和使用  
][RMAN catalog _]     [基于catalog 创建RMAN存储脚本  
][catalog _RMAN_]     [基于catalog 的RMAN 备份与恢复  
][catalog _RMAN _]     [RMAN 备份路径困惑  
][RMAN _ 4]     [使用RMAN实现异机备份恢复(WIN平台)  
][RMAN_WIN_]     [使用RMAN迁移文件系统数据库到ASM  
][RMAN_ASM]     [linux 下RMAN备份shell脚本  
][linux _RMAN_shell_]     [使用RMAN迁移数据库到异机][RMAN]

有关ORACLE体系结构请参考  
     [Oracle 表空间与数据文件  
][Oracle _ 5]     [Oracle 密码文件  
][Oracle _ 6]     [Oracle 参数文件  
][Oracle _ 7]     [Oracle 联机重做日志文件(ONLINE LOG FILE)  
][Oracle _ONLINE LOG FILE_]     [Oracle 控制文件(CONTROLFILE)  
][Oracle _CONTROLFILE_]     [Oracle 归档日志  
][Oracle _ 8]     [Oracle 回滚(ROLLBACK)和撤销(UNDO)  
][Oracle _ROLLBACK_UNDO_]     [Oracle 数据库实例启动关闭过程  
][Oracle _ 9]     [Oracle 10g SGA 的自动化管理  
][Oracle 10g SGA _]     [Oracle 实例和Oracle数据库(Oracle体系结构)][Oracle _Oracle_Oracle]

[http_blog.csdn.net_robinson_0612]: http://blog.csdn.net/robinson_0612
[http_bbs.dbsupport.cn]: http://bbs.dbsupport.cn
[Oracle_nbsp]: http://pub.idqqimg.com/wpa/images/group.png
[Oracle_nbsp_Oracle_nbsp]: http://wp.qq.com/wpa/qunwpa?idkey=63ed41c9a94b48ebc4d3d956537065ba6d18a649c353b09bfdac284518b7b8d8
[crs_setperm_RAC_]: http://blog.csdn.net/robinson_0612/article/details/8219242
[crs_profile_RAC_]: http://blog.csdn.net/robinson_0612/article/details/8192571
[RAC _]: http://blog.csdn.net/robinson_0612/article/details/8129506
[Oracle RAC services]: http://blog.csdn.net/robinson_0612/article/details/8124232
[Services in Oracle Database 10g]: http://blog.csdn.net/robinson_0612/article/details/8089812
[Migrate datbase from single instance to Oracle RAC]: http://blog.csdn.net/robinson_0612/article/details/8090095
[Oracle RAC _]: http://blog.csdn.net/robinson_0612/article/details/8073620
[Oracle RAC _ 1]: http://blog.csdn.net/robinson_0612/article/details/8072367
[Oracle RAC _Load Balance_]: http://blog.csdn.net/robinson_0612/article/details/8064599
[Oracle RAC _Load Balance_ 1]: http://blog.csdn.net/robinson_0612/article/details/8060634
[ORACLE RAC _listener.ora tnsnames.ora]: http://blog.csdn.net/robinson_0612/article/details/8053007
[ORACLE RAC _ _listener.ora tnsnames.ora_]: http://blog.csdn.net/robinson_0612/article/details/8020800
[RAC _ 1]: http://blog.csdn.net/robinson_0612/article/details/6791667
[CRS-1006 _ CRS-0215]: http://blog.csdn.net/robinson_0612/article/details/7926241
[Linux _RHEL 5.5_ _Oracle 10g RAC]: http://blog.csdn.net/robinson_0612/article/details/7906282
[runcluvfy _Oracle RAC]: http://blog.csdn.net/robinson_0612/article/details/6533094
[Link 1]: http://blog.csdn.net/robinson_0612/article/details/5925526
[sqlnet.ora_IP_Oracle]: http://blog.csdn.net/robinson_0612/article/details/6629141
[Oracle]: http://blog.csdn.net/robinson_0612/article/details/6629043
[Oracle _LISTENER_]: http://blog.csdn.net/robinson_0612/article/details/6629249
[ORACLE]: http://blog.csdn.net/robinson_0612/article/details/5917103
[Oracle _]: http://blog.csdn.net/robinson_0612/article/details/5791597
[Oracle _ 1]: http://blog.csdn.net/robinson_0612/article/details/5816012
[Oracle _ 2]: http://blog.csdn.net/robinson_0612/article/details/5791585
[Oracle _ 3]: http://blog.csdn.net/robinson_0612/article/details/5768233
[Oracle _ 4]: http://blog.csdn.net/robinson_0612/article/details/6041217
[SYSTEM _]: http://blog.csdn.net/robinson_0612/article/details/6041207
[SYSAUX_]: http://blog.csdn.net/robinson_0612/article/details/5810732
[Oracle _unsing backup controlfile]: http://blog.csdn.net/robinson_0612/article/details/7962187
[RMAN _]: http://blog.csdn.net/robinson_0612/article/details/6032525
[RMAN _ 1]: http://blog.csdn.net/robinson_0612/article/details/6032597
[RMAN _ 2]: http://blog.csdn.net/robinson_0612/article/details/6032739
[RMAN _ 3]: http://blog.csdn.net/robinson_0612/article/details/6041247
[RMAN catalog _]: http://blog.csdn.net/robinson_0612/article/details/6043649
[catalog _RMAN_]: http://blog.csdn.net/robinson_0612/article/details/6073020
[catalog _RMAN _]: http://blog.csdn.net/robinson_0612/article/details/6073069
[RMAN _ 4]: http://blog.csdn.net/robinson_0612/article/details/6414338
[RMAN_WIN_]: http://blog.csdn.net/robinson_0612/article/details/6639064
[RMAN_ASM]: http://blog.csdn.net/robinson_0612/article/details/6453954
[linux _RMAN_shell_]: http://blog.csdn.net/robinson_0612/article/details/8029245
[RMAN]: http://blog.csdn.net/robinson_0612/article/details/8076841
[Oracle _ 5]: http://blog.csdn.net/robinson_0612/article/details/5611738
[Oracle _ 6]: http://blog.csdn.net/robinson_0612/article/details/5611672
[Oracle _ 7]: http://blog.csdn.net/robinson_0612/article/details/5559174
[Oracle _ONLINE LOG FILE_]: http://blog.csdn.net/robinson_0612/article/details/5749556
[Oracle _CONTROLFILE_]: http://blog.csdn.net/robinson_0612/article/details/5737527
[Oracle _ 8]: http://blog.csdn.net/robinson_0612/article/details/5784713
[Oracle _ROLLBACK_UNDO_]: http://blog.csdn.net/robinson_0612/article/details/5731158
[Oracle _ 9]: http://blog.csdn.net/robinson_0612/article/details/5542983
[Oracle 10g SGA _]: http://blog.csdn.net/robinson_0612/article/details/5534832
[Oracle _Oracle_Oracle]: http://blog.csdn.net/robinson_0612/article/details/5529239