SQWareProduction:oracle:etc:sqwora GlobalVar.cfg

From Wiki_dbSQWare
Revision as of 20:36, 14 July 2010 by Exploit (talk | contribs) (Updated by Expdbtools)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Fichier de configuration $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:
Global var
Il contient les variables de fonctionnement de SQWareProduction.

gvsqw_ConnectDb =>  [par défaut: Enable
gvsqw_DefTbsSystem =>  [par défaut: "'SYSTEM','SYS','DBSNMP','OUTLN','WMSYS','ORDSYS','MDSYS','DBSNMP','DIP'"
gvsqw_EgrepIvFs =>  [par défaut: 'Filesystem|Disponible'
gvsqw_EgrepWar =>  [par défaut: 'Warning |Security |Recovery '
gvsqw_ExportCompressorExt =>  [par défaut: gz
gvsqw_ExportNbGeneration =>  [par défaut: 1
gvsqw_GrantsSysPublic =>  [par défaut: "'UTL_TCP','UTL_FILE','UTL_HTTP','UTL_SMTP','DBMS_LOB','DBMS_SQL','DBMS_SCHEDULER','OWA_UTIL'"
gvsqw_GzipLogsHisto =>  [par défaut: 7
gvsqw_Hostname =>  [par défaut: $(hostname|cut -d '.' -f1)
gvsqw_MailMsg_oracle =>  [par défaut: 'TrtOraAuto'
gvsqw_Mail_oracle =>  [par défaut: 'dba'
gvsqw_NbDaysFull =>  [par défaut: 7

gvsqw_NbDaysInc => [par défaut: 2 gvsqw_NbDaysInc => [par défaut: 3

gvsqw_NbRmanThreadCopyBackups =>  [par défaut: 4
gvsqw_NbThread =>  [par défaut: 2
gvsqw_ObjTbsSystem =>  [par défaut: "'SYS', 'SYSTEM','OUTLN','WMSYS','ORDSYS','MDSYS','DBSNMP','DIP'"
gvsqw_PrivAny =>  [par défaut: "'DBA','SYS','SYSTEM','ORACLE','IMP_FULL_DATABASE','EXP_FULL_DATABASE','WMSYS','OUTLN','AQ_ADMINISTRATOR_ROLE','OEM_MONITOR', 'DATAPUMP_IMP_FULL_DATABASE', 'SCHEDULER_ADMIN'"
gvsqw_PrivSystem =>  [par défaut: "'DBA','SYS','SYSTEM','ORACLE','DBSNMP','IMP_FULL_DATABASE','WMSYS','OUTLN','DATAPUMP_IMP_FULL_DATABASE','SCHEDULER_ADMIN', 'LOGSTDBY_ADMINISTRATOR'"
gvsqw_RmanDefaultDeviceType =>  [par défaut: 'DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET'
gvsqw_RmanDefaultRetentionPlolicy =>  [par défaut: 'RECOVERY WINDOW OF 6 DAYS'
gvsqw_RmanForceCatConnectBck =>  [par défaut: disable
gvsqw_RmanWaitTimeOut =>  [par défaut: 600
gvsqw_RoleAdmin =>  [par défaut: "'DBA','SYS','SYSTEM','SYSMAN','DATAPUMP_IMP_FULL_DATABASE'"
gvsqw_RoleTooStrong =>  [par défaut: "'DBA','SYS', 'SYSTEM', 'SYSMAN', 'DATAPUMP_IMP_FULL_DATABASE','OUTLN','LOGSTDBY_ADMINISTRATOR'"
gvsqw_RootAdmin =>  [par défaut: '$HOME/admin/${ORACLE_SID}'
gvsqw_RootArch =>  [par défaut: '/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/archive'
gvsqw_RootCfg =>  [par défaut: '$HOME/admin/${ORACLE_SID}/edtConfig'
gvsqw_RootDbf =>  [par défaut: '/$(echo ${HOME}|cut -d/ -f2)/data/${ORACLE_SID}'
gvsqw_RootExp =>  [par défaut: '/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/exp'
gvsqw_RootExpLog =>  [par défaut: '/$(echo $HOME|cut -d/ -f2)/backup/${ORACLE_SID}/exp/log'
gvsqw_RootExpLogSource =>  [par défaut: '/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/exp/log'
gvsqw_RootExpSource =>  [par défaut: '/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/exp'
gvsqw_RootRman =>  [par défaut: '/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/rman'
gvsqw_RootRmanSource =>  [par défaut: '/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/rman'
gvsqw_SizeMinSch =>  [par défaut: 10
gvsqw_SizeMinSeg =>  [par défaut: 10
gvsqw_SuppArchAlert =>  [par défaut: 30
gvsqw_SuppBckCfg =>  [par défaut: 30
gvsqw_SuppLogsHisto =>  [par défaut: 30
  1. gvsqw_WebDbaDirAwr => [par défaut: 'Directory to store AWR reports'
  2. gvsqw_WebDbaUserConn => [par défaut: 'Connection string ssh user@hostname'

[ -r $gvsqw_OraBin/../etc_cust/sqwora_GlobalVar.cfg ] && . $gvsqw_OraBin/../etc_cust/sqwora_GlobalVar.cfg [ -r $gvsqw_RootCfg/sqwora_GlobalVar.cfg ] && . $gvsqw_RootCfg/sqwora_GlobalVar.cfg

Nuvola apps information.png
Note:
You can overload variables contain in $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg

by the same variables in $gvsqw_OraBin/../etc_cust/sqwora_GlobalVar.cfg for all your environnement
or in $HOME/sqwConfig/sqwora_GlobalVar.cfg specifically for this user.