Search Results

Ok I've finished the script.
Any remarks? Please let me know.

#!/bin/bash

# values
USER=username
PASS=password
SIDORA=sid
LOG=/var/log/$SIDORA.log
DATUM=date
#Login to the DB
sqlplus -s...

That could work.

But the output of the statement is
1
----------------------
1

so when I do a grep on the 1 it will also write to the logfile when the date in that file is the date and time...

Well the query work.
I get a 1/1 respone, but when I close the DB de response is something like:
Unable to connect, no response from host.

At the first respone, de script don't have to do...

Hi all,

I'm trying to create a script that does the following:
Connect with SQLplus to my oracle db. Do a select 1 from dual; and when I don't get a value back. Than put the $DATE in a logfile.
...