6/6

A Performing Database Upgrade Tasks Manually

This appendix describes how to perform database upgrade tasks manually if you do not use the WebLogic Upgrade Wizard to upgrade from WebLogic Portal 10.2/10.3/10.3.2/10.3.4/10.3.5/10.3.6 to release 10.3.7.

See the README.txt file and the upgrade_db.properties file in the <WLPORTAL_HOME>\common\lib\upgrade\db directory for detailed information about the files used in the upgrade and specific upgrade steps.

This appendix contains the following sections:

• Appendix A, "Upgrading your Main WebLogic Portal 10.2/10.3/10.3.2/10.3.4/10.3.5/10.3.6 Database"

• Appendix A, "Dropping Deprecated Compoze Database Tables After Upgrade"

A.1 Upgrading your Main WebLogic Portal 10.2/10.3/10.3.2/10.3.4/10.3.5/10.3.6 Database

If you did not upgrade your main WebLogic Portal database from 10.2/10.3/10.3.2/10.3.4/10.3.5/10.3.6 to 10.3.7 using the WebLogic Upgrade Wizard, you can perform the upgrade manually.

Note:

As part of the upgrade process, the DDL automatically creates the RDBMS Security Store tables in the schema for which the p13nDatasource is configured. If a portal domain administrator wishes to use or configure a database schema other than the schema for which the p13nDatasource is configured, he or she must manually run the following script to create the RDBMS Security Store tables for that schema:

<WLPORTAL_HOME>/p13n/db/<database_vendor>/rdbms_security_store_create_tables.sql

For more information on the RDBMS Security Store tables, see "RDBMS Security Store Tables" in the Oracle Fusion Middleware Database Administration Guide for Oracle WebLogic Portal.

Perform the following steps to upgrade your WebLogic Portal database:

1. Shut down WebLogic Server.

2. Back up your database data as described by your database vendor.

3. Edit the <WLPORTAL_HOME>\common\lib\upgrade\db\upgrade_db.properties file for your database environment. Replace the @ symbols and the text between the symbols with the correct values for @DB_USER@, @DB_PASSWORD@, @DB_HOST@, @DB_PORT@, and @DB_NAME@.

4. In the upgrade_db.properties file, modify and uncomment the files= setting for your portal database. Follow the instructions in the upgrade_db.properties file for your specific type of upgrade.

5. Run the following script: upgrade_db.cmd/.sh.

A.2 Dropping Deprecated Compoze Database Tables After Upgrade

After you upgrade to WebLogic Portal 10.3.7, you can drop the tables associated with Compoze/Collaboration using the following script:

<WLPORTAL_HOME>\portal\db\<DMBS>\dep9_drop_tables.sql