D Database Maintenance

How Oracle WSM Uses Databases

Oracle WSM Database stores information from the following Oracle WSM components:

• Oracle WSM Policy Manager

• Oracle WSM Monitor

• Oracle WSM Agents

• Oracle WSM Gateways

The Oracle WSM Database is also used to store the raw and compiled data associated with the Performance Metrics generated by the Oracle WSM Monitor.

Oracle Lite 10g

Oracle WSM comes bundled with Oracle Lite Database 10g. When you install Oracle WSM on Microsoft Windows as a standalone installation with the Basic Installation option, Oracle Lite 10g is automatically installed.

If the installer confirms that the property value of the parameter install.db.type has been set to oracle, then it installs Oracle WSM and connects it to the specified database.

The wsmadmin initialize operation automatically creates the database tables required by Oracle Web Services Manager. It then uploads the requisite data to those tables. For details, see "initialize".

Oracle 10g

Integration of Oracle 10g with Oracle Web Services Manager requires completion of the following tasks:

1. Modify the install.properties file prior to installing Oracle Web Services Manager, setting the database properties according to Table D-1.

   Table D-1 install.properties Settings for Oracle 10g

   Property	Description
   db.type	Specify oracle
   db.driver.type	Specify thick or thin. The JDBC thin driver allows you to use 100% Java to access Oracle data. The thick driver uses Oracle-specific native code (that is non-Java) which provides a performance boost compared to the thin driver at the cost of significantly larger size and client-side installation.
   db.host	The machine name, IP address, and port of the computer hosting the database. For a single node, this is specified using the syntax host:port For a RAC database, this is specified using the syntax host1:port1^host2:port2^
   db.name	The service name of the database instance in which the Oracle Web Services Manager Registry resides (the default is CCORE).
   db.userid	The schema or account used to log in to the database.
   db.password	The password associated with the account specified by db.userid.
   db.type	Specify oracle

   
   

2. Initialize the Oracle database by opening a command window, navigating to ORACLE_HOME\owsm\bin and executing the following command:

   wsmadmin initialize

   For more information about using the wsmadmin initialize command, see "initialize".

Changing Passwords

You may want to change passwords for security reasons; in particular, database passwords may need to be changed on a regular basis. Oracle recommends that you use a single Oracle WSM Database in your Oracle WSM environment. However, Oracle WSM components can support multiple instances of the database.

The following procedure describes how to change a database password for a single instance of an Oracle WSM Database.

To change a password for a single database instance

1. Change the password for the OWSM schema in the Oracle Database.

2. Restart the Oracle Application Server on which the Oracle WSM components are deployed.

3. Edit the ORACLE_HOME\owsm\bin\coresv.properties file, and update the dataload.messagelog.db.password property with the new database password.

4. Encode the password in the coresv.properties file.

   wsmadmin encodePasswords coresv.properties dataload.messagelog.db.password
   

5. Copy the database configuration properties to the configuration directory property files.

   wsmadmin copyDBConfig
   

6. Redeploy the Oracle WSM applications either individually or using the all parameter.

   wsmadmin deploy oc4j_admin_password all
   

7. Restart the Oracle Application Server instance.

Complete the procedure in "Updating the Database Configuration Properties"."

The following procedure describes how to change a database password for multiple instances of an Oracle WSM Database.

To update and reconcile a password for multiple database instances

1. Change the password for the OWSM schema in the Oracle Database.

2. Restart the Oracle Application Server on which the Oracle WSM components are deployed.

3. Update the relevant attribute in the application properties file for each application. These files are located in ORACLE_HOME\owsm\config\application_name.

4. Encode the password for each property that was changed in step 3.

   wsmadmin encodePasswords file_name property_name
   

5. Redeploy the Oracle WSM components that connect to the database.

   wsmadmin deploy oc4j_admin_password component
   

6. Restart the Oracle Application Server instance.

7. Repeat this procedure for each Oracle Database that is used by an Oracle WSM component.

Complete the procedure in "Updating the Database Configuration Properties"."