Template:SQWareProduction sqwora GlobalVar.cfg content: Difference between revisions
Jump to navigation
Jump to search
m Updated by Expdbtools |
No edit summary |
||
(58 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
File content: | File content: | ||
<pre> | <pre> | ||
#!/bin/ | #!/bin/bash | ||
################################################################### | ################################################################### | ||
# SQWareProduction for Oracle module of dbSQWare | # SQWareProduction for Oracle module of dbSQWare | ||
# | # | ||
# | # dbSQWare is distributed in the hope that it will be useful, | ||
# but WITHOUT ANY WARRANTY; without even the implied warranty of | # but WITHOUT ANY WARRANTY; without even the implied warranty of | ||
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | ||
# | # CGU/CGA for more details. | ||
# | # | ||
# You should have received a copy of the | # You should have received a copy of the CGU/CGA | ||
# along with this program. If not, see <http://www. | # along with this program. If not, see <http://www.dbsqware.com/licenses/>. | ||
# | # | ||
# For information : contact@dbsqware.com or www.dbsqware.com | # For information : contact@dbsqware.com or www.dbsqware.com | ||
################################################################### | ################################################################### | ||
## @Synopsis Global var | ## @Synopsis Global var for Oracle | ||
## @Copyright Copyright | ## @Copyright Copyright 2007-2025, dbSQWare (www.dbsqware.com) | ||
#global | #global | ||
export | export gvsqw_SqwVersionDbms=2025.06 | ||
export | export gvsqw_ExcludeEvalVar='^gvsqw_ExternalDbaUser=|^gvsqw_AsmDgTable=' | ||
export gvsqw_DbaUser='/ as sysdba' | |||
export | #Put 'True' for this variable for script which accept database not OPEN | ||
#Put | export gvsqw_AcceptNotOpen='False' | ||
#Put gvsqw_DB_UNIQUE_NAME instead of ORACLE_SID for RAC or DG env | |||
export | |||
#Put | |||
export gvsqw_RootAdmin='$HOME/admin/${ORACLE_SID}' | export gvsqw_RootAdmin='$HOME/admin/${ORACLE_SID}' | ||
export gvsqw_RootCfg='$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_RootDbf='/$(echo ${HOME}|cut -d/ -f2)/data/${ORACLE_SID}' | ||
export | export gvsqw_TnsDbsPath="$HOME/SQWareProduction/oracle/etc_cust" | ||
#export gvsqw_OracleWalletStor='$gvsqw_RootAdmin/sqwConfig/MyWalletStor' #change with the good wallet store | |||
export | |||
# | #global 12c multitenant | ||
#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 | #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 | |||
export | |||
export | |||
export | |||
##Globaly forcing return code for scripts | ##Globaly forcing return code for scripts | ||
Line 96: | Line 47: | ||
#for RMAN scripts | #for RMAN scripts | ||
export gvsqw_RootRman='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/rman' | 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_RootRmanSource='/$(eval echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/rman' | ||
export gvsqw_RootDbfSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/data/${lvsqw_InstanceSource}' | 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_RootArch='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/archive' | ||
export gvsqw_NbRmanThreadCopyBackups=4 | export gvsqw_NbRmanThreadCopyBackups=4 | ||
Line 104: | Line 55: | ||
export gvsqw_RmanDefaultRetentionPlolicy='RECOVERY WINDOW OF 6 DAYS' | export gvsqw_RmanDefaultRetentionPlolicy='RECOVERY WINDOW OF 6 DAYS' | ||
export gvsqw_RmanDefaultDeviceType='DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET' | 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' | |||
#for exports and refresh scripts | #for exports and refresh scripts | ||
export gvsqw_RootExp='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/exp' | 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_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_RootExpSource='/$(eval 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_RootExpLogSource='/$(eval echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/backup/${lvsqw_InstanceSource}/exp/log' | ||
export gvsqw_ExportCompressorExt=gz | export gvsqw_ExportCompressorExt=gz | ||
export gvsqw_ExportNbGeneration=1 | export gvsqw_ExportNbGeneration=1 | ||
#for physical backups | |||
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 | |||
#for expdp scripts | |||
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 | |||
#for expdp all PDB | |||
export gvsqw_NbThreadExpdpPDB=2 #For PDB script | |||
export gvsqw_GenExcludeExpdpPdb="" #To exclude PDB to export with PDB and AllSchemas script | |||
export gvsqw_GenExcludeExpdpPdbExtra="" | |||
#for expdp all schema | |||
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') | |||
AND USERNAME NOT LIKE 'APEX_%' | |||
AND USERNAME NOT LIKE '%SYS' | |||
AND USERNAME NOT LIKE 'C##%' | |||
AND USERNAME NOT LIKE 'SYS%'" #To exclude schemas to export with AllSchemas script | |||
export gvsqw_GenExcludeExpdpSchemaExtra="" | |||
#for check instance script | #for check instance script | ||
Line 124: | Line 114: | ||
#for gather indicators | #for gather indicators | ||
export gvsqw_NoASM=Disable #Put Enable to deactivate ASM indicators | |||
export gvsqw_SizeMinSch=10 | export gvsqw_SizeMinSch=10 | ||
export gvsqw_SizeMinSeg=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') | |||
AND OWNER NOT LIKE 'APEX_%' | |||
AND OWNER NOT LIKE '%SYS' | |||
AND OWNER NOT LIKE 'C##%' | |||
AND OWNER NOT LIKE 'SYS%'" | |||
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 | |||
AUTO_STAT_EXTENSIONS | |||
CASCADE | |||
CONCURRENT | |||
DEGREE | |||
ESTIMATE_PERCENT | |||
GLOBAL_TEMP_TABLE_STATS | |||
GRANULARITY | |||
INCREMENTAL | |||
INCREMENTAL_LEVEL | |||
INCREMENTAL_STALENESS | |||
METHOD_OPT | |||
NO_INVALIDATE | |||
OPTIONS | |||
PREFERENCE_OVERRIDES_PARAMETER | |||
PUBLISH | |||
STALE_PERCENT | |||
STAT_CATEGORY | |||
TABLE_CACHED_BLOCKS | |||
AUTOSTATS_TARGET | |||
ROOT_TRIGGER_PDB | |||
COORDINATOR_TRIGGER_SHARD | |||
AUTO_TASK_STATUS | |||
AUTO_TASK_MAX_RUN_TIME | |||
AUTO_TASK_INTERVAL | |||
WAIT_TIME_TO_UPDATE_STATS" | |||
#Remove or replace extra characters like E or e with accent ! | |||
export gvsqw_StringReplaceSch="tr -d '\015'|tr '\311' 'E'|tr '\351' 'e'" | |||
#ASM table to size of DG, set 'v$asm_diskgroup' if you want exact values | |||
export gvsqw_AsmDgTable='v$asm_diskgroup_stat' | |||
#PK for indicators, if ORACLE_SID not unique, put for example | |||
# - gvsqw_DbAlias='$ORACLE_SID:$(hostname|cut -d '.' -f1)' for standalone env | |||
# - gvsqw_DbAlias='$gvsqw_DB_UNIQUE_NAME:$gvsqw_HOST_UNIQUE_NAME' for RAC or DG env | |||
# - ... | |||
export gvsqw_DbAlias='$ORACLE_SID' | |||
#export gvsqw_FsIndicators='fs1,fs2' #Put the list with ',' of FS you when to add to the collect | |||
#Put gvsqw_DistDbaUser for distant connection (indicators, awr, checl) | |||
#export gvsqw_DistDbaUser='user/passwd@$ORACLE_SID' | |||
#for stop/start | #for stop/start | ||
export gvsqw_TimeOutImmediate=600 | export gvsqw_TimeOutImmediate=600 | ||
export gvsqw_Listener='LSN$ORACLE_SID' | |||
#for SQWareWeb | #for SQWareWeb | ||
export | export gvsqw_MonitorTimeAWR='trunc(sysdate-1)' | ||
export gvsqw_MonitorTimeStatspack='trunc(sysdate-1)' | |||
#export gvsqw_WebDbaDirAwr='Directory to store AWR reports' | #export gvsqw_WebDbaDirAwr='Directory to store AWR reports' | ||
#export gvsqw_ChmodReportsFiles='644' | |||
# | #export gvsqw_ChmodReportsDir='755' | ||
# | |||
</pre> | </pre> |
Latest revision as of 18:54, 1 July 2025
File content:
#!/bin/bash ################################################################### # SQWareProduction for Oracle module of dbSQWare # # dbSQWare is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # CGU/CGA for more details. # # You should have received a copy of the CGU/CGA # along with this program. If not, see <http://www.dbsqware.com/licenses/>. # # For information : contact@dbsqware.com or www.dbsqware.com ################################################################### ## @Synopsis Global var for Oracle ## @Copyright Copyright 2007-2025, dbSQWare (www.dbsqware.com) #global export gvsqw_SqwVersionDbms=2025.06 export gvsqw_ExcludeEvalVar='^gvsqw_ExternalDbaUser=|^gvsqw_AsmDgTable=' export gvsqw_DbaUser='/ as sysdba' #Put 'True' for this variable for script which accept database not OPEN export gvsqw_AcceptNotOpen='False' #Put gvsqw_DB_UNIQUE_NAME instead of ORACLE_SID for RAC or DG env 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 #global 12c multitenant #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) ##Globaly forcing return code for scripts #export gvsqw_ForcedReturnCodeScript_sqwora_SchemaRefresh=0 #for RMAN scripts 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' #for exports and refresh scripts 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 #for physical backups 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 #for expdp scripts 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 #for expdp all PDB export gvsqw_NbThreadExpdpPDB=2 #For PDB script export gvsqw_GenExcludeExpdpPdb="" #To exclude PDB to export with PDB and AllSchemas script export gvsqw_GenExcludeExpdpPdbExtra="" #for expdp all schema 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') AND USERNAME NOT LIKE 'APEX_%' AND USERNAME NOT LIKE '%SYS' AND USERNAME NOT LIKE 'C##%' AND USERNAME NOT LIKE 'SYS%'" #To exclude schemas to export with AllSchemas script export gvsqw_GenExcludeExpdpSchemaExtra="" #for check instance script 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'" #for gather indicators 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') AND OWNER NOT LIKE 'APEX_%' AND OWNER NOT LIKE '%SYS' AND OWNER NOT LIKE 'C##%' AND OWNER NOT LIKE 'SYS%'" 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 AUTO_STAT_EXTENSIONS CASCADE CONCURRENT DEGREE ESTIMATE_PERCENT GLOBAL_TEMP_TABLE_STATS GRANULARITY INCREMENTAL INCREMENTAL_LEVEL INCREMENTAL_STALENESS METHOD_OPT NO_INVALIDATE OPTIONS PREFERENCE_OVERRIDES_PARAMETER PUBLISH STALE_PERCENT STAT_CATEGORY TABLE_CACHED_BLOCKS AUTOSTATS_TARGET ROOT_TRIGGER_PDB COORDINATOR_TRIGGER_SHARD AUTO_TASK_STATUS AUTO_TASK_MAX_RUN_TIME AUTO_TASK_INTERVAL WAIT_TIME_TO_UPDATE_STATS" #Remove or replace extra characters like E or e with accent ! export gvsqw_StringReplaceSch="tr -d '\015'|tr '\311' 'E'|tr '\351' 'e'" #ASM table to size of DG, set 'v$asm_diskgroup' if you want exact values export gvsqw_AsmDgTable='v$asm_diskgroup_stat' #PK for indicators, if ORACLE_SID not unique, put for example # - gvsqw_DbAlias='$ORACLE_SID:$(hostname|cut -d '.' -f1)' for standalone env # - gvsqw_DbAlias='$gvsqw_DB_UNIQUE_NAME:$gvsqw_HOST_UNIQUE_NAME' for RAC or DG env # - ... export gvsqw_DbAlias='$ORACLE_SID' #export gvsqw_FsIndicators='fs1,fs2' #Put the list with ',' of FS you when to add to the collect #Put gvsqw_DistDbaUser for distant connection (indicators, awr, checl) #export gvsqw_DistDbaUser='user/passwd@$ORACLE_SID' #for stop/start export gvsqw_TimeOutImmediate=600 export gvsqw_Listener='LSN$ORACLE_SID' #for SQWareWeb 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'