Problems when installing RDB

[alfredgg]

Hello,

I'm trying to install the RDB from a Windows 10 machine with WinCC OA 16 installed to a Linux machine with Oracle 19 installed.

Connection and first steps of win_install.bat are working properly. However, at certain point, it fails. The detectable errors it gives to me are the next:

Code: Select all

Running script RDB_ARCSITE.SQL
==============================

Inserting Data Into Table ARC_SITE and Defining File-Path CDB5@CDB5
Anlage dynamisch ALERT: -1
Anlage dynamisch EVENT: -1
Error for: lAlertScreenView
Error for: lAlertAddValuesPivot
Error for: lAlertScreenPivotView

Running script RDB_AppUser.sql
==============================


Creating synonyms for the Application-User
==========================================


Granting object rights to role R_APP_PVSSRDB
============================================

grant select on ALERTHISTORYDBLINK to R_APP_PVSSRDB
                *
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on VALERTSCREEN to R_APP_PVSSRDB
                *
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on VALERTSCREENPIVOT to R_APP_PVSSRDB
                *
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on ALERTADDVALUESPIVOT to R_APP_PVSSRDB
                *
ERROR at line 1:
ORA-00942: table or view does not exist

Giving to me also the next summary:

Code: Select all

Checking Setup

==============

setup - main config entries: OK
setup - creating group and archive + switching: FAILED! 4/0
setup - created sites per instance: OK
setup - active monitor jobs: OK
setup - packages and package bodies: OK
setup - sequences: OK
setup - history groups: FAILED! 2/0
setup - dynamic history tables per group: FAILED! 2/0
setup - standard lastval tables per group: FAILED 2/0
setup - standard tables: OK
setup - enabled standard triggers: OK
setup - user defined types: OK
setup - views per group: FAILED! 5/0
setup - user or OS authentication for backup and recovery: OK
setup - time zone exists: OK
setup - valid time zone: FAILED! 0/-60000000000000
setup - connection to extern source: OK
setup - standard CS tables: OK
setup - CS packages and functions: OK
setup - CS monitoring views: OK
setup - log entries 'I'nformation: FAILED! 12-16/5-16
setup - log entries 'W'arnings: OK
setup - log entries 'E'rrors: FAILED! 0/2
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Can you detect here if I mistook, forgot, or overlook some step? Not being an Oracle expert I have been stuck with this for days.

Thanks!

[leoknipp]

First of all you have to check which patch for WinCC OA 3.16 is installed.
Oracle Server and Client of version 19c are only supported when using the newest patch P017 for WinCC OA 3.16.

I'm not sure if a missing patch is the cause for the problem but first of all the software requirements must be fulfilled.

Best Regards
Leopold Knipp
Senior Support Specialist

[alfredgg]

It's confirmed I have the patch P017 installed and the error keeps appearing on executing win_install.bat.

[leoknipp]

For the analysis possibly more detailed information is necessary, e.g. the RDB_config.sql file you have used for the configuration of the RDB database.
In that case it is maybe to share data when getting in contact with your common WinCC OA support.

Best Regards
Leopold Knipp
Senior Support Specialist