Difference between revisions of "SQWareProduction:oracle:etc:sqwora GlobalVar.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 5: | Line 5: | ||
File content: | File content: | ||
<pre> | <pre> | ||
| − | export gvsqw_EdtVersion=2.0. | + | export gvsqw_EdtVersion=2.0.02 |
export gvsqw_ConnectDb=Enable | export gvsqw_ConnectDb=Enable | ||
export gvsqw_DbaUser='/' | export gvsqw_DbaUser='/' | ||
export gvsqw_Hostname=$(hostname|cut -d '.' -f1) | export gvsqw_Hostname=$(hostname|cut -d '.' -f1) | ||
| − | export gvsqw_MailMsg_oracle= | + | export gvsqw_MailMsg_oracle="TrtOraAuto$gvsqw_Env" |
export gvsqw_Mail_oracle='default@dbsqware.com' | export gvsqw_Mail_oracle='default@dbsqware.com' | ||
export gvsqw_EgrepIvFs='Filesystem|Disponible' | export gvsqw_EgrepIvFs='Filesystem|Disponible' | ||
| Line 17: | Line 17: | ||
export gvsqw_TraceJobDb=enable | export gvsqw_TraceJobDb=enable | ||
export gvsqw_UploadLogFile=enable | export gvsqw_UploadLogFile=enable | ||
| + | export gvsqw_TraceBackup=enable | ||
export gvsqw_UploadLogFileMaxLine=200 | export gvsqw_UploadLogFileMaxLine=200 | ||
export gvsqw_SuppLogsHisto=30 | export gvsqw_SuppLogsHisto=30 | ||
| Line 30: | Line 31: | ||
export gvsqw_ScpOptions="-o BatchMode=yes -o StrictHostKeyChecking=no" | export gvsqw_ScpOptions="-o BatchMode=yes -o StrictHostKeyChecking=no" | ||
export gvsqw_DistPasswdFile="$HOME/.passwd_oracle" | export gvsqw_DistPasswdFile="$HOME/.passwd_oracle" | ||
| + | export gvsqw_TnsDbsPath="$HOME/SQWareProduction/oracle/etc_cust" | ||
export gvsqw_CHtmlError='<font color="#FF0000">' | export gvsqw_CHtmlError='<font color="#FF0000">' | ||
export gvsqw_CHtmlOk='<font color="#00FF00">' | export gvsqw_CHtmlOk='<font color="#00FF00">' | ||
| Line 62: | Line 64: | ||
export gvsqw_ExportCompressorExt=gz | export gvsqw_ExportCompressorExt=gz | ||
export gvsqw_ExportNbGeneration=1 | 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_EgrepWar='Warning |Security |Recovery ' | ||
export gvsqw_DefTbsSystem="'SYSTEM','SYS','DBSNMP','OUTLN','WMSYS','ORDSYS','MDSYS','DBSNMP','DIP'" | export gvsqw_DefTbsSystem="'SYSTEM','SYS','DBSNMP','OUTLN','WMSYS','ORDSYS','MDSYS','DBSNMP','DIP'" | ||
| Line 98: | Line 108: | ||
gvsqw_EgrepIvFs => | gvsqw_EgrepIvFs => | ||
gvsqw_EgrepWar => | gvsqw_EgrepWar => | ||
| + | gvsqw_ExpdpCompressorExt => | ||
| + | gvsqw_ExpdpDirectory => | ||
| + | gvsqw_ExpdpNbGeneration => | ||
gvsqw_ExportCompressorExt => | gvsqw_ExportCompressorExt => | ||
gvsqw_ExportNbGeneration => | gvsqw_ExportNbGeneration => | ||
| Line 110: | Line 123: | ||
gvsqw_NbRmanThreadCopyBackups => | gvsqw_NbRmanThreadCopyBackups => | ||
gvsqw_NbThread => | gvsqw_NbThread => | ||
| + | gvsqw_NbThreadExpdp => | ||
gvsqw_ObjTbsSystem => | gvsqw_ObjTbsSystem => | ||
| + | gvsqw_PhysicalColdNbGeneration => | ||
gvsqw_PreFormatHtlml => | gvsqw_PreFormatHtlml => | ||
gvsqw_PrivAny => | gvsqw_PrivAny => | ||
| Line 126: | Line 141: | ||
gvsqw_RootDbf => | gvsqw_RootDbf => | ||
gvsqw_RootDbfSource => | gvsqw_RootDbfSource => | ||
| + | gvsqw_RootExpdp => | ||
gvsqw_RootExp => | gvsqw_RootExp => | ||
gvsqw_RootExpLog => | gvsqw_RootExpLog => | ||
gvsqw_RootExpLogSource => | gvsqw_RootExpLogSource => | ||
gvsqw_RootExpSource => | gvsqw_RootExpSource => | ||
| + | gvsqw_RootPhysicalColdBackup => | ||
| + | gvsqw_RootPhysicalHotBackup => | ||
gvsqw_RootRman => | gvsqw_RootRman => | ||
gvsqw_RootRmanSource => | gvsqw_RootRmanSource => | ||
| Line 152: | Line 170: | ||
gvsqw_THtmlThInter => | gvsqw_THtmlThInter => | ||
gvsqw_TimeOutImmediate => | gvsqw_TimeOutImmediate => | ||
| + | gvsqw_TnsDbsPath => | ||
| + | gvsqw_TraceBackup => | ||
gvsqw_TraceJobDb => | gvsqw_TraceJobDb => | ||
gvsqw_UploadLogFile => | gvsqw_UploadLogFile => | ||
Revision as of 21:53, 12 November 2011
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.02
export gvsqw_ConnectDb=Enable
export gvsqw_DbaUser='/'
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_DbAlias='$ORACLE_SID'
- export gvsqw_DistDbaUser='user/passwd@$ORACLE_SID'
export gvsqw_TimeOutImmediate=600 export gvsqw_Listener='LSN$ORACLE_SID' export gvsqw_WebDbaURL="http://webdba"
- export gvsqw_WebDbaUser='Connection string ssh user@hostname'
- export gvsqw_WebDbaDirAwr='Directory to store AWR reports'
Variable explanation:
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_Listener => gvsqw_MailMsg_oracle => gvsqw_Mail_oracle => 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 =>
