Praveen wrote:
> 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
Personally ... and I can't remember why ... I'd use oradim to drop the
Oracle service and recreate it. Every time I've had this problem the
issue has been one of Window's services and this fixes it.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Oct 29 2004 - 21:04:06 CDT
