After Installing Oracle Database 18c

The Oracle Database version that is installed on your database server must match the one on your Oracle Database Client. Oracle Client Installation contains more information about installing Oracle Database Clients.

Creating Oracle Database Tablespaces

If using Simphony 19.2.1 or later, creation of database Tablespaces is automatically performed by the Simphony installation application.

For versions prior to the Simphony 19.2.1 release, ensure the following Simphony database Tablespaces are created on your database server or servers:
  • MCRSPOS

  • MCRSCACHE

Appendix A: Sample Script for Creating Oracle Tablespaces contains a sample script to create the database Tablespaces. The Database Administrator’s Guide contains more information about creating database Tablespaces. The Administrator's Reference for Linux and UNIX-Based Operating Systems contains information about administering an Oracle Database on these platforms.

Increasing Database Process Count

Run the ALTER SYSTEM SET processes=300 SCOPE=SPFILE; command on the Oracle Database and restart the Oracle Database Service. If you are using the Oracle Linux operating system, run the shutdown immediate; command and then run the STARTUP pfile=init.ora; command to restart the service. The Oracle Database Platform Guide for Microsoft Windows and the Oracle Database Administrator's Reference for Linux and UNIX-Based Operating Systems contain more information about restarting the Oracle Database Service.

If you are using a Microsoft Windows Server, restart the OracleServiceSIMPHONY service using the Windows Services dialog. The Platform Guide for Microsoft Windows contains more information about restarting the Oracle Database Service on Microsoft Windows Servers.