OraFAQ Forum: Linux » Shell Script

Home » Infrastructure » Linux » Shell Script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Shell Script [message #685344]

Mon, 13 December 2021 07:08

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.

Report message to a moderator

Re: Shell Script [message #685345 is a reply to message #685344]

Mon, 13 December 2021 07:54

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 11:53:48 CDT 2025