ORA-01092 ORA-12432: LBAC error: zllegnp: OCIStmtExecute fault case recently due to the database hang live, helpless directly killed the pmon process, once again started received the ORA-01092: ORACLE instance terminated. disconnection forced and ORA-12432: LBAC error: zllegnp: OCIStmtExecute. Well, it's an error that has never been encountered. The following describes and solves this error. 1. fault description
Idle> startupORACLE instance started. total System Global Area 238530560 bytesFixed Size 1335724 bytesVariable Size 167775828 bytesDatabase Buffers 62914560 bytesRedo Buffers 6504448 bytesDatabase mounted. ORA-01092: ORACLE instance terminated. disconnection forcedORA-12432: LBAC error: zllegnp: OCIStmtExecuteProcess ID: 10704 Session ID: 125 Serial number: 52, fault analysis-first look at the prompts of a few ORA said what [oracle @ linux1 ~] $ Oerr ora 109201092,000 00, "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. -- the preceding ora 1092 is usually caused by shutdown abort. You need to check alert. Log [oracle @ linux1 ~] $ Oerr ora 1243212432,000 00, "LBAC error: % s" // * Cause: LBAC enforcement resulted in an error. // * Action: Correct the problem identified in the error message. -- the preceding ora 12432 error is about LBAC. -- view the alert Log and the trace file generated by it. $ tail-fn 50/u02/database/usbo/diag/rdbms/usbo/trace /alert_usbo.logTue Sep 03 14:58:39 2013ARC3 started with pid = 29, OS id = 10716 SMON: enabling cache recoveryArchived Log entry 53 added f Or 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 completedSMON: enabling tx recoveryDatabase Characterset is AL32UTF8No Resource Manager plan activeErrors in file/u02/database/usbo/diag/rdbms/usbo/trace/usbo_ora_10704.trc: ORA- 12432: LBAC error: zllegnp: OCIStmtExecuteErrors in file/u02/database/usbo/diag/rdbms/usbo/trace/usbo_ora_10704.trc: ORA-12432: LBAC error: zllegnp: OCIStmtExecuteError 12432 happened during db open, shutting down databaseUSER (ospid: 10704): terminating the instance due to error 12432 Instance terminated by USER, pid = 10704ORA-1092 signalled during: alter database open... opiodr aborting proces S unknown ospid (10704) as a result of ORA-1092Tue Sep 03 14:58:40 2013ORA-1092: opitsk aborting process $ tail-10/u02/database/usbo/diag/rdbms/usbo/trace/usbo_ora_10704.trc Avg compares per lookup = 173/173 = 1.0 parse resets sets nab of thread 1 seq 57 to 72 with 8 zeroblks *** 14:58:39. 830ORA-12432: LBAC error: zllegnp: OCIStmtExecuteORA- 12432: LBAC error: zllegnp: OCIStmtExecute *** 14:58:39. 830 USER (ospid: 10704): terminating the instance due to error 12432 -- the above information is relatively general, some are difficult to confirm, query metalink, found solution -- ORA-01092 ORA-12432 lbac error zllegnp While Starting Up An Instance (Doc ID 735801.1) -- although The Version range is Oracle Database-Enterprise Edition-Version 11.1.0.6 to 11.1.0.6 [Release 11.1], my Version 11.2 is still applicable-The reason why Oracle cannot start 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. troubleshooting -- solutions provided by 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 ChengStep 2 $ sqlplus "/as sysdba" SQL> startup migrateSQL> @? /Rdbms/admin/catnools. sqlSQL> shutdown immediateSQL> startupSQL> select * from v $ version where rownum <2; BANNER implements Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production