09-21-2012
Still no luck . Am not sure why the process is unable to display the value.
Please let me know what I am missing here.
Thanks
Megha
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I'm attempting to populate an array in ksh using the following command:
set -A $(SELECT_INVOICE | sed '/^$/d')
SELECT_INVOICE is a function that executes the SQL query.
Problem: Some of the invoice numbers have alpha characters with spaces(example: OVEN MICRO). The Korn shell is treating... (1 Reply)
Discussion started by: kdst
1 Replies
2. UNIX for Dummies Questions & Answers
how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies
3. UNIX for Advanced & Expert Users
Hello All,
I was just wondering if there is any direct way to access PL/SQL OUT variables from Korn Shell Script.
I could already figure out how to return a single value back from PL/SQL to Shell Script (using bind variable).
But, what if we want to return multiple values?
One option I... (4 Replies)
Discussion started by: bright_future
4 Replies
4. Shell Programming and Scripting
Hi Guys,
I haven't worked on oracle much but I have a situation where I have to do bdf in all the servers and insert that information into oracle table. I have already created table which have 7 columns, I can insert manually but I dont know how to insert that using Korn shell.
SERVER_ID ... (9 Replies)
Discussion started by: pareshan
9 Replies
5. Shell Programming and Scripting
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies
6. Shell Programming and Scripting
Hello,
Could someone please suggest if there is a way to pass an perl array(pass @v_array) to SQL as in below eg :
#!/usr/bin/perl
@v_array = (1,2,4,5,6,8);
$db_userid = 'ni71/ni711';
$bufTPO = qx{ sqlplus -s << EOF
$db_userid
set verify off
set feedback off
set... (1 Reply)
Discussion started by: arunshankar.c
1 Replies
7. Shell Programming and Scripting
I'm in the process of writng a function that consists of a case statement is there a way of calling the function and passing a value to it?
ie
function1 () {
case
opt1 do .....
opt2 do.....
esac
}
function opt1
I'm aware the syntax is not correct, but you get the general idea. (1 Reply)
Discussion started by: squrcles
1 Replies
8. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
9. Shell Programming and Scripting
Hi all,
Hopefully you can help. This is what I'm trying to achieve:
Obtain a list of usernames out of an Oracle Database
Based on this list, link each username with an Oracle Internet Directory (OID) GUID
Using the username and GUID perform a database update for all users
Here are the... (7 Replies)
Discussion started by: exm
7 Replies
10. Shell Programming and Scripting
I am fairly new to writing scripts, and have gotten a lot of help from this site in the past with many of the posts.
I have a question/issue with a script I am attempting to write and have a question regarding executing an sql statement inside of a loop (do while). I have in the past written... (1 Reply)
Discussion started by: josbor01
1 Replies
LEARN ABOUT REDHAT
e2fsadm
E2FSADM(8) System Manager's Manual E2FSADM(8)
NAME
e2fsadm - ext2 filesystem / LVM administration
SYNOPSIS
e2fsadm [-d|--debug] [-h|--help] {[-l|--extents] [+|-]LogicalExtentsNumber|" [-L|--size] [+|-]LogicalVolumeSize[kKmMgGtT]} [-n|--nofsck]
[-v|--verbose] [--version] LogicalVolumePath
DESCRIPTION
e2fsadm allows resizing of a logical volume containing a mounted or unmounted ext2 filesystem. For unmounted filesystems it can extend the
logical volume and grow the filesystem using resize2fs(8) or ext2resize(8), or shrink the filesystem and then reduce the logical volume
afterwards. For mounted filesystems it can extend the logical volume and grow the filesystem using ext2online(8).
OPTIONS
-d, --debug
Enables additional debugging output (if compiled with DEBUG).
-h, --help
Print a usage message on standard output and exit successfully.
-l, --extents [+|-]LogicalExtentsNumber
Resize the filesystem/logical volume to or by the number of logical extents. If you use + or - then the number will be relative the
th current size of the logical volume, otherwise the volume will be resized to LogicalExtentsNumber extents.
-L, --size [+|-]LogicalVolumeSize[kKmMgGtT]
Resize the filesystem/logical volume to or by the given size. If you use + or - then the number will be relative the the current
size of the logical volume, otherwise the volume will be resized to LogicalVolumeSize. A size suffix of K for kilobytes, M for
megabytes, G for gigabytes or T for terabytes can be used.
-n, --nofsck
Avoid the filesystem check before the resize operation. A filesystem check is mandatory before resize2fs(8), but is optional for
ext2resize(8), and is not allowed for ext2online(8) because the filesystem is mounted. Useful if a check has been done before
starting e2fsadm.
-t, --test
Test run without real resizing.
-v , --verbose
Gives verbose runtime information about e2fsadm's activities.
--version
Print version number and exit successfully.
DIAGNOSTICS
e2fsadm calls e2fsck(8), lvextend(8), lvreduce(8), and resize2fs(8), ext2resize(8), or ext2online(8) internally. By default, for mounted
filesystems e2fsadm will look for resize2fs first, and failing that it will look for ext2resize. For mounted filesystems it will try to
run ext2online. It returns an exit code of 0 for success or > 0 for error:
1 the filesystem size is invalid
2 the logical volume name is missing
3 the logical volume name is invalid
4 the logical volume doesn't exist
5 an error occured while reading the VGDA
6 an error occured while resizing the filesystem
7 /proc/mounts is not available
8 the filesystem is mounted
9 the filesystem type is not ext2
10 the e2fsck(8) command is missing or was not found
11 resize2fs(8) is missing or was not found
12 unable to run e2fsck(8)
13 unable to run resize2fs(8)
14 an error occured while reading the logical volume
15 logical volume size error
16 lvextend(8) is missing or was not found
17 unable to run lvextend(8)
18 lvreduce(8) is missing or was not found
19 unable to run lvreduce(8)
95 driver/module not in kernel
96 invalid I/O protocol version
97 error locking logical volume manager
98 invalid lvmtab (run vgscan(8))
99 invalid command line
ENVIRONMENT VARIABLES
E2FSADM_RESIZE_CMD
Command to call instead of resize2fs(8).
E2FSADM_RESIZE_OPTS
Options for the EXT2_RESIZE_CMD.
E2FSADM_ONLINE_CMD
Command to call instead of ext2online(8).
E2FSADM_ONLINE_OPTS
Options for the EXT2_ONLINE_CMD.
SEE ALSO
lvm(8), lvcreate(8), lvextend(8), lvreduce(8), resize2fs(8), ext2resize(8), ext2online(8)
AUTHOR
Heinz Mauelshagen <Linux-LVM@Sistina.com>
Heinz Mauelshagen LVM TOOLS E2FSADM(8)