pak edwin, sekedar workaround aja nech, gmana klo mounting nya dbikin permanen aja.. saya jg pake gtu. jadi pas expnya gk perlu susah2 mounting dl pake user root, cukup lgs pake user oracle aja..
regards, [L] --- Edwin Setiawan <[EMAIL PROTECTED]> wrote: > 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 > === message truncated === ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs
