Template:SQWareProduction sqwora GlobalVar.cfg explanation
Variables explanation:
#General variables gvsqw_SqwVersion => SQWare Production version gvsqw_ConnectDb => if connection to db evalable then Enable else Disable gvsqw_Hostname => Hostname for prompt and trace gvsqw_GlobalMsgMail => Begining of email subject gvsqw_GlobalMail => email adress, put NoNail in gvsqw_GlobalMail if you don't want to send mail on error gvsqw_SendmailHtmlFormat => Html format for email, put disable in gvsqw_SendmailHtmlFormat if you don't want to send mail in html format gvsqw_PreFormatHtlml => enable if file is already formated gvsqw_Colors => enable, put disable in gvsqw_Colors if you don't want to print in color gvsqw_TraceJobDb => enable, put disable in gvsqw_TraceJobDb if you don't want to trace job execution in SQWareRepository gvsqw_EgrepIvFs => for 'egrep -v' on 'df' command gvsqw_SuppLogsHisto => number of days to delete log files gvsqw_GzipLogsHisto => number of days to compress log files gvsqw_SuppArchAlert => number of days to delete archives of alert files gvsqw_SuppBckCfg => number of days to delete archives of init and control files gvsqw_RootAdmin => admin directory gvsqw_RootCfg => configuration directory gvsqw_RootDbf => datafiles directory gvsqw_NbThread => default number of thread for parallelism gvsqw_SshOptions => ssh default options gvsqw_ScpOptions => scp default options ##Globaly forcing return code for scripts gvsqw_ForcedReturnCodeScript_sqwora_SchemaRefresh => To force return code of sqwora_SchemaRefresh.ksh ... #for RMAN scripts gvsqw_RootRman => default RMAN backup directory gvsqw_RootRmanSource => default RMAN backup directory of source instance gvsqw_RootDbfSource => default datafiles directory of source instance gvsqw_RootArch => default archive logs directory gvsqw_NbRmanThreadCopyBackups => default number of thread for parallelism for copy RMAN backups gvsqw_RmanWaitTimeOut => default time out for SqwArchmon gvsqw_RmanForceCatConnectBck => to force connection on recovery catalog gvsqw_RmanDefaultRetentionPlolicy => default RMAN retention policy gvsqw_RmanDefaultDeviceType => default RMAN device type #for exports and refresh scripts gvsqw_RootExp => default export directory gvsqw_RootExpLog => default export log directory gvsqw_RootExpSource => default export directory of source instance gvsqw_RootExpLogSource => default export log directory of source instance gvsqw_ExportCompressorExt => default compression for export gvsqw_ExportNbGeneration => default number generation of export to keep online #for check instance script gvsqw_EgrepWar => default egrep for report gvsqw_DefTbsSystem => users with default SYSTEM tablespace gvsqw_ObjTbsSystem => owners of objects in SYSTEM tablespace gvsqw_RoleAdmin => users with admin role gvsqw_RoleTooStrong => users with admin role gvsqw_PrivSystem => users with system privileges gvsqw_PrivAny => users with ANY privileges gvsqw_GrantsSysPublic => search for public execute #for gather indicators gvsqw_SizeMinSch => Size min in Meg of schema to insert into SQWare Repository gvsqw_SizeMinSeg => Size min in Meg of segment to insert into SQWare Repository #for manage stop/start gvsqw_TimeOutImmediate => Time out of 'shutdown immediate' and make 'shutdown abort' gvsqw_Listener => Listener name #for SQWare Web gvsqw_WebDbaURL => SQWare Web URL gvsqw_WebDbaUser => Connection string ssh user@hostname to SQWare Web gvsqw_WebDbaDirAwr => Directory to store AWR reports on SQWare Web
