topic Re: issue cron when execute script the dump Oracle. in Operating System - HP-UX

issue cron when execute script the dump Oracle.

Claudemir Franco — Fri, 23 Feb 2007 13:41:13 GMT

Hi, people

I have a problem in the cron when execute a script the dump. I get the following error:
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
EXP-00002: error in writing to export fileerror closing export file /tmp/export_rateprd1_pipe
EXP-00000: Export terminated unsuccessfully

I found the thread http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=945790
but unsuccessfully.

any ideas?

Tks.

Claudemir.

Re: issue cron when execute script the dump Oracle.

A. Clay Stephenson — Fri, 23 Feb 2007 15:16:46 GMT

How did you setup the named pipe? (At least judging from the file name, it appears to be a named pipe.) Is there a reader process for this named pipe? Does the export process have write permission on the pipe?

Re: issue cron when execute script the dump Oracle.

Claudemir Franco — Mon, 26 Feb 2007 08:27:25 GMT

Stephenson,

The name pipe is "export_rateprd1_pipe" and the permission to file pipe is:
prw-r--r-- 1 oracle dba 0 Feb 26 10:21 export_rateprd1_pipe

Curious it is that it was functioning. Command line is function, but in crontab unsuccessfully.

any ideas?

Tks.

Claudemir.

Re: issue cron when execute script the dump Oracle.

Oviwan — Mon, 26 Feb 2007 08:33:55 GMT

Hy

Do you execute it from the oracle users cron?

Regards

Re: issue cron when execute script the dump Oracle.

Claudemir Franco — Mon, 26 Feb 2007 08:35:58 GMT

Hi,

Yeap my friends,

Claudemir.

Re: issue cron when execute script the dump Oracle.

gstonian — Mon, 26 Feb 2007 08:43:29 GMT

Whats your crontab entry look like ?

Try to eliminate the problems one by one. Try adjusting permissions of the file and re-running. This would at least eliminate any permissions problems.

Re: issue cron when execute script the dump Oracle.

Claudemir Franco — Mon, 26 Feb 2007 08:47:03 GMT

gstonian,

my cron for user ORACLE
21 10 * * * $HOME/bin/exp_bancoz.sh rateprd1 full 2 >$HOME/log/exp_full_rateprd1.log 2>&1

In my script exp_bancoz.sh, i added one line with the command "chmod 666 /tmp/file_pipe" after the command "mknod". But unsuccessfully.

Tks

Claudemir,

Re: issue cron when execute script the dump Oracle.

Peter Godron — Mon, 26 Feb 2007 10:11:07 GMT

Claudemir,
could you please:

1. Review all your earlier threads with a view to reward the answers given, giving feedback and closing them. Your profile is 0 of 18 answers rewarded. Please read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions.

2. Post the $HOME/bin/exp_bancoz.sh script and any parameter file for the export command

Re: issue cron when execute script the dump Oracle.

A. Clay Stephenson — Mon, 26 Feb 2007 10:17:07 GMT

Bear in mind that when you create a named pipe (or a pipe of any kind for that matter), you must have 2 processes: a writer process (the exp command in your case) and a reader process (which might be a cat or dd to a file or tape). It is not clear that you have established a reader process; if not, your observed behavior is exactly what would be expected.

Re: issue cron when execute script the dump Oracle.

Claudemir Franco — Mon, 26 Feb 2007 12:02:12 GMT

Hi gurus,

My script is attachment!!!

Thanks a lot.

Claudemir

Re: issue cron when execute script the dump Oracle.

A. Clay Stephenson — Mon, 26 Feb 2007 12:15:29 GMT

Since you said that it was functioning if invoked from the shell interactively but fails when run under cron, that means that you are having problems with cron's intentionally sparse environment. I suspect that the command gzip is not in your PATH when run under cron --- but you need to check every command. You probably need to add /usr/contrib/bin to your PATH within the script.

Re: issue cron when execute script the dump Oracle.

Claudemir Franco — Tue, 27 Feb 2007 07:52:40 GMT

Hi People,

Thanks a lot of!

A. Clay,
I made accurately you said me and now the script is functioning. Thanks!!!

Claudemir