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)
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)
Hello,
If I run this command on the server it works.
# dbc "update config set radio_enabled = 0;"
how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line.
#!/usr/bin/perl
#database path
$dbc='/opt/bin/psql -Userver... (0 Replies)
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
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)
I've been sent the following script to finish. It's supposed to connect to an oracle database, query it, and send an email if the query result value is one or more. Currently it isn't connecting properly, just giving the following error:
ERROR: ORA-01017: invalid username/password; logon denied... (2 Replies)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Hi,
I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script.
The scenario is like....
Suppose I have a file abc.txt that has the card numbers..it could be in thousands..
then I need to fire a query like
... (12 Replies)
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies
LEARN ABOUT HPUX
cdsclerk
cdsclerk(1m)cdsclerk(1m)NAME
cdsclerk - Manages the interface between clients and the CDS server
SYNOPSIS
cdsclerk [-D] [-w route]
OPTIONS
For debugging use only. Causes the cdsadv clerk process not to fork. Routes serviceability messages.
DESCRIPTION
The cdsclerk command manages the interface between clients and the CDS server.
Privilege Required
You must log in as superuser (root).
NOTES
This command is used by the advertiser on the system where the CDS clerk is running. You should use this command interactively only to do
diagnostic work on the host system.
EXAMPLE
Before you run the following process, make sure that other clerks are not running. To start the cdsclerk process, follow these steps:
Make sure that a CDS server is already running somewhere within the cell. Log in to the system as superuser (root). Log in to DCE as the
machine principal of the local host. Enter the principal name in the format /hosts/hostname/self as shown in the following example command
for a host named orion whose password is smith: # dce_login hosts/orion/self smith Enter the following command to see if the dced process
is already running: # ps
If the dced process appears on the list of active processes, proceed to step 5. If the dced process does not appear on the list of active
processes, enter the following command to start the process: # dced Enter the following command to start the cdsadv process: # cdsadv Enter
the following command with the appropriate arguments to start the cdsclerk process: # cdsclerk
RELATED INFORMATION
Books: OSF DCE Administration Guide
cdsclerk(1m)