Problem with starting "RDB Archive Manager"

[a.wilimowski@europolgaz.com.pl]

Hi,

OS: RedHat 7.6
WinCCOA 3.16 (3.15)

I have problem with starting "RDB Archive Manager" when my WinCC_OA project run as service on user "scada" (not root user). Errors in Log Viewer are:

when I use entry "oracleClientVersion = 12" or "oracleClientVersion >= 11" or "oracleClientVersion = 11" in config file of my project:
WCCOArdb (97), 2019.07.29 13:41:07.049, SYS, FATAL, 2, Manager Stop, OCCI loading error. Check the Oracle Client! Could not load Version 11
WCCOArdb (97), 2019.07.29 13:41:07.049, SYS, FATAL, 2, Manager Stop, OCCI loading error. Check the Oracle Client Version and the config entry "oracleClientVersion"!

or

when I don't use entry "oracleClientVersion " in config file of my project:
WCCOArdb (97), 2019.07.29 13:18:15.805, SYS, WARNING, 133, Could not load shared library /opt/WinCC_OA/3.16/bin/OCCIWrapper_12.so, libocci.so.12.1: nie można otworzyć pliku obiektu dzielonego: Nie ma takiego pliku ani katalogu
WCCOArdb (97), 2019.07.29 13:18:15.805, SYS, WARNING, 61, Cannot open file, OCCI Function loading error:, /opt/WinCC_OA/3.16/bin/OCCIWrapper_12.so, createEnvironment
WCCOArdb (97), 2019.07.29 13:18:15.805, SYS, FATAL, 2, Manager Stop, OCCI loading error. Check the Oracle Client Version and the config entry "oracleClientVersion"!, /opt/WinCC_OA/3.16/bin/OCCIWrapper_12.so

I have configure environment variables in /etc/init.d/wincc file in /etc/systemd/system/winccoa@.service and in .bash_profile file.

When I run my project on root user (as a service) or on "scada" user but not as a service, my project run properly with "RDB Archive Manager" connected to data base.

Does anyone know what a problem can be? It's possible to run WinCC OA project as a service on "not root user"?

Best regards,
Adam

[leoknipp]

It should be possible to run the project as non root user.
Did you follow the steps for the service installation described in the WinCC OA Documentation?
Which of the options have you used to configure the service?

Best Regards
Leopold Knipp
Senior Support Specialist

[a.wilimowski@europolgaz.com.pl]

Yes, I follow the steps for the service installation described in the WinCC OA Documentation. I used systemd service file. I activated service by command "systemctl enable winccoa@epg1" (epg1 is name of my project). Below I send the contents of the files: winccoa@.service and environment variable for this service.

winccoa@.service file:
[Unit]
Description=WinCC OA project '%i'

[Service]
EnvironmentFile=/etc/systemd/system/environment_oracle
ExecStart=/opt/WinCC_OA/3.16/bin/WCCILpmon -proj %i
ExecStop=/opt/WinCC_OA/3.16/bin/WCCILpmon -proj %i -stopWait
User=scada

[Install]
WantedBy=multi-user.target




environment_oracle file:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=${ORACLE_BASE}/product/DB12201SE2/Client
ORACLE_SID=epgdb
PATH=${PVSS_PATH}/bin:${PATH}:$PATH:$HOME/.local/bin:$HOME/bin:${ORACLE_HOME}/bin:/opt/WinCC_OA/3.16/bin
LD_LIBRARY_PATH=${PVSS_PATH}/bin:${LD_LIBRARY_PATH}:/usr/local/lib:/usr/lib:${ORACLE_HOME}/lib:${ORACLE_HOME}/lib32:/opt/WinCC_OA/3.16/bin
EOF

Best regards,
Adam