Problems with SQLPLUS in shellscript Post: 302239333

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Create Shellscript

I am new to UNIX. I got the file from Oracle, with two columns (Table Name and Column Name). I need to create the shell script where the result suppose to include plain text, <table_name>, <Column_name> from the file. Plain text will be the statements to create index in Oracle. something like...

2. UNIX for Advanced & Expert Users

ftp in Shellscript

Can I do something like this from a shellscript ?: ftp 12.34.56.78 <<! username password put a.c bye ! It does not go through as the login fails. Is there any alternative to do the above requirement? Thanks in advance. Gowrish

3. Shell Programming and Scripting

Need help with shellscript

Hello. I am a novince at writing shell scripts but here is the question. I have to write a shell script that does the following: Once executed via crontab, the script should do the following: a. get date/time stamp in for format 10-MAR-05 and b. execute shell script my_script.sh (which...

4. Shell Programming and Scripting

Problems with storing oracle sqlplus query output shell script

Hello everyone, I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected. I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't...

5. Shell Programming and Scripting

Needed shellscript for the following

hi all, i need the shell script for he below requirement i had the input file as a_20121217_035120( frmat is a_date_hhmmss) a_20121217_035128 a_20121217_035456 a_20121217_035767 a_20121217_035178 a_20121217_035189 a_20121217_035220 my output should be a_20121217_035456...

6. Shell Programming and Scripting

Help with shellscript

I am new in shell script i want to convert .txt file in the format axsjdijdjjdk to a x s j d i j d j j d k

7. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}...

8. Shell Programming and Scripting

Telnet shellscript

cat << EOF | telnet alt1.aspmx.l.google.com 25 HELO verify-email.org MAIL FROM: <check@verify-email.org> RCPT TO: <test@gmail.com> quit EOF Hello, I'm trying to get the result of that execution, and can not see the result or bring it to a txt ... the direct command in ssh running the result...

9. Shell Programming and Scripting

Avoid $ symbol while calling sqlplus in shellscript.

Hi All, we have requirement, i am created a shell script , inside i am connecting sqlplus and execute the query. below my code for your reference. get_sqlid () { sqlid=$( sqlplus -s $PBDW_USERID/$PBDW_PW@$PBDW_SID <<EOF DEFINE TBLNAME=$1 set feedback off set serverout on size...

LEARN ABOUT REDHAT

mkoctfile

MKOCTFILE(1)						      General Commands Manual						      MKOCTFILE(1)

NAME

       mkoctfile - Compile dynamic-load modules for GNU Octave

SYNOPSIS

       mkoctfile [-IDIR] [-DDEF] [-lLIB] [-LDIR] [-M|--depend]	  [-c] [-o   FILE|--output  FILE] [-p  VAR|--print  VAR] [-s|--strip]	[-v|--ver-
       bose] [-h|-?|--help] file ...

DESCRIPTION

       mkoctfile is used to compile source C, C++ or Fortran source code in dynamically loadble file for octave(1).

OPTIONS

       mkoctfile accepts the following options:

       -IDIR   Add include directory DIR to compile commands.

       -DDEF   Add definition DEF to compiler call.

       -lLIB   Add library LIB to link command.

       -LDIR   Add library directory DIR to link command.

       -M|--depend
	       Generate dependency files (.d) for C and C++ source files.

       -c      Compile but do not link.

       -o FILE|--output FILE
	       Output file name; default extension is .oct.

       -p VAR|--print VAR
	       Print configuration variable VAR.  Recognized variables are:
		   CPPFLAGS    CPICFLAG
		   INCFLAGS    CXX
		   F2C	       CXXFLAGS
		   F2CFLAGS    CXXPICFLAG
		   F77	       XTRA_CFLAGS
		   FFLAGS      XTRA_CXXFLAGS
		   FPICFLAG    SHLEXT
		   CC	       SH_LD
		   CFLAGS      SH_LDFLAGS

       -s|--strip
	       Strip the output file.

       -v|--verbose
	       Echo commands as they are executed.

       file    Compile or linke file. Recognised file types are
		   .c	 C source
		   .cc	 C++ source
		   .C	 C++ source
		   .cpp  C++ source
		   .f	 Fortran source
		   .F	 Fortran source
		   .o	 object file
		   .SH SEE ALSO
		   .BR octave (1).

AUTHOR

       John W. Eaton <jwe@bevo.che.wisc.edu>

       This manual page was contributed by Dirk Eddelbuettel <edd@debian.org> for the Debian GNU/Linux distribution but may be used by others.

GNU Octave							  1 November 2002						      MKOCTFILE(1)