Perform Server Post-Installation Tasks

To complete the installation of Oracle Clinical database server on a Windows computer, perform the following tasks:

• Limit Permissions on the XMLTEMP Folder
  
• Review the opa_settings.bat File
  

Limit Permissions on the XMLTEMP Folder

By default, a Windows installation grants read and write privileges to the XMLTEMP database folder to everyone. To reduce security risks, limit permissions on the XMLTEMP folder for all Windows database server installations.

1. Use Windows Explorer to locate the XMLTEMP folder in the OPA_HOME directory.
2. Right-click on the XMLTEMP folder, and then select Properties from the menu.
3. Click the Sharing tab, then click Advanced Sharing.
4. Select the Share this folder check box to enable sharing with other users on your network.
5. Click Permissions.
6. Give Read and Write (Change) permissions to user oracle.
7. Click OK to save your changes and close the Permissions dialog box.
8. Click OK to save your changes and close the Advanced Sharing dialog box.
9. Click Close to close the Properties dialog box.

Review the opa_settings.bat File

On Windows systems, configurations are defined in the opa_settings.bat file. This file contains the commands to set environment variables at startup and execution of the PSUB service.

1. Review the opa_settings.bat file in the following directory:

   Drive:\opapps\bin

2. Adjust the default values, if necessary.

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

Note:

• The db_env_setting records in opa_settings.bat 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 for important information.
• 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.