Tidak bisa pak...... [EMAIL PROTECTED] backup]# sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 18 10:15:07 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn reins/oracle ERROR: ORA-12546: TNS:permission denied
SQL> Sedang set env di root sudah saya tambah seperti ini: 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 ________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Yoel Susanto Sent: Monday, February 18, 2008 11:11 AM To: [email protected] Subject: Re: [indo-oracle] cron Job scheduler seperti email saya yang sebelumnya pak. Coba di test apakah dengan user ROOT anda bisa login menggunakan sqlplus sqlplus reins/oracle On 18/02/2008, Edwin Setiawan <[EMAIL PROTECTED]> wrote: > > 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] <indo-oracle%40yahoogroups.com> [mailto: > [email protected] <indo-oracle%40yahoogroups.com>] On > Behalf Of Yoel Susanto > Sent: Monday, February 18, 2008 10:44 AM > To: [email protected] <indo-oracle%40yahoogroups.com> > 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] <unsubscribe%40yahoogroups.com> > <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] > > > [Non-text portions of this message have been removed]
