If you are upgrading a client using Oracle and do not have the required Oracle Client software release and patch set installed on it, install or upgrade it before you upgrade the Contenta software.
About this task
Note: Be sure that the client is installed with the same version of Oracle software that is installed on the Oracle Server.
Procedure
- Follow the instructions provided by Oracle to upgrade the Oracle Client software and install the appropriate Oracle patches on the Contenta Clients that are required for this SDL Contenta release.
See the Platform Requirements document for information about the system requirements. Perform the upgrade as the administrator user.
- After the Oracle Client is installed, use the Net8 Assistant to verify that a service entry exists for Oracle.
If one does not exist, use the Net Configuration Assistant to update the tnsnames.ora file. Provide the information described in the following table. See the Oracle documentation if you need additional information for this step.
Note: Use the same Service Name that was used when you installed the Oracle Server. The upgrade program does not prompt for a Service Name.
| Net Configuration Assistant |
|---|
| Add New Service | Service name is user-defined. |
| Protocol | TCP/IP |
| Host Name | Name of database server on which the Contenta Oracle instance (SID) resides. |
| Port Number | Use the Oracle default port number unless otherwise instructed by your DBA. |
| Service Name | Name of the Contenta Oracle instance (SID). |
- Restart the Oracle Server system.
After you upgrade Oracle Server and Client, test Oracle connectivity before continuing.