database nya ud d STARTUP atau belum??
________________________________ Dari: Wadi Achmed <[email protected]> Kepada: [email protected] Terkirim: Sen, 28 Desember, 2009 15:13:26 Judul: Re: [indo-oracle] ORA-01034: ORACLE not available 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 <wisnu...@yahoo. com>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_aggregat e_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=107374182 4 > #*.memory_target= 1073741824 > *.open_cursors= 1000 > *.processes= 1000 > *.remote_login_ passwordfile= 'EXCLUSIVE' > *.sessions=665 > *.undo_tablespace= 'UNDOTBS2' > *.db_file_multibloc k_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: indo-oracle- unsubscribe@ yahoogroups. com > Website: http://indooracle. wordpress. com > http://www.facebook .com/group. php?gid=51973053 515 > ------------ --------- --------- --------- -------- > > 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] ___________________________________________________________________________ Dapatkan nama yang Anda sukai! Sekarang Anda dapat memiliki email di @ymail.com dan @rocketmail.com. http://mail.promotions.yahoo.com/newdomains/id/ [Non-text portions of this message have been removed]
