重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-12432: LBAC error: zllegnp:OCIStmtExecute [打印本页]

作者: 郑全 时间: 2023-2-8 12:57
标题: ORA-12432: LBAC error: zllegnp:OCIStmtExecute
操作系统无法登录，硬关机重启后，无法启动数据库，报：

。。。
ORA-01092: ORACLE instance terminated. Disconnection forced

看报警文件，有以下内容：

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

$ 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

搜MOS上，有一篇文档：ORA-01092 ORA-12432 LBAC ERROR ZLLEGNP While Starting Up An Instance (Doc ID 735801.1)

提到这个问题，

原因是：

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.

解决办法：

1.关闭 lbac

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk lbac_off ioracle

2.重新创建 ols
$ sqlplus "/ as sysdba"
SQL> startup migrate
SQL> @?/rdbms/admin/catnools.sql
SQL> shutdown immediate
SQL> startup

我按这个操作了，再次打开，还是起不起来

我的环境为：oracle10.2.0.5 + Linux6.5 ,mos 上的环境为oracle 11g,也没有 catnools.sql 文件，是catol.sql,
解决办法：
  SQL> startup migrate
  SQL> DROP USER LBACSYS CASCADE;
  SQL> @?/rdbms/admin/catol.sql
  SQL> shutdown immediate
  SQL> startup

可以成功的打开数据库。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)