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]
