Kkula
Browse Questions » Visualization general: Windows control center Oa - error when try to configure the ORACLE DB for RDB with way_of_backup set to datapump value

About User

Questions Asked: 37.9K

Answers Given: 32

0
  • Open

Visualization general: Windows control center Oa - error when try to configure the ORACLE DB for RDB with way_of_backup set to datapump value

WinCC OA - error when try to configure the ORACLE DB for RDB with way_of_backup set to datapump value
- OS Linux CentOS 7,
- WinCC OA v3.16 P019,
- Oracle client v.19c,
- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
If I run the unix_install.sh with way_of_backup set to datapump value I get the error (see the log attached).
If I change the way_of_backup to 'rman' the scipt is executed succefully.
What should I do to make the script work with way_of_backup set to datapump value (as recommended)?
Thank you.

0 Likes 0 Favourites 0 Followers 0 Comments
Answers(1)

WinCC OA Oracle DB Configuration - Datapump Backup Error

Based on your reported issue with WinCC OA v3.16 P019 on CentOS 7, using Oracle 19c, the error during unix_install.sh execution with way_of_backup set to 'datapump' is likely due to missing or incorrectly configured Oracle Data Pump prerequisites.

Here's a troubleshooting approach:

  1. Verify Data Pump Installation: Ensure Oracle Data Pump is correctly installed and accessible on the Oracle server.
  2. Check Directory Permissions: The directory specified for Data Pump backups (WAY_OF_BACKUP_DIR in WinCC OA configuration) must have appropriate read/write permissions for the Oracle user.
  3. Confirm SYSDBA Privileges: The Oracle user used by WinCC OA must have the SYSDBA privilege.
  4. TNS Configuration: Validate the TNS configuration (tnsnames.ora) to ensure WinCC OA can connect to the Oracle database using the specified service name.
  5. Oracle Parameter: Check the Oracle parameter db_create_file_dest and ensure it's set correctly.

Refer to these Siemens resources for further guidance:

If the issue persists, please open a support request via the Siemens Support Portal, providing the complete error log and your WinCC OA configuration details.

0