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.
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 10g on Windows platform:
- Start the Oracle Database Configuration Assistant. Click "Next"
- Select the option "Create a Database" and click "Next"
- Select the option "General Purpose" and click "Next"
- 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.
- Check the option "Configure the Database with Enterprise Manager", and accept
the default selection for other options and click "Next"
- Enter a Password and Confirm Password for all accounts or you can enter different passwords
and click "Next"
- Select the storage mechanism as "File System" and click "Next"
- 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".
- Choose the recovery options for the database and click "Next"
- Uncheck the option "Sample Schemas" and click "Next"
- In the "Memory" tab, select the "Custom" option
- 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".
- If you wish, you can review (and modify) the control file, data files and redo log groups for the database.
Click "Next".
- Select the option "Create Database" and click "Finish"
- Click on the button "Save as an HTML file" to save the database parameters, then
click "OK" to proceed with creating the database
- 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:
- Start the Oracle Database Configuration Assistant. Click "Next"
- Select the option "Create a Database" and click "Next"
- Select the option "General Purpose" and click "Next"
- 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.
- Check the option "Configure the Database with Enterprise Manager", and accept
the default selection for other options and click "Next"
- Enter a Password and Confirm Password for all accounts or you can enter different passwords
and click "Next"
- Select the storage mechanism as "File System" and click "Next"
- 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".
- Choose the recovery options for the database and click "Next"
- Uncheck the option "Sample Schemas" and click "Next"
- In the "Memory" tab, select the "Custom" option
- 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".
- Select the default security settings "Keep the enhanced 11 g default security settings", then click
on the "Next" button
- Check the option "Enable automatic maintenance tasks" and click "Next"
- If you wish, you can review (and modify) the control file, data files and redo log groups for the database.
Click "Next"
- Select the option "Create Database" and click "Finish"
- Click on the button "Save as an HTML file" to save the database parameters, then
click "OK" to proceed with creating the database
- 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.
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 10g or 11g:
You have to to do the following to configure the Oracle client on the web server machine.
It is required that you install the full Oracle client for use with Tracker.
The Instant Client that is available for Oracle 10g or 11g is not sufficient for use with
Tracker. If Tracker is installed on a 64-bit operating system, please install the
32-bit version of the full Oracle client.
Browse to Oracle Metalink
or contact Oracle Technical Support for further details on how to install Oracle Database 10g or 11g software.
:
- Start Net Configuration Assistant that gets installed when you install the client.
- Select the option "Local Net Service Name configuration" and click "Next".
- Select the option "Add" and click "Next".
- Enter the newly created Oracle database name as the "Service Name" and click "Next".
- Select "TCP" protocol and click "Next".
- Enter the Oracle Server name as the "Host Name" and select "Use the standard port number" and click "Next".
- Select "Yes, perform a test" and click "Next".
- Click "Change Login".
- 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".
- Enter the newly created Oracle database name as the "Net Service Name" and click "Next".
- Select "No" to configure another net service name and click "Next".
- 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.