I have a script which connects to different database servers using sqlplus. Is there a way by which I can run a shell command on that host from sqlplus?

I know about 'host' command but it runs script on the local machine where the original script is running. Is there a way to run command on the remote host to which I am connection thru sqlplus.

Thanks

man remsh

Is there any other way apart from rsh/remsh.. rsh is blocked. When I do it says permission denied.

Thanks,

What are you trying to do? (rather than fixing how you are currently doing it)

I have a script that connects to different databases using sqlplus. It basically pulls rows from all the different servers and creates a repository in a single table on host machine.

Apart from pulling information from each database, I also want a script to get executed on the OS where the database reside.

Is this possible using sqlplus?

Thanks.

If rsh and remsh are "turned off" then, no. Not without privilege.

You do realize that you can access all of the remote Oracle servers without physically running your sql code on those servers. In other words, you can write a block of code on boxa, that runs on boxa, that accesses, in turn, all of the remote Oracle instances that you need to query. You never leave boxa, where you have to run your script.

Ask your DBA to set up tnsnames and make a few other other changes so you can do that. This is standard Oracle. You may already be able to do that now, so ask your DBA "how to"