Oracle Client 19c Installation under Linux

• Install the official 19c full client (Version: 19.8) installation files.
• After the installation, setup the environment variables in the bashrc or in the basch_profile files, as usual for RDB under Linux!

  Example

  ORACLE_HOME=/usr/lib/oracle/19.8/
  PATH="$HOME/.local/bin:$HOME/bin:$PATH" 
  PATH=${ORACLE_HOME}/bin/:/opt/WinCC_OA/3.18/bin/:$PATH
  TNS_ADMIN=/home/user/admin/

  Note: Set the required environment variables with ldconfig, see chapter Set necessary environment variables for the libraries with ldconfig.
• In order to patch to the 19.8 client, the tool Opatch must be updated to the version p6880880_190000_Linux-x86-64.zip or newer. In order to update, replace the directory "OPatch" in the $ORACLE_HOME directory.
• Install the 19.8 DBRU (Database Release Update) from Oracle, which is available with the file p31281355_190000_Linux-x86-64.zip from Oracle. Follow the instructions in the readme files to install the patch. Note that it is NOT necessary to update the database, as this patch is only applied on the client!

• Apply the One-Off patch "p28933630_198000DBRU_Linux-x86-64.zip" from Oracle. Take the lib file of the One-Off Patch(libocci_gcc53.so.19.1) and copy it to the LD_LIBRARY_PATH lib folder. In our case this will be the following:

  /usr/lib/oracle/19.8/

• In order to set WinCC OA to use the correct library there are two possibilities:

  • Copy the lib libocci_gcc53.so.19.1 to the /opt/WinCC_OA/3.18/bin/ directory

  OR

  • Make a symbolic link to the new lib in the bin directory of the WinCC OA installation as follows:

    sudo ln -s $ORACLE_HOME/libocci_gcc53.so.19.1

Now your 3.18 Linux RDB project is ready and can be started!