Configuring an Oracle Database for Use with Service Registry

In order to use Service Registry with an Oracle database instead of the default Java DB database, you must install and configure the Oracle database for use with Service Registry. This manual does not describe how to install an Oracle database; consult the Oracle documentation for this information.

Once Oracle is installed, the required configuration tasks are as follows:

• Download and install the Oracle JDBC JAR file

• Create a database, defining a non-default number of cursors

• Create a user for the database

• Edit the tnsnames.ora file to allow multiple clients to connect over the network

These tasks are described in the following sections:

• To Obtain the Oracle JDBC JAR File

• To Create a Database

• To Create a Database User

• To Edit the tnsnames.ora File

After these tasks are completed, configure Service Registry as described in To Configure Service Registry as Root Using Custom Properties After a Configure Later Installation or To Configure Service Registry as a Non-Root User Using Custom Properties After a Configure Later Installation. This configuration must include the task described in To Edit Database Properties for the Oracle Database.

To Obtain the Oracle JDBC JAR File

1. Download the ojdbc14.jar file from the Oracle OTN network.

2. Copy this file into the ServiceRegistry-base/lib directory.

   For example, on Solaris OS, the command would look something like this:

   cp ojdbc14.jar /opt/SUNWsrvc-registry/lib

3. Change to the ServiceRegistry-base/install directory.

4. Run the following command:

   Ant-base/ant -f build-install.xml -Dinstall.properties=props-file configure.extern

To Create a Database

To create an Oracle database, use the Oracle Database Configuration Assistant utility.

1. Start the utility using the dbca command:

   dbca

2. On the Welcome screen, click Next.

3. On the Step 1 screen (Operations), select the Create a Database radio button and click Next.

4. On the Step 2 screen (Database Templates), select the General Purpose radio button and click Next.

5. On the Step 3 screen (Database Identification), specify a Global Database Name and a System Identifier (SID) for the database and click Next.

   For the Global Database name, specify soar followed by a domain name, as in soar.mydomain.mycompany.com.

   For the SID, specify soar.

6. On the Step 4 screen (Management Options), accept the default settings and click Next.

   The Configure the Database with Enterprise Manager checkbox is selected, and the Use Database Control for Database Management radio button is selected.

7. On the Step 5 screen (Database Credentials), select the Use the Same Password for All Accounts radio button, type a password of your choice in the text fields, and click Next.

8. On the Step 6 screen (Storage Options), accept the default settings and click Next.

   The File System radio button is selected.

9. On the Step 7 screen (Database File Locations), accept the default settings and click Next.

   The Use Database File Locations from Template radio button is selected.

10. On the Step 8 screen (Recovery Configuration), accept the default settings and click Next.

    The Specify Flash Recovery Area checkbox is selected, and default values are filled in for the two fields.

11. On the Step 9 screen (Database Content), accept the default settings and click Next.

    The Sample Schemas checkbox is not selected.

12. On the Step 10 screen (Initialization Parameters), select the Character Sets tab.

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

14. At the bottom of the Step 10 screen, select the All Initialization Parameters radio button.

15. In the All Initialization parameters dialog, scroll to the open_cursors parameter.

16. Change the value to 3000 and click Close.

17. Click Next.

18. On the Step 11 screen (Database Storage), click Next.

19. On the Step 12 screen (Creation Options), accept the default selection of Create Database and click Finish.

To Create a Database User

To create a database user, use the sqlplus utility.

1. Become superuser by issuing the following command:

   su - oracle

2. Start the sqlplus utility:

   sqlplus /nolog

3. At the prompt, connect to the database:

   sqlplus>connect / as sysdba

4. Create a user and specify the password for the user:

   sqlplus>create user user-name identified by password;

   The password value must be at least six characters.

   For example, to specify a user named APP and a password of app123, you would use the following command:

   sqlplus>create user APP identified by app123;

5. Grant privileges to the user you created:

   sqlplus>grant connect, resource, dba to APP;

6. Exit the utility:

   exit

To Edit the tnsnames.ora File

To allow multiple clients to connect to the database over a network, edit the file tnsnames.ora.

1. Go to the directory Oracle-base/product/10.1.0/db_1/network/admin/.

2. Open the file tnsnames.ora in a text editor.

3. At the end of the file, append the following:

   SOAR =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = host.domain)(PORT = 1521))
       (CONNECT_DATA =
         (SERVER = SHARED)
         (SERVICE_NAME = soar)
       )
     )

   For host.domain, substitute the full domain name of the system where the database is installed.