ORACLE_SID dan ORACLE_HOME sudah saya set di .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_HOME=/OraHome/oracle11g/product/11.1.0/db_1;export ORACLE_HOME
ORACLE_LIB_PATH=$ORACLE_HOME/lib;export ORACLE_LIB_PATH
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
ORACLE_SID=PROD;export ORACLE_SID
export PATH
kemudian saya check juga
[ora...@testing ~]$ env | grep ORACLE_SID
ORACLE_SID=PROD
[ora...@testing ~]$ env | grep ORACLE_HOME
ORACLE_HOME=/OraHome/oracle11g/product/11.1.0/db_1
Mohon koreksi dimana kekeliruannya...???
Salam,
Wisnu
________________________________
From: Mohammad Arief Pradipto <[email protected]>
To: [email protected]
Sent: Mon, December 28, 2009 2:13:16 PM
Subject: Re: External Email: --> [indo-oracle] ORA-01034: ORACLE not available
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
[Non-text portions of this message have been removed]
