SQWareProduction:oracle:etc:sqwora GlobalVar.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:
Global var for Oracle
It contains the operating variables of SQWareProduction.
File content:
export gvsqw_EdtVersion=2.0.12
export gvsqw_ConnectDb=Enable
export gvsqw_DbaUser='/'
export gvsqw_InstanceNameForceCase='UpperCase'
export gvsqw_AcceptNotOpen='False'
export gvsqw_Hostname=$(hostname|cut -d '.' -f1)
export gvsqw_MailMsg_oracle="TrtOraAuto$gvsqw_Env"
export gvsqw_Mail_oracle='default@dbsqware.com'
export gvsqw_EgrepIvFs='Filesystem|Disponible'
export gvsqw_SendmailHtmlFormat=enable
export gvsqw_PreFormatHtlml=enable
export gvsqw_Colors=enable
export gvsqw_TraceJobDb=enable
export gvsqw_UploadLogFile=enable
export gvsqw_TraceBackup=enable
export gvsqw_UploadLogFileMaxLine=200
export gvsqw_SuppLogsHisto=30
export gvsqw_GzipLogsHisto=7
export gvsqw_SuppBckCfg=30
export gvsqw_SuppArchAlert=30
export gvsqw_RootAdmin='$HOME/admin/${ORACLE_SID}'
export gvsqw_RootAdminDist='$HOME/admin/oracle/${ORACLE_SID}'
export gvsqw_RootCfg='$gvsqw_RootAdmin/edtConfig'
export gvsqw_RootDbf='/$(echo ${HOME}|cut -d/ -f2)/data/${ORACLE_SID}'
export gvsqw_NbThread=2
export gvsqw_SshOptions="-q -o BatchMode=yes -o StrictHostKeyChecking=no"
export gvsqw_ScpOptions="-o BatchMode=yes -o StrictHostKeyChecking=no"
export gvsqw_DistPasswdFile="$HOME/.passwd_oracle"
export gvsqw_TnsDbsPath="$HOME/SQWareProduction/oracle/etc_cust"
export gvsqw_CHtmlError='<font color="#FF0000">'
export gvsqw_CHtmlOk='<font color="#00FF00">'
export gvsqw_CHtmlInfo='<font color="#0000FF">'
export gvsqw_CHtmlEnd='</font>'
export gvsqw_THtmlBegin='<table class="edt">'
export gvsqw_THtmlEnd='</table>'
export gvsqw_THtmlThBegin='<tr class="edtth"><th>'
export gvsqw_THtmlThEnd='</th></tr>'
export gvsqw_THtmlThInter='</th><th>'
export gvsqw_THtmlTdBegin1='<tr class="edtnc"><td>'
export gvsqw_THtmlTdBegin2='<tr class="sqwc_"><td>'
export gvsqw_THtmlTdEnd='</td></tr>'
export gvsqw_THtmlTdInter='</td><td>'
export gvsqw_THtmlPre="<pre class='edt'>"
export gvsqw_THtmlPreEnd=""
export gvsqw_HtmlCss="<html><head>
- export gvsqw_ForcedReturnCodeScript_sqwora_SchemaRefresh=0
export gvsqw_RootRman='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/rman' export gvsqw_RootRmanSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/rman' export gvsqw_RootDbfSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/data/${lvsqw_InstanceSource}' export gvsqw_RootArch='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/archive' export gvsqw_NbRmanThreadCopyBackups=4 export gvsqw_RmanWaitTimeOut=600 export gvsqw_RmanForceCatConnectBck=disable export gvsqw_RmanDefaultRetentionPlolicy='RECOVERY WINDOW OF 6 DAYS' export gvsqw_RmanDefaultDeviceType='DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET' export gvsqw_RootExp='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/exp' export gvsqw_RootExpLog='/$(echo $HOME|cut -d/ -f2)/backup/${ORACLE_SID}/exp/log' export gvsqw_RootExpSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/exp' export gvsqw_RootExpLogSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/exp/log' export gvsqw_ExportCompressorExt=gz export gvsqw_ExportNbGeneration=1 export gvsqw_RootPhysicalColdBackup='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/PhysicalColdBackup' export gvsqw_RootPhysicalHotBackup='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/PhysicalHotBackup' export gvsqw_PhysicalColdNbGeneration=1 export gvsqw_RootExpdp='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/expdp' export gvsqw_ExpdpDirectory='dbsqware_datapump' export gvsqw_ExpdpCompressorExt=none export gvsqw_ExpdpNbGeneration=1 export gvsqw_NbThreadExpdp=2 export gvsqw_EgrepWar='Warning |Security |Recovery ' export gvsqw_DefTbsSystem="'SYSTEM','SYS','DBSNMP','OUTLN','WMSYS','ORDSYS','MDSYS','DBSNMP','DIP'" export gvsqw_ObjTbsSystem="'SYS', 'SYSTEM','OUTLN','WMSYS','ORDSYS','MDSYS','DBSNMP','DIP'" export gvsqw_RoleAdmin="'DBA','SYS','SYSTEM','SYSMAN','DATAPUMP_IMP_FULL_DATABASE'" export gvsqw_RoleTooStrong="'DBA','SYS', 'SYSTEM', 'SYSMAN', 'DATAPUMP_IMP_FULL_DATABASE','OUTLN','LOGSTDBY_ADMINISTRATOR'" export gvsqw_PrivSystem="'DBA','SYS','SYSTEM','ORACLE','DBSNMP','IMP_FULL_DATABASE','WMSYS','OUTLN','DATAPUMP_IMP_FULL_DATABASE','SCHEDULER_ADMIN', 'LOGSTDBY_ADMINISTRATOR'" export gvsqw_PrivAny="'DBA','SYS','SYSTEM','ORACLE','IMP_FULL_DATABASE','EXP_FULL_DATABASE','WMSYS','OUTLN','AQ_ADMINISTRATOR_ROLE','OEM_MONITOR', 'DATAPUMP_IMP_FULL_DATABASE', 'SCHEDULER_ADMIN'" export gvsqw_GrantsSysPublic="'UTL_TCP','UTL_FILE','UTL_HTTP','UTL_SMTP','DBMS_LOB','DBMS_SQL','DBMS_SCHEDULER','OWA_UTIL'" export gvsqw_SizeMinSch=10 export gvsqw_SizeMinSeg=10 export gvsqw_AsmDgTable='v$asm_diskgroup_stat' export gvsqw_DbAlias='$ORACLE_SID'
- export gvsqw_DistDbaUser='user/passwd@$ORACLE_SID'
export gvsqw_TimeOutImmediate=600 export gvsqw_Listener='LSN$ORACLE_SID' export gvsqw_MonitorTimeAWR='trunc(sysdate-1)' export gvsqw_WebDbaURL="http://webdba"
- export gvsqw_WebDbaUser='Connection string ssh user@hostname'
- export gvsqw_WebDbaDirAwr='Directory to store AWR reports'
Variable explanation:
gvsqw_AcceptNotOpen => gvsqw_AsmDgTable => gvsqw_CHtmlEnd => gvsqw_CHtmlError => gvsqw_CHtmlInfo => gvsqw_CHtmlOk => gvsqw_Colors => gvsqw_ConnectDb => gvsqw_DbAlias => gvsqw_DbaUser => gvsqw_DefTbsSystem => #gvsqw_DistDbaUser => gvsqw_DistPasswdFile => gvsqw_EdtVersion => gvsqw_EgrepIvFs => gvsqw_EgrepWar => gvsqw_ExpdpCompressorExt => gvsqw_ExpdpDirectory => gvsqw_ExpdpNbGeneration => gvsqw_ExportCompressorExt => gvsqw_ExportNbGeneration => #gvsqw_ForcedReturnCodeScript_sqwora_SchemaRefresh => gvsqw_GrantsSysPublic => gvsqw_GzipLogsHisto => gvsqw_Hostname => gvsqw_HtmlCss => gvsqw_InstanceNameForceCase => gvsqw_Listener => gvsqw_MailMsg_oracle => gvsqw_Mail_oracle => gvsqw_MonitorTimeAWR => gvsqw_NbRmanThreadCopyBackups => gvsqw_NbThread => gvsqw_NbThreadExpdp => gvsqw_ObjTbsSystem => gvsqw_PhysicalColdNbGeneration => gvsqw_PreFormatHtlml => gvsqw_PrivAny => gvsqw_PrivSystem => gvsqw_RmanDefaultDeviceType => gvsqw_RmanDefaultRetentionPlolicy => gvsqw_RmanForceCatConnectBck => gvsqw_RmanWaitTimeOut => gvsqw_RoleAdmin => gvsqw_RoleTooStrong => gvsqw_RootAdminDist => gvsqw_RootAdmin => gvsqw_RootArch => gvsqw_RootCfg => gvsqw_RootDbf => gvsqw_RootDbfSource => gvsqw_RootExpdp => gvsqw_RootExp => gvsqw_RootExpLog => gvsqw_RootExpLogSource => gvsqw_RootExpSource => gvsqw_RootPhysicalColdBackup => gvsqw_RootPhysicalHotBackup => gvsqw_RootRman => gvsqw_RootRmanSource => gvsqw_ScpOptions => gvsqw_SendmailHtmlFormat => gvsqw_SizeMinSch => gvsqw_SizeMinSeg => gvsqw_SshOptions => gvsqw_SuppArchAlert => gvsqw_SuppBckCfg => gvsqw_SuppLogsHisto => gvsqw_THtmlBegin => gvsqw_THtmlEnd => gvsqw_THtmlPreEnd => gvsqw_THtmlPre => gvsqw_THtmlTdBegin1 => gvsqw_THtmlTdBegin2 => gvsqw_THtmlTdEnd => gvsqw_THtmlTdInter => gvsqw_THtmlThBegin => gvsqw_THtmlThEnd => gvsqw_THtmlThInter => gvsqw_TimeOutImmediate => gvsqw_TnsDbsPath => gvsqw_TraceBackup => gvsqw_TraceJobDb => gvsqw_UploadLogFile => gvsqw_UploadLogFileMaxLine => #gvsqw_WebDbaDirAwr => gvsqw_WebDbaURL => #gvsqw_WebDbaUser =>
