Home » Infrastructure » Linux » Shell Script
Shell Script [message #685344] Mon, 13 December 2021 07:08 Go to next message
knd.prasad
Messages: 35
Registered: December 2009
Location: HYDERABAD
Member
Hi,

#!/bin/ksh
userid="apps"
psw="apps"
cstring="TEST122"
filena="inbnd.csv"
folder="/home/applmgr/inbound/"
desfolder="/home/applmgr/inbound/processed"
datafilename="/home/applmgr/inbound/inbnd.csv"
ctlfilename="/u03/oracle/TEST122/fs1/EBSapps/appl/fnd/12.0.0/bin/inbound_int_sh.ctl"
logfilename="/home/applmgr/inbound/sqllog_sh.log"
badlogname="/home/applmgr/inbound/sqlbadlog_sh.log"
sqlldr userid=apps/apps@TEST122 data=$datafilename control=$ctlfilename log=$logfilename bad=$badlogname
mv $datafilename $desfolder/inbnd_${CURR_DATE}.csv


Commit point reached - logical record count 22
mv: cannot stat `/home/applmgr/inbound/inbnd.csv\r': No such file or directory


I am getting error in mv command.


Please help me.

Re: Shell Script [message #685345 is a reply to message #685344] Mon, 13 December 2021 07:54 Go to previous message
Michel Cadot
Messages: 68292
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have an hidden character (\r) in this line
datafilename="/home/applmgr/inbound/inbnd.csv"

Note: this an Oracle db related forum.

In addition, if you don't feedback in your topics you won't have more help.

Previous Topic: Kernel configurations for 10 oracle instances
Next Topic: How restart Oracle Database with OL8 Server Reboot
Goto Forum:
  


Current Time: Wed Oct 05 07:12:07 CDT 2022