Problems with SQLPLUS in shellscript

9 More Discussions You Might Find Interesting

1. 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...

2. 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...

3. 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}...

4. 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

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

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...

7. 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...

8. 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

9. 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...

LEARN ABOUT CENTOS

update-desktop-database

UPDATE-DESKTOP-DATABASE(1)				      General Commands Manual					UPDATE-DESKTOP-DATABASE(1)

NAME

       update-desktop-database - Build cache database of MIME types handled by desktop files

SYNOPSIS

       update-desktop-database [-q|--quiet] [-v|--verbose] [DIRECTORY...]

DESCRIPTION

       The update-desktop-database program is a tool to build a cache database of the MIME types handled by desktop files.

       The  cache database contains the list of MIME types that can be handled by desktop files, as well as, for each MIME type, a list of desktop
       files that can handle this MIME type. This cache database ease the work of applications that need to find an application that  can  open  a
       document  of  a specific MIME type: those applications will not have to parse all the desktop files existing on the system, and can instead
       parse this cache database.

       If no DIRECTORY is specified as argument, the desktop files that will be processed are the ones installed in $XDG_DATA_DIRS/applications.

       If both the --quiet and --verbose options are used, then --verbose will be ignored.

OPTIONS

       The following options are supported:

       -q, --quiet
	      Do not display any information about processing and updating progress.

       -v, --verbose
	      Display more information about processing and updating progress.

NOTES

       If an invalid MIME type is met, it will be ignored and the creation of the cache database will continue.

       The format of the cache database is a simple desktop entry format, with a MIME Cache group, containing one key per MIME type. The key  name
       is the MIME type, and the key value is the list of desktop file that can handle this MIME type.

       The  order  of the desktop files found for a MIME type is not significant.  Therefore, an external mechanism must be used to determine what
       is the preferred desktop file for a MIME type.

EXAMPLE

       Here is a simple example of a cache database:

	       [MIME Cache]
	       application/x-shellscript=gedit.desktop;
	       text/plain=gedit.desktop;gvim.desktop;
	       video/webm=totem.desktop;

       This cache database is created with three desktop files, each containing a MimeType key:

	       gedit.desktop: MimeType=text/plain;application/x-shellscript;
	       gvim.desktop: MimeType=text/plain;
	       totem.desktop: MimeType=video/webm;

FILES

       $XDG_DATA_DIRS/applications/mimeinfo.cache

	      This file is the cache database created by update-desktop-database.

BUGS

       If you find bugs in the update-desktop-database program, please report these on https://bugs.freedesktop.org.

								  FREEDESKTOP.ORG					UPDATE-DESKTOP-DATABASE(1)

Shell Programming and Scripting