Re: Oracle10G error!!!!

Hi

If i connect from sqlplus prompt, it is working fine. but if java is trying to connect, then it is saying following error...

(java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select
/*+ rule */ bucket_cn...","Typecheck heap","kgghteInit")

What might be the problem?

praveen

spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0410282227.3c8f42ef_at_posting.google.com>...
> Hi,
>
> Thanks for response,
> Yes i have changed the large_pool_size to larger size.
> java_pool_size=20971520
> *.job_queue_processes=10
> *.large_pool_size=80971520
> *.open_cursors=300
> *.pga_aggregate_target=25165824
> *.processes=100
> *.remote_login_passwordfile='EXCLUSIVE'
> *.sessions=1105
> *.sga_target=167772160
> *.shared_pool_size=41457280
> *.sort_area_size=65536
>
> But, After changing, if restarte the database. Now, it is sayiing...
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
>
> Env varaibles, ORA_HOME and ORACLE_SID are set.
> And one more thing is it is createing log file in
> \oracle\product\10.1.0\db_1\database directory. The file contents are
> like ...
> An Unhandled Exception Occurred,
> Exception Number : 0xc0000005
> Exception Address : 0x6130975c
>
>
> fitzjarrell_at_cox.net (David Fitzjarrell) wrote in message news:<9711ade0.0410271424.792dfc9_at_posting.google.com>...
> > spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0410270503.e1021fa_at_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
> >
> > Your large pool is only 4 meg; increase its size and you should
> > eliminate the problem. Also, why are you using an 8k block size and a
> > db_file_multiblock_read_count of 16 on Windows? It should be 8.
> >
> > David Fitzjarrell
Received on Fri Oct 29 2004 - 08:56:03 CDT