By following the method mentioned above, one can make any
oracle script file run from oracle through shell script. The shell programming
mentioned above is a simple one, but it can be extended to handle complicated
business requirements. Also, any oracle process that needs to be run frequently
can be invoked through a shell script, which in turn can be configured to run
at given time intervals. If the server is a remote one then there may be a
possibility that the running oracle process may get interrupted for say network
issues. To avoid the issue, the shell script may be run in nohup mode allowing
the process to run in the background from server side until the end without
getting affected for different network issues.