sqlplus: No such file or directory Post: 302743161

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

ubuntu-dev-tools

ubuntu-dev-tools(5)						File Formats Manual					       ubuntu-dev-tools(5)

NAME

       ubuntu-dev-tools - Configuration for the ubuntu-dev-tools package.

DESCRIPTION

       The  ubuntu-dev-tools  package  is  similar in scope to the devscripts(1) package, providing a collection of scripts which may be of use to
       Ubuntu and Debian developers or others wishing to build Debian packages.

       Some of these scripts have options which may be configured  on  a  system-wide  and  per-user  basis.   These  options  are  configured	in
       devscripts.conf(5).

       All variables are described in the script's manpages. Package-wide variables begin with "UBUNTUTOOLS" and are listed below.

       Every script which reads the configuration files can be forced to ignore them by using the --no-conf command-line option.

ENVIRONMENT

       All ubuntu-dev-tools configuration variables can be set (and overridden) by setting them in the environment (unlike devscripts).

       In addition, several scripts use the following environment variables:

       UBUMAIL
	      Overrides  DEBEMAIL  and	DEBFULLNAME  when  the	target	is  clearly  Ubuntu.   Can  either  contain an e-mail address or Full Name
	      <email@example.org>.

       DEBEMAIL, DEBFULLNAME
	      As in devscripts(1).

PACKAGE-WIDE VARIABLES
       The currently recognised package-wide variables are:

       UBUNTUTOOLS_BUILDER
	      This specifies the preferred test-builder, one of pbuilder (default), sbuild, pbuilder-dist.

       UBUNTUTOOLS_DEBIAN_MIRROR
	      The preferred Debian archive mirror.  Should be of the form http://ftp.debian.org/debian (no trailing slash).  If not specified, the
	      master will be used.

       UBUNTUTOOLS_DEBSEC_MIRROR
	      The  preferred Debian security archive mirror.  Should be of the form http://security.debian.org (no trailing slash).  If not speci-
	      fied, the master will be used.

       UBUNTUTOOLS_UBUNTU_MIRROR
	      The preferred Ubuntu archive mirror.  Should be of the form http://archive.ubuntu.com/ubuntu (no trailing slash).  If not specified,
	      the master will be used.

       UBUNTUTOOLS_UBUNTU_PORTS_MIRROR
	      The preferred Ubuntu archive mirror.  Should be of the form http://ports.ubuntu.com (no trailing slash).	If not specified, the mas-
	      ter will be used.

       UBUNTUTOOLS_LPINSTANCE
	      The launchpad instance to communicate with. e.g. production (default) or staging.

       UBUNTUTOOLS_MIRROR_FALLBACK
	      Whether or not to fall-back to the master archive mirror.  This is usually the desired behaviour, as mirrors can	lag  the  masters.
	      If on a private network with only a local mirror, you may want to set this to no.  One of yes (default) or no.

       UBUNTUTOOLS_UPDATE_BUILDER
	      Whether or not to update the test-builder before each test build.  One of yes or no (default).

       UBUNTUTOOLS_WORKDIR
	      The directory to use for preparing source packages etc.  When unset, defaults to a directory in /tmp/ named after the script.

SEE ALSO

       devscripts(1), devscripts.conf(5)

AUTHORS

       This manpage was written by Stefano Rivera <stefanor@ubuntu.com>.

ubuntu-dev-tools						 December 19 2010					       ubuntu-dev-tools(5)