Coba check symptoms berikut. : When running the following as root at local host: $ORACLE_HOME/sqlplus userid/pw - gets the following error:
ORA-12546: TNS:permission denied But $ORACLE_HOME/sqlplus userid/[EMAIL PROTECTED] - works successfully. apakah sesuai dengan keadaan Anda? Kalo iya...do the following -- To implement the solution, please execute the following steps:: Change your directory to: $ cd $ORACLE_HOME/install Run changePerm.sh and specify the patched server Oracle home location, before accessing client-side utilities or libraries in the database home. Semua di atas dari metalink. On 18/02/2008, 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] <indo-oracle%40yahoogroups.com> [mailto: > [email protected] <indo-oracle%40yahoogroups.com>] On > Behalf Of Yoel Susanto > Sent: Monday, February 18, 2008 11:11 AM > To: [email protected] <indo-oracle%40yahoogroups.com> > 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] <edwin%40reindo.co.id>> > 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><indo-oracle%40yahoogroups.com> [mailto: > > [email protected] > > <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com>] On > > Behalf Of Yoel Susanto > > Sent: Monday, February 18, 2008 10:44 AM > > To: [email protected] > > <indo-oracle%40yahoogroups.com><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><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] > > > > [Non-text portions of this message have been removed]
