|
|
Sponsored Content
Special Forums
Windows & DOS: Issues & Discussions
Help required for Running SQLPLUS command from Bat file
Post 302885731 by RudiC on Tuesday 28th of January 2014 06:42:45 AM
01-28-2014
|
|
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have created get_list.bat file containing following line:
dir /B /O-d >file_list.txt
I am executing ftp command from Unix box and transferring get_list.bat file to windows server.
In my next ftp command I am trying to execute this test.bat file by entering this line:
get_list
or by... (9 Replies)
Discussion started by: alx
9 Replies
2. Shell Programming and Scripting
Hi guys,
I am facing issues while triggering sqlplus with "/" option
I can connect to database with USER ID and password. but, if i just specify "/" option since it is "externally identiifed user" it doesn't work
Any suggestions?
mail me @ Removed.
Regards, Giri (2 Replies)
Discussion started by: chittari
2 Replies
3. 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
4. Windows & DOS: Issues & Discussions
I have a .bat file on windows, which converts a .xls file into .csv file and using a ksh script i would usually FTP this .csv file...
Now i want to trigger this .bat form my ksh script.
can i use rsh command in my FTP to run .bat file on windows and then ftp the generated .csv file...is... (19 Replies)
Discussion started by: bhagya2340
19 Replies
5. Shell Programming and Scripting
cron job not running the sqlplus command in shell script but the shell script works fine from command line..
Cronjob:
5 * * * * /home/dreg/script.sh
script.sh:
#!/bin/ksh
/oracle/u000/app/oracle/product/10204/GEN/bin/sqlplus -s <user>/<pass>@<sid/home/dreg/sqlscript.sh
... (18 Replies)
Discussion started by: Ikea
18 Replies
6. Shell Programming and Scripting
Hi all,
on AIX 6.1 I want to run the following but for 5 DB. How should I do that ? Using FOR, WHILE ???? How ?
export ORACLE_SID=DB1
sqlplus / as sysdba << EOF
whenever sqlerror exit sql.sqlcode;
whenever oserror exit FAILURE
set define off
set head off
set feedback off
set echo off... (1 Reply)
Discussion started by: big123456
1 Replies
7. Solaris
I am using following code to connect to oracle database from solaris shell script. which will try thrice to connect the database ...at the 4rth atempt it will exir=t.
count=0
while ; do
sqlplus -s $usrname/$password@dbSID <<-EOF | tee $logfile
WHENEVER OSERROR EXIT 9;
WHENEVER SQLERROR... (4 Replies)
Discussion started by: millan
4 Replies
8. 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
9. Shell Programming and Scripting
Hello All,
I have a requirement in which i need to run few Oracle sql files in parallel.
I want to use xargs command to achieve parallelism.
I tried below command:
cat x|xargs -n 1 -P 5 sqlplus -s $usr/$pwd@$Host @{}
File x has the list of sql files to be executed.
I am getting the... (3 Replies)
Discussion started by: vikas_trl
3 Replies
LEARN ABOUT OSF1
log
Log(4) Kernel Interfaces Manual Log(4) NAME
Log, .Log - Contains the uucp program log files SYNOPSIS
/usr/spool/uucp/.Log DESCRIPTION
The /usr/spool/uucp/.Log directories contain uucp program log files. The uucp program normally places status information about each trans- action in the appropriate log file each time you use the networking utilities facility. All transactions of the uucico and uuxqt daemons are logged in files named for the remote system concerned. The files are stored in a subdirectory of the /usr/spool/uucp/.Log directory named for the daemon involved. Thus, the log files are named with a form of the following: /usr/spool/uucp/.Log/DaemonName/SystemName The uucp and uuto commands call the uucico daemon. The uucico daemon activities for a particular remote system are logged in the System- Name file in the /usr/spool/uucp/.Log/uucico directory on the local system. The uux and uusend commands call the uuxqt daemon. The uuxqt daemon activities for a particular remote system are logged in the SystemName file in the /usr/spool/uucp/.Log/uuxqt directory on the local system. When more than one uucp process is running, however, the system cannot access the standard log file, so it places the status information in a file with a .Log prefix that covers just the single transaction. The uucp program can automatically append the temporary log files to a primary log file. This is called compacting the log files, and is handled by the uudemon.cleanu command, a shell procedure, which combines the log files of the activities of the uucico and uuxqt daemons on a system and stores them in the /usr/spool/uucp/.Old directory. The default is for the uudemon.cleanu command to save log files that are 2 days old. This default can be changed by modifying the appro- priate line in the shell script. If storage space is a problem on a particular system, reduce the number of days that the files are kept in the individual log files. The uulog command can be used to view the uucp program log files. RELATED INFORMATION
Daemons: cron, uucico(8), uusched(8) Commands: uucp(1), uudemon.cleanu(4), uulog(1), uusend(1), uuto(1), uux(1) delim off Log(4)