Creating Databases

You need to manually create the gwdb and musicdb databases before you can select Oracle as your database during the Sun GlassFish Mobility Platform installation.

To create the gwdb and musicdb databases, complete the following steps:

1. Start the Database Configuration Assistant (DBCA) utility.

2. On the Operations screen, select the Create a Database radio button and click Next.

3. On the Database Template screen, select the General Purpose radio button and click Next.

4. On the Database Identification screen, specify “gwdb” in the Global Database Name field and accept the default SID setting, which is also “gwdb”. Click Next.

5. On the Management Options screen, accept the default settings and click Next.

6. On the Database Credentials screen, select the Use the Same Password for All Accounts radio button. Type any password, such as gwdb, in the Password and Confirm Password fields, then click Next.

7. On the Storage Options screen, accept the default settings, then click Next.

8. On the Database File Locations screen, accept the default settings, then click Next.

9. On the Recovery Configuration screen, accept the default settings, then click Next.

10. On the Database Content screen, accept the default settings, then click Next.

11. On the Initialization Parameters screen, select the Character Sets tab.

12. Select the radio button labeled “Choose from the list of character sets”, then select UTF8 from the menu. Click Next.

13. On the Database Storage screen, click Next.

14. On the Creation Options screen, accept the default setting of Create Database, then click Finish.

15. On the Confirmation screen, click OK.

    DBCA creates and starts the Oracle database instance and completes the database creation.

16. Repeat steps 1–15 for the musicdb database, replacing “gwdb” with “musicdb” in step 4 and step 6.