Beispiel für eine RDB Config Datei

Nachfolgend ein Beispiel für eine konfigurierte "RDB_config.sql" Datei, welche alle nötigen Einstellungen für die Verwendung mit dem WinCC OA RDB Manager enthält. Für eine Beschreibung der möglichen Parameter siehe: Parameter für das Oracle DB-Setup

-- $Author$ $Date$ $Revision$
-------------------------------------------------------------------------------------------------------------------
-- ATTENTION: THIS FILE HAS BEEN FILLED WITH SAMPLE DATA - PLEASE ADJUST THE PARAMETERS ACCORDING TO YOUR NEEDS! --
-------------------------------------------------------------------------------------------------------------------
-- ACHTUNG: HIER SIND BEISPIELDATEN EINGETRAGEN - JE NACH PROJEKTUMGEBUNG M�SSEN DIE EINTR�GE ANGEPASST WERDEN!  --
-------------------------------------------------------------------------------------------------------------------

prompt
prompt RDB Config: Defining RDB setup <<default>> parameters
prompt =========================================
prompt

----------------------
-- Setup Parameters --
----------------------

-- Config entries: Please adjust them according to your specific environment
-- Please enter all paths marked "(on DB server*)" with terminating slash or backslash! All given paths must already exist, they will not be created on the DB server!

-- config entries for standalone DB Server or the first node RAC cluster
define connect_identifier  = 'dbvisit1'      -- Connect Identifier (TNS Alias)
define sysdba_user      = 'SYS'             -- Sysdba User, e.g. sys or empty for OS-authentication
define yesno_newuser    = 'yes'              -- yes -> creates new schema/user; no -> no need for sysdba + uses existing user (provided with all the necessary grants) + all user objects will be recreated + all archives will be deleted
define schema_user      = 'RDB'              -- Name of new or existing User; schema user and application user must be different!!
define app_user     = 'APP'                  -- New PVSS Application User; schema user and application user must be different!!
define os_sys    = 'unix'                    -- Operating system on the DB server (win/unix)
define way_of_backup    = 'datapump'         -- way_of_backup (parameter was named formerly use_rman): 
-- Logical Backup (datapump) must be used for Container Databases. 
-- For conventional Database Operation Mode (without Pluggable Database ) valid entries:
--    a.) Logical Backup (datapump) - RECOMMENDED  
--    b.) Operating system (os) - FOR BACKWARDS COMPATIBILITY ONLY 
--    c.) RMAN (rman)   - FOR BACKWARDS COMPATIBILITY ONLY 
define useModifiedTimestampFor2x2FWD = 'no'   -- if 2x2-redundancy or forward-to-center (fwd) will be used - this parameter must be set to 'yes' 
define zip_backup       = 'yes'               -- Zip Backups (yes/no)
define sequence_start      = 100000           -- Sequence Start, minimum 0
define sequence_maxvalue   = 199999           -- Sequence Maxvalue, up to 99.999.999
define path_oraclebin      = '/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_10/bin/'    -- Path Oracle-Bin (on DB server*), used for ForceDel on Windows and for path to Oracle executables on Unix
define instance_name    = 'dbvisit1'          -- SID Identifier of Database-Instance of standalone DB server or when RAC Cluster first Database-Instance SID1 on first node in cluster
define host_name    = 'oda01-0'               -- Host Name of the standalone DB Server or first node of RAC cluster
define path_backup      = '/u01/backup/WinCCOA/dbvisit1/'   -- Path Backup, backup path for backup archives (on DB server*) - must already exist
define mytimezone       = 'Europe/Vienna'     -- Local Time Zone (see v$timezone_names)
define asm_instance     = ''                  -- must be empty when not using ASM! SID Identifier for ASM-Instance of the standalone DB Server (usually +ASM, when ASM is used) or of the first node in RAC cluster,usually +ASM1
define service_name     = 'dbvpdb.etm-ag.com' -- Service Name, use SERVICE_NAME from TNSNAMES (use only Oracle SID if no service_name available, just in single instance case, normally not used anymore)
define number_db_storage   = 1                -- Default 1, cannot be changed because Oracle Dataguard is not supported anymore.
define path_asm_bin     = ''                  -- must be empty when not using ASM! Path ASM-Bin (on DB server*), used for Oracle executables used especially for the ASM functionalities 

