Mas Wisnu, Error tersebut terjadi karena masalah ukuran SGA.
SGA nya dikecilin aja. Karena memory anda 2GB, maka SGA nya buat menjadi maksimal 80% nya, awalnya: PROD.__sga_target= 2097152000 ==> lebih kurang 97% dari Physical RAM menjadi: PROD.__sga_target= 1717986918 ==> lebih kurang 80% dari Physical RAM Cheers, Wadi Achmed On Mon, Dec 28, 2009 at 2:01 PM, wisnu dwi hidayat <[email protected]>wrote: > Dear Masters & Members, > > Mohon bantuannya... saya sedang restore database di PC biasa (untuk testing > aja) dengan memory 2GB, Oracle11g (OS RHEL5) dan saya mengalami error > seperti berikut ketika saya shutdown immadiate dari sqlplus... tapi kalo di > shutdown abort bisa.. > > ORA-01034: ORACLE not available > ORA-27101: shared memory realm does not exist > > Padahal oracle telah terinstall dengan baik tanpa error, listener juga > sudah ok.. > > Adapun konfigurasi initSID.ora sebagai berikut; > > PROD.__db_cache_size=570425344 > PROD.__java_pool_size=16777216 > PROD.__large_pool_size=16777216 > PROD.__oracle_base='/OraHome/oracle11g'#ORACLE_BASE set from environment > PROD.__pga_aggregate_target=637534208 > PROD.__sga_target= 2097152000 > PROD.__shared_io_pool_size=0 > #PROD.__shared_pool_size=500M > PROD.__streams_pool_size=0 > *.audit_file_dest='/OraHome/oracle11g/product/11.1.0/db_1/rdbms/audit' > *.audit_trail='db' > *.compatible='11.1.0.0.0' > > *.control_files='/disk1/oradata/PROD/control01.ctl','/disk2/oradata/PROD/control02.ctl' > *.db_block_size=8192 > *.db_domain='' > *.db_name='PROD' > *.diagnostic_dest='/OraHome/oracle11g' > *.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODXDB)' > *.log_archive_dest_1='LOCATION=/disk2/oradata/archive' > *.log_archive_format='ARC%t_%s_%r.dbf' > #*.memory_max_target=1073741824 > #*.memory_target=1073741824 > *.open_cursors=1000 > *.processes=1000 > *.remote_login_passwordfile='EXCLUSIVE' > *.sessions=665 > *.undo_tablespace='UNDOTBS2' > *.db_file_multiblock_read_count=128 > *.filesystemio_options=SETALL > #*.parallel_server=true > *.DB_BLOCK_BUFFERS=2097152 > *.SHARED_POOL_SIZE=600M > *.USE_INDIRECT_DATA_BUFFERS=TRUE > > Mohon bantuannya sekali lagi dimana yg perlu di benahi...? > > Salam, > > Wisnu > ~Newbie~ > > > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > > > [Non-text portions of this message have been removed]
