Difference between revisions of "SQWareProduction:oracle:etc:sqwora GlobalVar.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
(Tag: Replaced)
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}}
−
{{SQWareProduction_sqwora_GlobalVar.cfg_content}}
+
<br>
−
{{SQWareProduction_sqwora_GlobalVar.cfg_explanation}}
+
<br>
 +
File content:
 +
<pre>
 +
export gvsqw_SqwVersionDbms=2023.08
 +
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_RootExpdpPdb='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/expdp/$lvsqw_PdbName'
 +
export gvsqw_RootExpdpPdbSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/expdp/$lvsqw_PdbName_Source'
 +
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_NbThreadExpdpSchema=2 #For AllSchema script
 +
export gvsqw_GenExcludeExpdpPdb="" #To exclude PDB to export with AllSchemas script
 +
export gvsqw_GenExcludeExpdpPdbExtra=""
 +
export gvsqw_GenExcludeExpdpSchema="USERNAME 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_GenExcludeExpdpSchemaExtra=""
 +
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_PathList="HOME;gvsqw_RootAdmin;gvsqw_RootCfg;gvsqw_RootExpdp;gvsqw_RootExp;gvsqw_RootRman"
 +
export gvsqw_PathListExtra=""
 +
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>
 +
Variables explanation:
 +
<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_GenExcludeExpdpPdbExtra =>
 +
gvsqw_GenExcludeExpdpPdb =>
 +
gvsqw_GenExcludeExpdpSchemaExtra =>
 +
gvsqw_GenExcludeExpdpSchema =>
 +
#gvsqw_GenExcludeSchemasObjects =>
 +
gvsqw_GenExcludeSchemasObjectsExtra =>
 +
gvsqw_GenExcludeSchemasObjects =>
 +
gvsqw_GrantsSysPublic =>
 +
gvsqw_Listener =>
 +
gvsqw_MonitorTimeAWR =>
 +
gvsqw_MonitorTimeStatspack =>
 +
gvsqw_NbRmanThreadCopyBackups =>
 +
gvsqw_NbThreadExpdp =>
 +
gvsqw_NbThreadExpdpSchema =>
 +
gvsqw_ObjTbsSystem =>
 +
#gvsqw_OracleWalletStor =>
 +
gvsqw_ParallelQuery =>
 +
gvsqw_PathListExtra =>
 +
gvsqw_PathList =>
 +
#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_RootExpdpPdb =>
 +
gvsqw_RootExpdpPdbSource =>
 +
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>

Revision as of 16:57, 6 November 2023

Configuration file $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:
Global var for Oracle
It contains the operating variables of SQWareProduction.


File content: 

export gvsqw_SqwVersionDbms=2023.08
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_RootExpdpPdb='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/expdp/$lvsqw_PdbName'
export gvsqw_RootExpdpPdbSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/expdp/$lvsqw_PdbName_Source'
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_NbThreadExpdpSchema=2 #For AllSchema script
export gvsqw_GenExcludeExpdpPdb="" #To exclude PDB to export with AllSchemas script
export gvsqw_GenExcludeExpdpPdbExtra=""
export gvsqw_GenExcludeExpdpSchema="USERNAME 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_GenExcludeExpdpSchemaExtra=""
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_PathList="HOME;gvsqw_RootAdmin;gvsqw_RootCfg;gvsqw_RootExpdp;gvsqw_RootExp;gvsqw_RootRman"
export gvsqw_PathListExtra=""
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'



Variables explanation: 

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_GenExcludeExpdpPdbExtra => 
gvsqw_GenExcludeExpdpPdb => 
gvsqw_GenExcludeExpdpSchemaExtra => 
gvsqw_GenExcludeExpdpSchema => 
#gvsqw_GenExcludeSchemasObjects => 
gvsqw_GenExcludeSchemasObjectsExtra => 
gvsqw_GenExcludeSchemasObjects => 
gvsqw_GrantsSysPublic => 
gvsqw_Listener => 
gvsqw_MonitorTimeAWR => 
gvsqw_MonitorTimeStatspack => 
gvsqw_NbRmanThreadCopyBackups => 
gvsqw_NbThreadExpdp => 
gvsqw_NbThreadExpdpSchema => 
gvsqw_ObjTbsSystem => 
#gvsqw_OracleWalletStor => 
gvsqw_ParallelQuery => 
gvsqw_PathListExtra => 
gvsqw_PathList => 
#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_RootExpdpPdb => 
gvsqw_RootExpdpPdbSource => 
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 =>
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.


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:oracle:etc:sqwora_GlobalVar.cfg&oldid=25140"