Thanks to all who responded! In response to my query about running Intralink reports without sitting in front of the server machine, I received the following suggestions (which I have summarized):
- The consensus is that you can't just run reports (using runrpt) or use the DSMU through a shared drive, you have to be logged in to the server in some fashion. Other than sitting at the server console, here are the options that came up:
- Terminal Services: Bad idea as they don't play well with Oracle.
- VNC: A number of people suggested this option. It requires software to be installed on the server.
- PC Anywhere: A number of people also endorsed this option. Again, it requires software to be installed on the server.
- Remote Command (from the Windows Resource Kit): allows SQL scripts to be run remotely (including stopping and starting Intralink).
- Oracle Client Software (or some other form of raw database access like TOAD): These tools connect directly to the dataserver the way the Intralink client does, so no IT assistance is required. This can be a risky approach as it gives you the ability to edit the database tables directly. If you know SQL, though, this can be a good way to get information from the database, but isn't really a replacement for being able to run scripts on the dataserver.