sqlplus: No such file or directory Post: 302743107

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

passing unix variable to sqlplus without a file name

Hi, I want to input unix variable to sqlplus.The following is working fine sqlplus username/password @dummy.sql param1 param2 << EOF create user $1 identified by $2; EOF But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that?? Thanks...

2. UNIX for Dummies Questions & Answers

File Format issue: Output of sqlplus

Hi, I am using a query like below in my shell script : { { echo "set echo off" echo "set head off" echo "whenever sqlerror exit -1; select NUMBER ||','|| FNAME ||','|| LOC ||','|| ...

3. UNIX for Dummies Questions & Answers

SQLPlus spool file

HI Have some problem with spooling out some relatively large number of records (~2-3 mil) Small table - OK though. Getting error: SP2 0308: cannot close spool file. Any thoughts? sqlplus -s user/pwd << EOF set term off set head off set trims on set pages 0 set...

4. Shell Programming and Scripting

error running sqlplus from shell file

I am running a shell file following script on bash shell in solaris 10 ( echo abc@orcl echo abc echo "set feedback off" echo "truncate table SIndexDataTypeHst1_changes;" ) | sqlplus -s but getting the following error ERROR: ORA-01005: null password given; logon denied ...

5. UNIX for Dummies Questions & Answers

SQLPLUS Password Parameter file being used when logging in

Good day to everyone. This is my first time posting and just barely above basic Unix training. I think i have search thoroughly to ensure my question hasn't already been posted. But on the off chance the answer has been posted, please be nice as I am not 100% sure I know what I am looking for. I...

6. Shell Programming and Scripting

How to get sqlplus column header once in csv file?

Hi All, Could anyoone please let me know how do I get sqlplus column header once in csv file Scripts are below: cat concreq.sh #!/bin/bash . $HOME/.profile while ; do sqlplus apps/pwd <<-EOF set lines 100 pages 100 col "USER_CONCURRENT_QUEUE_NAME" format a40; --set termout off...

7. Shell Programming and Scripting

Generating file from sqlplus

Hi Frndz, I have req in which i need to run the query stored in some file and then store the resultset of the query in some other file. PFB the code i have written: #----Start job log--- SQLLOG='/opt/app/vertica2/cdr_dev/logs/conn_orac_db.log' ORA_USER='abc' ORA_PASSWD='xyz' ...

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

9. Programming

How to pass parameter from file to sqlplus in UNIX?

i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different. 343535435 365765767 343534543 343543543 i want to pass this file to sqlplus and sql command is ...

LEARN ABOUT DEBIAN

pull-lp-source

PULL-LP-SOURCE(1)					      General Commands Manual						 PULL-LP-SOURCE(1)

NAME

       pull-lp-source - download a source package from Launchpad

SYNOPSIS

       pull-lp-source [options] source package [release|version]

DESCRIPTION

       pull-lp-source  downloads  and  extracts  the  specified version of <source package> from Launchpad, or the latest version of the specified
       release.  To request a version from a particular pocket say release-pocket (with a magic -release for only the release pocket).	If no ver-
       sion or release is specified, the latest version in the development release will be downloaded.

OPTIONS

       Listed below are the command line options for pull-lp-source:

       source package
	      This is the source package that you would like to be downloaded from Launchpad.

       version
	      This is the version of the source package to be downloaded.

       release
	      This  is	the  release that you would like the source package to be downloaded from.  This value defaults to the current development
	      release.

       -h, --help
	      Display a help message and exit.

       -d, --download-only
	      Do not extract the source package.

       -m UBUNTU_MIRROR, --mirror=UBUNTU_MIRROR
	      Use the specified Ubuntu mirror.	Should be in the form http://archive.ubuntu.com/ubuntu.  If the package isn't found on	this  mir-
	      ror, pull-lp-source will fall back to Launchpad, as its name implies.

       --no-conf
	      Do not read any configuration files, or configuration from environment variables.

ENVIRONMENT

       All  of	the  CONFIGURATION  VARIABLES  below are also supported as environment variables.  Variables in the environment take precedence to
       those in configuration files.

       DIST   Specifies the default target.

CONFIGURATION VARIABLES

       The following variables can be set in the environment or in ubuntu-dev-tools(5) configuration files.  In  each  case,  the  script-specific
       variable takes precedence over the package-wide variable.

       PULL_LP_SOURCE_UBUNTU_MIRROR, UBUNTUTOOLS_UBUNTU_MIRROR
	      The default value for --mirror.

SEE ALSO

       dget(1), pull-debian-source(1), pull-debian-debdiff(1), ubuntu-dev-tools(5)

AUTHOR

       pull-lp-source  and  this manual page were written by Iain Lane <iain@orangesquash.org.uk>.  Both are released under the GNU General Public
       License, version 3 or later.

ubuntu-dev-tools						   4 August 2008						 PULL-LP-SOURCE(1)