Template:SQWareProduction sqwora GlobalVar.cfg content

From Wiki_dbSQWare
Revision as of 16:50, 23 December 2016 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.


File content:

#!/bin/ksh
###################################################################
# SQWareProduction for Oracle module of dbSQWare is developped with GPL License 3.0 :
#
# 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,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
# 
# You should have received a copy of the GNU General Public License
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
# 
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
## @Synopsis	Global var for Oracle
## @Copyright	Copyright 2010-2017, dbSQWare (www.dbsqware.com)
## @License	GPL v3

#global
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_RootDbf='/$(echo ${HOME}|cut -d/ -f2)/data/${ORACLE_SID}'
export gvsqw_TnsDbsPath="$HOME/SQWareProduction/oracle/etc_cust"

#global 12c multitenant
#export gvsqw_PdbDbaUser=user/passwd => for global pdb connection
#export gvsqw_PdbPasswdFile=passfile => file parameter for pdb connection (pdb_name;user;passwd)
#export gvsqw_SqlPlusMoreOpt='-R 3'

##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'

#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_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 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
#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'
#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'