-- Parameter for backwards compatibility if way_of_backup (formerly use_rman) (RMAN,OS) is used and if CONTAINER database mode is not used.
define path_dbfile      = ''                  -- Path Dbfile (on DB server*)
define path_tempdbfile     = ''               -- Path Tempdbfile (on DB server*)
define path_alert       = ''                  -- Path Alert, path of alertgrouptype-database-files (on DB server*) - must already exist
define path_event       = ''                  -- Path Event, path of eventgrouptype-database-files (on DB server*) - must already exist

-- config entries for the second node (in case of Oracle RAC cluster), leave it empty if there is none (if there are even more than two nodes, please use Site-Config-PVSS-Panel to enter the data)
define connect_identifier2 = ''               -- <TNS-Alias> Connect Identifier (TNS Alias) of the second node in RAC cluster, must be the same as for first node in Oracle RAC cluster
define instance_name2      = ''               -- <DBSID2> SID Identifier of Database-Instance of the second node in RAC cluster
define host_name2       = ''                  -- <Host2> Host Name of the second node in RAC cluster
define asm_instance2    = ''                  -- <ASMSID2> SID Identifier of ASM-Instance of the second node in RAC cluster, usually +ASM2
define service_name2    = ''                  -- <service-name> Service Name for the second node in RAC cluster, must the same as for the first node
       
-- config entries which are set to useful and recommended defaults
define use_occi     = 'yes'                   -- Using Oracle C++ Call Interface (yes/no) in order to perform bulk operations (instead of SQLAPI which does not support bulk operations) -> "writeWithBulk = 1"
define use_java     = 'yes'                   -- no -> using C-DLL, yes -> using Java code (recommended)
define sys_partitions      = 'no'             -- history tables can be partitioned on their sys_id, usually partitioning is not necessary, except there are many distributed systems
define extra_TempTS     = 'no'                -- creating an extra temporary tablespace for the schema user or using the system's default temporary tablespace (ATTENTION: if 'yes', then please also enter a value for <uniform_size>!)
define public_grants    = 'no'                -- creating public synonyms and grants (R_APP_PVSSRDB) -> schema user's objects which are available for the app user become public

-- expert config entries - no need to change these values - they are set to useful defaults
define type_float       = 'NUMBER'            -- type by which float values are represented, e.g. NUMBER or BINARY_DOUBLE or ...
define initial_size     = '500M'              -- default initial size for the datafiles of all RDB-tablespaces (schema, temporary and archive tablespaces), corresponding to the Oracle <size_clause> which is part of the <datafile_tempfile_spec>; see also "Oracle Database SQL Reference"
define next_size    = '64M'                   -- default extension size for the datafiles of all RDB-tablespaces, corresponding to the value in the Oracle <autoextend_clause>, which is part of the <datafile_tempfile_spec>, if empty (''), Oracle will extend the datafile only by the default blocksize; see also "Oracle Database SQL Reference"
define uniform_size     = ''                  -- default uniform size, corresponding to the value for the uniform size allocation in the Oracle <extent_management_clause>, must be empty ('') for AUTO ALLOCATE (which is Oracle Default); see also "Oracle Database SQL Reference"
define physical_attributes = ''               -- default physical_attributes_clause for tables (physical attributes) or indexes (physical_attrib_idx), corresponds 1:1 to Oracle's <physical_attributes_clause>, if empty (''), then Oracle will work with its defaults, ...
define physical_attrib_idx = ''               -- (continued from line above) ..., may be used to define some or all of the following: STORAGE_CLAUSE, PCT_FREE, INITRANS (info: tablespace has SEGMENT SPACE MANAGEMENT AUTO); see also "Oracle Database SQL Reference"
define use_arc_idx_ts      = 'yes'            -- enable or disable index on TS, usually enabled (yes or no)
define threshold_append	   = 100           -- block size above which inserts are done with optimizer hint /*+APPEND*/, block size of 0 disables the append-optimizer-hint
--define storage_clause      = ''             -- obsolet since 6.2 -> default storage clause for tables etc. -> written to table ARC_CONFIG, default used to be '(INITIAL 10M MINEXTENTS 1 MAXEXTENTS UNLIMITED)', now empty -> Oracle manages storage
--define storage_clause_idx  = ''             -- obsolet since 6.2 -> default storage clause for indexes     -> written to table ARC_CONFIG, default used to be '(INITIAL 10M MINEXTENTS 1 MAXEXTENTS UNLIMITED)', now empty -> Oracle manages storage

