Oracle: Database transfer

HCL WebSphere Portal is installed with an Apache Derby database that is good for demonstration purposes, and also for portlet and theme development. In a production environment, we must configure portal to use a production-level database such as Oracle. We use the Configuration Wizard to configure a new database server with HCL WebSphere Portal.

• For the stand-alone server topology, run the database transfer option before running the federated security option.
• For the cluster topology, run the database transfer before creating the deployment manager profile.

For the option "Do you want to transfer to one database or multiple databases or schemas", select multiple databases or schemas to...

• Configure multiple databases with different data sources and different users per schema
• Configure a single database with different data sources and different users.

On the Database Settings panel, we can choose to turn on validation by selecting Yes to the option "Connect to database server to validate settings"

• Syntax validation checks:
  • Port number is in the range of 1 - 65535.
  • JCBS format in the database URL fields is valid.
  • Database library jar file (ojdbc8.jar) path is correct.
  • Context root value is valid.

• Database connection validation checks that a connection can be made to the database server. The wizard can connect to the database server to validate the host name and port number values that you enter.

We can select No, if we have determined that our parameters are correct, or if the database server is unavailable when generating scripts.

Configuration Wizard database transfer

The following steps reflect all possible options the Configuration Wizard Database Transfer process. You will only see a subset of options depending on the database type. Click View Step Command to see the task and properties associated with each step in the wizard.

1. Back up the properties files that the wizard uses during the configuration.

   Condition	None
   ConfigEngine task	backup-property-files-for-dbxfer

   These are the wkplc*.properties files under profile_home/ConfigEngine/properties.

2. Manual Step: Create the database users and groups.

   Condition	None
   ConfigEngine task	None

3. Manual Step: Create the database runtime users and groups.

   Condition	None
   ConfigEngine task	None

4. Manual Step: Download the script and view instructions to delete existing databases.

   Condition	None
   ConfigEngine task	None

5. Create the databases.

   Condition	None
   ConfigEngine task	create-database

6. Manual Step: Download the script and run it on the database server to create the database.

   Condition	Select to manually create the database.
   ConfigEngine task	None

7. Manual Step: Download the script and run it on the database server to create the database.

   Condition	Select to manually create the database.
   ConfigEngine task	None

8. Manual Step: Create your Oracle database.

   Condition	None
   ConfigEngine task	None

9. Manual Step: Download the script and view instructions to create the databases.

   Condition	None
   ConfigEngine task	None

10. Manual Step: Create the data directory, data, and the index directory, index, on the database server.

    Condition	Select to manually create users and assign them permissions.
    ConfigEngine task	None

11. Set up your database.

    Create database schemas and users, and grant privileges to database users.

    If we are using an Oracle database with Automatic Storage Management we must perform additional manual instructions after you perform this step. See Oracle: Creating JCR table spaces (Automatic Storage Management).

    Condition	None
    ConfigEngine task	setup-database

12. Manual Step: Download the script and run it on the database server to set up the database.

    Condition	Select to manually assign users permissions.
    ConfigEngine task	None

13. Manual Step: Download the script and run it on the database server to set up the database.

    If we have configured the database with Automatic Storage Management, edit the script for your environment before running.

    Condition	Select to manually create users and assign them permissions.
    ConfigEngine task	None

14. Manual Step: Download the script and run it on the database server to set up the database.

    Condition	Select to manually create users and assign them permissions.
    ConfigEngine task	None

15. Validate the database connection and environment.

    Condition	None
    ConfigEngine task	validate-database validate-database-environment

16. Stop the portal server.

    Condition	collation support
    ConfigEngine task	stop-portal-server

17. Transfer the database.

    Condition	None
    ConfigEngine task	database-transfer enable-profiles-check-managed package-profiles

18. Grant privileges to the database runtime users.

    Condition	None
    ConfigEngine task	grant-runtime-db-user-privileges

19. Manual Step: Download the script and run it on the database server to grant privileges to the runtime user.

    Condition	Select to manually create users and assign them permissions.
    ConfigEngine task	None

20. Manual Step: Download the script and run it to grant the database runtime user the appropriate privileges to work with database tables.

    Condition	Select to manually create users and assign them permissions.
    ConfigEngine task	None

21. Manual Step: Download the script and run it on the database server to grant privileges to database runtime users.

    Condition	Select to manually create users and assign them permissions.
    ConfigEngine task	None

22. Connect to the databases.

    Condition	None
    ConfigEngine task	None

23. Manual Step: Download the script and view instructions to reset the check pending status on portal table spaces.

    Condition	None
    ConfigEngine task	None

24. Reset the web content manager event log.

    Condition	None
    ConfigEngine task	None

25. Configure the JCR domain to support large files.

    Condition	None
    ConfigEngine task	datasource-enable-fully-materialize-lob-data

26. Manual Step: Improve database response time for the database that contains the JCR domain.

    Condition	None
    ConfigEngine task	None

27. Start the portal server.

    Condition	None
    ConfigEngine task	start-portal-server

What to do next

You transferred the data from Apache Derby to your preferred database. One quick way to test the database configuration is to log in and explore the site to validate the site is working as you expected. Go to:

http://host_name:port/context_root/default_portal_home.

There are options to configure your environment more.

Use the Enable Federated Security option to add an LDAP user registry.

Use the Create a Deployment Manager option to create a deployment manager profile that is augmented with HCL WebSphere Portal resources.

See also

• Configuration Wizard Overview
• Oracle DB Transfer Troubleshooting
• Oracle worksheet: Transfer the database
• Oracle worksheet: Transfer to multiple databases