trima kasih mas wisnu... mas sy pake oracle 10g di rhel5...itu sm aja kan script'y...hm klo gk ada oratab'y mungkin sy salah x install'y...akan sy coba lagi...^^
2010/1/6 wisnu dwi hidayat <[email protected]> > > > Dear Mas Arie, > > Mas saya juga pakai RHEL5, ada kok /etc/oratab... Berikut langkah2 yg sy > gunakan; > > 1. Edit /etc/oratab > > vi /etc/oratab > > contohnya seperti berikut; > > # This file is used by ORACLE utilities. It is created by root.sh > # and updated by the Database Configuration Assistant when creating > # a database. > > # A colon, ':', is used as the field terminator. A new line terminates > # the entry. Lines beginning with a pound sign, '#', are comments. > # > # Entries are of the form: > $ORACLE_SID:$ORACLE_HOME:<N|Y>:Y <=====(beritanda Y dan remarks "#" di > depan sebelum tanda dollar "$" dihilangkan) > > # atau ALTERNATIVE LAIN juga bisa dengan kita menuliskan langsung ORACLE > SID dan ORACLE_HOME nya... CONTOH; > > PROD:/OraHome/oracle11g/product/11.1.0/db_1:Y <======== (ini contoh lho) > > # The first and second fields are the system identifier and home > # directory of the database respectively. The third filed indicates > # to the dbstart utility that the database should , "Y", or should not, > # "N", be brought up at system boot time. > # > # Multiple entries with the same $ORACLE_SID are not allowed. > # > > 2. Langkah berikutnya Tambahkan pula script auto startup dan shutdown > > Sebagai user oracle, pastikan dbstart dan dbshut ada (available) > which dbstart > which dbshut > > Kemudian coba buat init script, > vi /etc/init..d/dbora > contoh isinya seperti berikut, > #!/bin/sh > # chkconfig: 345 99 10 > # description: Oracle auto start-stop script. > # > # Set ORA_HOME to be equivalent to the $ORACLE_HOME > # from which you wish to execute dbstart and dbshut; > # > # Set ORA_OWNER to the user id of the owner of the > # Oracle database in ORA_HOME. > > ORA_HOME=/u01/11g/product/11.1.0/OraDb11g_home1 <==== (sesuaikan dg path > anda) > > ORA_OWNER=oracle <===== (sesuaikan dg yg anda miliki) > > if [ ! -f $ORA_HOME/bin/dbstart ] > then > echo "Oracle startup: cannot start" > exit > fi > > case "$1" in > 'start') > # Start the Oracle databases: > # The following command assumes that the oracle login > # will not prompt the user for any values > su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME" > ;; > 'stop') > # Stop the Oracle databases: > # The following command assumes that the oracle login > # will not prompt the user for any values > su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME" > ;; > esac > > setelah anda membuat script diatas save dan kemudian ikuti langkah berikut, > chmod 750 /etc/init.d/dbora > chkconfig --level 345 dbora on > > CATATAN: > Jangan lupa edit .bash_profile terlebih dahulu di /home/oracle dan > sesuaikan path ORACLE_HOME dan ORACLE_SID > > cd /home/oracle > > vi .bash_profile > > contohnya; > > # .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 > > Semoga membantu.. > Regards, > Wisnu > ~Newbie~ > > ________________________________ > From: arie sandy <[email protected] <zonearie%40gmail.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Mon, January 4, 2010 6:40:33 PM > Subject: Re: [indo-oracle] oracle di linux > > > mas ko gk ada ada ya /etc/oratab > apa sy harus buat dulu oratab'y di /etc secara manual.. > > Pada 4 Januari 2010 01:05, Wadi Achmed <wadiach...@gmail. com> menulis: > > > > > > > Hi Arie, > > > > Di /etc/oratab set column terakhir dari database instance yang mau auto > > start > > dengan Y. > > > > Cheers, > > Wadi Achmed > > > > > > On Sat, Jan 2, 2010 at 5:43 PM, arie sandy > > <[email protected]<zonearie%40gmail. com>> > > > wrote: > > > > > Halo semua, > > > > > > Mau tanya ... kan sy install oracle 10g di linux RHEL5...biar c > oracle'y > > > startup saat abis di restart sintax'y apa ya... > > > karna sy masih belajar...minta tutorial'y DBA dunk yang bhs indo aja > agar > > > mudah di mengerti... > > > > > > terima kasih semua...^^ > > > > > > > > > [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<indo-oracle- > unsubscribe% 40yahoogroups. 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] > > > > > > > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
