Checklist for the database server (Oracle)
Applies to:
If you use an Oracle database server, do these tasks before you install IBM OpenPages®:
- Check that all of the required ports are available. See Port assignments.
- If the database server is running on Linux®,
set up the operating system users and groups for Oracle (
oinstall,dba,oracle). See Creating users and groups on the Oracle database server for Linux operating systems. - Install Oracle and create a database for OpenPages. See Oracle Database 19c installations.
- Review the list of Oracle package dependencies.
To function correctly, the OpenPages Oracle packages must have access to some standard Oracle objects. If you are using a standard Oracle deployment, access to these objects is granted by default.
Some environments, however, might restrict the default Oracle access model and remove public access from some of the objects. Review the list of package dependencies to ensure access is granted. See Oracle package dependencies.
- Set environment variables.
- Prepare the database for OpenPages
Preparing the Oracle database.
You need SYSDBA privileges to do this task.
- If you're using a clustered environment, see Increasing the Oracle connection limit.
- Test the connection to the database. See Testing the connections to the database server and the OpenPages database (Oracle).
- If the database server is on a separate computer, install the database client software on each application server and reporting server. For more information, see Oracle database client installations.