1,在启库的时候报ORA-12432: LBAC error: zllegnp:OCIStmtExecute
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
Thu Feb 21 09:45:52 EST 2013
Errors in file /paic/app/oracle/admin/vmdev/udump/vmdev_ora_5885.trc:
ORA-12432: LBAC error: zllegnp:OCIStmtExecute
Error 12432 happened during db open, shutting down database
USER: terminating instance due to error 12432
Instance terminated by USER, pid = 5885
ORA-1092 signalled during: ALTER DATABASE OPEN...
Trace文件内容:
[vm10g@Test-Dev9-026_OssDB bdump]$ more /paic/app/oracle/admin/vmdev/udump/vmdev_ora_5885.trc
/paic/app/oracle/admin/vmdev/udump/vmdev_ora_5885.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /paic/app/oracle/product
System name: Linux
Node name: Test-Dev9-026_OssDB
Release: 2.6.18-308.el5
Version: #1 SMP Fri Jan 27 17:17:51 EST 2012
Machine: x86_64
Instance name: vmdev
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 5885, image: oracle@Test-Dev9-026_OssDB (TNS V1-V3)
Warning: keltnfy call to ldmInit failed with error 46
*** ACTION NAME:() 2013-02-21 09:45:52.098
*** MODULE NAME:(sqlplus@Test-Dev9-026_OssDB (TNS V1-V3)) 2013-02-21 09:45:52.09
8
*** SERVICE NAME:() 2013-02-21 09:45:52.098
*** SESSION ID:(324.3) 2013-02-21 09:45:52.098
Thread 1 checkpoint: logseq 78, block 674, scn 317783
start recovery at logseq 78, block 674, scn 317783
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 28Kb in 0.02s => 1.39 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/75 (0%)
Longest LWN: 3Kb, moves: 0/26 (0%)