Documentation Center

Upgrading or installing Oracle

Perform a set of upgrade or installation steps if you do not have the Oracle release and patches listed in the SDL Contenta Platform Requirements installed on your database server, Contenta Server and/or Contenta Client workstation.

Procedure

  1. Use the instructions provided by Oracle to upgrade the Oracle Server software on your Oracle database server.
  2. Use the instructions provided by Oracle to upgrade the Oracle Client software on your Contenta Server and on the Contenta Client workstations that have Contenta Administrative tools and Reports installed. By default, the upgrade is performed with the NCHAR datatype set to AL16UTF16. Only change this datatype if you have confirmation from an SDL Customer Support representative that your preferred datatype is supported.
  3. On your Contenta Server and Contenta Client workstations, use the Oracle Net Assistant to verify that a service entry exists for Oracle. If this is not the case, use the Assistant to update the file tnsnames.ora. Refer to Oracle documentation for additional information. Provide the following information:
    Net8 AssistantDescription
    Add New ServiceDefined by the user. This value must not contain a hyphen.
    ProtocolSet to TCP/IP.
    Host NameThe name of the database server on which the Contenta Oracle instance (SID) resides.
    Port NumberThe Oracle default port number, unless your database administrator instructs you otherwise.
    Service NameThe name of the Contenta Oracle instance (SID).
  4. After installing the Oracle Patch Set, execute the Oracle database upgrade utility, dbua, to complete the patch installation process.
  5. Restart the Oracle Server server.
  6. Test the Oracle connectivity between your database clients and the database server.
  7. If you intend to use the dbimport.pl tool to create your database instance before importing the Oracle .dmp file, the Oracle database administrator must set the deferred_segment_creation property to false to ensure the import of any empty tables in that file. To do so, run the following SQL commands to dynamically alter the Oracle database instance:
    alter system set deferred_segment_creation=false scope=both;