Upgrade of an RDB Project
In case of an already existing RDB project in WinCC OA the following steps have to be proceed/checked in order to upgrade to a new WinCC OA version. If one of these steps does not apply to conditions during the upgrade, skip it.
This is how to upgrade your project
-
When you update under Windows to WinCC OA version 3.17 and older WinCC OA versions are installed parallel, note that you have to delete the File oraocci10.dll of older WinCC OA versions from the WinCC OA bin directory.
-
Check the "RDB_config_template.sql"(<WinCC_OA_InstallationPath>\data\RDBSetup\ora) file for new, changed or deleted parameters and adjustyour own"RDB_config.sql" file accordingly. For this process it is recommended to use a file compare program (e.g. "Beyond Compare" or "UltraCompare").
-
If a database user already exists, this step is not required and even must not be executed, because otherwise this user will be overwritten! If a new database user shall be created, call the batch file (<WinCC_OA_InstallationPath>\data\RDBSetup\ora) using the command line for starting the setup in order to apply the changed settings for the configuration of the connection to the Oracle database: win_install.bat >Batch file for Windows or unix_install.sh >Batch file for Linux
For security reasons, the passwords are not entered in the "RDB_config.sql" but requested interactive.
-
Upgrade the RDB schema. Start the WinCC OA project with the new WinCC OA version. Do not establish a database connection before upgrading the schema. You can, however, start the RDB manager without a database connection also before the upgrade. See also DB-Schema Upgrade.
Troubleshooting
-
If a database repair is suggested at each project start of an upgraded RDB project without any reasonable basis, it should be checked whether the dbase.touch file or a *.taf file is read only. These need to be extended by a write access.