DBAmon DB Client Configuration

DBAmon

DB Client Configuration - Windows/NT4

Configuration - Windows/NT4 DB Server

Install RSH Software
The Microsoft NT Resource Kit software is used to provide remsh functionality.
Steps:
1. Install Software: Install the software on your NT server.
2. Configure Software: Create an .rhosts file will connectivity:
```
dbamonmaster.domain.com dbamonuser
```
3. Start Service: Start the service corresponding to your RSH software. Make sure in the Settings->Services scree that you make this service autostart at system boot time.
4. Test: From your DBAmon Master Server as the userid that DBAmon will run with, run:
```
remsh  dir
```
Install ActivePerl
Refer to the ActivePerl WWW Site and download and install Perl. Note the location of the Perl executable (probably E:\Perl\bin\Perl).
Install DBI/DBD For Perl
See CPAN .
ODBC Configuration - Oracle
- Create ODBC Driver
  On NT server:
  - Start
  - Settings
  - Control Panel
  - ODBC
  - Click SYSTEM DSN Tab
  - Add
  - Oracle ODBC Driver
  - Finish
  - Data Source Name: DBAmonOracle{ORACLE_SID}
  - Service Name: {ORACLE_SID}
  - Userid: system
  - OK (Driver Setup)
  - OK (ODBC Data Source Administrator)
- Update Password For ODBC Driver
  On NT server:
  - Start
  - Run
  - regedit
  - HKEY_LOCAL_MACHINE
  - SOFTWARE
  - ODBC
  - odbc.ini
  - DBAmonOraclePONYPROD
  - Edit
  - New
  - String Value
  - Password (Name of new "Name")
  - Right Click on Password Field
  - Modify
  - Value data: (Password of Oracle system user)
  - Registry
  - Exit
Check /tmp
DBAmon downloads software to every DB Server that it monitors. It is place in /tmp, so ensure that /tmp has at least, say, 1MB of free space.

That's it!
DBAmon.com
This Document: http://www.dbamon.com/config/configdb_mssql.shtml