Difference between revisions of "Template:SQWareProduction sqwora GlobalVar.cfg content"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
(37 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
#!/bin/ksh
 
#!/bin/ksh
 
###################################################################
 
###################################################################
−
# SQWareProduction for Oracle module of dbSQWare is developped with GPL License 3.0 :
+
# SQWareProduction for Oracle module of dbSQWare
−
#
 
−
# This program is free software: you can redistribute it and/or modify
 
−
# it under the terms of the GNU General Public License as published by
 
−
# the Free Software Foundation, either version 3 of the License, or
 
−
# (at your option) any later version.
 
 
#  
 
#  
 
# dbSQWare is distributed in the hope that it will be useful,
 
# 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
−
# GNU General Public License for more details.
+
# CGU/CGA for more details.
 
#  
 
#  
−
# You should have received a copy of the GNU General Public License
+
# You should have received a copy of the CGU/CGA
−
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
# 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 2010-2012, OctopusDBA
+
## @Copyright Copyright 2010-2024, dbSQWare (www.dbsqware.com)
−
## @License GPL v3
 
−
## SVN : $URL$
 
−
## SVN : $Id$
 
  
 
#global
 
#global
−
export gvsqw_EdtVersion=2.0.08
+
export gvsqw_SqwVersionDbms=2024.01
−
export gvsqw_ConnectDb=Enable
+
export gvsqw_ExcludeEvalVar='^gvsqw_ExternalDbaUser=|^gvsqw_AsmDgTable='
 
export gvsqw_DbaUser='/'
 
export gvsqw_DbaUser='/'
 
#Put 'True' for this variable for script which accept database not OPEN
 
#Put 'True' for this variable for script which accept database not OPEN
 
export gvsqw_AcceptNotOpen='False'
 
export gvsqw_AcceptNotOpen='False'
−
export gvsqw_Hostname=$(hostname|cut -d '.' -f1)
 
−
export gvsqw_MailMsg_oracle="TrtOraAuto$gvsqw_Env"
 
−
#Put NoNail in gvsqw_Mail_oracle if you don't want to send mail on error
 
−
export gvsqw_Mail_oracle='default@dbsqware.com'
 
−
export gvsqw_EgrepIvFs='Filesystem|Disponible'
 
−
#Put disable in gvsqw_SendmailHtmlFormat if you don't want to send mail in html format
 
−
export gvsqw_SendmailHtmlFormat=enable
 
−
export gvsqw_PreFormatHtlml=enable
 
−
#Put disable in gvsqw_Colors if you don't want to print in color
 
−
export gvsqw_Colors=enable
 
−
#Put disable in gvsqw_TraceJobDb if you don't want to trace job execution in SQWareRepository
 
−
export gvsqw_TraceJobDb=enable
 
−
#Put disable in gvsqw_UploadLogFile if you don't want to upload log of job execution in SQWareRepository
 
−
export gvsqw_UploadLogFile=enable
 
−
#Put disable in gvsqw_TraceBackup if you don't want to backup execution in SQWareRepository
 
−
export gvsqw_TraceBackup=enable
 
−
export gvsqw_UploadLogFileMaxLine=200
 
−
export gvsqw_SuppLogsHisto=30
 
−
export gvsqw_GzipLogsHisto=7
 
−
export gvsqw_SuppBckCfg=30
 
−
export gvsqw_SuppArchAlert=30
 
 
#Put gvsqw_DB_UNIQUE_NAME instead of ORACLE_SID for RAC or DG env
 
#Put gvsqw_DB_UNIQUE_NAME instead of ORACLE_SID for RAC or DG env
 
export gvsqw_RootAdmin='$HOME/admin/${ORACLE_SID}'
 
export gvsqw_RootAdmin='$HOME/admin/${ORACLE_SID}'
 
export gvsqw_RootAdminDist='$HOME/admin/oracle/${ORACLE_SID}'
 
export gvsqw_RootAdminDist='$HOME/admin/oracle/${ORACLE_SID}'
−
export gvsqw_RootCfg='$gvsqw_RootAdmin/edtConfig'
+
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 gvsqw_NbThread=2
 
−
export gvsqw_SshOptions="-q -o BatchMode=yes -o StrictHostKeyChecking=no"
 
−
export gvsqw_ScpOptions="-o BatchMode=yes -o StrictHostKeyChecking=no"
 
−
export gvsqw_DistPasswdFile="$HOME/.passwd_oracle"
 
 
export gvsqw_TnsDbsPath="$HOME/SQWareProduction/oracle/etc_cust"
 
export gvsqw_TnsDbsPath="$HOME/SQWareProduction/oracle/etc_cust"
 +
#export gvsqw_OracleWalletStor='$gvsqw_RootAdmin/sqwConfig/MyWalletStor' #change with the good wallet store
  
−
#Html tags
+
#global 12c multitenant
−
export gvsqw_CHtmlError='<font color="#FF0000">'
+
#export gvsqw_PdbDbaUser=user/passwd => for global local pdb connection
−
export gvsqw_CHtmlOk='<font color="#00FF00">'
+
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_CHtmlInfo='<font color="#0000FF">'
+
#export gvsqw_SqlPlusMoreOpt='-R 3'
−
export gvsqw_CHtmlEnd='</font>'
+
#export gvsqw_PdbDbaUser_Source=user/passwd => for global source pdb connection
−
export gvsqw_THtmlBegin='<table  class="edt">'
+
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_THtmlEnd='</table>'
 
−
export gvsqw_THtmlThBegin='<tr class="edtth"><th>'
 
−
export gvsqw_THtmlThEnd='</th></tr>'
 
−
export gvsqw_THtmlThInter='</th><th>'
 
−
export gvsqw_THtmlTdBegin1='<tr class="edtnc"><td>'
 
−
export gvsqw_THtmlTdBegin2='<tr class="sqwc_"><td>'
 
−
export gvsqw_THtmlTdEnd='</td></tr>'
 
−
export gvsqw_THtmlTdInter='</td><td>'
 
−
export gvsqw_THtmlPre="pre class='edt'>"
 
−
export gvsqw_THtmlPreEnd="/pre>"
 
−
export gvsqw_HtmlCss="<html><head>
 
−
<style type='text/css'>
 
−
body.edt {font:10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}
 
−
pre.edt {font:10pt Courier;color:black; background:White;}
 
−
pre.edtfoot {font:8pt Courier;color:#2E8B57; background:White;}
 
−
h1.edt {font:bold 12pt Courier New, Courier, mono;color:#0000FF;background-color:White;border-bottom:1px solid #cccc99;margin-top:0pt; margin-bottom:0pt;padding:0px 0px 0px 0px;}
 
−
h2.edt {font:bold 10pt Courier New, Courier, mono ; text-decoration:underline;color:#000000;background-color:White;margin-top:4pt; margin-bottom:0pt;}
 
−
h3.edt {font:10pt Courier New, Courier, mono ; text-decoration:underline;color:#000000;background-color:White;margin-top:4pt; margin-bottom:0pt;}
 
−
li.edt {font:10pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;}
 
−
table.edt {border-width:1px; border-style:solid; border-color:black; width:50%;border-collapse: separate;}
 
−
tr.edtth {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:black; background:#C0C0C0;padding-left:4px; padding-right:4px;padding-bottom:2px}
 
−
tr.edtnc {font:10pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;}
 
−
tr.sqwc_    {font:10pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#eee; vertical-align:top;}
 
−
a.edt {font:bold 8pt Arial,Helvetica,sans-serif;color:#663300; vertical-align:top;margin-top:0pt; margin-bottom:0pt;}
 
−
a:link { color :black ; text-decoration:underline ; }
 
−
a:visited { color: purple ; }
 
−
a:hover { color: red ; }
 
−
</style>
 
−
</head>
 
−
<body class='edt'>
 
−
"
 
  
 
##Globaly forcing return code for scripts
 
##Globaly forcing return code for scripts
Line 116: 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
Line 132: Line 78:
 
#for expdp scripts
 
#for expdp scripts
 
export gvsqw_RootExpdp='/$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/expdp'
 
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_ExpdpDirectory='dbsqware_datapump'
 +
export gvsqw_ExcludeErrorRefreshDrop='^ORA-04043: '
 +
export gvsqw_ExcludeErrorRefreshImp='^ORA-31684: |^ORA-39082: '
 
export gvsqw_ExpdpCompressorExt=none
 
export gvsqw_ExpdpCompressorExt=none
 +
export gvsqw_ExpdpNbDropAttempts=3
 
export gvsqw_ExpdpNbGeneration=1
 
export gvsqw_ExpdpNbGeneration=1
 
export gvsqw_NbThreadExpdp=2
 
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 150: Line 116:
 
export gvsqw_SizeMinSch=10
 
export gvsqw_SizeMinSch=10
 
export gvsqw_SizeMinSeg=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')
 +
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_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
 
#ASM table to size of DG, set 'v$asm_diskgroup' if you want exact values
 
export gvsqw_AsmDgTable='v$asm_diskgroup_stat'
 
export gvsqw_AsmDgTable='v$asm_diskgroup_stat'
Line 157: Line 161:
 
# - ...
 
# - ...
 
export gvsqw_DbAlias='$ORACLE_SID'
 
export gvsqw_DbAlias='$ORACLE_SID'
−
#Put gvsqw_DistDbaUser for distant connection (indicators, awr, check)
+
#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'
 
#export gvsqw_DistDbaUser='user/passwd@$ORACLE_SID'
  
Line 166: Line 171:
  
 
#for SQWareWeb
 
#for SQWareWeb
−
export gvsqw_WebDbaURL="http://webdba"
+
export gvsqw_MonitorTimeAWR='trunc(sysdate-1)'
−
#export gvsqw_WebDbaUser='Connection string ssh user@hostname'
+
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'
−
# Source custom
+
#export gvsqw_ChmodReportsDir='755'
−
[ -r $gvsqw_OraBin/../etc_cust/sqwora_GlobalVar.cfg ] && . $gvsqw_OraBin/../etc_cust/sqwora_GlobalVar.cfg
 
−
 
 
−
# For not normed environnement
 
−
[ -r $HOME/edtConfig/sqwora_GlobalVar.cfg ] && . $HOME/edtConfig/sqwora_GlobalVar.cfg
 
 
</pre>
 
</pre>

Revision as of 22:24, 25 February 2024


File content: 

#!/bin/ksh
###################################################################
# 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 2010-2024, dbSQWare (www.dbsqware.com)

#global
export gvsqw_SqwVersionDbms=2024.01
export gvsqw_ExcludeEvalVar='^gvsqw_ExternalDbaUser=|^gvsqw_AsmDgTable='
export gvsqw_DbaUser='/'
#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='/$(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'

#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='/$(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

#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='/$(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

#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_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')
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_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'
Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwora_GlobalVar.cfg_content&oldid=26621"