12-05-2011
Thanks Scott and binlib for the quick answers. I am in the mean time, making few modifications and will update this place once I am done, hopefully today.
What had happened was the user I am using for running script didn't have access to the sqlplus command and thus, I need to run it as a su user which will work.
Thanks again for quickly offering help.
Regards,
Brian.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Discussion started by: mogabr
4 Replies
2. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
3. Shell Programming and Scripting
a job extracts orcle data into unix as flat file.
a single record breaks into two record in unix flat file. This is the case only for 6 records out of 60 lack records.
(its not single record in two line. but its single record into record. ie., \n come into picture)
can you tell me what... (6 Replies)
Discussion started by: Gopal_Engg
6 Replies
4. Shell Programming and Scripting
So, I would like to run differen select queries on multiple databases..
I made a script wich I thought to be called something like..
./script.sh sql_file_name out.log
or to enter select statement in a command line..
(aix)
and I did created some shell script wich is not working..
it... (6 Replies)
Discussion started by: bongo
6 Replies
5. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
6. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
7. Shell Programming and Scripting
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies
8. Shell Programming and Scripting
Hello,
Following my learning of shell scripting.. I got stuck yet again.
If I execute this command on terminal:
$ sed "s/off/on/g" file > fileAUX
I successfully change the text off to on from file to fileAUX.
But the same command is not working inside a shell script. I tested and... (2 Replies)
Discussion started by: quinestor
2 Replies
9. Shell Programming and Scripting
echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on";
Select statement is mentioned below
echo "select res.ti_book_no from disney_ticket_history res where res.ti_status =${STATUS} and... (7 Replies)
Discussion started by: aroragaurav.84
7 Replies
10. Shell Programming and Scripting
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
Discussion started by: nkm0brm
5 Replies
LEARN ABOUT OPENSOLARIS
gnome-cleanup
gnome-cleanup(1) User Commands gnome-cleanup(1)
NAME
gnome-cleanup - cleans GNOME user preferences
SYNOPSIS
gnome-cleanup user
DESCRIPTION
gnome-cleanup erases all GNOME user preferences, returning the user to the default look and feel. This can be used to undo undesired pref-
erence settings, or to correct the desktop if the preferences become corrupt. The GNOME preference files are automatically recreated the
next time the user logs into a GNOME session. By default this program erases the configuration files for the user running the command.
However, a different user can be specified on the command line. Of course, configuration files are only erased if the user running gnome-
cleanup has appropriate file permissions to erase the user's configuration files.
gnome-cleanup will display a listing of all preference files that it will erase before erasing any files, and prompts the user to confirm
that they would like to erase these files. Files are erase only after receiving a positive confirmation from the user.
gnome-cleanup cannot be run while logged into a GNOME session. Users should run this program when logged into another session, for exam-
ple, the Failsafe session. If the user tries to run this program while already logged into GNOME, an error message is displayed.
OPTIONS
None.
OPERANDS
The following operands are supported:
user Specify the user whose configuration files will be erased. The files will only be erased if the user running gnome-cleanup
has file permissions to erase the user's configuration files. This is useful, for example, if you want to run the script
as the root user to erase the configuration files for a specific user. If user is not specified, the user is the same as
the user who runs the gnome-cleanup command.
EXAMPLES
Example 1: Erase GNOME user preferences
example% gnome-cleanup
After displaying a list of preference files that will be erase, the following question is displayed:
Do you wish to remove these files (Y/N)
The files are erase only if the user provides a positive response.
EXIT STATUS
The following exit values are returned:
0 Application exited successfully
>0 Application exited with failure
FILES
The following files are used by this application:
/usr/bin/gnome-cleanup Executable for GNOME cleanup.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWgnome-panel |
+-----------------------------+-----------------------------+
|Interface stability |Volatile |
+-----------------------------+-----------------------------+
SEE ALSO
attributes(5)
NOTES
Written by Brian Cameron, Sun Microsystems Inc., 2003, 2007.
SunOS 5.11 27 Nov 2007 gnome-cleanup(1)