rats_server Installation
 

Installation for this is rather simple.  Install the appropriate Oracle components, and configure them so that you can connect to your remote database using sqlplus. Pick a directory where rats_server is going to live. In that directory, you need to put the rats_server binary.  That directory also needs a ratscal file, and a ratsconf file. Create/populate these files according to their descriptions in the documentation under Server Detail Config. Make a directory called rats_logs. Run rats_server as root, and set the machine up so it is run as root whenever the machine is rebooted.

ORACLE INSTALL COMMENTS
The majority of the installation process for rats_server involves installing the appropriate Oracle components. In order to do this, you need an oracle 7.3.3 CD or an nfs mountable staging area installed on a networked drive. You will also need an oracle user on the box that you are installing on. The Oracle installer should then be used to install the TCP/IP adapter, sqlnet, sqlplus, the oracle XA library, the sql module for C, and the ProC libraries. Once they are installed, you need to set the environment variables in the oracle users .cshrc file. You need to set ORACLE_BASE, ORACLE_HOME, and TNS_ADMIN the first two paths should have been chosen while running through the installer. TNS_ADMIN should be set to /var/opt/oracle.  In this directory you have to set up tnsnames.ora and sqlnet.ora. The installer may create sqlnet.ora, but it is kind of a chicken and the egg thing. If you don't set up all your paths before running the installer, it doesn't know where to write it. (note: the directory also contains listener.ora which really isn't important if you are only setting up for remote connections to someone else's database)  The file tnsnames.ora is the main place you are likely to have problems that cause you to be unable to connect to the remote server.

This is by no means meant to be a meaningful set of instructions for setting up oracle. That will require you to procure the manuals, a dba, or the Oracle support number. It does however highlight a number of critical elements which should make getting started or troubleshooting a little bit easier.