Perform Server Post-Installation Tasks

This section describes the following tasks that you perform to complete the installation of Oracle Clinical database server on a UNIX computer:

• Complete the Setup of the opapps Account
  
• Limit Permissions on the XMLTEMP Folder
  
• Review the opa_settings File
  
• Check for Oracle Clinical Databases on a UNIX Server
  

Complete the Setup of the opapps Account

1. Create the log directory for opapps in the following location:

   OPA_HOME/log

2. Define the environment variables for the opapps user:
   1. Open the .cshrc file. This file is located in the home directory after you log in as the opapps user. You can use the following command to view the hidden .cshrc file:

      ls -arlt

   2. Add the following lines to the .cshrc file:

      set path=( $path ORACLE_HOME/bin ORACLE_HOME/lib )

      setenv RXC_LOG OPA_HOME/log

      source OPA_HOME/bin/copa_setup_alias

      where:

      ORACLE_HOME is the directory where you installed Oracle Database 19c.

      OPA_HOME is the directory where you installed Oracle Clinical database server.

   3. Source the .cshrc file when you finish editing it:

      source .cshrc

      Note:

      For HP-UX Port, copy $ORACLE_HOME/bin/oraenv to$OPA_BIN/oraenv_opa.

      For example: cp $ORACLE_HOME/bin/oraenv

      $OPA_BIN/oraenv_opa

      ORACLE_HOME: Oracle 19c Home

      OPA_BIN: <OPA Home>/bin

Limit Permissions on the XMLTEMP Folder

To reduce security risks, you should limit permissions on the XMLTEMP folder for all database server installations.

1. Log in as opapps.
2. Go to the OPA_HOME directory.
3. Modify chmod <permission> xmltemp as follows:
   Example:

   chmod 777 xmltemp

Review the opa_settings File

The Installer creates the opa_setting file and enters all necessary entries and default values for the Oracle Clinical environment.

1. Review the opa_settings file in the following directory:
   OPA_HOME/bin
2. Adjust the default values for the Oracle Clinical environment, if necessary.

   See the Oracle Clinical Administrator's Guide for a list of the environment variables and for information about changing, adding, and verifying values.

Note:

• The db_env_setting records in opa_settings define a default value for particular environment variables that are set when the application calls opa_setup. You can override the default values for all databases or for a particular database.
• See Choose a Character Set.
• NLS_DATE_FORMAT must be set to DD-MON-RRRR. It is possible to override this setting for display in RDC Onsite, the Patient Data Report, and Oracle Clinical data entry, but the value in opa_settings must be DD-MON-RRRR.

Check for Oracle Clinical Databases on a UNIX Server

As part of the implementation of the PDR hyperlinks on superscripts, a new script post-processes DCI Form Version templates to insert hyperlink placeholders. This process can fail with error ORA-27369, when a database post-install step has not been completed. For example, for a database on HP-UX, refer to https://docs.oracle.com/en/database/oracle/oracle-database/19/hpdbi/oracle-database-postinstallation-tasks.html#GUID-FCF693BF-FB7F-4FA6-81BD-DF669675D401. You can also refer to My Oracle Support Article ID 391820.1, Scheduled Job Running Shell.