Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle10G error!!!!

Re: Oracle10G error!!!!

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 28 Oct 2004 17:25:16 -0700
Message-ID: <1099009456.250966@yasure>


Praveen wrote:

> 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

What is in your alert log?
Is it XP Pro or Home?
Have you checked metalink?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Oct 28 2004 - 19:25:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US