How to create an oracle Database

Create an Oracle Database

By default ProblemTracker 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 ProblemTracker.

To use ProblemTracker 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.

Oracle 8i on Windows platform:

1. Start the Oracle Database Configuration Assistant.
2. Select the option "Create a Database" and click "Next".
3. If you wish to have a standard Oracle database, select the option "Typical (recommended)" and click "Next". But, if you wish to have the Oracle database use multinationalization, then choose the option "Custom" and click "Next" and continue with the installation.
4. Select the appropriate method (either copy existing files from the CD, or create new database files) for creating the database and click "Next".
5. Select the environment (either OLTP, DSS, or Hybrid/Multipurpose system) in which the database will operate and click "Next". The default and the recommended one is a hybrid system.
6. Enter the approximate number of users who will be concurrently connected to the database at any given time and then click "Next". If you are not sure, accept the default value.
7. Select the options you want to configure for use in the database and click "Next".
8. Enter the workgroup name (recommended) for the Global Database Name and the SID (System Identifier) or you can enter any valid database name. If you have chosen the option "Custom" in Step 3, then click the "Change Character Set..." button and choose the appropriate character set you need. Say if you wish to have "UTF8" character set, then choose "UTF8" for the options "Character Set" and "National Character Set" in the dialog and then click "Next".
9. Select the option "Create database now" and click "Finish". Click "Yes" to the confirmation dialog.
10. Creation of Oracle database will take few minutes depending on the options you have chosen to configure. Please wait until Oracle gives a confirmation stating that the database has been created and then note the Global Database Name, SID, SYS and SYSTEM account passwords in a safe place.

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.

Now you have successfully created an Oracle database.