Shell Programming and Scripting

Hi Unix Gurus,

I have a requirement to write a script, Oracle DB gets referesh every 6hrs, hence we need write a script to connect to the database , if it connects it should generate a file to proceed the next job application or when an error when connectiong to DB it should not generate any file so my next jobs will not be triggered.

Thanks in Advance !!!

Shiv

Hello what have you tried so far and where are you stuck?

Also,

Please search this forum with the keyword "sqlplus oracle"

Google Search Results for sqlplus oracle | The UNIX and Linux Forums

Thanks Scrutinizer for the reply, Sorry i am new to scripting i did not even start with head , please help me out

We are all volunteering our time and expertise, we can give you the direction you need, but you have to put some effort into solving your own problem. This is not a contracted support hotline.

Please explain "Oracle DB gets referesh every 6hrs" it means refresh the entire db as like all objects in db?

Code:

#!/bin/bash

LogDirectory='/var/tmp/logs'
DataDirectory='/var/tmp/data'

DBUSER='scott'
DBUSERPASSWORD='tiger'
DB='oracle'

sqlplus -s <<EOF  > ${LogDirectory}/query.log
${DBUSER}/${DBUSERPASSWORD}@${MYDB}
set linesize 32767
set feedback off
set heading off

select * from dual;

EOF