06-08-2006
Running SQLPLUS from Shellscripting ...
Hi guys,
I am facing issues while triggering sqlplus with "/" option
I can connect to database with USER ID and password. but, if i just specify "/" option since it is "externally identiifed user" it doesn't work
Any suggestions?
mail me @ Removed.
Regards, Giri
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a script which connects to different database servers using sqlplus. Is there a way by which I can run a shell command on that host from sqlplus?
I know about 'host' command but it runs script on the local machine where the original script is running. Is there a way to run command on the... (9 Replies)
Discussion started by: dkr123
9 Replies
2. Shell Programming and Scripting
I have 3 shell scripts below.... I need to write a command line parser
for these 3 utilities.
basically the parser will accept ANY number of commands in this syntax
-r = right -f = findtext -c = count so you do something like
mu.s -r 3 4 5 -f hello goodbye.txt -c *.c -h 5 4 3
right... (5 Replies)
Discussion started by: TurboArkhan
5 Replies
3. 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
4. Shell Programming and Scripting
cron job not running the sqlplus command in shell script but the shell script works fine from command line..
Cronjob:
5 * * * * /home/dreg/script.sh
script.sh:
#!/bin/ksh
/oracle/u000/app/oracle/product/10204/GEN/bin/sqlplus -s <user>/<pass>@<sid/home/dreg/sqlscript.sh
... (18 Replies)
Discussion started by: Ikea
18 Replies
5. Shell Programming and Scripting
Hello,
This may not be the right place to ask for help for this problem but i might be because i'm using Java & SqlPlus in alot of Kshell scripts.
Just to give a high level picture, i'm basically using Java to control each SqlPlus execute command, by reading a flat file that contains the run... (2 Replies)
Discussion started by: bobk544
2 Replies
6. Shell Programming and Scripting
Hi,
Can someone please help me here with this one.
This is my script:
# more tosh.sh
#!/usr/bin/ksh
clear
. /home/oracle/.profile
echo "Good morning, world."
export ORACLE_HOME=/u01/app/oracle/product/9.0.1
export PATH=$ORACLE_HOME/bin:/usr/local/bin
export ORACLE_SID=xxxx
... (11 Replies)
Discussion started by: santoshpayal
11 Replies
7. Shell Programming and Scripting
Hi all,
on AIX 6.1 I want to run the following but for 5 DB. How should I do that ? Using FOR, WHILE ???? How ?
export ORACLE_SID=DB1
sqlplus / as sysdba << EOF
whenever sqlerror exit sql.sqlcode;
whenever oserror exit FAILURE
set define off
set head off
set feedback off
set echo off... (1 Reply)
Discussion started by: big123456
1 Replies
8. Solaris
I am using following code to connect to oracle database from solaris shell script. which will try thrice to connect the database ...at the 4rth atempt it will exir=t.
count=0
while ; do
sqlplus -s $usrname/$password@dbSID <<-EOF | tee $logfile
WHENEVER OSERROR EXIT 9;
WHENEVER SQLERROR... (4 Replies)
Discussion started by: millan
4 Replies
9. Windows & DOS: Issues & Discussions
Hello All,
Good Afternoon.
I am new to this platform and I need one small help regarding running a SQL file from Bat file. Below is what I am doing,
1. I placed the below command in one Bat file.
start putty.exe -ssh user@host -pw pwd -m C:\2.txt
2. In 2.txt, I have below command.
... (3 Replies)
Discussion started by: PavanPatil
3 Replies
10. 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
LEARN ABOUT CENTOS
tk_setpalette
tk_setPalette(n) Tk Built-In Commands tk_setPalette(n)
__________________________________________________________________________________________________________________________________________________
NAME
tk_setPalette, tk_bisque - Modify the Tk color palette
SYNOPSIS
tk_setPalette background
tk_setPalette name value ?name value ...?
tk_bisque
_________________________________________________________________
DESCRIPTION
The tk_setPalette procedure changes the color scheme for Tk. It does this by modifying the colors of existing widgets and by changing the
option database so that future widgets will use the new color scheme. If tk_setPalette is invoked with a single argument, the argument is
the name of a color to use as the normal background color; tk_setPalette will compute a complete color palette from this background color.
Alternatively, the arguments to tk_setPalette may consist of any number of name-value pairs, where the first argument of the pair is the
name of an option in the Tk option database and the second argument is the new value to use for that option. The following database names
are currently supported: activeBackground foregroundselectColor activeForeground highlightBackgroundselectBack-
ground background highlightColor selectForeground disabledForeground insertBackgroundtroughColor tk_setPalette tries to
compute reasonable defaults for any options that you do not specify. You can specify options other than the above ones and Tk will change
those options on widgets as well. This feature may be useful if you are using custom widgets with additional color options.
Once it has computed the new value to use for each of the color options, tk_setPalette scans the widget hierarchy to modify the options of
all existing widgets. For each widget, it checks to see if any of the above options is defined for the widget. If so, and if the option's
current value is the default, then the value is changed; if the option has a value other than the default, tk_setPalette will not change
it. The default for an option is the one provided by the widget ([lindex [$w configure $option] 3]) unless tk_setPalette has been run pre-
viously, in which case it is the value specified in the previous invocation of tk_setPalette.
After modifying all the widgets in the application, tk_setPalette adds options to the option database to change the defaults for widgets
created in the future. The new options are added at priority widgetDefault, so they will be overridden by options from the .Xdefaults file
or options specified on the command-line that creates a widget.
The procedure tk_bisque is provided for backward compatibility: it restores the application's colors to the light brown ("bisque") color
scheme used in Tk 3.6 and earlier versions.
KEYWORDS
bisque, color, palette
Tk 4.0 tk_setPalette(n)