Dear Wisnu, Coba eksekusi command tnsping alias_name_db -> hasilnya gimana ?
Regards, Defry --- On Sun, 12/27/09, wisnu dwi hidayat <[email protected]> wrote: From: wisnu dwi hidayat <[email protected]> Subject: [indo-oracle] ORA-01034: ORACLE not available To: [email protected] Date: Sunday, December 27, 2009, 11:01 PM 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] Reply to sender | Reply to group Messages in this topic (7) Recent Activity: New Members 20 Visit Your Group [Non-text portions of this message have been removed]
