WinCC OpenArchitecture using Oracle RDB-Manager…<\/p>\n
*) Oracle db_files
\n*) Oracle logfile size
\n*) Oracle Password-Lifetime
\n*) Example WinCC OA config file
\n*) TCP\/IP timeout settings on windows
\n*) WinCC OA Archive Group Sizing<\/p>\n
Oracle db_files
\n===============
\nalter system set db_files=65536 scope=both;<\/p>\n
Oracle logfile size
\n===================
\nFor huge load (>1000 values\/second) logfile size should be increased!<\/p>\n
select * from v$logfile;<\/p>\n
alter database add logfile size 512M;
\nalter database add logfile size 512M;
\nalter database add logfile size 512M;<\/p>\n
remove other\/small logfiles. If the logfiles are the current one then you have to switch the logfile and initiate a checkpoint before you are able to remove the old one.<\/p>\n
alter system switch logfile;
\nalter system checkpoint;<\/p>\n
alter database drop logfile group Oracle Password-Life-Time WinCC OA Config [data] [ValueArchiveRDB] [ctrl] [ui] Example TNSNAMES.ORA for a cluster with two networks:<\/p>\n Windows TCP\/IP Timeout Set the following registry entry (or create if it does not exist): KeepAliveTime<\/p>\n Key: HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\Tcpip\\Parameters WinCC OA Archive Group Sizing Block Size Maximum Datafile File Size WinCC OpenArchitecture using Oracle RDB-Manager… *) Oracle db_files *) Oracle logfile size *) Oracle Password-Lifetime *) Example WinCC OA config file *) TCP\/IP timeout settings on windows *) WinCC OA Archive Group Sizing Oracle db_files =============== alter system set db_files=65536 scope=both; Oracle logfile size =================== For huge load (>1000 values\/second) logfile size should be increased! … Continue reading WinCC OA RDB-Manager Config & Database Settings…<\/span>
\n=========================
\nTo prevent password expiration the default profile should be changed.
\nalter profile default limit password_life_time unlimited;<\/p>\n
\n===============
\n
\n[general]
\nuseRDBArchive = 1
\nuseRDBGroups = 1<\/p>\n
\nsendAlertsToRAIMA=1 # for HDB\/RDB Parallel<\/p>\n
\nDbUser = \"PVSSRDB\"
\nDbPass = \"xxx\"
\nDbType = \"ORACLE\"
\nDb = \"DB\"
\nwriteWithBulk = 1<\/p>\n
\nqueryRDBdirect = 1
\nCtrlDLL = \"CtrlADO\"
\nCtrlDLL = \"CtrlRDBArchive\"
\nCtrlDLL = \"CtrlRDBCompr\"<\/p>\n
\nqueryRDBdirect = 1
\nCtrlDLL = \"CtrlADO\"
\nCtrlDLL = \"CtrlRDBArchive\"
\nCtrlDLL = \"CtrlRDBCompr\"
\n<\/code>
\n <\/p>\n
\nDB =
\n(DESCRIPTION =
\n (ENABLE=BROKEN)
\n (ADDRESS_LIST=
\n (ADDRESS = (PROTOCOL = TCP)(HOST = mainhdr1-vip)(PORT = 1521))
\n (ADDRESS = (PROTOCOL = TCP)(HOST = mainhdr1b-vip)(PORT = 1522))
\n )
\n (ADDRESS_LIST=
\n (ADDRESS = (PROTOCOL = TCP)(HOST = mainhdr2-vip)(PORT = 1521))
\n (ADDRESS = (PROTOCOL = TCP)(HOST = mainhdr2b-vip)(PORT = 1522))
\n )
\n (CONNECT_DATA =
\n (SERVICE_NAME = DB)
\n (FAILOVER_MODE =
\n (TYPE = SELECT)
\n (METHOD = BASIC)
\n (RETRIES = 20)
\n (DELAY = 5)
\n )
\n )
\n)
\n<\/code><\/p>\n
\n======================
\nAlso the tcp\/ip timeout on windows should be decreased:<\/p>\n
\nValue type: REG_DWORD \u2013 Time in milliseconds
\nRange: 1 \u2013 0xFFFFFFFF
\nDefault value: 7.200.000 (two hours)
\nFor example this value can be set to 180000 (decimal), equals 3 minutes.<\/p>\n
\n=============================
\nIncrease the max archive group size of existing (EVENT, ALERT) and new archives. The default size of 1GB is really damn small. Think about the max. db_files parameter (each archive file switch creates a new db file). Sizes of 20GB+ is no problem for Oracle. But keep in mind that there are file size limits (RDB Manager does not use Oracle Big-File-Tablespaces). For a block size of 8k the max file size is 32GB. <\/p>\n
\n———– —————————
\n2k 4194303 * 2k = 8 GB
\n4k 4194303 * 4k = 16 GB
\n8k 4194303 * 8k = 32 GB
\n16k 4194303 * 16k = 64 GB
\n32k 4194303 * 32k = 128 GB<\/p>\n","protected":false},"excerpt":{"rendered":"