use below code to trace error.
Seems like sqlplus is unable to connect to database may be some issue with userid/password or SID.
then check the error.txt for the error occured
Also try to write the sql query in a seperate file sqlquery.txt and execute it as below
and see what happens...
Last edited by aashish.sharma8; 08-09-2012 at 07:31 AM..
Reason: Added info
Hello-
The code below works fine expect that it does not update the table CTL_INTERFACE "red highlight". Any idea what I'm doing wrong here?
Thanks:D
# coNNECT to the database and insert a row then get the new row id
cycle_id=`sqlplus -S $XXX_USER/$XXX_PW@$XXX_CONNECT << EOF
SET ECHO... (3 Replies)
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)
Hi
Our nis server running on Sun solaris 8 operating system.
I have added a new user in the nis passwd file
& when I am trying to update the file from nis server by using
following command:
# cd /var/yp
# make
updated passwd
It updates the passwd file but does not come back to command... (3 Replies)
Hi Expert,
Below is a real production environment issue:
we are using shell script to FTP to a remote server and fetch around 150 files every day, for each file we need to keep a entry inside ORACLE DB table, before insert into table, each file has a associated logid, which need to be... (2 Replies)
Hi,
I've created a very basic script to run apt-get update and apt-get dist-upgrade unattended (run with cron) and save the logs. Though, it's not really a script, just a file containing the commands to run in order: pasteit .com/18601
I'm currently testing this and ran into some unexpected... (4 Replies)
i have redhat service as public dns i have added new entry but when i reload the named service i got this error in log
the working directory is not writable (1 Reply)
I want to update svn code using a nightly job using cron, i have created a job in cron as,
30 17-19 * * 1-5 /home/saprab/svnUpdate.sh <branch> <svnusername> <svnpassword> >> <logfile> 2>&1
svnUpdate.sh :
===============
#!/bin/bash
branch=$1
svnuser=$2
svnpass=$3
cd ${branch}... (2 Replies)
Hi,
I am facing an issue wherein some temporary files (here docs) are getting created in /tmp and are not getting deleted automatically.
When i check the list of open files with below command i can see one file is getting appended continuously.(In this case /tmp/sfe7h.34p)
The output is... (4 Replies)
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)
Hi
i want to update the BASH because of the "shell shock" vulnerability.
my RedHat 5 is clean install with the default mirror site.
when im running the command: yum update bash
im getting a message saying there is no update. you can see in the attach picture...
what am i doing wrong? is... (4 Replies)
Discussion started by: guy3145
4 Replies
LEARN ABOUT DEBIAN
rt-setup-database-4
rt-setup-database(8) Request Tracker Reference rt-setup-database(8)NAME
rt-setup-database - Set-up the database for Request Tracker
SYNOPSIS
rt-setup-database --action ...
OPTIONS
action
Several actions can be combined using comma separated list.
init
Initialize the database. This is combination of multiple actions listed below. Create DB, schema, setup acl, insert core data and
initial data.
upgrade
Apply all needed schema/acl/content updates (will ask for version to upgrade from)
create
Create the database.
drop
Drop the database. This will ERASE ALL YOUR DATA.
schema
Initialize only the database schema
To use a local or supplementary datafile, specify it using the '--datadir' option below.
acl Initialize only the database ACLs
To use a local or supplementary datafile, specify it using the '--datadir' option below.
coredata
Insert data into RT's database. This data is required for normal functioning of any RT instance.
insert
Insert data into RT's database. By default, will use RT's installation data. To use a local or supplementary datafile, specify it
using the '--datafile' option below.
datafile
file path of the data you want to action on
e.g. "--datafile /path/to/datafile"
datadir
Used to specify a path to find the local database schema and acls to be installed.
e.g. "--datadir /path/to/"
dba dba's username
dba-password
dba's password
prompt-for-dba-password
Ask for the database administrator's password interactively
skip-create
for 'init': skip creating the database and the user account, so we don't need administrator privileges
root-password-file
for 'init' and 'insert': rather than using the default administrative password for RT's "root" user, use the password in this file.
perl v5.14.2 2013-05-22 rt-setup-database(8)