SQWareProduction:oracle:etc:sqwora GlobalVar.cfg: Difference between revisions
m Updated by BatchUser |
m Updated by BatchUser |
||
Line 1: | Line 1: | ||
Configuration file $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:<br> | Configuration file $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:<br> | ||
{{SQWareProduction_sqwora_GlobalVar.cfg_presentation}} | {{SQWareProduction_sqwora_GlobalVar.cfg_presentation}} | ||
{{ | <br> | ||
{{ | <br> | ||
File content: | |||
<pre> | |||
export gvsqw_EdtVersion=2.0.b2 | |||
export gvsqw_ConnectDb=Enable | |||
export gvsqw_DbaUser='/' | |||
export gvsqw_Hostname=$(hostname|cut -d '.' -f1) | |||
export gvsqw_MailMsg_oracle='TrtOraAuto' | |||
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_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_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="</pre>" | |||
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_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' | |||
</pre> | |||
<br> | |||
<br> | |||
Variable explanation: | |||
<pre> | |||
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_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_ObjTbsSystem => | |||
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_RootExp => | |||
gvsqw_RootExpLog => | |||
gvsqw_RootExpLogSource => | |||
gvsqw_RootExpSource => | |||
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_TraceJobDb => | |||
gvsqw_UploadLogFile => | |||
gvsqw_UploadLogFileMaxLine => | |||
#gvsqw_WebDbaDirAwr => | |||
gvsqw_WebDbaURL => | |||
#gvsqw_WebDbaUser => | |||
</pre> | |||
{{SQWareProductionSurchargeVar|oracle|Ora|sqwora_GlobalVar.cfg}} | {{SQWareProductionSurchargeVar|oracle|Ora|sqwora_GlobalVar.cfg}} | ||
<br> | <br> |
Revision as of 22:43, 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.b2 export gvsqw_ConnectDb=Enable export gvsqw_DbaUser='/' export gvsqw_Hostname=$(hostname|cut -d '.' -f1) export gvsqw_MailMsg_oracle='TrtOraAuto' 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_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_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_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_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_ObjTbsSystem => 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_RootExp => gvsqw_RootExpLog => gvsqw_RootExpLogSource => gvsqw_RootExpSource => 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_TraceJobDb => gvsqw_UploadLogFile => gvsqw_UploadLogFileMaxLine => #gvsqw_WebDbaDirAwr => gvsqw_WebDbaURL => #gvsqw_WebDbaUser =>