Otdfbt

Multi tool use

Crime rates in a post-scarcity economy

How do I minimise waste on a flight?

Examples where existence is harder than evaluation

Do these creatures from the Tomb of Annihilation campaign speak Common?

When an electron around an atom drops to a lower state, is 100% of the energy converted to a photon?

logo selection for poster presentation

How to start your Starctaft II games vs AI immediatly?

Every group the homology of some space?

Opposite party turned away from voting when ballot is all opposing party

Did any early RISC OS precursor run on the BBC Micro?

My perfect evil overlord plan... or is it?

Using mean length and mean weight to calculate mean BMI?

Trying to understand a summation

What's an appropriate age to involve kids in life changing decisions?

Is there a reason why Turkey took the Balkan territories of the Ottoman Empire, instead of Greece or another of the Balkan states?

Add elements inside Array conditionally in JavaScript

Employee is self-centered and affects the team negatively

How to explain intravenous drug abuse to a 6-year-old?

Was Mohammed the most popular first name for boys born in Berlin in 2018?

How would an instant or sorcery with an effect that targets work with Feather?

Why is the episode called "The Last of the Starks"?

What's the difference between "ricochet" and "bounce"?

Gift for mentor after his thesis defense?

My parents are Afghan

In Aix , Deletion of oracle user is running by manually executing the script file, but working through contab file

script works manually but not in cron jobcrontab not running scheduled script fileexecuting a sh script from the cronscript executing perfectly in terminal but not in cronPython script succeeds manually but fails on crontabCron job is running but not executing entire scriptAIX diff not showing the content of a new fileWhere's the global inputrc file in AIX?New user added but having error in AIX 7.1While running oracle DBD::Oacle installation am getting this “Cannot find or open file: /lib32/crt0_64.o”

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

-2

i am trying to import data from production to dev environment.

i have created scheduler

1. for backup & data copy from production to dev


2. deletion of oracle user and import or database. through crontab jobs.

However i am facing difficulty in deleting the user through crontab file. manually is working by pressing the enter button in the script.

below is my crontab file details

#!/usr/bin/ksh

var1=`date +%Y%m%d`
sdate=`date`

#export ORACLE_HOME=/oracle/soft11gR2/11.2.0/bin

export PATH=$PATH:/oracle/soft11gR2/11.2.0/bin/bin

export ORACLE_HOME=/oracle/soft11gR2/11.2.0/bin

LOGFILE=/oracle/aaa/bbbimport1.log

echo " Copy Started Date - " $sdate >> $LOGFILE

export ORACLE_SID=qaws

sqlplus "/as sysdba"<<EOF

whenever sqlerror exit sql.sqlcode;

set echo off

set heading off

@123.sql;

exit;
EOF

@123.SQL-----contains

drop user test cascade;
drop user test cascade;

If any one has any resolution to this kind of problem, pls reply.

cron oracle aix

share|improve this question

edited Apr 29 at 14:05

Sven♦

88.1k10148202

asked Apr 29 at 14:01

uday kiranuday kiran

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please read in question ..deletion not working through crontab script
  
  – uday kiran
  Apr 29 at 14:02
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You could try and debug... Some ideas: linuxquestions.org/questions/programming-9/…
  
  – Lorinczy Zsigmond
  May 3 at 15:28
  

  
  
  
  

add a comment | 

-2

i am trying to import data from production to dev environment.

i have created scheduler

1. for backup & data copy from production to dev


2. deletion of oracle user and import or database. through crontab jobs.

However i am facing difficulty in deleting the user through crontab file. manually is working by pressing the enter button in the script.

below is my crontab file details

#!/usr/bin/ksh

var1=`date +%Y%m%d`
sdate=`date`

#export ORACLE_HOME=/oracle/soft11gR2/11.2.0/bin

export PATH=$PATH:/oracle/soft11gR2/11.2.0/bin/bin

export ORACLE_HOME=/oracle/soft11gR2/11.2.0/bin

LOGFILE=/oracle/aaa/bbbimport1.log

echo " Copy Started Date - " $sdate >> $LOGFILE

export ORACLE_SID=qaws

sqlplus "/as sysdba"<<EOF

whenever sqlerror exit sql.sqlcode;

set echo off

set heading off

@123.sql;

exit;
EOF

@123.SQL-----contains

drop user test cascade;
drop user test cascade;

If any one has any resolution to this kind of problem, pls reply.

cron oracle aix

share|improve this question

edited Apr 29 at 14:05

Sven♦

88.1k10148202

asked Apr 29 at 14:01

uday kiranuday kiran

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please read in question ..deletion not working through crontab script
  
  – uday kiran
  Apr 29 at 14:02
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You could try and debug... Some ideas: linuxquestions.org/questions/programming-9/…
  
  – Lorinczy Zsigmond
  May 3 at 15:28
  

  
  
  
  

add a comment | 

i am trying to import data from production to dev environment.

i have created scheduler

1. for backup & data copy from production to dev


2. deletion of oracle user and import or database. through crontab jobs.

However i am facing difficulty in deleting the user through crontab file. manually is working by pressing the enter button in the script.

below is my crontab file details

#!/usr/bin/ksh

var1=`date +%Y%m%d`
sdate=`date`

#export ORACLE_HOME=/oracle/soft11gR2/11.2.0/bin

export PATH=$PATH:/oracle/soft11gR2/11.2.0/bin/bin

export ORACLE_HOME=/oracle/soft11gR2/11.2.0/bin

LOGFILE=/oracle/aaa/bbbimport1.log

echo " Copy Started Date - " $sdate >> $LOGFILE

export ORACLE_SID=qaws

sqlplus "/as sysdba"<<EOF

whenever sqlerror exit sql.sqlcode;

set echo off

set heading off

@123.sql;

exit;
EOF

@123.SQL-----contains

drop user test cascade;
drop user test cascade;

If any one has any resolution to this kind of problem, pls reply.

cron oracle aix

share|improve this question

edited Apr 29 at 14:05

Sven♦

88.1k10148202

asked Apr 29 at 14:01

uday kiranuday kiran

1

#!/usr/bin/ksh

var1=`date +%Y%m%d`
sdate=`date`

#export ORACLE_HOME=/oracle/soft11gR2/11.2.0/bin

export PATH=$PATH:/oracle/soft11gR2/11.2.0/bin/bin

export ORACLE_HOME=/oracle/soft11gR2/11.2.0/bin

LOGFILE=/oracle/aaa/bbbimport1.log

echo " Copy Started Date - " $sdate >> $LOGFILE

export ORACLE_SID=qaws

sqlplus "/as sysdba"<<EOF

whenever sqlerror exit sql.sqlcode;

set echo off

set heading off

@123.sql;

exit;
EOF

drop user test cascade;
drop user test cascade;

share|improve this question

edited Apr 29 at 14:05

Sven♦

88.1k10148202

asked Apr 29 at 14:01

uday kiranuday kiran

1

share|improve this question

edited Apr 29 at 14:05

Sven♦

88.1k10148202

asked Apr 29 at 14:01

uday kiranuday kiran

1

edited Apr 29 at 14:05

Sven♦

88.1k10148202

edited Apr 29 at 14:05

Sven♦

88.1k10148202

asked Apr 29 at 14:01

uday kiranuday kiran

1

asked Apr 29 at 14:01

uday kiranuday kiran

1