Instructions for Using SiteMinder with an Oracle Database

Run the SMOracle.exe program on the Oracle Server machine.
Bring up the MSDOS Command prompt and change directories to the directory where SMOracle.exe is found.
Execute SMOracle.exe. The program takes several command line arguments:
```
Usage: SMOracle [-u user] [-p password] [-d directory] [-h 
oracle_home]
-u username     Oracle Database Owner name, default: SiteMinder
-p password     Oracle user password, default: SiteMinder
-d directory    Absolute path to SiteMinder DB Oracle directory, 
default: this one
-h oracle_home  Absolute path to Oracle Home directory, default: 
C:\ORANT
```
Be sure to put quotes around any of those arguments that have spaces in them. For example, if the Oracle home directory is C:\Oracle\ORANT, and the SiteMinder Oracle Directory (with the builddb.cmd and other above mentioned files) is C:\Program Files\Netegrity\SiteMinder\Oracle, and you wanted the database password "alamagordo" but were happy to leave the default user name "SiteMinder," you would execute:
C:\>SMOracle -h C:\Oracle\ORANT -d "C:\Program Files\Netegrity\SiteMinder\Oracle" -p alamagordo
The first output of the program will be the entered username, password, directory, oracle home, and machine name that it will use to create the database. A lot of text and warning messages are to be expected during the Oracle database creation step. If the program fails due to an unusual local setup, you can try to follow each of these steps manually.
The remaining steps are all performed on the SiteMinder machine, which is not necessarily the same as the Oracle server.

Edit the Oracle NET80 configuration file

If the SiteMinder Policy Server is not running on the Oracle server machine, edit the text file tnsnames.ora in the Oracle home \NET80\ADMIN\ subdirectory, to connect to the Oracle server SiteMinder world. Add the lines:

SiteMinder.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = machine)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = STMD)
    )
  )

Where machine is the Oracle server computer name. If the SiteMinder Policy Server is running on the Oracle server, this step is done by SMOracle.exe.

Set up the ODBC services

On the SiteMinder administering machine, bring up the ODBC Data Source Administrator. From the Start menu, select Settings > Control Panel > ODBC.
Select System DSN and remove all SiteMinder entries.
Now add the Oracle data source: select Add, then select the Oracle ODBC Driver of your choice.
In Oracle ODBC Driver Setup, type in "SiteMinder Data Source" as the Data Source Name, "SiteMinder" as the Service Name (or Server Name for an Intersolv Oracle ODBC driver). Ignore the other fields. Click OK to close the Driver Setup, then the ODBC Data Source Administrator.

Set up SiteMinder to work with the Oracle ODBC service

Bring up the SiteMinder Policy Server Management Console program, SMConsole.
Select the ODBC tab at the top. For Policy Store, the default Database, set Data Source Name: Site Minder Data Source, User Name, Password,Verify Password: as the inputs to SmOracle.exe, "SiteMinder" if you allowed them to default. Then cycle through the Other Data Sources; check Use the Policy Store Database for each of them. Click Apply at the bottom.

Restart the SiteMinder services

In the SiteMinder Management Console, select the Status tab at the top.
Click Stop then Start for each of the Running services: Authentication, Authorization, Administration and Accounting (if that is running). Each service should stop and restart without error.
Finally click OK to close the Management Console.

Import the database information

From the MSDOS Command prompt and from the directory where the SiteMinder database contents text file, data.txt is found, run "smobjimport -idata.txt". This should read in the previously created database information. There should be no failures.