NetResults Tracker Help
Using Oracle Database

The following instructions apply to use of Oracle Database. Oracle is a professional RDBMS and by its nature is very complex. This document assumes that you are very familiar with the administration and use of Oracle. Please refer to the documentation included with Oracle for detailed instructions where necessary.

For questions regarding the use of Oracle, please contact Oracle Corporation technical support.

In order to use Oracle with Tracker you must perform the following steps on the machine in which the Oracle Server is installed:

  1. Create an Oracle Database
  2. Configuring the Oracle Client (for remote Oracle servers only)


  1. Create an Oracle Database

    By default Tracker uses a Microsoft Access database, however it can also be used with Oracle. Oracle database is a separately sold product available from Oracle Corporation and is not bundled with Tracker.

    To use Tracker with Oracle, you must first create a database using Oracle. You can create a database of any name, although it is recommended that it matches the workgroup name. If your Oracle software is installed on a machine with a Windows-based platform, perform the following steps to create the database. If your Oracle software is installed on a Sun Solaris platform, click here for a different set of steps.

    You can create one Oracle database for use with multiple workgroups. You should use a different User and Tablespace for each workgroup pointed at a single Oracle database. Users and Tablespaces can be set when during the process of adding a workgroup.

    Oracle 9i on Windows or Sun Solaris platform:

    1. Start the Oracle Database Configuration Assistant
    2. Select the option "Create a Database" and click "Next"
    3. Select the option "General Purpose" and click "Next"
    4. Enter the Global Database Name in the form "databasename.domain" and the System Identifier (SID) in the form "databasename", then click "Next". It is advised that you select the database name to match the workgroup name that you will be using. However, using a different name is acceptable.
    5. Select the option "Dedicated Server Mode" and click "Next"
    6. Select the "Custom" option
    7. If you do not plan to use multinationalization, skip to the next step. If you wish to have the Oracle database use multinationalization, then click on the "DB Sizing" tab. In the "Database Character Set" field, select "UTF8".
    8. Click "Next". Click "Next" once more.
    9. Check the option for the option "Create Database" and click "Finish"
    10. Click "OK" to confirm the creation of the database
    11. Click on the button "Save as an HTML file" to save the database parameters, then click "OK" to proceed with creating the database
    12. After the database creation operation has completed successfully, click on the "Password Management" button to change the default password and unlock the database accounts of the new database

    Oracle 10g on Windows platform:

    1. Start the Oracle Database Configuration Assistant. Click "Next"
    2. Select the option "Create a Database" and click "Next"
    3. Select the option "General Purpose" and click "Next"
    4. Enter the Global Database Name in the form "databasename.domain" and the System Identifier (SID) in the form "databasename", then click "Next". It is advised that you select the database name to match the workgroup name that you will be using. However, using a different name is acceptable.
    5. Check the option "Configure the Database with Enterprise Manager", and accept the default selection for other options and click "Next"
    6. Enter a Password and Confirm Password for all accounts or you can enter different passwords and click "Next"
    7. Select the storage mechanism as "File System" and click "Next"
    8. Select the location of the Database files to be created. If you are not sure as what to choose, select the option "Use Database File Locations from Template" and click "Next".
    9. Choose the recovery options for the database and click "Next"
    10. Uncheck the option "Sample Schemas" and click "Next"
    11. In the "Memory" tab, select the "Custom" option
    12. If you do not plan to use multinationalization, skip to the next step. If you wish to have the Oracle database use multinationalization, then click on the "Character Sets" tab. In the "Database Character Set" field, click "Choose from the list of character sets", and select "UTF8" from the list. Also select "UTF8" for the "National Character Set". Click "Next".
    13. If you wish, you can review (and modify) the control file, data files and redo log groups for the database. Click "Next".
    14. Select the option "Create Database" and click "Finish"
    15. Click on the button "Save as an HTML file" to save the database parameters, then click "OK" to proceed with creating the database
    16. After the database creation operation has completed successfully, click on the "Password Management" button to change the default password and unlock the database accounts of the new database

    Oracle 11g on Windows platform:

    1. Start the Oracle Database Configuration Assistant. Click "Next"
    2. Select the option "Create a Database" and click "Next"
    3. Select the option "General Purpose" and click "Next"
    4. Enter the Global Database Name in the form "databasename.domain" and the System Identifier (SID) in the form "databasename", then click "Next". It is advised that you select the database name to match the workgroup name that you will be using. However, using a different name is acceptable.
    5. Check the option "Configure the Database with Enterprise Manager", and accept the default selection for other options and click "Next"
    6. Enter a Password and Confirm Password for all accounts or you can enter different passwords and click "Next"
    7. Select the storage mechanism as "File System" and click "Next"
    8. Select the location of the Database files to be created. If you are not sure as what to choose, select the option "Use Database File Locations from Template" and click "Next".
    9. Choose the recovery options for the database and click "Next"
    10. Uncheck the option "Sample Schemas" and click "Next"
    11. In the "Memory" tab, select the "Custom" option
    12. If you do not plan to use multinationalization, skip to the next step. If you wish to have the Oracle database use multinationalization, then click on the "Character Sets" tab. In the "Database Character Set" field, click "Choose from the list of character sets", and select "UTF8" from the list. Also select "UTF8" for the "National Character Set". Click "Next".
    13. Select the default security settings "Keep the enhanced 11 g default security settings", then click on the "Next" button
    14. Check the option "Enable automatic maintenance tasks" and click "Next"
    15. If you wish, you can review (and modify) the control file, data files and redo log groups for the database. Click "Next"
    16. Select the option "Create Database" and click "Finish"
    17. Click on the button "Save as an HTML file" to save the database parameters, then click "OK" to proceed with creating the database
    18. After the database creation operation has completed successfully, click on the "Password Management" button to change the default password and unlock the database accounts of the new database

    Now you have successfully created an Oracle database.

  2. Configuring the Oracle Client on the Web Server (for remote Oracle servers only)

    If your Oracle server is installed on a machine other than the Web Server, then you have to do the following on the Web Server in order to connect to the Oracle database and use Tracker.

    For Oracle 9i:

    You have to to do the following to configure the Oracle client on the web server machine:

    1. Start Net / Net9 Configuration Assistant (or Net / Net9 Easy Config Utility) that gets installed when you install the client.
    2. Select the option "Create", give the workgroup name as the "New Net Service Name" and click "Next".
    3. Select "TCP/IP (Internet Protocol)" and click "Next".
    4. Enter the Oracle Server name as the "Host Name" and accept the default for the "Port Number" and click "Next".
    5. Enter the workgroup name for the "Database SID" field and click "Next".
    6. Click "Test Service".
    7. In the new dialog, enter the username and password as NRTracker and click "Test". If the database and the NRTracker user are configured correctly, then a successful connection will be established. Click "Done" to close the dialog.
    8. Click "Finish".

    For Oracle 10g or 11g:

    You have to to do the following to configure the Oracle client on the web server machine:

    1. Start Net Configuration Assistant that gets installed when you install the client.
    2. Select the option "Local Net Service Name configuration" and click "Next".
    3. Select the option "Add" and click "Next".
    4. Enter the newly created Oracle database name as the "Service Name" and click "Next".
    5. Select "TCP" protocol and click "Next".
    6. Enter the Oracle Server name as the "Host Name" and select "Use the standard port number" and click "Next".
    7. Select "Yes, perform a test" and click "Next".
    8. Click "Change Login".
    9. In the new dialog, enter the username and password as NRTracker and click "OK". If the database and the NRTracker user are configured correctly, then a successful connection will be established. Click "Next".
    10. Enter the newly created Oracle database name as the "Net Service Name" and click "Next".
    11. Select "No" to configure another net service name and click "Next".
    12. Click "Next" and click "Finish" to close the dialog.

    Now you have successfully configured your Oracle client for the Tracker workgroup. To complete the process of creating your Oracle workgroup(s), please complete the steps listed in the Adding a Workgroup section.

 


NetResults Tracker © 1997-2010 NetResults Corporation. All rights reserved.