Home » Applications » Oracle Fusion Apps & E-Business Suite » Concurrent Program to FTP file (E-Business Suite 11i)
Concurrent Program to FTP file [message #352126] Mon, 06 October 2008 04:44 Go to next message
cjhall01
Messages: 6
Registered: September 2008
Junior Member
Hi,

I am new to writing Linux scripts and am trying to set up a concurrent program which will regularly FTP a file from our DB server to a remote ftp server.

I have written a shell script in Notepad which looks something like

#!/bin/ksh
ftp <servername>
user <username> <password>
cd /usr/tmp
put <filename>

and I have named it and put it in /app00/applmgr/ftrani/appl/xbol/11.5.0/bin - I have given the file the '777' permissions.

I have then defined the executable, set it up as a concurrent program and then ran it as a request.

When I do this I get an error message saying that the executable for this program cannot be executed.

Can anyone help me with this? I'm not sure whether it is the file I have created or what I've done with it, if anyone has any examples or anything for this it would be greatly appreciated, thank


Chris
Re: Concurrent Program to FTP file [message #352136 is a reply to message #352126] Mon, 06 October 2008 05:21 Go to previous messageGo to next message
soniasaini23
Messages: 5
Registered: April 2005
Location: gurgaon
Junior Member

Launch a telnet session

Go to $XBOL_TOP/bin
$ chmod 755 program_name.prog
$ pbrun impdba –u uroracleuser
$ ln -s $FND_TOP/bin/fndcpesr $XBOL_TOP/bin/program_name

n executable method should be host.

Re: Concurrent Program to FTP file [message #352148 is a reply to message #352136] Mon, 06 October 2008 05:44 Go to previous messageGo to next message
cjhall01
Messages: 6
Registered: September 2008
Junior Member
Hi thenks for the reply,

could I just check with this line

$ pbrun impdba –u uroracleuser

what should be put for "uroracleuser"?


thank you for your help,


Chris
Re: Concurrent Program to FTP file [message #352152 is a reply to message #352136] Mon, 06 October 2008 05:56 Go to previous messageGo to next message
cjhall01
Messages: 6
Registered: September 2008
Junior Member
I tried to run

$ pbrun impdba –u uroracleuser

as $ pbrun impdba –u sysadmin

and I got a message error of

-bash: pbrun: command not found


Chris
Re: Concurrent Program to FTP file [message #352154 is a reply to message #352152] Mon, 06 October 2008 06:10 Go to previous messageGo to next message
soniasaini23
Messages: 5
Registered: April 2005
Location: gurgaon
Junior Member
That’s the way Oracle On Demand works, this won’t work under other environments.
Skip this step if you are not using oracle on demand.
otherwise enter the command as
pbrun impdba -u <ur instance name like abprod>.




Re: Concurrent Program to FTP file [message #352164 is a reply to message #352154] Mon, 06 October 2008 07:16 Go to previous messageGo to next message
cjhall01
Messages: 6
Registered: September 2008
Junior Member
Hi,

I am still getting the error "-bash: pbrun: command not found", do I have to be in a certain directory when I run this command?


Chris
Re: Concurrent Program to FTP file [message #352165 is a reply to message #352164] Mon, 06 October 2008 07:18 Go to previous messageGo to next message
soniasaini23
Messages: 5
Registered: April 2005
Location: gurgaon
Junior Member
Try running this step directly.
$ ln -s $FND_TOP/bin/fndcpesr $XBOL_TOP/bin/program_name
Re: Concurrent Program to FTP file [message #352167 is a reply to message #352165] Mon, 06 October 2008 07:30 Go to previous messageGo to next message
cjhall01
Messages: 6
Registered: September 2008
Junior Member
Hi,

I got a message saying

ln: creating symbolic link '/bin/xbo_ubel_extract_ftp' to /bin/fndcpesr': Permission Denied

do you know what that means?


Chris
Re: Concurrent Program to FTP file [message #352395 is a reply to message #352126] Tue, 07 October 2008 07:59 Go to previous message
cjhall01
Messages: 6
Registered: September 2008
Junior Member
Hi,

I have managed to re-write my shell with vi, I have
then made sure that the permissions on the file are correct, then formed a soft link with the fndcpesr command,
then defnied it as an executable,
then defined it as a concurrent program,
then added it to a request set and ran it but am still getting the same error message that the executable cannot be ran,

can anyone think of what else I may not have done?
Previous Topic: Email output pdf
Next Topic: Oracle FSG Report
Goto Forum:
  


Current Time: Mon Jul 01 12:25:24 CDT 2024