-- config entries for control of setup or upgrades
define upgrade_sizeparams_override = 'no'     -- yes -> data taken from this file (RDB_config.sql), no -> existing configuration of ARC_CONFIG remains
define upgrade_alertlastval     = 'yes'       -- yes -> the alert lastval table will be deleted and recreated, risk of data loss during upgrade, no -> no recreation, risk of structure incompatibilities
define upgrade_eventlastval     = 'yes'       -- yes -> the event lastval table(s) will be deleted and recreated, risk of data loss during upgrade, no -> no recreation, risk of structure incompatibilities
define reset_cs          = 'no'               -- yes -> delete and recreate whole CS part, no -> leave tables and contents, recreate packages, etc.
define longTermStatCalcInt      = 24          -- is used for all compressions where the interval is greater than 24 HOURS. So each interval job for compressions with interval>24h is running f.e. once a day. 24=once a day, 12=twice a day and 1=every hour 

-- config entries for 2x2-redundancy or forward-to-center (fwd)
define whatpackage     = '2x2'                -- 2x2 redundancy (2x2) or forward-to-center-synchronization (fwd)
define connect_first   = '&connect_identifier'       -- first (=local) connect string (in this example taken from above)
define connect_second  = 'DUMMY_DISTANT_DB'   -- second (=distant) connect string
define whatinstall     = '3'                  -- install on first (1) or second site (2) or install on both sides (3)
define syncjob_intval  = 3                    -- interval of synchronization job in MINUTES (for J_SYNC2X2 or J_SYNCFWD)
define maxintval_len   = 60                   -- only for 2x2: maximum length of synchronization interval in SECONDS (to divide a large interval into smaller units to transmit them over the db-link)
define system_first    = 1                    -- only for 2x2: first system ID of first or local system to match the first system ID of second or distant system
define system_second   = 2                    -- only for 2x2: first system ID of second or distant system to match the first system ID of first or local system
define system_first2   = ''                   -- optional and only for 2x2: second system ID of first or local system to match the second system ID of second or distant system
define system_second2  = ''                   -- optional and only for 2x2: second system ID of second or distant system to match the second system ID of first or local system
define schema_user_second = '&schema_user'-- optional for fwd: if the user name of the second system is different than system one.

-- Index Organized tables
define IOT_enabled = 'yes'                    -- use of the Index Organized Tables instead of standard heap onesl
define compression_init_value = 'no'          -- no -> calculation of MIN/MAX/AVG uses only values which occurred within the calculated interval, yes -> calculation of MIN/MAX/AVG uses the last value from the previous interval as initial value
define validTimeDiff	= 300                 -- valid time difference between WinCC_OA and Oracle. It's used for ArchiveSwitching time 
define use_extended_oracle_types = 'no' 	  -- if f.e. max_string_size > 4000 should be used, an upgrade of the Oracle database itself will be necessary - please have a look at the ONLINE Help