Oracle: Troubleshooting Database Transfer
If you encounter a failure during the configuration process, determine whether we can run the step again, skip the step, or if you must clean up the step. For some failed steps, learn how to correct the issue and recover from the failure. Each potential step in the configuration is included. Because the steps vary depending on your selections, the steps are not numbered. Find the step that failed to learn more about correcting and recovering from the failure. To change a value entered in the wizard, run the configuration again. If you must go through the wizard again, download the wizard selections that you made to save time. Then, cancel the configuration. Start the process over and upload your saved selections. Correct or enter values for the parameters that caused the failure.
Back up the properties files that the wizard uses during the configuration
During this step, the wizard attempts to back up the wkplc.properties, wkplc_dbdomain.properties, and wkplc_dbtype.properties files.
Actions Notes Run the step again We can run the step again without causing any harm. Alternatively, we can manually back up the properties files instead of running the step again. Skip the step If you already backed up your properties files before starting this configuration, we can skip this step. If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step None required
Manual Step: Create the database users and groups
During this step, you create the database configuration users and groups on the database server. If you need a runtime user for day-to-day operations, create the runtime database users and groups on the database server. Use the database user IDs and group names that are entered in the wizard when we create the database users and groups.
Actions Notes Run the step again We cannot rerun a manual step, but we can perform the instructions for the step again without harm. If you realize later in the configuration that the database users and groups were not created correctly, we can repeat these instructions. For example, you might encounter a failure in the setup database step if the database users and groups are created incorrectly. We can repeat these instructions to correct the issue and then perform the setup database step again. Skip the step If you successfully created the database users and groups before starting this configuration, we can skip this step.If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step None required
Create your databases
Actions Notes Run the step again Use the ERRORCODE and SQLSTATE associated with the error message in the ConfigTrace.log to determine the reason for the failure. We can run the step again if the reason for the failure does not affect any values entered in the wizard. For example, if you forgot to copy the JDBC JAR files from your database to the portal server, we can copy the files to the portal server. Then run the step again. If you need to update wizard values to correct the issue, do NOT run the step again. Create new scripts in the wizard. Upload your saved selections, update your values, and create scripts. Examples of issues that result in you updating your values include entering the wrong port number or entering an incorrect host name into the wizard.
Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step None required. If the step fails because you entered incorrect values in the wizard, remove the database manually, enter correct values to create your scripts, then run the configuration again.
Manual Step: Download the script and run it on the database server to create your database
During this step, you download a script to create your database.
Actions Notes Run the step again We cannot rerun a manual step, but we can perform the instructions for the step again without harm. In this step, you download a script to run. Use the ERRORCODE and SQLSTATE associated with the error message in the ConfigTrace.log to determine the reason for the failure. We can run the step again if the reason for the failure does not affect any values entered in the wizard. For example, if you forgot to copy the JDBC JAR files from your database to the portal server, we can copy the files to the portal server, then run the step again. If you need to update wizard values to correct the issue, do NOT run the step again. Create new scripts in the wizard. Upload your saved selections, update your values, and create scripts. Examples of issues that result in you updating your values include entering the wrong port number or entering an incorrect host name into the wizard.
Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step Not applicable
Set up your database
Use the ERRORCODE and SQLSTATE associated with the error message in the ConfigTrace.log to determine the source of the problem.
Actions Notes Run the step again We can run the step again if the issue for the failure does not affect any values entered in the wizard. If you need to update values, create new scripts in the wizard. Upload your saved selections, change the affected values, and create new scripts to run. For example, if you entered the wrong path to your database library, you must upload your saved selections, correct the path, and then configure your system with new scripts. Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step None required
Manual Step: Download the script and run it on the database server to set up your database
During this step, you set permissions on your database.
Actions Notes Run the step again We cannot rerun a manual step, but we can perform the instructions for the step again without harm. In this step, you download a script to run. Use the ERRORCODE and SQLSTATE associated with the error message in the ConfigTrace.log to determine the reason for the failure. We can run the downloaded script again if the issue for the failure does not affect any values entered in the wizard. For example, if you created database users and groups incorrectly on your database server, we can correct the issue and run the step again. If you need to update values, create new scripts in the wizard. Upload your saved selections, change the affected values, and create new scripts to run. Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step None required
Manual Step: Set up JCR collation for correct language locale order (DB2 only)
Actions Notes Run the step again We cannot rerun a manual step, but we can perform the instructions for the step again without harm. Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step Remove the database and create the database again.
Manual Step: Restart the DB2 server
During this step, you set global database default values that are required for the database that you created. These global values do not take effect until you restart your database server.
Actions Notes Run the step again We cannot rerun a manual step, but we can perform the instructions for the step again without harm. Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. If you already restarted your database server, we can skip this step. Clean up step None required
Validate the database connection and environment
During this step, you are validating that the database is still available and that we can successfully connect to the database.
Actions Notes Run the step again We cannot rerun a manual step, but we can perform the instructions for the step again without harm. Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step None required
Stop the portal server
Actions Notes Run the step again We can run the step again without causing any harm. Skip the step If you already stopped the portal server, we can skip this step. Clean up step None required
Transfer the database
Actions Notes Run the step again Use the ERRORCODE and SQLSTATE associated with the error message in the ConfigTrace.log to determine the reason for the failure. If you have a portal failure that does not have a SQLSTATE error code that is associated with the error message, we can run the step again if the issue for the failure does not affect any values entered in the wizard. If you need to update values in the wizard, create new scripts in the wizard. Upload your saved selections, change the affected values, and create new scripts to run. You do not need to run previous successful steps. Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step None required
Grant privileges to the database runtime users
Actions Notes Run the step again We can run the step again if the issue for the failure does not affect any values entered in the wizard. If you need to update values in the wizard, create new scripts in the wizard. Upload your saved selections, change the affected values, and create new scripts to run. You do not need to run previous successful steps. Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step None required
Manual Step: Download the script and run it on the database server to grant privileges to the runtime user
Actions Notes Run the step again We cannot rerun a manual step, but we can perform the instructions for the step again without harm. In this step, you download a script to run. We can run the downloaded script again if the issue for the failure does not affect any values entered in the wizard. For example, if you created runtime users and groups incorrectly on your database server, we can correct the issue and run the script again. If you need to update values in the wizard, Create new scripts in the wizard. Upload your saved selections, change the affected values, and create new scripts to run. You do not need to run previous successful steps. Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step None required
Configure the JCR domain to support large files
Actions Notes Run the step again We cannot rerun a manual step, but we can perform the instructions for the step again without harm. Skip the step If this step is successful, we can skip it if you encounter a failure in a later step and need to run the configuration again. Clean up step None required
Start the portal server
Actions Notes Run the step again We can run the step again without causing any harm Skip the step If you already started the portal server, we can skip this step. Clean up step None required
Related tasks