-- $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 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 = 'oracle-scan' -- 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 use_rman = 'rman' -- Backup-Mode: Operating system (os), Operation system standard version (std), RMAN (rman); for standard version 'std' and 'os' are the same define os_sys = 'unix' -- Operating system on the DB server (win/unix) 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_dbfile = '+DATA/OCCORCL/' -- Path Dbfile (on DB server*) define path_tempdbfile = '+DATA/OCCORCL/' -- Path Tempdbfile (on DB server*) define path_oraclebin = '/u01/app/oracle/product/12.1.0/dbhome/bin/' -- Path Oracle-Bin (on DB server*), used for ForceDel on Windows and for path to Oracle executables on Unix define instance_name = 'occorcl1' -- 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 = 'oracle1' -- Host Name of the standalone DB Server or first node of RAC cluster define path_backup = '+DATA/OCCORCL/' -- Path Backup, backup path for backup archives (on DB server*) - must already exist define path_alert = '+DATA/OCCORCL/' -- Path Alert, path of alertgrouptype-database-files (on DB server*) - must already exist define path_event = '+DATA/OCCORCL/' -- Path Event, path of eventgrouptype-database-files (on DB server*) - must already exist define mytimezone = 'Asia/Shanghai' -- Local Time Zone (see v$timezone_names) define asm_instance = '+ASM1' -- 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 = 'occorcl' -- 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 = '/u01/app/12.1.0/grid_1/bin/' -- must be empty when not using ASM! Path ASM-Bin (on DB server*), used for Oracle executables used especially for the ASM functionalities -- 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 = 'oracle-scan' -- 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 = 'occorcl2' -- SID Identifier of Database-Instance of the second node in RAC cluster define host_name2 = 'oracle2' -- Host Name of the second node in RAC cluster define asm_instance2 = '+ASM2' -- SID Identifier of ASM-Instance of the second node in RAC cluster, usually +ASM2 define service_name2 = 'occorcl' -- 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 !) 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 which is part of the ; 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 , which is part of the , 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 , 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 , 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 -- Index Organized tables define IOT_enabled = 'no' -- 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