Oracle10G error!!!!

From: Praveen <spraveen2001_at_yahoo.com>
Date: 27 Oct 2004 06:03:59 -0700
Message-ID: <98d8ec76.0410270503.e1021fa@posting.google.com>

Hi All,

I'm using Oracle 10g on Win Xp system SP2. I have the following entries in spfile.ora file:

  processes                = 100
  sessions                 = 1105


  __shared_pool_size       = 117440512

  shared_pool_size         = 33554432


  __large_pool_size        = 20971520

  large_pool_size          = 4194304


  __java_pool_size         = 20971520

  java_pool_size           = 20971520
  sga_target               = 167772160
  control_files            =
D:\ORACLE\PRODUCT\10.1.0\DB_1\FISDB10G\CONTROL01.CTL,

D:\ORACLE\PRODUCT\10.1.0\DB_1\FISDB10G\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.1.0\DB_1\FISDB10G\CONTROL03.CTL

  db_block_size            = 8192


  __db_cache_size          = 4194304

  compatible               = 10.1.0.2.0
  db_file_multiblock_read_count= 16

  db_recovery_file_dest =
D:\oracle\product\10.1.0\flash_recovery_area   db_recovery_file_dest_size= 2147483648

  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  global_names             = FALSE
  dispatchers              = (protocol=TCP)
  utl_file_dir             = d:\temp
  job_queue_processes      = 10
  background_dump_dest     =
D:\ORACLE\PRODUCT\10.1.0\ADMIN\FISDB10G\BDUMP
  user_dump_dest           =
D:\ORACLE\PRODUCT\10.1.0\ADMIN\FISDB10G\UDUMP
  core_dump_dest           =
D:\ORACLE\PRODUCT\10.1.0\ADMIN\FISDB10G\CDUMP
  sort_area_size           = 65536
  db_name                  = fisdb10g
  open_cursors             = 300
  pga_aggregate_target     = 25165824

I'm getting the following error frequently. And around 35 programmers will connect daily.

ORA-00604: error occurred at recursive SQL level 1 ORA-12414: internal LBAC error: zllcsi:OCIStmtExecute  Error: ORA-04031: unable to allocate 64088 bytes of shared memory ("large pool","unknown object","session heap","kksfal:1:frame segment")

ORA-06512: at "LBACSYS.LBAC_CACHE", line 99
ORA-06512: at "LBACSYS.LBAC_EVENTS", line 74
ORA-06512: at line 2

Can anybody help me why this error is coming?

Thanks,
Praveen Received on Wed Oct 27 2004 - 08:03:59 CDT