D Database Maintenance

This chapter explains how to connect the various supported databases to your Oracle Web Services Manager (Oracle WSM) deployment.

This chapter includes the following sections:

• How Oracle WSM Uses Databases

• Oracle Lite 10g

• Oracle 10g

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".

Note:

Oracle Lite is optimal for demonstration and proof-of-concept deployments of Oracle WSM on a single host machine. It is not certified for production environments. You must integrate production Oracle WSM deployments with Oracle 10g.

Uninstalling Oracle Lite

The following procedure describes how to uninstall Oracle Lite.

To uninstall the bundled Oracle Lite instance

1. Open a command window, and go to the directory where you installed Oracle Lite.

   The default location of the Oracle Lite installation is indicated by the value of the olite.install.home property in the install.properties file.

2. From the command prompt, run the following command:

   wsmadmin uninstallOLite

   For more information about uninstalling Oracle Lite using the wsmadmin command, see "uninstallOLite".

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. Edit the attribute db.password in the ORACLE_HOME/owsm/bin/coresv.properties file.

2. From the command prompt, execute the following command:

   wsmadmin encodePasswords coresv.properties

3. From the command prompt, execute the wsmadmin copyDBConfig command:

   wsmadmin copyDBConfig

4. From the command prompt, execute the wsmadmin deploy command:

   wsmadmin deploy component

See Appendix C, "Oracle Web Services Manager WSMADMIN Commands" for more information.

The following procedure describes how to change your database password when you have multiple instances of Oracle WSM Database.

To update and reconcile a password for multiple database instances

1. Update the relevant attribute in the application properties file for each application. These are located under ORACLE_HOME/owsm/config/application_name.

2. Update and reconcile the passwords for all the database instances.

3. From the command prompt, execute the wsmadmin encodePassword command for each affected file:

   wsmadmin encodePasswords path_to_file properties

4. From the command prompt, execute the wsmadmin deploy command:

   wsmadmin deploy component

See Appendix C, "Oracle Web Services Manager WSMADMIN Commands" for more information.