SQWareProduction:oracle:etc:sqwora GlobalVar.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:
Global var for Oracle
It contains the operating variables of SQWareProduction.
File content:
export gvsqw_SqwVersionDbms=2025.10
export gvsqw_ExcludeEvalVar='^gvsqw_ExternalDbaUser=|^gvsqw_AsmDgTable='
export gvsqw_DbaUser='/ as sysdba'
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=$HOME/.passwd_oracle_pdb #file parameter for local pdb connection (DEFAULT;pdb_name;user;passwd or DEFAULT;DEFAULT;user;passwd)
#export gvsqw_SqlPlusMoreOpt='-R 3'
#export gvsqw_PdbDbaUser_Source=user/passwd => for global source pdb connection
export gvsqw_PdbPasswdFile_Source=$HOME/.passwd_oracle_pdb #=> file parameter for source (refresh for example) pdb connection (DEFAULT;pdb_name;user;passwd or DEFAULT;DEFAULT;user;passwd)
#export gvsqw_ForcedReturnCodeScript_sqwora_SchemaRefresh=0
export gvsqw_RootRman='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/rman'
export gvsqw_RootRmanSource='/$(eval echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/rman'
export gvsqw_RootDbfSource='/$(eval 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='/$(eval echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/exp'
export gvsqw_RootExpLogSource='/$(eval 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='/$(eval 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='/$(eval 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_NbThreadExpdpPDB=2 #For PDB script
export gvsqw_GenExcludeExpdpPdb="" #To exclude PDB to export with PDB and AllSchemas script
export gvsqw_GenExcludeExpdpPdbExtra=""
export gvsqw_NbThreadExpdpSchema=2 #For AllSchema script
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_NoASM=Disable #Put Enable to deactivate ASM indicators
export gvsqw_SizeMinSch=10
export gvsqw_SizeMinSeg=10
export gvsqw_AuditLogonNbDaysSelect=2
export gvsqw_AuditLogonNbDaysDelete=7
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_CommandPathVersionList="$gvsqw_CommandPathVersionList sqlplus;-V"
export gvsqw_CommandPathVersionListExtra=""
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_AuditLogonNbDaysDelete => gvsqw_AuditLogonNbDaysSelect => #gvsqw_ChmodReportsDir => #gvsqw_ChmodReportsFiles => gvsqw_CommandPathVersionList => gvsqw_CommandPathVersionListExtra => 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_NbThreadExpdpPDB => gvsqw_NbThreadExpdpSchema => gvsqw_NoASM => 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 =>
