ORA-12432: LBAC error: zllegnp:OCIStmtExecute

博客内容描述了在启动 Oracle 10g 数据库时遇到 ORA-12432 错误的问题,该错误是由于 Label Security(LBAC)元数据不完整导致的。解决方案包括禁用 LBAC 选项,通过执行特定 SQL 命令清理并重新初始化数据库,以及删除用户 LBACSYS。经过这些步骤,数据库成功启动。
摘要由CSDN通过智能技术生成

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%)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值