Howto find out to which Oracle Schema to upgrade?

[fandersen]

Hi,

for our current project we migrate a PVSS 3.9 project to WinCC OA 3.14 Upd10. Oracle is used for archiving. Prior to the readiness of the WinCC OA project we want to migrate the Oracle database schema. Is there another way to find out to which version we have to upgrade the schema?


We cannot use the method described in the manual by starting the RDB archive manager, since the project is not ready yet.

WCCOArdb (97), 2008.02.13 09:14:53.503, SYS, FATAL, 0, , DB Schema is RDB needs to have the Version , Starting with the wrong version! Upgrade to the required version!


Cheers,
Florian

[fandersen]

Ok, I have found it myself. I just created a temporary WinCC OA project and followed the instructions in the WinCC OA manual in chapter "First-Time Installation".

[Gertjan van Schijndel]

You can find the db schema version in the readme file under 'Additional installation steps'.

The 3.14 P010 readme contains the following:

Please run WinCC_OA_Home\\data\\RDBSetup\\ora\\win_upgrade 8.15 or unix_upgrade 8.15 to apply latest changes to the DBSchema.

[fandersen]

Hi Gerjan,

thank you.