Installing Oracle server software

Oracle Server software must be installed on the database server before you install Contenta on your servers or workstations. Refer to the Platform Requirements document for the exact version of Oracle that is supported with this version of Contenta.

About this task

Follow the installation instructions provided by Oracle to install the Oracle Server. Oracle Home location is the directory into which you want to install the Oracle software.

Procedure

  1. In previous versions of Oracle (for example, Oracle 8i), the Global Database Name was referred to as the Oracle SID. This is the name you must include in the tnsnames.ora file on client workstations. You configure the tnsnames.ora file on the client workstations when you install the Oracle Client software. Note this name for client installations.
  2. Passwords in Oracle are user-defined. Note these passwords.
  3. Set the Database Character Set and National Character Set to the Preferred Definitions described in Defining Oracle Character Sets.
  4. If you plan to install Contenta Client on the server, you must configure the Oracle Listener and tnsnames.ora file. To do this, you can install the Oracle Client on the server which prompts you for the necessary information, or you can configure it through the Oracle-supplied interfaces.
  5. Obtain and install the appropriate Oracle Patch Set as indicated in the SDL Contenta Platform Requirements document. Refer to Oracle documentation to install Oracle patch sets.
  6. After installing the Oracle Patch Set, execute the Oracle database upgrade utility (dbua) to complete the patch installation process.
  7. To use dbimport.pl to create your database instance, before importing the Oracle .dmp file, the Oracle database administrator must set deferred_segment_creation=false to ensure that any empty tables in the .dmp file are imported. Enter the following SQL alter system command to dynamically alter the Oracle database instance:
    alter system set deferred_segment_creation=false scope=both;