Home » RDBMS Server » Server Administration » export scheduling problem
export scheduling problem [message #202767] Sun, 12 November 2006 02:54 Go to next message
khosravi
Messages: 68
Registered: April 2006
Member

hello
please say to me what methods exists for scheduling export(expdp or exp)
and what is beter

i have tried to use dbms_scheduler package for scheduling export but i don't succeed
i even maked shell file (under linux) with below content

sh1.sh
******************************************************
* time > test.txt *
* exp ali/ali120@products file=/home/oracle/exp1.dmp *
* *
******************************************************

and i created EXECUTABLE job by dbms_scheduler that execute sh1.sh when the job run
the first line of sh1.sh (time > test.txt) execute fine but second line (exp ali/...)
dont execute


Re: export scheduling problem [message #202769 is a reply to message #202767] Sun, 12 November 2006 04:31 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Before scheduling a script, first make sure that the script works fine..here the script itself is not working so that should be tackled first. To do that, try to execute the script manually and post what errors you are getting at the second line of the script.

Re: export scheduling problem [message #202776 is a reply to message #202769] Sun, 12 November 2006 05:48 Go to previous messageGo to next message
khosravi
Messages: 68
Registered: April 2006
Member
i have tested my script that work fine manually
Re: export scheduling problem [message #202785 is a reply to message #202776] Sun, 12 November 2006 11:38 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

@khosravi
Please post the errors that you are getting.
Re: export scheduling problem [message #202786 is a reply to message #202767] Sun, 12 November 2006 11:55 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
It could be that the script is lacking environmental variables.
Re: export scheduling problem [message #202958 is a reply to message #202786] Mon, 13 November 2006 07:29 Go to previous message
khosravi
Messages: 68
Registered: April 2006
Member
error code is:
---------------------------------------------------
SQL> execute dbms_scheduler.run_job('EXP_JOB09');
BEGIN dbms_scheduler.run_job('EXP_JOB09'); END;

*
ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit code: 32512
ORA-06512: at "SYS.DBMS_ISCHED", line 148
ORA-06512: at "SYS.DBMS_SCHEDULER", line 374
ORA-06512: at line 1
-------------------------------------------------


if you think problem is environmental variables
please say that whitch environmental variables must be set
Previous Topic: OMS
Next Topic: NLS LANG setting
Goto Forum:
  


Current Time: Thu Dec 08 10:43:29 CST 2016

Total time taken to generate the page: 0.10349 seconds