Install Oracle or Oracle RAC
Use Oracle or Oracle RAC as the database software.
- Review the database considerations.
- ensure the DB is supported by this version of WebSphere Portal. Refer to the list of supported databases in the WebSphere Portal detailed system requirements.
- Install the Oracle client and any required fix packs. Follow the instructions provided with the Oracle documentation.
- Install Oracle JDBC Type 4 drivers or Oracle JDBC OCI Type 2 drivers as appropriate.
Refer to the Oracle or Oracle RAC product documentation for installation instructions.
Oracle RAC
- Verify the Oracle CRS (Cluster Ready Service) and Oracle RAC databases are installed and configured on the primary and secondary nodes.
- Start global services daemon (GSD), oracle listeners, and agents in both RAC nodes. Run the following commands:
- $ gsdctl start
- $ lsnrctl start
- $ agentctl start
- The default tablespace size for Oracle RAC may need to be set to 1024MB with autoextend turned on for database transfer to be successful.
Update environment variables
- JDBC OCI Type 2 drivers only (AIX): Set the environment variable on the IBM WebSphere Portal server to point to the directory where you downloaded and extracted the compressed Oracle client files.
LIBPATH=/u01/app/oracle/product/11.2.0/client_1;export LIBPATH
- JDBC OCI (Linux and Solaris): Set the environment variable on the IBM WebSphere Portal server to point to the directory where you downloaded and extracted the compressed Oracle client files.
LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/client_1;export LD_LIBRARY_PATH
- Restart server1 to ensure the Configuration Wizard uses the updated environment variables.
What to do next
Use the Configuration Wizard to set up and configure the database to work with WebSphere Portal. Use the wizard to create custom scripts that you or the database administrator can use to configure the database. We can also use the wizard to automatically set up and configure the database. The wizard creates instructions and scripts based on the selections and provided data.
When we use the wizard, you provide information about the database for our environment.
Before we enter the database name (dbdomain.DbName) in the Configuration Wizard, check the database documentation for restrictions on character length.