Re: Oracle10G error!!!!

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 - 01:27:02 CDT