SQWareProduction:oracle:etc:sqwora GlobalVar.cfg : Différence entre versions
m (Updated by BatchUser) (Balise : Remplacé) |
m (Updated by BatchUser) |
||
Ligne 1 : | Ligne 1 : | ||
− | + | Fichier de configuration $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:<br> | |
{{SQWareProduction_sqwora_GlobalVar.cfg_presentation}} | {{SQWareProduction_sqwora_GlobalVar.cfg_presentation}} | ||
− | {{ | + | <br> |
− | {{ | + | <br> |
+ | Contenu du fichier: | ||
+ | <pre> | ||
+ | export gvsqw_SqwVersionDbms=2023.03 | ||
+ | export gvsqw_ExcludeEvalVar='^gvsqw_ExternalDbaUser=|^gvsqw_AsmDgTable=' | ||
+ | export gvsqw_DbaUser='/' | ||
+ | export gvsqw_AcceptNotOpen='False' | ||
+ | export gvsqw_RootAdmin='$HOME/admin/${ORACLE_SID}' | ||
+ | export gvsqw_RootAdminDist='$HOME/admin/oracle/${ORACLE_SID}' | ||
+ | export gvsqw_RootAdminDisable='$HOME' | ||
+ | export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig' | ||
+ | export gvsqw_RootScripts='$HOME/admin/${ORACLE_SID}/scripts' | ||
+ | export gvsqw_RootDbf='/$(echo ${HOME}|cut -d/ -f2)/data/${ORACLE_SID}' | ||
+ | export gvsqw_TnsDbsPath="$HOME/SQWareProduction/oracle/etc_cust" | ||
+ | #export gvsqw_OracleWalletStor='$gvsqw_RootAdmin/sqwConfig/MyWalletStor' #change with the good wallet store | ||
+ | #export gvsqw_PdbDbaUser=user/passwd => for global local pdb connection | ||
+ | #export gvsqw_PdbPasswdFile=passfile => file parameter for local pdb connection (pdb_name;user;passwd or DEFAULT;user;passwd) | ||
+ | #export gvsqw_SqlPlusMoreOpt='-R 3' | ||
+ | #export gvsqw_PdbDbaUser_Source=user/passwd => for global source pdb connection | ||
+ | #export gvsqw_PdbPasswdFile_Source=passfile => file parameter for source (refresh for example) pdb connection (pdb_name;user;passwd or DEFAULT;user;passwd) | ||
+ | #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_RmanDeleteRetentionPolicy='RECOVERY WINDOW OF 6 DAYS' | ||
+ | export gvsqw_RsyncDefaultSourceDir='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/rman' | ||
+ | export gvsqw_RmanForceCumulative=disable | ||
+ | export gvsqw_RmanZdlra=Disable | ||
+ | export gvsqw_RmanCatalogStatus="'COMPLETED','COMPLETED WITH WARNINGS'" | ||
+ | export gvsqw_RmanCatalogNbDays=2 | ||
+ | export gvsqw_RmanMkdirOption='-p' | ||
+ | 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_RootExpdpSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/expdp' | ||
+ | export gvsqw_ExpdpDirectory='dbsqware_datapump' | ||
+ | export gvsqw_ExcludeErrorRefreshDrop='^ORA-04043: ' | ||
+ | export gvsqw_ExcludeErrorRefreshImp='^ORA-31684: |^ORA-39082: ' | ||
+ | export gvsqw_ExpdpCompressorExt=none | ||
+ | export gvsqw_ExpdpNbDropAttempts=3 | ||
+ | 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_ParallelQuery='/*+ PARALLEL(6) */' #for query table size on DBA_SEGMENTS | ||
+ | #export gvsqw_GenExcludeSchemasObjects="and OWNER not in ('ANONYMOUS','APEX_050000','APEX_PUBLIC_USER','APPQOSSYS','AUDSYS','CTXSYS','DBSFWUSER','DBMS_SFW_ACL_ADMIN','DBSNMP','DIP','DVSYS','DVF','FLOWS_FILES','GGSYS','GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','HR','LBACSYS','MDDATA','MDSYS','ORDPLUGINS','ORDSYS','ORDDATA','PUBLIC','OUTLN','ORACLE_OCM','REMOTE_SCHEDULER_AGENT','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','SYSTEM','SYSBACKUP','SYS','SYSKM','SYSDG','SYSRAC','SYS$UMF','SYS$NULL','WMSYS','XDB')" | ||
+ | export gvsqw_GenExcludeSchemasObjects="OWNER not in ('PERFSTAT','DATAHUB_OWNER','ANONYMOUS','DBSFWUSER','DBMS_SFW_ACL_ADMIN','DBSNMP','DIP','DVF','FLOWS_FILES','GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','HR','MDDATA','ORDPLUGINS','ORDDATA','PUBLIC','OUTLN','ORACLE_OCM','REMOTE_SCHEDULER_AGENT','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','SYS','XDB') | ||
+ | export gvsqw_GenExcludeSchemasObjectsExtra="" | ||
+ | export gvsqw_DbmsStatsParams="APPROXIMATE_NDV_ALGORITHM | ||
+ | export gvsqw_StringReplaceSch="tr -d '\015'|tr '\311' 'E'|tr '\351' 'e'" | ||
+ | export gvsqw_AsmDgTable='v$asm_diskgroup_stat' | ||
+ | export gvsqw_DbAlias='$ORACLE_SID' | ||
+ | #export gvsqw_FsIndicators='fs1,fs2' #Put the list with ',' of FS you when to add to the collect | ||
+ | #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_MonitorTimeStatspack='trunc(sysdate-1)' | ||
+ | #export gvsqw_WebDbaDirAwr='Directory to store AWR reports' | ||
+ | #export gvsqw_ChmodReportsFiles='644' | ||
+ | #export gvsqw_ChmodReportsDir='755' | ||
+ | </pre> | ||
+ | <br> | ||
+ | <br> | ||
+ | Explication des variables: | ||
+ | <pre> | ||
+ | gvsqw_AcceptNotOpen => | ||
+ | gvsqw_AsmDgTable => | ||
+ | #gvsqw_ChmodReportsDir => | ||
+ | #gvsqw_ChmodReportsFiles => | ||
+ | gvsqw_DbAlias => | ||
+ | gvsqw_DbaUser => | ||
+ | gvsqw_DbmsStatsParams => | ||
+ | gvsqw_DefTbsSystem => | ||
+ | #gvsqw_DistDbaUser => | ||
+ | gvsqw_EgrepWar => | ||
+ | gvsqw_ExcludeErrorRefreshDrop => | ||
+ | gvsqw_ExcludeErrorRefreshImp => | ||
+ | gvsqw_ExcludeEvalVar => | ||
+ | gvsqw_ExpdpCompressorExt => | ||
+ | gvsqw_ExpdpDirectory => | ||
+ | gvsqw_ExpdpNbDropAttempts => | ||
+ | gvsqw_ExpdpNbGeneration => | ||
+ | gvsqw_ExportCompressorExt => | ||
+ | gvsqw_ExportNbGeneration => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwora_SchemaRefresh => | ||
+ | #gvsqw_FsIndicators => | ||
+ | #gvsqw_GenExcludeSchemasObjects => | ||
+ | gvsqw_GenExcludeSchemasObjectsExtra => | ||
+ | gvsqw_GenExcludeSchemasObjects => | ||
+ | gvsqw_GrantsSysPublic => | ||
+ | gvsqw_Listener => | ||
+ | gvsqw_MonitorTimeAWR => | ||
+ | gvsqw_MonitorTimeStatspack => | ||
+ | gvsqw_NbRmanThreadCopyBackups => | ||
+ | gvsqw_NbThreadExpdp => | ||
+ | gvsqw_ObjTbsSystem => | ||
+ | #gvsqw_OracleWalletStor => | ||
+ | gvsqw_ParallelQuery => | ||
+ | #gvsqw_PdbDbaUser_Source => | ||
+ | #gvsqw_PdbDbaUser => | ||
+ | #gvsqw_PdbPasswdFile => | ||
+ | #gvsqw_PdbPasswdFile_Source => | ||
+ | gvsqw_PhysicalColdNbGeneration => | ||
+ | gvsqw_PrivAny => | ||
+ | gvsqw_PrivSystem => | ||
+ | gvsqw_RmanCatalogNbDays => | ||
+ | gvsqw_RmanCatalogStatus => | ||
+ | gvsqw_RmanDefaultDeviceType => | ||
+ | gvsqw_RmanDefaultRetentionPlolicy => | ||
+ | gvsqw_RmanDeleteRetentionPolicy => | ||
+ | gvsqw_RmanForceCatConnectBck => | ||
+ | gvsqw_RmanForceCumulative => | ||
+ | gvsqw_RmanMkdirOption => | ||
+ | gvsqw_RmanWaitTimeOut => | ||
+ | gvsqw_RmanZdlra => | ||
+ | gvsqw_RoleAdmin => | ||
+ | gvsqw_RoleTooStrong => | ||
+ | gvsqw_RootAdmin => | ||
+ | gvsqw_RootAdminDisable => | ||
+ | gvsqw_RootAdminDist => | ||
+ | gvsqw_RootArch => | ||
+ | gvsqw_RootCfg => | ||
+ | gvsqw_RootDbf => | ||
+ | gvsqw_RootDbfSource => | ||
+ | gvsqw_RootExp => | ||
+ | gvsqw_RootExpdp => | ||
+ | gvsqw_RootExpdpSource => | ||
+ | gvsqw_RootExpLog => | ||
+ | gvsqw_RootExpLogSource => | ||
+ | gvsqw_RootExpSource => | ||
+ | gvsqw_RootPhysicalColdBackup => | ||
+ | gvsqw_RootPhysicalHotBackup => | ||
+ | gvsqw_RootRman => | ||
+ | gvsqw_RootRmanSource => | ||
+ | gvsqw_RootScripts => | ||
+ | gvsqw_RsyncDefaultSourceDir => | ||
+ | gvsqw_SizeMinSch => | ||
+ | gvsqw_SizeMinSeg => | ||
+ | #gvsqw_SqlPlusMoreOpt => | ||
+ | gvsqw_SqwVersionDbms => | ||
+ | gvsqw_StringReplaceSch => | ||
+ | gvsqw_TimeOutImmediate => | ||
+ | gvsqw_TnsDbsPath => | ||
+ | #gvsqw_WebDbaDirAwr => | ||
+ | </pre> | ||
{{SQWareProductionSurchargeVar|oracle|Ora|sqwora_GlobalVar.cfg}} | {{SQWareProductionSurchargeVar|oracle|Ora|sqwora_GlobalVar.cfg}} | ||
<br> | <br> |
Version du 11 février 2023 à 09:29
Fichier de configuration $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:
Global var for Oracle
Contient les variables operationnelles de SQWareProduction.
Contenu du fichier:
export gvsqw_SqwVersionDbms=2023.03 export gvsqw_ExcludeEvalVar='^gvsqw_ExternalDbaUser=|^gvsqw_AsmDgTable=' export gvsqw_DbaUser='/' export gvsqw_AcceptNotOpen='False' export gvsqw_RootAdmin='$HOME/admin/${ORACLE_SID}' export gvsqw_RootAdminDist='$HOME/admin/oracle/${ORACLE_SID}' export gvsqw_RootAdminDisable='$HOME' export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig' export gvsqw_RootScripts='$HOME/admin/${ORACLE_SID}/scripts' export gvsqw_RootDbf='/$(echo ${HOME}|cut -d/ -f2)/data/${ORACLE_SID}' export gvsqw_TnsDbsPath="$HOME/SQWareProduction/oracle/etc_cust" #export gvsqw_OracleWalletStor='$gvsqw_RootAdmin/sqwConfig/MyWalletStor' #change with the good wallet store #export gvsqw_PdbDbaUser=user/passwd => for global local pdb connection #export gvsqw_PdbPasswdFile=passfile => file parameter for local pdb connection (pdb_name;user;passwd or DEFAULT;user;passwd) #export gvsqw_SqlPlusMoreOpt='-R 3' #export gvsqw_PdbDbaUser_Source=user/passwd => for global source pdb connection #export gvsqw_PdbPasswdFile_Source=passfile => file parameter for source (refresh for example) pdb connection (pdb_name;user;passwd or DEFAULT;user;passwd) #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_RmanDeleteRetentionPolicy='RECOVERY WINDOW OF 6 DAYS' export gvsqw_RsyncDefaultSourceDir='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/rman' export gvsqw_RmanForceCumulative=disable export gvsqw_RmanZdlra=Disable export gvsqw_RmanCatalogStatus="'COMPLETED','COMPLETED WITH WARNINGS'" export gvsqw_RmanCatalogNbDays=2 export gvsqw_RmanMkdirOption='-p' 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_RootExpdpSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/expdp' export gvsqw_ExpdpDirectory='dbsqware_datapump' export gvsqw_ExcludeErrorRefreshDrop='^ORA-04043: ' export gvsqw_ExcludeErrorRefreshImp='^ORA-31684: |^ORA-39082: ' export gvsqw_ExpdpCompressorExt=none export gvsqw_ExpdpNbDropAttempts=3 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_ParallelQuery='/*+ PARALLEL(6) */' #for query table size on DBA_SEGMENTS #export gvsqw_GenExcludeSchemasObjects="and OWNER not in ('ANONYMOUS','APEX_050000','APEX_PUBLIC_USER','APPQOSSYS','AUDSYS','CTXSYS','DBSFWUSER','DBMS_SFW_ACL_ADMIN','DBSNMP','DIP','DVSYS','DVF','FLOWS_FILES','GGSYS','GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','HR','LBACSYS','MDDATA','MDSYS','ORDPLUGINS','ORDSYS','ORDDATA','PUBLIC','OUTLN','ORACLE_OCM','REMOTE_SCHEDULER_AGENT','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','SYSTEM','SYSBACKUP','SYS','SYSKM','SYSDG','SYSRAC','SYS$UMF','SYS$NULL','WMSYS','XDB')" export gvsqw_GenExcludeSchemasObjects="OWNER not in ('PERFSTAT','DATAHUB_OWNER','ANONYMOUS','DBSFWUSER','DBMS_SFW_ACL_ADMIN','DBSNMP','DIP','DVF','FLOWS_FILES','GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','HR','MDDATA','ORDPLUGINS','ORDDATA','PUBLIC','OUTLN','ORACLE_OCM','REMOTE_SCHEDULER_AGENT','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','SYS','XDB') export gvsqw_GenExcludeSchemasObjectsExtra="" export gvsqw_DbmsStatsParams="APPROXIMATE_NDV_ALGORITHM export gvsqw_StringReplaceSch="tr -d '\015'|tr '\311' 'E'|tr '\351' 'e'" export gvsqw_AsmDgTable='v$asm_diskgroup_stat' export gvsqw_DbAlias='$ORACLE_SID' #export gvsqw_FsIndicators='fs1,fs2' #Put the list with ',' of FS you when to add to the collect #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_MonitorTimeStatspack='trunc(sysdate-1)' #export gvsqw_WebDbaDirAwr='Directory to store AWR reports' #export gvsqw_ChmodReportsFiles='644' #export gvsqw_ChmodReportsDir='755'
Explication des variables:
gvsqw_AcceptNotOpen => gvsqw_AsmDgTable => #gvsqw_ChmodReportsDir => #gvsqw_ChmodReportsFiles => gvsqw_DbAlias => gvsqw_DbaUser => gvsqw_DbmsStatsParams => gvsqw_DefTbsSystem => #gvsqw_DistDbaUser => gvsqw_EgrepWar => gvsqw_ExcludeErrorRefreshDrop => gvsqw_ExcludeErrorRefreshImp => gvsqw_ExcludeEvalVar => gvsqw_ExpdpCompressorExt => gvsqw_ExpdpDirectory => gvsqw_ExpdpNbDropAttempts => gvsqw_ExpdpNbGeneration => gvsqw_ExportCompressorExt => gvsqw_ExportNbGeneration => #gvsqw_ForcedReturnCodeScript_sqwora_SchemaRefresh => #gvsqw_FsIndicators => #gvsqw_GenExcludeSchemasObjects => gvsqw_GenExcludeSchemasObjectsExtra => gvsqw_GenExcludeSchemasObjects => gvsqw_GrantsSysPublic => gvsqw_Listener => gvsqw_MonitorTimeAWR => gvsqw_MonitorTimeStatspack => gvsqw_NbRmanThreadCopyBackups => gvsqw_NbThreadExpdp => gvsqw_ObjTbsSystem => #gvsqw_OracleWalletStor => gvsqw_ParallelQuery => #gvsqw_PdbDbaUser_Source => #gvsqw_PdbDbaUser => #gvsqw_PdbPasswdFile => #gvsqw_PdbPasswdFile_Source => gvsqw_PhysicalColdNbGeneration => gvsqw_PrivAny => gvsqw_PrivSystem => gvsqw_RmanCatalogNbDays => gvsqw_RmanCatalogStatus => gvsqw_RmanDefaultDeviceType => gvsqw_RmanDefaultRetentionPlolicy => gvsqw_RmanDeleteRetentionPolicy => gvsqw_RmanForceCatConnectBck => gvsqw_RmanForceCumulative => gvsqw_RmanMkdirOption => gvsqw_RmanWaitTimeOut => gvsqw_RmanZdlra => gvsqw_RoleAdmin => gvsqw_RoleTooStrong => gvsqw_RootAdmin => gvsqw_RootAdminDisable => gvsqw_RootAdminDist => gvsqw_RootArch => gvsqw_RootCfg => gvsqw_RootDbf => gvsqw_RootDbfSource => gvsqw_RootExp => gvsqw_RootExpdp => gvsqw_RootExpdpSource => gvsqw_RootExpLog => gvsqw_RootExpLogSource => gvsqw_RootExpSource => gvsqw_RootPhysicalColdBackup => gvsqw_RootPhysicalHotBackup => gvsqw_RootRman => gvsqw_RootRmanSource => gvsqw_RootScripts => gvsqw_RsyncDefaultSourceDir => gvsqw_SizeMinSch => gvsqw_SizeMinSeg => #gvsqw_SqlPlusMoreOpt => gvsqw_SqwVersionDbms => gvsqw_StringReplaceSch => gvsqw_TimeOutImmediate => gvsqw_TnsDbsPath => #gvsqw_WebDbaDirAwr =>