The error states that the OS cannot find Oracle Database Utility: sqlplus in its PATH.
Check if you have variable ORACLE_HOME defined:
If yes, check if sqlplus is available in bin directory:
If the utility exists, set your PATH to include $ORACLE_HOME/bin directory:
You can put above in startup scripts to ensure that it is available each time you create a new session.
Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Hello All,
I am starting with UNIX. Any help is highly appreciated.
How to extract data using UNIX shell script? And how do you export data using UNIX shell scripts into Microsoft Excel format?
Thank you. (3 Replies)
Hi All,
I need to write a shell script(ksh) to take the tables backup in oracle(exporting tables data).
The tables list is not static, and those are selecting through dynamic sql
query. Can any body help how to write this shell script.
Thanks, (3 Replies)
I am writing a unix shell script that will extract records from table and write into a file.
======================================
#! /bin/ksh
############################
# AFI Monitor Script
############################
. /db2/uszlad48/sqllib/db2profile
export... (5 Replies)
Hi,
How to fetch data from oracle database in unix shell scripting.
list=`sqlplus -s ds_user/dsuser@EMI <<EOF
set feedback off
set serveroutput on
set heading off
set pagesize 0
set tab off
select IP_ID from table
/
exit
EOF`
The output is not what i expected.I need output in... (4 Replies)
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea . (2 Replies)
Hi All ,
I am stuck on the below situation.I have a table called "test" which are created on hive.I need to export the data from hive to a file(test.txt) on local unix system.I have tried the below command ,but its giving the exception .
hive -e "select * from test " > /home/user/test.txt ;
... (1 Reply)
Discussion started by: STCET22
1 Replies
LEARN ABOUT ULTRIX
filecap
FILECAP:(8) System Administration Utilities FILECAP:(8)NAME
filecap - a program to see capabilities
SYNOPSIS
filecap [ -a | -d | /dir | /dir/file [cap1 cap2 ...] ]
DESCRIPTION
filecap is a program that prints out a report of programs with file based capabilities. If a file is not in the report or there is no
report at all, no capabilities were found. For expedience, the default is to check only the directories in the PATH environmental variable.
If the -a command line option is given, then all directories will be checked. If a directory is passed, it will recursively check that
directory. If a path to a file is given, it will only check that file. If the path to the file includes capabilities, then they are written
to the file.
OPTIONS -a This tells the program to show all capabilities starting from the / directory. Normally the PATH environmental variable is used to
show you capabilities on files you are likely to execute.
-d This dumps all capabilities for reference.
EXAMPLES
To check file capabilities in $PATH:
filecap
To check file capabilities of whole system:
filecap -a
To check file capabilities recursively in a directory:
filecap /usr
To check file capabilities of a specific program:
filecap /bin/passwd
To list all possible capabilities:
filecap -d
To set a file capability on a specific program:
filecap /bin/ping net_raw net_admin
SEE ALSO pscap(8), netcap(8), capabilities(7).
AUTHOR
Steve Grubb
Red Hat March 2009 FILECAP:(8)