10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
ENVIROMENT
Linux: RHEL 6.4
Log Path: /usr/iplanet/servers/https-company/logs
Log Format: user.log.03-15-2015
I have log4j log rotation enabled rotating files on a daily basis.
The rotated logs are NOT compressed & are taking up too much space.
I need a script that will run daily that... (1 Reply)
Discussion started by: admin_job_admin
1 Replies
2. 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
3. Shell Programming and Scripting
This is my .sh file
sqlplus -s my_user/my_pswd@mydb @my_sql.sql
ret_code=$?
if
then
echo "return code is $ret_code "
echo "Failed"
else
echo "return code is $ret_code "
echo "Success"
fi
=====================================================
and my_sql.sql is
whenever... (4 Replies)
Discussion started by: emailsafath2011
4 Replies
4. Shell Programming and Scripting
HELLO,
I am using such a command to write oracle sqlplus query result to text file:
sqlplus -S xxx/xxx@xxxxxxx @\tmp\2.sql>\tmp\123.txt
Is it possible to script that:
If command succesfull write in \tmp\log.txt:
timestamp and "succeded"
and create 123.txt with results
else
If error... (2 Replies)
Discussion started by: tomasba
2 Replies
5. Linux
Hi all,
I am new to redhat/fedora linux.
In fedora linux 6,we created one file system(hda3 - /fs).
in this mount poing we were installed mounta vista os.
while booting we are getting below error messages.
1)
Booting 'mountaVisat(2.6.18_pro 500_pc_target-x86_586 smp)'
root(hd0,1)... (2 Replies)
Discussion started by: arjunreddy3
2 Replies
6. 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
7. Shell Programming and Scripting
I am running a script that invokes SQLPLUS. During the execution I get the following:
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jun 11 16:12:50 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 -... (3 Replies)
Discussion started by: ssmith001
3 Replies
8. Shell Programming and Scripting
hi friends,
i m tryin to load data from one set of table to other i have sql procedure al ready for it..!
i m going to load the procedure only if data in one of my table for example
table "landing " have 10 records each attribute of this table is
file_name status date ... (2 Replies)
Discussion started by: kulbir
2 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I wrote a shell script to call oracle procedure. But when i am trying to connet sqlplus with the fallowing statement It is giving me error " callproce.sh : sqlplus: not found". What could be the problem.
sqlplus -s $CONNECT_STRING >$LOGFILE <<!!
thank u all
papachi (2 Replies)
Discussion started by: papachi
2 Replies
10. Shell Programming and Scripting
Hi folks a wee problem that requires some help.
I am writing a script that allows me to automate the changing of a password in sqlplus
the problem i encounter is that the code contains a case statement that allows the helpdesk to select whether to allow or deny access by switching the... (1 Reply)
Discussion started by: w33man
1 Replies
STCPCLI(1) BP executables STCPCLI(1)
NAME
sstcpcli - DTN simple TCP convergence layer input task
SYNOPSIS
stcpcli local_hostname[:local_port_nbr]
DESCRIPTION
stcpcli is a background "daemon" task comprising 1 + N threads: one that handles TCP connections from remote stcpclo tasks, spawning
sockets for data reception from those tasks, plus one input thread for each spawned socket to handle data reception over that socket.
The connection thread simply accepts connections on a TCP socket bound to local_hostname and local_port_nbr and spawns reception threads.
The default value for local_port_nbr, if omitted, is 4556.
Each reception thread receives bundles over the associated connected socket. Each bundle received on the connection is preceded by a
32-bit unsigned integer in network byte order indicating the length of the bundle. The received bundles are passed to the bundle protocol
agent on the local ION node.
stcpcli is spawned automatically by bpadmin in response to the 's' (START) command that starts operation of the Bundle Protocol; the text
of the command that is used to spawn the task must be provided at the time the "stcp" convergence layer protocol is added to the BP
database. The convergence layer input task is terminated by bpadmin in response to an 'x' (STOP) command. stcpcli can also be spawned and
terminated in response to START and STOP commands that pertain specifically to the STCP convergence layer protocol.
EXIT STATUS
0 stcpcli terminated normally, for reasons noted in the ion.log file. If this termination was not commanded, investigate and solve the
problem identified in the log file and use bpadmin to restart stcpcli.
1 stcpcli terminated abnormally, for reasons noted in the ion.log file. Investigate and solve the problem identified in the log file,
then use bpadmin to restart stcpcli.
FILES
No configuration files are needed.
ENVIRONMENT
No environment variables apply.
DIAGNOSTICS
The following diagnostics may be issued to the ion.log log file:
stcpcli can't attach to BP.
bpadmin has not yet initialized Bundle Protocol operations.
No such stcp duct.
No STCP induct matching local_hostname and local_port_nbr has been added to the BP database. Use bpadmin to stop the STCP convergence-
layer protocol, add the induct, and then restart the STCP protocol.
CLI task is already started for this duct.
Redundant initiation of stcpcli.
Can't get IP address for host
Operating system error. Check errtext, correct problem, and restart STCP.
Can't open TCP socket
Operating system error. Check errtext, correct problem, and restart STCP.
Can't initialize socket
Operating system error. Check errtext, correct problem, and restart STCP.
stcpcli can't create access thread
Operating system error. Check errtext, correct problem, and restart STCP.
BUGS
Report bugs to <ion-bugs@korgano.eecs.ohiou.edu>
SEE ALSO
bpadmin(1), bprc(5), stcpclo(1)
perl v5.14.2 2012-05-25 STCPCLI(1)