LinuxQuestions.org
Review your favorite Linux distribution.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 12-27-2017, 08:22 AM   #16
dfreybur
LQ Newbie
 
Registered: Aug 2017
Location: Austin, TX, US
Posts: 11

Rep: Reputation: Disabled

Quote:
Originally Posted by Natarajachar View Post
The following is the script I wrote:

#!/bin/bash

echo "***********Archive file deletion started at `date`***********"
echo " "
export ORACLE_HOME=/u01/oracle_home/contentdb
#cd $ORACLE_HOME
Your script has no Oracle environment settings and your error is that there are no Oracle environment settings. So add the list of Oracle environment settings then. They don't get set automatically in crontab runs.
 
Old 12-27-2017, 08:47 AM   #17
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,634

Rep: Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965
Quote:
Originally Posted by Natarajachar View Post
The following is the script I wrote:
Code:
#!/bin/bash

echo "***********Archive file deletion started at `date`***********"
echo " "
export ORACLE_HOME=/u01/oracle_home/contentdb
#cd $ORACLE_HOME
/u01/oracle_home/contentdb/bin/rman <<EOF
connect target /;
connect CATALOG cat/catalog@conprddb;
spool msglog to '/u02/backup/log/rman_archive_del_new.log'
change archivelog all crosscheck;
delete noprompt expired archivelog all;

exit;
EOF
echo "The archival process ended at `date`">>/u02/backup/rman/rman_archive_del1.log
So as you've been told before, you need to put your scripts into CODE tags when posting them. And the one you posted here is almost an exact copy of the one from your other thread, with a couple of minor changes. In the several months you've been working on this, have you made no progress at all?? You were told in your other thread, that you need to make sure that you're running this in the Oracle user's CRON...are you???

And as you've been told also, you need to contact Oracle, since you are PAYING FOR ORACLE, RIGHT???? Have you done that?? Posting your questions over and over and not acknowledging what you're told or answering questions, won't get you much help.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
bash script not working as expected when executed at startup kuhnto Linux - Newbie 8 09-26-2017 08:00 PM
[SOLVED] sudo not working as expected on custom script. crwdawg Linux - Security 8 01-31-2013 06:27 AM
[SOLVED] rsyslog upstart script not working as expected grail Ubuntu 3 03-23-2011 07:47 PM
Wireless script not working as expected SlowCoder Linux - General 6 05-24-2008 07:06 AM
Crontab not working as expected nro Linux - Newbie 7 08-29-2005 12:56 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 05:18 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration