Configuration - Windows/NT4 DB Server - Oracle
- Install RSH Software
The Microsoft NT Resource Kit software is used to
provide remsh functionality.
Steps:
- Install Software: Install the software on your NT
server.
- Configure Software: Create an .rhosts file will connectivity:
dbamonmaster.domain.com dbamonuser
- 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.
- Test: From your DBAmon Master Server as the userid that
DBAmon will run with, run:
remsh dir
- Add entry to .rhosts file on DBAmon Master Server for this DB Client
Due to a bug in Microsoft RCP which does not allow you to rcp to the Windows/NT
box, we have to pull the files from the NT box. So, you will have to add an .rhosts
entry to the userid that runs DBAmon on the Master Server to allow this. If your
nt box is "chuckie", add the following line:
chuckie.domain.com +
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
Notes:
- You will need to know the Oracle password for user=system.
- The ORACLE_SID mentioned here is the TNSNAMES.ORA entry name and it must be equal to the DB name.
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)
Store Password For ODBC Driver - Oracle >= 8.0.5.7
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
Store Password For ODBC Driver - Oracle < 8.0.5.7
You will have to store the internal user=system password in
a file. For example if your user=system password is manager
and your ORACLE_HOME is e:\orant, run:
echo manager > e:\orant\net80\admin\.system
Test ODBC Driver
On NT server:
- Start
- Programs
- Oracle
- Oracle ODBC Test
- Connect:
- Machine Data Sources: Tab
- DBAmonOracle{SID}: Click
- OK
- Enter system Password
- OK
- ALL TABLES
- File -> Exit
That's it!
