12-12-2012
linux i686 (32 bits)
---------- Post updated at 07:43 AM ---------- Previous update was at 07:39 AM ----------
maybe because i have installed instantclient-sqlplus-linux.x64-11.2.0.3.0.zip and instantclient-basic-linux.x64-11.2.0.3.0.zip instead of 32bits . I will try
---------- Post updated at 09:48 AM ---------- Previous update was at 07:43 AM ----------
no it doesn't still work
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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... (3 Replies)
Discussion started by: sakthi.abdullah
3 Replies
2. UNIX for Dummies Questions & Answers
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 ||','||
... (2 Replies)
Discussion started by: deepakgang
2 Replies
3. UNIX for Dummies Questions & Answers
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... (1 Reply)
Discussion started by: Leo_NN
1 Replies
4. Shell Programming and Scripting
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
... (3 Replies)
Discussion started by: mmunir
3 Replies
5. UNIX for Dummies Questions & Answers
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... (1 Reply)
Discussion started by: Mrjester
1 Replies
6. Shell Programming and Scripting
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... (5 Replies)
Discussion started by: a1_win
5 Replies
7. Shell Programming and Scripting
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'
... (7 Replies)
Discussion started by: gnnsprapa
7 Replies
8. Shell Programming and Scripting
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}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
9. Programming
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
... (7 Replies)
Discussion started by: pallvi_mahajan
7 Replies
LEARN ABOUT DEBIAN
ubuntu-build
UBUNTU-BUILD(1) General Commands Manual UBUNTU-BUILD(1)
NAME
ubuntu-build - command-line interface to Launchpad build operations
SYNOPSIS
ubuntu-build <srcpackage> <release> <operation>
DESCRIPTION
ubuntu-build provides a command line interface to the Launchpad build operations.
OPERATIONS
Listed below are the available operations for ubuntu-build:
status Outputs the build status of the package on Launchpad on all architectures.
retry Requests that the package has another attempt at rebuilding from source. This will only work if the package has Failed to build on
Launchpad.
rescore
Requests that the package's build priority be raised in the build queue. Only members of the Launchpad build administrators may
issue this operation, and it may only be performed on packages which Need building.
OPTIONS
Listed below are the command line options for ubuntu-build:
-h or --help
Display a help message and exit.
Retry and rescore options:
These options may only be used with the 'retry' and 'rescore' operations.
-a ARCHITECTURE, --arch=ARCHITECTURE Rebuild or rescore a specific architecture. Valid architectures include: amd64, sparc, powerpc,
i386, armel, armhf, ia64, lpia, hppa.
Batch processing:
These options and parameter ordering is only available in --batch mode. Usage: ubuntu-build --batch [options] <package>...
--batch Enable batch mode
--series=SERIES Selects the Ubuntu series to operate on (default: current development series)
--retry Retry builds (give-back).
--rescore=PRIORITY Rescore builds to <priority>.
--arch2=ARCHITECTURE Affect only 'architecture' (can be used several times). Valid architectures are: amd64, sparc, powerpc, i386,
armel, armhf, ia64, lpia, hppa.
AUTHORS
ubuntu-build was written by Martin Pitt <martin.pitt@canonical.com>, and this manual page was written by Jonathan Patrick Davies
<jpds@ubuntu.com>.
Both are released under the terms of the GNU General Public License, version 3 or (at your option) any later version.
ubuntu-dev-tools June 2010 UBUNTU-BUILD(1)