Dbms_scheduler In Unix Shell


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Dbms_scheduler In Unix Shell
# 8  
Old 01-07-2008
It says RMAN command not found and SEED(database) not found. It is because my boss has shutdown the database. I will get back to the forum if i have any problem.

Quote:
Originally Posted by radoulov
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.
# 9  
Old 01-07-2008
I modified the script but it is still giving me an error
exec>/u01/oradata/bkup_$$.log 2>&1
ORACLE_HOME=/u01/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=SEED: export ORACLE_SID
path="$PATH:$ORACLE_HOME/bin"
rman target=/<<
EOF
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALLOCATE CHANNEL ch1 device type disk FORMAT
'/u01//oradata/ora/%U';
BACKUP AS COMPRESSED BACKUPSET
DATABASE PLUS ARCHIVELOG;
SQL 'ALTER DATABASE OPEN';} EXIT ;
EOF

In the log file it displays that /u01/oracle/product/10.2 is a directory and the next line it display that RMAN not found. I will appreciate your suggestions guys. I will be greateful.


Quote:
Originally Posted by radoulov
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.
# 10  
Old 01-07-2008
You didn't use what I suggested:

this:

Code:
ORACLE_SID=SEED: export ORACLE_SID

should become:

Code:
ORACLE_SID=SEED; export ORACLE_SID

and, this:

Code:
path="$PATH:$ORACLE_HOME/bin"

(as long as you don't use zsh) should be changed to:

Code:
PATH="$PATH:$ORACLE_HOME/bin"

(Unix is case sensitive)

It would be easier if you post the entire script and output.
# 11  
Old 01-07-2008
Do i have to specify .oraenv?
# 12  
Old 01-07-2008
Try with ORACLE_HOME, ORACLE_SID and PATH for now.
# 13  
Old 01-07-2008
Man you are genious.May god bless you. It works. I really appreciate your time and efforts.

Quote:
Originally Posted by radoulov
You didn't use what I suggested:

this:

Code:
ORACLE_SID=SEED: export ORACLE_SID

should become:

Code:
ORACLE_SID=SEED; export ORACLE_SID

and, this:

Code:
path="$PATH:$ORACLE_HOME/bin"

(as long as you don't use zsh) should be changed to:

Code:
PATH="$PATH:$ORACLE_HOME/bin"

(Unix is case sensitive)

It would be easier if you post the entire script and output.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Passing variables from UNIX to Ansible to UNIX shell

I m passing a variable stringg from Unix shell which has value 'Good Day' to ansible and from ansible to a second shell script where it print only Good instead of 'Good Day' passing the variable stringg from unix shell script1.sh echo $stringg ansible-playbook install.yml -i... (1 Reply)
Discussion started by: mohtashims
1 Replies

2. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

3. UNIX for Dummies Questions & Answers

Unix Shell Scripting( Calling from Unix to PLSQL)

Hello Experts, I have the following questions to be discussed here at this esteemed discussion forum. I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of... (1 Reply)
Discussion started by: faizsaadq
1 Replies

4. Shell Programming and Scripting

FTP from windows to unix server using unix shell script

Hi, Is it possible to ftp a huge zip file from windows to unix server using unix shell scripting? If so what command i need to use. thanks in advance. (1 Reply)
Discussion started by: Shri123
1 Replies

5. Shell Programming and Scripting

Connecting to multiple unix server from unix server using shell script

Hi Gurus, I'm a unix newbie and I would like to connect to multiple unix servers from unix server using shell script i.e from server a to server b,c,d etc. I want to copy the files from unix server a to server b, c, d. I can access staright using ssh without the need to have password and user... (5 Replies)
Discussion started by: sexyTrojan
5 Replies

6. Shell Programming and Scripting

How to connect unix server to unix server through shell scripts

Hi, I would like to connect UNIX server to UNIX server through shell scripts and i have some concepts . But i am totally confused how to connect UNIX server to UNIX server throuth running a script. It will be greatful to me if any buddy will help me. with simple example please. Thanks in... (2 Replies)
Discussion started by: phatan
2 Replies

7. Shell Programming and Scripting

How to connect unix server to unix server through shell scripts

Hi, I would like to connect UNIX server to UNIX server through shell scripts and i have some concepts . But i am totally confused how to connect UNIX server to UNIX server throuth running a script. It will be greatful to me if any buddy will help me. Thanks in advance. Phatan:) (2 Replies)
Discussion started by: phatan
2 Replies

8. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies

9. AIX

Difference between writing Unix Shell script and AIX Shell Scripts

Hi, Please give me the detailed Differences between writing Unix Shell script and AIX Shell Scripts. Thanks in advance..... (0 Replies)
Discussion started by: haroonec
0 Replies

10. Shell Programming and Scripting

How to run unix commands in a new shell inside a shell script?

Hi , I am having one situation in which I need to run some simple unix commands after doing "chroot" command in a shell script. Which in turn creates a new shell. So scenario is that - I need to have one shell script which is ran as a part of crontab - in this shell script I need to do a... (2 Replies)
Discussion started by: hkapil
2 Replies
Login or Register to Ask a Question