UNIX for Dummies Questions & Answers

I trying to call shell scripts through DBMS_SCHEDULER of Oracle. My procedure executed successfully and my shell scripts executed perfect in UNIX. However, the job does not run when i look through in SQL. I dont see any errors. Did any one of you use dbms_scheduler package to call shell scripts ? Do i need to add anything in my shell scripts? Please help

SQL> BEGIN
2 DBMS_SCHEDULER.CREATE_PROGRAM(
3 PROGRAM_NAME =>'CMS_DATABASE_BKUP',
4 PROGRAM_ACTION =>'/u01/j.ksh',
5 PROGRAM_TYPE => 'EXECUTABLE',
6 ENABLED => TRUE);
7
8 DBMS_SCHEDULER.CREATE_SCHEDULE(
9 SCHEDULE_NAME => 'CMS_SCHEDULE',
10 START_DATE => SYSDATE,
11 REPEAT_INTERVAL =>
12 'FREQ=HOURLY; INTERVAL=1',
13 COMMENTS=>'BACKUP');
14
15 DBMS_SCHEDULER.CREATE_JOB(
16 JOB_NAME => 'MSV_FULL',
17 JOB_TYPE => 'EXECUTABLE',
18 JOB_ACTION =>'/u01/j.ksh',
19 ENABLED => TRUE,
20 START_DATE => SYSDATE,
21 REPEAT_INTERVAL =>
22 'FREQ=HOURLY; INTERVAL=1',
23 COMMENTS=>'BACKUP');
24 END;
25 /

Shell scripts- j.ksh
rman target=/ <<EOF
SHUTDOWN IMMEDIATE
STARTUP MOUNT

ALLOCATE CHANNEL C1 DEVICE TYPE DISK
FORMAT '/U01/ORADATA/%U'
BACKUP DATABASE PLUS ARCHIVELOG;
SQL 'ALTER DATABASE OPEN';
>> EXIT;
EOF

Can you guys give me any suggestions

Modify the script like this:

j.ksh

Code:

#! /path/to/your/shell -xv

exec >/tmp/output_$$.log 2>&1

# set the enviroment here
ORACLE_HOME= ...
ORACLE_SID= ...
PATH="$PATH:$ORACLE_HOME/bin"
export ORACLE_HOME ORACLE_SID PATH

rman target=/ <<EOF
SHUTDOWN IMMEDIATE
STARTUP MOUNT

ALLOCATE CHANNEL C1 DEVICE TYPE DISK
FORMAT '/U01/ORADATA/%U'
BACKUP DATABASE PLUS ARCHIVELOG;
SQL 'ALTER DATABASE OPEN';
>> EXIT;
EOF

exit

Post the content of /tmp/output_<pid>.log.

Hi all experts,
Please explain the follwoing lines as i quoted below.

Is it arguments?

>/tmp/output_$$.log 2>&1

Please help

Test the job with the modified shell and post the output, please ...

As far as your request for explanation is concerned, there are many tutorials on Internet that describe/explain the
shell syntax.