Executing Unix Shell Script

mkeevil · Post by **mkeevil** » Mon Jul 18, 2005 1:06 pm

We are running Oracle 9i on a Solaris 8 box and I was wondering if there is anyway to execute a shell script that is on that remote box?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Jul 18, 2005 1:14 pm

Look for rsh.

mkeevil · Post by **mkeevil** » Mon Jul 18, 2005 1:55 pm

DS is running on Windows, can't use rsh right????

gsherry1 · Post by **gsherry1** » Mon Jul 18, 2005 2:21 pm

mkeevil wrote:DS is running on Windows, can't use rsh right????

You will be able to use rsh and many other Unix like commands if you install cygwin on your windows installation.

mkeevil · Post by **mkeevil** » Mon Jul 18, 2005 2:34 pm

Where can I download cygwin and find the documentation for it? Is there a way to do it with Native DS? without installing any other products?

gsherry1 · Post by **gsherry1** » Mon Jul 18, 2005 2:45 pm

mkeevil wrote:Where can I download cygwin and find the documentation for it? Is there a way to do it with Native DS? without installing any other products?

Cygwin is free, and you can find more information about it here:
http://www.cygwin.com/
I am able to run rsh from a windows cmd prompt, which means you should be able to do it from DataStage on windows platform.

I am not a windows expert, so I am not aware of any other windows method to accomplish the same task.

mkeevil · Post by **mkeevil** » Mon Jul 18, 2005 3:20 pm

I installed the product to my computer to test it, and it placed an icon on my PC... I can run shell commands when I use the executable that it installed but how do I run them from the dos command line?

gsherry1 · Post by **gsherry1** » Tue Jul 19, 2005 7:52 am

mkeevil wrote:I installed the product to my computer to test it, and it placed an icon on my PC... I can run shell commands when I use the executable that it installed but how do I run them from the dos command line?

To execute any windows command from command line, the location of that executable must be in the %PATH% environment variable.

To check if this is so:
1. start cygwin shell and type 'cygpath -w /' This should return the root of the cygwin installation, which is typically "c:\Cygwin" or "c:\Program Files\Cygwin".
2. Check MyComputer->Properties->Advanced->EnvironmentVariables->System Variables->Path value to see if it contains the path returned from step 1 with \bin at end.
3. If not add this path with \bin at end to the path and retry running rsh from command line.

mkeevil · Post by **mkeevil** » Tue Jul 19, 2005 8:47 am

The only problem is I dont think this can connect to a secured shell, I am going to try to use openssh. At least this is what our unix admin told me.

DSXchange

Executing Unix Shell Script

Executing Unix Shell Script

Running RSH on Windows

Running rsh from windows command line.