What you ask isn't trivial (IMHO). To start, you might look into Expect to send commands to launched programs (like sqlplus). There are other ways to do this but it seems to fit best with what you've outlined here.

It might be easiest to have most of the startup/shutdown controls in a Perl script local to that machine so your local script just needs to login and start the remote script.