Saya pernah kejadian seperti ini dulu ada beberapa sebab: 1. environment ORACLE_SID atau ORACLE_HOME tidak ada / belum disetting 2. settingan SGA tidak benar, bisa jadi terlalu kecil atau justru lebih besar dari memory fisik yang ada
Hope this helps, regards, adipt ----- Original Message ----- From: wisnu dwi hidayat<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Sent: Monday, December 28, 2009 2:01 PM Subject: External Email: --> [indo-oracle] ORA-01034: ORACLE not available 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] ________________________________ Mulai 1 januari 2010 PT. Federal International Finance menempati gedung baru MENARA FIF - Jl. TB. Simatupang Kav. 15, Cilandak Barat Jakarta 12340, Telp: (021) 769 8899, Fax: (021) 7590 5599 [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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
