FIND REDLOG FILES..... ksh: dbfFILe: parameter not set
When I attempt to perform the script below....
Code:
#!/bin/ksh
. $HOME/.profile
# Initial Script Prerequisites
ORACLE_SID=MDirect ; export ORACLE_SID
REDOLOGDIR=$ARCLOGDEST ; export REDOLOGDIR
dbfFILE=$REDOLOGDIR/dbflist.txt ; export dbfFILE
# Log into Oracle to perform Switch of REDOLOGS.
echo "Oracle to perform SWITCH."
sqlplus /nolog << EOF
connect / as sysdba ;
alter system switch logfile ;
EOF
# Take a nap (300=5min)
echo "SLEEP TIME (5mins)"
sleep 300
cd $REDOLOGDIR/tmp
# Find all .dbf files newer than the timefile and put listing into
# the dbfFILE to be read.
echo "FIND REDLOG FILES....."
find $REDOLOGDIR -name \*.dbf -type f -newer $REDOLOGDIR/tmp/timefile -exec ls {
} \; > $dbfFILE
while read dbfEntry; do
echo $dbfEntry
echo "cp: " $REDOLOGDIR/$dbfEntry " to " $REDOLOGDIR "/tmp"
cp $REDOLOGDIR/$dbfEntry .
echo "compress :......."
compress *.dbf
echo "cp: to MDDEV/U02/...."
cp -p $REDOLOGDIR/tmp/*.Z /mddev/u02/oracle/admin/MDirect/arch
if [ $? != 0 ]
then
echo
echo "ERRORS encountered with Redolog Move"
echo "with file: " $dbfEntry
echo
rm $REDOLOGDIR/tmp/*.dbf*
exit # EXIT from script.
else
echo "rm: " $REDOLOGDIR"/tmp/"$dbfEntry
rm $REDOLOGDIR/tmp/*.dbf*
echo "TOUCH PERFORMED..."
touch $REDOLOGDIR/tmp/timefile
fi
done < $dbfFILe
I initially thought it was a result of the FIND statement and have tried redirecting the output of the `-exec ls {}` statement in the above form and (initially)... find $REDOLOGDIR -name \*.dbf -type f -newer $REDOLOGDIR/tmp/timefile -exec ls {} > $ dbfFILE \;
I am reading a file into a parameter in my program
typeset nums_type
if the contents of nums_type = asdfghbqwerty
how do make a new paremeter eqaul to the 7th character of nums_type.
like
${type} = b (2 Replies)
I am using a Sun Ultra 30 with 250MG of RAM and 9GIG of hard drive. I connect to the machine via Exceed 6 and have the Oracle8i for Solaris in the cdrom drive. I have read and complied with Oracle's instruction in preparation to installing Oracle. Since I don't have enough space to cp the content... (1 Reply)
Hi
I am new to this forum. Please forgive me, If I am wrong anywhere. I am trying to understand the below code. Can anyone help in understanding what is ${#ST} here. Is that the value of the first parameter??:confused:...what is exit 1 mean. Any clarification is greatly appreciated.
export... (3 Replies)
hi, linux gurus...
i'm trying to write a script in ksh called ResetPass that allows a user to change mysql passwords. the script accepts user, password and host like this: ResetPass <user> <password> <host>. here's the code:
*****************************************************
mysql... (1 Reply)
Hello,
Could anyone help me with some KSH syntax? I'm trying to pass a list as a function parameter in a KSH?
For example I have code like this:
print_counter() {
N=$1
C=$2
for A in $C; do
echo "This is $N number $A"
done
}
NAME=BRICK
COUNT=" 1 2 3 4"
... (2 Replies)
Hi, i have this script
setenv.sh
if
then
echo "is empty"
fi
echo "done"
The following is the result when i run the script from command without and with a dot and space operator
$ setenv.sh
is empty
done
$ . setenv.sh
sh: VAR_1: Parameter not set.
$
It's our standard to run... (5 Replies)
I want to do something like this:
alias cd2="cd /data_saves/$(/opt/bin/util/getcustdb -i $@)"
Where /opt/bin/util/getcustdb is an inhouse script to lookup customer db name based on a provided id number
Then when I use the alias I can
cd2 4567
and have it run "/opt/bin/util/getcustdb -i... (3 Replies)
Hi,
A very basic query.
I am working on two different UNIX servers and I see different behaviours for my user id. This has to be a setting in the .profile, but I can't seem to find where :confused:
So, in one server if I type echo $XYZDD (a random variable), I get a blank line with no... (2 Replies)
My intention is to go through list of addresses and call google geocode api for each of them. I am using lynx for this, but somehow I can't supply the parameters to it in a proper way.
To show that my parameters are OK I just hardcoded one address in my script and put it in my input file, and... (2 Replies)
Getting the following when I try to set -u or set -o nounset in ksh on Solaris. Anyone ever seen this? Using an account I just built so everything is default and default shell is set to ksh.
Oracle Corporation SunOS 5.11 11.3 September 2015
bar@solaris11:~$ echo $0
-ksh
bar@solaris11:~$ set... (3 Replies)
Discussion started by: epost
3 Replies
LEARN ABOUT PHP
oci_field_type
OCI_FIELD_TYPE(3)OCI_FIELD_TYPE(3)oci_field_type - Returns a field's data type nameSYNOPSIS
mixed oci_field_type (resource $statement, mixed $field)
DESCRIPTION
Returns a field's data type name.
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns the field data type as a string, or FALSE on errors.
EXAMPLES
Example #1
oci_field_type(3) example
<?php
// Create the table with:
// CREATE TABLE mytab (number_col NUMBER, varchar2_col varchar2(1),
// clob_col CLOB, date_col DATE);
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
$stid = oci_parse($conn, "SELECT * FROM mytab");
oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows
echo "<table border="1">
";
echo "<tr>";
echo "<th>Name</th>";
echo "<th>Type</th>";
echo "<th>Length</th>";
echo "</tr>
";
$ncols = oci_num_fields($stid);
for ($i = 1; $i <= $ncols; $i++) {
$column_name = oci_field_name($stid, $i);
$column_type = oci_field_type($stid, $i);
$column_size = oci_field_size($stid, $i);
echo "<tr>";
echo "<td>$column_name</td>";
echo "<td>$column_type</td>";
echo "<td>$column_size</td>";
echo "</tr>
";
}
echo "</table>
";
// Outputs:
// Name Type Length
// NUMBER_COL NUMBER 22
// VARCHAR2_COL VARCHAR2 1
// CLOB_COL CLOB 4000
// DATE_COL DATE 7
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumntype(3) instead. This name still can be used, it was left as alias of
oci_field_type(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO oci_num_fields(3), oci_field_name(3), oci_field_size(3).
PHP Documentation Group OCI_FIELD_TYPE(3)