[SOLVED] Oracle 11g database backup is failing as cronjob

fawaz25 · 07-09-2019, 07:43 AM

Dear All,

I am trying to take backup of database via following command.

Code:

expdp xyz/xyz@orcl schemas=xyz directory=dumps dumpfile=xyz_bk_date.dmp logfile=expdpxyz_bk_date.log

The above command is working fine via command prompt.

But if I make a script and add the above command in it and run it as a cronjob, it is failing.
i am getting the following error:
/home/oracle/scripts/backup.txt: line 6: expdp: command not found

TB0ne · 07-09-2019, 08:11 AM

Quote:

Originally Posted by fawaz25

Dear All,
I am trying to take backup of database via following command.

Code:

expdp xyz/xyz@orcl schemas=xyz directory=dumps dumpfile=xyz_bk_date.dmp logfile=expdpxyz_bk_date.log

The above command is working fine via command prompt. But if I make a script and add the above command in it and run it as a cronjob, it is failing. i am getting the following error:
/home/oracle/scripts/backup.txt: line 6: expdp: command not found

Again, as you've been asked several times previously, are you paying for Oracle? It is NOT FREE, and you've mentioned RAC in previous threads....have you contacted Oracle support? And what version/distro of Linux are you using???

Past that, your error is fairly plain; the expdp command isn't in the path that's exported via CRON, so specify the full path in the script.

fawaz25 · 07-10-2019, 01:35 AM

Quote:

Originally Posted by TB0ne

Again, as you've been asked several times previously, are you paying for Oracle? It is NOT FREE, and you've mentioned RAC in previous threads....have you contacted Oracle support? And what version/distro of Linux are you using???

Past that, your error is fairly plain; the expdp command isn't in the path that's exported via CRON, so specify the full path in the script.

We are using Oracle Linux 7.5 which is free.

As you mentioned, I mentioned the full path as below in the script:

Code:

/u01/app/oracle/product/12.2.0.1/db_1/bin/expdp

But still it is giving me the follwoing error:

Code:

UDE-00013: Message 13 not found; No message file for product=RDBMS, facility=UDE
UDE-00019: You may need to set ORACLE_HOME to your Oracle software directory

dc.901 · 07-10-2019, 06:03 AM

Quote:

Originally Posted by fawaz25

But still it is giving me the follwoing error:

Code:

UDE-00013: Message 13 not found; No message file for product=RDBMS, facility=UDE
UDE-00019: You may need to set ORACLE_HOME to your Oracle software directory

There it is in BOLD. If you do not know what ORACLE_HOME is, contact your DBA.

TB0ne · 07-10-2019, 06:46 AM

Quote:

Originally Posted by fawaz25

We are using Oracle Linux 7.5 which is free.

OEL is **NOT ORACLE DATABASE**, but Oracle Linux. One is free, the other is not. So why are you still not paying for Oracle???

Quote:

As you mentioned, I mentioned the full path as below in the script:

Code:

/u01/app/oracle/product/12.2.0.1/db_1/bin/expdp

But still it is giving me the follwoing error:

Code:

UDE-00013: Message 13 not found; No message file for product=RDBMS, facility=UDE
UDE-00019: You may need to set ORACLE_HOME to your Oracle software directory

...which is a DIFFERENT error than you initially posted. And as dc.901 said, this error (and the first error) are VERY obvious; you haven't set up Oracle correctly, don't have a path set, etc. If your DBA followed the installation instructions, you'd have the ORACLE_HOME environment variable set already. And **AGAIN**, if you contacted Oracle support, they could have told you this as well.

fawaz25 · 07-15-2019, 06:10 AM

Quote:

Originally Posted by TB0ne

OEL is **NOT ORACLE DATABASE**, but Oracle Linux. One is free, the other is not. So why are you still not paying for Oracle???

...which is a DIFFERENT error than you initially posted. And as dc.901 said, this error (and the first error) are VERY obvious; you haven't set up Oracle correctly, don't have a path set, etc. If your DBA followed the installation instructions, you'd have the ORACLE_HOME environment variable set already. And **AGAIN**, if you contacted Oracle support, they could have told you this as well.

We are paying for Oracle database. The issue is solved. Thanks for help.

fawaz25 · 07-15-2019, 06:11 AM

Quote:

Originally Posted by dc.901

There it is in BOLD. If you do not know what ORACLE_HOME is, contact your DBA.

DOne. Thank you.

TB0ne · 07-15-2019, 07:22 AM

Quote:

Originally Posted by fawaz25

We are paying for Oracle database. The issue is solved. Thanks for help.

Great; so why don't you post the solution???

fawaz25 · 07-16-2019, 12:33 AM

Quote:

Originally Posted by TB0ne

Great; so why don't you post the solution???

ORACLE_HOME was already set as an environment variable, but still the script was failing.

The problem was that cron was NOT reading any user profile settings, so I had to define it in the cron script.
I had to set the environment variable ORACLE_HOME in my script as below, and then ran the script via cronjob. Its working fine. Checking for all needed variables in .profile and defining it in the beginning of cron script solved the issue.

Code:

export ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1
$ORACLE_HOME/bin/expdp xyz/xyz@orcl schemas=xyz directory=dumps dumpfile=xyz_bk_date.dmp logfile=expdpxyz_bk_date.log

scasey · 07-16-2019, 10:25 AM

Quote:

Originally Posted by fawaz25

ORACLE_HOME was already set as an environment variable, but still the script was failing.

The problem was that cron was NOT reading any user profile settings, so I had to define it in the cron script.

Thank you for posting the solution. I'm sure it will help others in the future.

Yes, cron runs in its own environment, so setting environment variables and using absolute paths is always the Best Practice in cron jobs.