Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-27100: shared memory realm already exists

650105Aug 11 2009 — edited Aug 11 2009

i'm getting this problem i have change SGA_MAX_SIZE in spfile i got this error now i' have change value in initi .ora but error still presist i have 6gb ram and i only assing 800mb but this error occur again and again plz help my initi .ora is below and database is 9i

*.aq_tm_processes=1
*.background_dump_dest='E:\oracle\admin\ora9\bdump'
*.compatible='9.2.0.0.0'
*.control_files='E:\oracle\oradata\ora9\CONTROL01.CTL','E:\oracle\oradata\ora9\CONTROL02.CTL','E:\oracle\oradata\ora9\CONTROL03.CTL'
*.core_dump_dest='E:\oracle\admin\ora9\cdump'
*.db_block_size=8192

*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16

*.db_name='ora9'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ora9XDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='ora9'
*.java_pool_size=33554432
*.job_queue_processes=10

*.large_pool_size=8388608

*.open_cursors=300

*.pga_aggregate_target=25165824

*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648

*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='E:\oracle\admin\ora9\udump'
*.utl_file_dir='e:\userfiles'
*.sga_max_size=854288000

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2009

Added on Aug 11 2009

#general-database-discussions

2 comments

632 views