hi ,
I tried running a PL/SQL script through unix shell script.
But am getting the following error.
"Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus "
Kindly suggest.
Regards,
Samit (5 Replies)
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Hi I am getting this error while connecting to sql through a shell script, whereas i am able to connect to sql directly.
It was working properly earlier, no clue why i am getting this.
Please find the log below:
FTP to <IP> completed Wed Apr 30 11:42:01 BST 2008
Program ended. Wed Apr 30... (1 Reply)
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
I need help in the following script. I want to grep the sql errors insert into the error table and exit the shell script if there is any error, otherwise keep running the scripts.
Here is my script
#!/bin/csh -f
source .orapass
set user = $USER
set pass = $PASS
cd /opt/data/scripts
echo... (2 Replies)
Hi,
I am trying to call sql script from ksh job with parameters.The parameters passed from ksh job will be used in SELECT query in sql file to SPOOL the data in extract file.My questions are:
1) How to call a sql script from ksh job with parameters?
2) How to use the parameter in sql file to... (1 Reply)
I am connecting to sql databases through shell script. Databases that i am connecting will need password change every 60 days. This is according to our security policy and cannot be changed. But this is creating problem when connecting to Databases through shell script . To connect to oracle DB we... (2 Replies)
Hi Gurus,
I have a script which send sql query to oracle db and return value to my script.
dummy code like below:
sqlplus -s user/${PASSWD}@${ORACLE_SID} @${DIR}/query.sql > outputfile
using above code, when query has error, it send error to same out put file and exit code is 0, is... (6 Replies)
Hi Guys,
I am calling a SQL script which runs under while loop, i need to exit the while loop if i get error in sql script which is called
while
do
sqlplus -s user/pass@db @test.sql id$i
done
test.sql
whenever sqlerror exit;
alter table t1 add &1 number;
I need to come out of... (2 Replies)
Hi All
when I execute from psql prompt, I get the result, when I try to automate
using a shell script, the query is not working
# `/usr/bin/psql -U postgres -d coba1 -c "select name from users where
"Date" > current_date - 30;"`
ERROR: column "Date" does not exist
LINE 1: select... (2 Replies)
Discussion started by: srilinux09
2 Replies
LEARN ABOUT DEBIAN
oarnodesetting
oarnodesetting(1) OAR commands oarnodesetting(1)NAME
oarnodesetting - Change the state and properties of a node in OAR.
SYNOPSIS
oarnodesetting [-h hostname | [[-r resource_number][--sql "sql syntax"] | -a]]
DESCRIPTION
This command is used to Change the state and properties of a node in OAR.
OPTIONS -a, --add
Add a new resource.
-s, --state STATE
Set the new state of the node. The available states are: Alive, Absent and Dead.
-m, --maintenance on/off
Set the maintenance mode on/off (resource state will be set to absent and available_upto field set to 0).
-h, --hostname HOSTNAME
Set the node hostname.
-r, --resource
Set the resource.
--sql
Get resource identifiers which respond to the SQL where clause on the table jobs (ex: "type = 'default'").
-p, --property "PROPERTY=VALUE"
Set the property of the node to the given value.
-n, --nowait
Do not wait for job ends when the node switches to Absent or Dead.
EXAMPLES
oarnodesetting -s Alive -h node012
oarnodesetting -s Absent -h node012
COPYRIGHTS
Copyright 2003-2012 LIG http://lig.imag.fr This software is licensed under the GNU General Public License Version 2 or above. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oarnodesetting 2012-05-23 oarnodesetting(1)