Script exp-nya seperti ini pak.
/u01/oracle/product/10.2.0/db_1/bin/exp reins/oracle file=/opt/backup/senin/oracle.dmp >>/opt/backup/bu.log 2>&1;; _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Yoel Susanto Sent: Monday, February 18, 2008 10:44 AM To: [email protected] Subject: Re: [indo-oracle] cron Job scheduler bisa kasih perintah export yang anda pake? On 18/02/2008, Edwin Setiawan <[EMAIL PROTECTED] <mailto:edwin%40reindo.co.id> co.id> wrote: > > Oia pak Yoel, > Ini error mesg kalau saya exp login root. > > EXP-00056: ORACLE error 12546 encountered > ORA-12546: TNS:permission denied > EXP-00000: Export terminated unsuccessfully > > Salam, > Edwin. > -----Original Message----- > From: indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com <indo-oracle%40yahoogroups.com> [mailto: > indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com <indo-oracle%40yahoogroups.com>] On > Behalf Of Yoel Susanto > Sent: Friday, February 15, 2008 5:11 PM > To: indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com <indo-oracle%40yahoogroups.com> > Subject: Re: [indo-oracle] cron Job scheduler > > Pak Edwin, > > Untuk jalan exp, user tidak perlu harus oracle. bisa pake root user. > Yang penting environment variablenya ter- set dengan betul. > > Kalo mau tetap dengan crontab, yah bisa diusahakan supaya root bisa export > database. > > Kalo mau dengan scheduler, saya anjurkan buat script simple yang cuman > create a file. > Lalu coba create job yang execute shell script tersebut. > Try to make sure your scheduler is set up properly first. > > Cheers, > > On 15/02/2008, Edwin Setiawan <[EMAIL PROTECTED] <mailto:edwin%40reindo.co.id> co.id <edwin%40reindo.co.id>> > wrote: > > > > Terima kasih pak yoel, > > Saya adalah newbie pak di oracle. Sebelumnya saya biasa pake Informix. > > Saya membuat script di shell seperti dibawah ini. > > Kalau dengan user oracle, script ini jalan pak. > > Masalahnya adalah, script ini harus jalan dengan user root. > > Karena akan saya taruh di cron, pak. > > KArena saya berencana setelah backup pakai exp, langsung dialakukan > remote > > tar dengan mounting > > Padahal untuk jalanin command exp, kita harus pake user oracle. > > > > Akhirnya saya akalin seperti ini, untuk expnya saya pakai em, sedang > > mountingnya pakai cron. > > Masalahnya pada saat saya lakukan dengan job scheduler, error yang > muncul > > adalah : > > Details > > ORA-27369: job of type EXECUTABLE failed with exit code: 255 > > STANDARD_ERROR="execve: Exec format error" > > > > Atau mungkin, bagaimana caranya untuk kasus seperti saya? Mungkin rekans > > yang lebih berpengalaman > > Dapat membantu saya... > > > > PATH=$PATH:$HOME/bin > > export PATH > > unset USERNAME > > ORACLE_HOME=/u01/oracle/product/10.2.0/db_1 > > ORACLE_BASE=/u01/oracle > > ORACLE_SID=orcl > > export ORACLE_HOME ORACLE_BASE ORACLE_SID > > PATH=$PATH:$HOME/bin:$ORACLE_HOME:$ORACLE_HOME/bin > > umask 022 > > > > z3=`date|cut -c1-3` > > x1=`date +%D|cut -c1-2` > > x2=`date +%D|cut -c4-5` > > x3=`date +%D|cut -c7-8` > > x4=$x3$x1$x2 > > date > /opt/backup/bu.log > > case $z3 in > > Mon)rm -rf /opt/backup/senin/oracle.dmp >>/opt/backup/data/bu.log 2>&1;; > > Tue)rm -rf /opt/backup/selasa/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > Wed)rm -rf /opt/backup/rabu/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > Thu)rm -rf /opt/backup/kamis/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > Fri)rm -rf /opt/backup/jumat/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > *)rm -rf /opt/backup/sabtu/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > esac > > sleep 30 > > case $z3 in > > Mon)/u01/oracle/product/10.2.0/db_1/bin/exp reins/oracle > > file=/opt/backup/senin/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > Tue)/u01/oracle/product/10.2.0/db_1/bin/exp reins/oracle > > file=/opt/backup/selasa/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > Wed)/u01/oracle/product/10.2.0/db_1/bin/exp reins/oracle > > file=/opt/backup/rabu/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > Thu)/u01/oracle/product/10.2.0/db_1/bin/exp reins/oracle > > file=/opt/backup/kamis/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > Fri)/u01/oracle/product/10.2.0/db_1/bin/exp reins/oracle > > file=/opt/backup/jumat/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > *)/u01/oracle/product/10.2.0/db_1/bin/exp reins/oracle > > file=/opt/backup/sabtu/oracle.dmp >>/opt/backup/bu.log 2>&1;; > > esac > > date >> /opt/backup/bu.log 2>&1 > > (cd /opt/backup/senin;chmod 777 *) > > (cd /opt/backup/selasa;chmod 777 *) > > (cd /opt/backup/rabu;chmod 777 *) > > (cd /opt/backup/kamis;chmod 777 *) > > (cd /opt/backup/jumat;chmod 777 *) > > (cd /opt/backup/sabtu;chmod 777 *) > > date >> /opt/backup/bu.log > > ##echo "Doing backup another machine .........." >> /opt/backup/bu.log > > ##/etc/mount oas:/datafile/bekap /sem > > ##sleep 3 > > ############# > > ##x5="/data/senin" > > ##if [ -d $x5 ] > > ##then > > ## case $z3 in > > ## Mon)(cd /sem/senin;rm -rf oracle.dmp);; > > ## Tue)(cd /sem/selasa;rm -rf oracle.dmp);; > > ## Wed)(cd /sem/rabu;rm -rf oracle.dmp);; > > ## Thu)(cd /sem/kamis;rm -rf oracle.dmp);; > > ## Fri)(cd /sem/jumat;rm -rf oracle.dmp);; > > ## esac > > ## case $z3 in > > ## Mon)(cd /opt/backup/senin;tar cvf - .)|(cd /sem/senin;tar xvf -);; > > ## Tue)(cd /opt/backup/selasa;tar cvf - .)|(cd /sem/selasa;tar xvf -);; > > ## Wed)(cd /opt/backup/rabu;tar cvf - .)|(cd /sem/rabu;tar xvf -);; > > ## Thu)(cd /opt/backup/kamis;tar cvf - .)|(cd /sem/kamis;tar xvf -);; > > ## Fri)(cd /opt/backup/jumat;tar cvf - .)|(cd /sem/jumat;tar xvf -);; > > ## esac > > ##else > > ## echo " Tar Harian ke busvr Error " >> /opt/backup/bu.log > > ##fi > > ##/etc/umount /sem > > date >> /opt/backup/bu.log 2>&1 > > > > ________________________________________ > > From: indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com> [mailto: > > indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com>] On > > Behalf Of Yoel Susanto > > Sent: Friday, February 15, 2008 11:04 AM > > To: indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com> > > Subject: Re: [indo-oracle] cron Job scheduler > > > > Pak Edwin, > > > > Akan lebih cepat kalo bapak menyertakan Error message atau informasi > lain > > yang membantu > > Daripada anda cuman dapat reply "apa error messagenya?" :) > > > > Coba check dahulu $ORACLE_HOME/rdbms/admin/externaljob.ora file > > apakah sudah di set seperti berikut. > > > > run_user = oracle > > run_group = dba > > > > Cheers, > > > > On 15/02/2008, Edwin Setiawan <[EMAIL PROTECTED] <mailto:edwin%40reindo.co.id> co.id <edwin%40reindo.co.id><edwin%40reindo.co.id>> > > wrote: > > > > > > Selamat siang, > > > Saya ingin membuat job pada oracle, yang fungsinya seperti cron. > > > Saya sudah buat file exekusinya, yang kalau kita jalankan lewat > prompt, > > > gak masalah. > > > Tapi, begitu saya masukin lewat scheduler job kok gak bisa ya apa saya > > > salah menu? > > > > > > Terima kasih > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > [Non-text portions of this message have been removed] > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: indo-oracle- <mailto:indo-oracle-unsubscribe%40yahoogroups.com> [EMAIL PROTECTED]<indo-oracle-unsubscribe%40yahoogroups.com> > Website: http://indooracle. <http://indooracle.wordpress.com> wordpress.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo- <http://indo-thin.blogspot.com> thin.blogspot.com > Yahoo! Groups Links > > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
