SQWareProduction:oracle
Contents
- 1 Presentation
- 2 bin
- 2.1 sqwArchmon
- 2.2 sqwArchmon.ksh
- 2.3 sqwora_ActivateMonitoring.ksh
- 2.4 sqwora_CopyDmpdp.ksh
- 2.5 sqwora_DbmsStats.ksh
- 2.6 sqwora_ExecSQL.ksh
- 2.7 sqwora_Expdp.ksh
- 2.8 sqwora_Export.ksh
- 2.9 sqwora_GatherDistantFsSize.ksh
- 2.10 sqwora_GatherIndicators.ksh
- 2.11 sqwora_GatherStructure.ksh
- 2.12 sqwora_GenerateAwr.ksh
- 2.13 sqwora_GenerateStatspack.ksh
- 2.14 sqwora_Impdp.ksh
- 2.15 sqwora_MonitorWithAwr.ksh
- 2.16 sqwora_MonitorWithAwrLastStat.ksh
- 2.17 sqwora_MonitorWithStatspack.ksh
- 2.18 sqwora_NetBackup.ksh
- 2.19 sqwora_ParallelRun.ksh
- 2.20 sqwora_PartialRefresh.ksh
- 2.21 sqwora_PhysicalColdBackup.ksh
- 2.22 sqwora_PurgeAlert.ksh
- 2.23 sqwora_RmanBackup.ksh
- 2.24 sqwora_RmanClone.ksh
- 2.25 sqwora_RsyncBackup.ksh
- 2.26 sqwora_RunJob.ksh
- 2.27 sqwora_SchemaRefreshExpdp.ksh
- 2.28 sqwora_SchemaRefresh.ksh
- 2.29 sqwora_SqwArchmon.ksh
- 3 etc
- 3.1 sqwora_Awr.cfg
- 3.2 sqwora_CreDb_Create.cfg
- 3.3 sqwora_CreDb_CrontabRef.cfg
- 3.4 sqwora_CreDb_Init_101.cfg
- 3.5 sqwora_CreDb_Init_102.cfg
- 3.6 sqwora_CreDb_Init_111.cfg
- 3.7 sqwora_CreDb_Init_112.cfg
- 3.8 sqwora_CreDb_Init_121.cfg
- 3.9 sqwora_CreDb_Init_122.cfg
- 3.10 sqwora_CreDb_Init_190.cfg
- 3.11 sqwora_CreDb_Init_210.cfg
- 3.12 sqwora_CreDb_Jobs.cfg
- 3.13 sqwora_CreDb_Listener.cfg
- 3.14 sqwora_CreDb_Rman.cfg
- 3.15 sqwora_CreDb_Sqlnet.cfg
- 3.16 sqwora_CreDb_Tnsnames.cfg
- 3.17 sqwora_DbmsStats.cfg
- 3.18 sqwora_GlobalVar.cfg
- 3.19 sqwora_IndicatorsVar.cfg
- 3.20 sqwora_Rman.cfg
- 3.21 sqwora_RmanClone.cfg
- 3.22 tnsnames.ora
- 3.23 .profile
- 3.24 .profile_confort
- 4 lib
- 4.1 sqwora_ActivateMonitoring.lib
- 4.2 sqwora_CopyDmpdp.lib
- 4.3 sqwora_DbmsStats.lib
- 4.4 sqwora_ExecSQL.lib
- 4.5 sqwora_Expdp.lib
- 4.6 sqwora_FixAwrPart.lib
- 4.7 sqwora_GatherDistantFsSize.lib
- 4.8 sqwora_GatherIndicators.lib
- 4.9 sqwora_GatherIndicators_Overload.lib
- 4.10 sqwora_GatherStructure.lib
- 4.11 sqwora_GenerateAwr.lib
- 4.12 sqwora_GenerateCreateInstance.lib
- 4.13 sqwora_GenerateStatspack.lib
- 4.14 sqwora_GenericRefresh.lib
- 4.15 sqwora_Global.lib
- 4.16 sqwora_Impdp.lib
- 4.17 sqwora_ManageStatspack.lib
- 4.18 sqwora_MenuRman.lib
- 4.19 sqwora_ModifyAutoextendDBF.lib
- 4.20 sqwora_MonitorArchives.lib
- 4.21 sqwora_MonitorWithAwrLastStat.lib
- 4.22 sqwora_MonitorWithAwr.lib
- 4.23 sqwora_MonitorWithStatspack.lib
- 4.24 sqwora_NetBackup.lib
- 4.25 sqwora_PartialRefresh.lib
- 4.26 sqwora_PhysicalColdBackup.lib
- 4.27 sqwora_RmanBackup.lib
- 4.28 sqwora_RmanClone.lib
- 4.29 sqwora_RsyncBackup.lib
- 4.30 sqwora_SchemaRefreshExpdp.lib
- 4.31 sqwora_SchemaRefresh.lib
- 4.32 sqwora_SetEnv.lib
- 4.33 sqwora_Wallet.lib
- 5 menu
- 6 tools
- 6.1 sql
- 6.2 sqwora_BackupPasswd.ksh
- 6.3 sqwora_Crypt.ksh
- 6.4 sqwora_ExecASMCommand.ksh
- 6.5 sqwora_FixAwrPart.ksh
- 6.6 sqwora_GenerateCreateInstance.ksh
- 6.7 sqwora_GetAlertFile.ksh
- 6.8 sqwora_ListAsyncFilesGlobal.ksh
- 6.9 sqwora_ListAsyncFiles.ksh
- 6.10 sqwora_ManageOracle.ksh
- 6.11 sqwora_ManageStatspack.ksh
- 6.12 sqwora_ModifyAutoextendDBF.ksh
- 6.13 sqwora_RmanConfigure.ksh
- 6.14 sqwora_RmanCrosscheck.ksh
- 6.15 sqwora_RmanDeleteObsolete.ksh
- 6.16 sqwora_RmanRegister.ksh
- 6.17 sqwora_SetEnv.ksh
- 6.18 sqwora_SetEnv_oratab.ksh
- 6.19 sqwora_SetEnv_RACASM_oratab.ksh
- 6.20 sqwora_Spm.ksh
- 6.21 sqwora_TestInstConnection.ksh
- 6.22 sqwora_TestMySQL.ksh
- 6.23 sqwora_TestSendmail.ksh
- 6.24 sqwora_Uncrypt.ksh
- 7 help
- 8 spm
Presentation
Usage
It's the module locally operating of oracle.
It is entirely written in ksh and sql.
It allows to manage the operation for oracle.
Example uses of the tool:
- Backup
- Recovery
- Compute statistics
- Indicators collection to store in referential database SQWareRepository
- Rotate logs
- ....
This module is deployed locally on the machine hosting the authorities to manage,
in order to avoid any points of weakness related to an NFS mount or whatever.
The deployment is done through a simple command SQWareCentral module using inventory located in SQWareRepository !
Installation guide for SQWareProduction for oracle
Explanation of directories
Directories located in $gvsqw_OraBin:
- bin : Directory containing standard scripts
- bin_cust : Directory containing customs scripts for your environnement
- etc : Directory containing the standard files of configuration
- etc_cust : Directory containing the customs files of configuration for your environnement (overload standards)
- help : Directory containing the standard files of help
- help_cust : Directory containing the customs files of help for your environnement
- lib : Directory containing the generic shell function librairies
- lib_cust : Directory containing the generic shell function librairies (overload standards)
- spm : Contain sql query toolkit
- tools : Directory containing the standard scripts used on an ad hoc
- tools_cust : Directory containing the customs scripts used on an ad hoc for your environnement
- menu : Directory containing the standard menus
- menu_cust : Directory containing the custom menus for your environnement
Naming convention of files
The majority of files are named with suffixes:
- *.ksh : for scripts
- *.cfg : for configuration files
- *.lib : for function librairies
- *.hlp : for help files
Naming convention in scripts
In general, the following naming convention is used in all scripts of SQWareProduction:
- gvsqw_ {} : global variable initialized by the environment and / or generic library
- lvsqw_ {} : local variable initialized by the script and / or a specific library
- gfsqw_ {} : function defined by a generic library
- lfsqw_ {} : function defined by the script and / or a specific library
bin
sqwArchmon
Script $gvsqw_OraBin/bin/sqwArchmon:
See the detailed help for sqwArchmon
sqwArchmon.ksh
Script $gvsqw_OraBin/bin/sqwArchmon.ksh:
See the detailed help for sqwArchmon.ksh
sqwora_ActivateMonitoring.ksh
Script $gvsqw_OraBin/bin/sqwora_ActivateMonitoring.ksh:
script to activate monitoring on tables
See the detailed help for sqwora_ActivateMonitoring.ksh
sqwora_CopyDmpdp.ksh
Script $gvsqw_OraBin/bin/sqwora_CopyDmpdp.ksh:
Copy dmpdp files by rsync
Actions:
- Copy dmpdp files get or put
The script can also:
- send email report of CopyDmpdp
- run shell script before load
- run shell script after load
See the detailed help for sqwora_CopyDmpdp.ksh
sqwora_DbmsStats.ksh
Script $gvsqw_OraBin/bin/sqwora_DbmsStats.ksh:
gather statistics avec DBMS_STATS
See the detailed help for sqwora_DbmsStats.ksh
sqwora_ExecSQL.ksh
Script $gvsqw_OraBin/bin/sqwora_ExecSQL.ksh:
execute SQL file on instance
See the detailed help for sqwora_ExecSQL.ksh
sqwora_Expdp.ksh
Script $gvsqw_OraBin/bin/sqwora_Expdp.ksh:
Generate Oracle expdp
Type of export can be
- full
- schema
- structure (full rows=no)
- parfile
- tables
Script makes purge of old generation automatically
You can also choose:
- different retention policy
- type of compression
- gzip
- bzip2
- compress
- none
- different directory to put dump file
- different directory to put log file
- copy dump file
See the detailed help for sqwora_Expdp.ksh
sqwora_Export.ksh
Script $gvsqw_OraBin/bin/sqwora_Export.ksh:
Generate Oracle export compressed by pipe
Type of export can be
- full
- schema
- structure (full rows=no)
- parfile
- tables
Script makes purge of old generation automatically
You can also choose:
- different retention policy
- type of compression
- gzip
- bzip2
- compress
- none
- different directory to put dump file
- different directory to put log file
See the detailed help for sqwora_Export.ksh
sqwora_GatherDistantFsSize.ksh
Script $gvsqw_OraBin/bin/sqwora_GatherDistantFsSize.ksh:
gather FS size
See the detailed help for sqwora_GatherDistantFsSize.ksh
sqwora_GatherIndicators.ksh
Script $gvsqw_OraBin/bin/sqwora_GatherIndicators.ksh:
Gather Oracle indicators and put them in SQWareRepository
Summary of collection:
- Volumetry (use, free) of instance
- Volumetry (use, free) of tablespaces
- Volumetry of schemas
- Volumetry of tables
- Volumetry of segments
- Volumetry (use, free) of FS
- Version, options, configuration, ... of instance
See the detailed help for sqwora_GatherIndicators.ksh
sqwora_GatherStructure.ksh
Script $gvsqw_OraBin/bin/sqwora_GatherStructure.ksh:
Gather Oracle structure and put them in SQWareRepository
Summary of collection:
- Tables list and options
- Columns list, types and options
- Indexes list, types and options
See the detailed help for sqwora_GatherStructure.ksh
sqwora_GenerateAwr.ksh
Script $gvsqw_OraBin/bin/sqwora_GenerateAwr.ksh:
Generate automatically AWR reports
Copy them in SQWareWeb and insert indicators in SQWareRepository
You can also choose:
- a different configuration file to generate reports
- a different directory to store reports
- to generate locally (don't copy reports on SQWareWeb and don't insert indicators in SQWareRepository)
- no delete local reports
See the detailed help for sqwora_GenerateAwr.ksh
sqwora_GenerateStatspack.ksh
Script $gvsqw_OraBin/bin/sqwora_GenerateStatspack.ksh:
generate Statspack report
See the detailed help for sqwora_GenerateStatspack.ksh
sqwora_Impdp.ksh
Script $gvsqw_OraBin/bin/sqwora_Impdp.ksh:
Import one or more schemas by impdp
Actions:
- Drop all objetcs of refreshed schema
- Makes import
The script can also:
- Retrieve dump file by rsync
- send email report of impdp
- run shell script before load
- run shell script after load
- keep a table list (save/restore)
See the detailed help for sqwora_Impdp.ksh
sqwora_MonitorWithAwr.ksh
Script $gvsqw_OraBin/bin/sqwora_MonitorWithAwr.ksh:
Generate monitoring workLoad based on AWR reports
Insert indicators in SQWareRepository
You can also choose:
- a different configuration file to generate reports
- a different directory to store reports
- to generate locally (don't insert indicators in SQWareRepository)
- no delete local reports
- date min of snap
- date max of snap
See the detailed help for sqwora_MonitorWithAwr.ksh
sqwora_MonitorWithAwrLastStat.ksh
Script $gvsqw_OraBin/bin/sqwora_MonitorWithAwrLastStat.ksh:
Generate monitoring workLoad based on AWR reports
Insert indicators in SQWareRepository
You must choose:
- a different directory to store reports
See the detailed help for sqwora_MonitorWithAwrLastStat.ksh
sqwora_MonitorWithStatspack.ksh
Script $gvsqw_OraBin/bin/sqwora_MonitorWithStatspack.ksh:
Monitor ratios with Statspack
See the detailed help for sqwora_MonitorWithStatspack.ksh
sqwora_NetBackup.ksh
Script $gvsqw_OraBin/bin/sqwora_NetBackup.ksh:
backup with NetBackup dump/backup files
See the detailed help for sqwora_NetBackup.ksh
sqwora_ParallelRun.ksh
Script $gvsqw_OraBin/bin/sqwora_ParallelRun.ksh:
Manages the execution of unix commands in parallel mode
Takes in parameter file with unix command to execute
You can choose:
- The parallel degree
- Aggressiveness of run (number of seconds between two runs)
- Aggressiveness of check end (number of seconds between two checks of end)
See the detailed help for sqwora_ParallelRun.ksh
sqwora_PartialRefresh.ksh
Script $gvsqw_OraBin/bin/sqwora_PartialRefresh.ksh:
Refresh of a tables list for one schema by exp/imp
Actions:
- Makes export of distant tables to refresh by ssh (list contained in a file)
- Retrieve dump file by scp
- Drop tables to refresh
- Makes import
The script can also:
- change of unix users target/source
- send email report of refresh
- run shell script after load
See the detailed help for sqwora_PartialRefresh.ksh
sqwora_PhysicalColdBackup.ksh
Script $gvsqw_OraBin/bin/sqwora_PhysicalColdBackup.ksh:
execute physical cold backup (gzip)
See the detailed help for sqwora_PhysicalColdBackup.ksh
sqwora_PurgeAlert.ksh
Script $gvsqw_OraBin/bin/sqwora_PurgeAlert.ksh:
archiving/purge of trace/alert files of the instance
Makes an archive (tgz) of diagnostic tree
Purge old archives after a number of days
See the detailed help for sqwora_PurgeAlert.ksh
sqwora_RmanBackup.ksh
Script $gvsqw_OraBin/bin/sqwora_RmanBackup.ksh:
Makes RMAN backups
You can choose backup type:
- incremental level 0 (i0)
- incremental level 1 (i1)
- archivelog (log)
Backup can be made online or offline (hot, cold)
The script can also:
- use the option 'skip readonly'
- autostart sqwarchmon when hot backup (if lvsqw_RmanAutoStartSqwArchmon=enable)
- makes freeze/unfreeze of cluster ressources when cold backup
- makes blackout disable/enable of supervision when cold backup
This script use configuration file $gvsqw_RootCfg/sqwora_Rman.cfg
See the detailed help for sqwora_RmanBackup.ksh
sqwora_RmanClone.ksh
Script $gvsqw_OraBin/bin/sqwora_RmanClone.ksh:
Makes RMAN clone
Script is fully automatic:
- Check space (you have to customize this function)
- Retrieve choosed backup that can be:
- LastFull => retrieve the last full backup
- LastInc => retrieve the last incremental backup
- MaxTime => retrieve the last backup
- <tag> => retrieve this backup tag (part of file name)
- Unregister from RMAN catalog
- Save old password
- Destroy old database
- Run cloning
The script can also:
- ignore disk warning (stop by default)
- makes copy backup only
- change of unix users target/source
- choose parallel degree of backup copy
- send email report of cloning
- run shell script before load
- run shell script after load
This script use configuration file $gvsqw_RootCfg/sqwora_Rman.cfg
See the detailed help for sqwora_RmanClone.ksh
sqwora_RsyncBackup.ksh
Script $gvsqw_OraBin/bin/sqwora_RsyncBackup.ksh:
rsync dir (without delete) to an other host
See the detailed help for sqwora_RsyncBackup.ksh
sqwora_RunJob.ksh
Script $gvsqw_OraBin/bin/sqwora_RunJob.ksh:
Run Oracle scripts and generate log and error file
based on $gvsqw_RootCfg/sqwora_Jobs.cfg configuration file
compress and purge oldest log files
See the detailed help for sqwora_RunJob.ksh
sqwora_SchemaRefreshExpdp.ksh
Script $gvsqw_OraBin/bin/sqwora_SchemaRefreshExpdp.ksh:
Refresh one or more schemas by expdp/impdp
Actions:
- Makes export of distant schema by ssh
- Retrieve dump file by scp
- Drop all objetcs of refreshed schema
- Makes import
The script can also:
- change of unix users target/source
- send email report of refresh
- run shell script before load
- run shell script after load
- keep a table list (save/restore)
See the detailed help for sqwora_SchemaRefreshExpdp.ksh
sqwora_SchemaRefresh.ksh
Script $gvsqw_OraBin/bin/sqwora_SchemaRefresh.ksh:
Refresh one or more schemas by exp/imp
Actions:
- Makes export of distant schema by ssh
- Retrieve dump file by scp
- Drop all objetcs of refreshed schema
- Makes import
The script can also:
- change of unix users target/source
- send email report of refresh
- run shell script before load
- run shell script after load
See the detailed help for sqwora_SchemaRefresh.ksh
sqwora_SqwArchmon.ksh
Script $gvsqw_OraBin/bin/sqwora_SqwArchmon.ksh:
See the detailed help for sqwora_SqwArchmon.ksh
etc
sqwora_Awr.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_Awr.cfg:
config for AWR report generation
See the detailed help for sqwora_Awr.cfg
sqwora_CreDb_Create.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Create.cfg:
See the detailed help for sqwora_CreDb_Create.cfg
sqwora_CreDb_CrontabRef.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_CrontabRef.cfg:
See the detailed help for sqwora_CreDb_CrontabRef.cfg
sqwora_CreDb_Init_101.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_101.cfg:
See the detailed help for sqwora_CreDb_Init_101.cfg
sqwora_CreDb_Init_102.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_102.cfg:
See the detailed help for sqwora_CreDb_Init_102.cfg
sqwora_CreDb_Init_111.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_111.cfg:
See the detailed help for sqwora_CreDb_Init_111.cfg
sqwora_CreDb_Init_112.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_112.cfg:
See the detailed help for sqwora_CreDb_Init_112.cfg
sqwora_CreDb_Init_121.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_121.cfg:
See the detailed help for sqwora_CreDb_Init_121.cfg
sqwora_CreDb_Init_122.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_122.cfg:
See the detailed help for sqwora_CreDb_Init_122.cfg
sqwora_CreDb_Init_190.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_190.cfg:
See the detailed help for sqwora_CreDb_Init_190.cfg
sqwora_CreDb_Init_210.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_210.cfg:
See the detailed help for sqwora_CreDb_Init_210.cfg
sqwora_CreDb_Jobs.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Jobs.cfg:
See the detailed help for sqwora_CreDb_Jobs.cfg
sqwora_CreDb_Listener.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Listener.cfg:
See the detailed help for sqwora_CreDb_Listener.cfg
sqwora_CreDb_Rman.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Rman.cfg:
See the detailed help for sqwora_CreDb_Rman.cfg
sqwora_CreDb_Sqlnet.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Sqlnet.cfg:
See the detailed help for sqwora_CreDb_Sqlnet.cfg
sqwora_CreDb_Tnsnames.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Tnsnames.cfg:
See the detailed help for sqwora_CreDb_Tnsnames.cfg
sqwora_DbmsStats.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_DbmsStats.cfg:
var for RMAN duplicate scripts
See the detailed help for sqwora_DbmsStats.cfg
sqwora_GlobalVar.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:
Global var for Oracle
It contains the operating variables of SQWareProduction.
See the detailed help for sqwora_GlobalVar.cfg
sqwora_IndicatorsVar.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_IndicatorsVar.cfg:
Global var for indicators scripts
It contains the operating variables of SQWareProduction.
See the detailed help for sqwora_IndicatorsVar.cfg
sqwora_Rman.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_Rman.cfg:
See the detailed help for sqwora_Rman.cfg
sqwora_RmanClone.cfg
Configuration file $gvsqw_OraBin/../etc/sqwora_RmanClone.cfg:
var for RMAN duplicate scripts
See the detailed help for sqwora_RmanClone.cfg
tnsnames.ora
Configuration file $gvsqw_OraBin/../etc/tnsnames.ora:
template for sqw tnsnames.ora
See the detailed help for tnsnames.ora
.profile
Sample file for .profile $gvsqw_OraBin/../etc/.profile:
Sample of lines to add to .profile of oracle users.
See the detailed help for .profile
.profile_confort
File to put aliases $gvsqw_OraBin/../etc/.profile_confort:
Contains confort aliases of SQWareProduction for oracle.
See the detailed help for .profile_confort
lib
sqwora_ActivateMonitoring.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_ActivateMonitoring.lib:
lib for sqwora_ActivateMonitoring.ksh
See the detailed help for sqwora_ActivateMonitoring.lib
sqwora_CopyDmpdp.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_CopyDmpdp.lib:
lib for sqwora_CopyDmpdp.ksh
See the detailed help for sqwora_CopyDmpdp.lib
sqwora_DbmsStats.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_DbmsStats.lib:
lib for sqwora_DbmsStats.ksh
See the detailed help for sqwora_DbmsStats.lib
sqwora_ExecSQL.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_ExecSQL.lib:
lib for sqwora_ExecSQL.ksh
See the detailed help for sqwora_ExecSQL.lib
sqwora_Expdp.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_Expdp.lib:
lib for sqwora_Expdp.ksh
See the detailed help for sqwora_Expdp.lib
sqwora_FixAwrPart.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_FixAwrPart.lib:
lib for sqwora_FixAwrPart.ksh
See the detailed help for sqwora_FixAwrPart.lib
sqwora_GatherDistantFsSize.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_GatherDistantFsSize.lib:
lib for sqwora_GatherFsSize.ksh
See the detailed help for sqwora_GatherDistantFsSize.lib
sqwora_GatherIndicators.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_GatherIndicators.lib:
lib for sqwora_GatherIndicators.ksh
See the detailed help for sqwora_GatherIndicators.lib
sqwora_GatherIndicators_Overload.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_GatherIndicators_Overload.lib:
lib for overload sqwora_GatherIndicators.ksh
See the detailed help for sqwora_GatherIndicators_Overload.lib
sqwora_GatherStructure.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_GatherStructure.lib:
lib for sqwora_GatherStructure.ksh
See the detailed help for sqwora_GatherStructure.lib
sqwora_GenerateAwr.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_GenerateAwr.lib:
lib for sqwora_GenerateAwr.ksh
See the detailed help for sqwora_GenerateAwr.lib
sqwora_GenerateCreateInstance.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_GenerateCreateInstance.lib:
lib for generate create database
See the detailed help for sqwora_GenerateCreateInstance.lib
sqwora_GenerateStatspack.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_GenerateStatspack.lib:
lib for sqwora_GenerateStatspack.ksh
See the detailed help for sqwora_GenerateStatspack.lib
sqwora_GenericRefresh.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_GenericRefresh.lib:
See the detailed help for sqwora_GenericRefresh.lib
sqwora_Global.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_Global.lib:
central lib of generic fonctions for oracle
See the detailed help for sqwora_Global.lib
sqwora_Impdp.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_Impdp.lib:
lib for sqwora_Impdp.ksh
See the detailed help for sqwora_Impdp.lib
sqwora_ManageStatspack.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_ManageStatspack.lib:
lib for sqwora_ManageStatspack.ksh
See the detailed help for sqwora_ManageStatspack.lib
sqwora_MenuRman.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_MenuRman.lib:
lib for sqwora_MenuRman.ksh
See the detailed help for sqwora_MenuRman.lib
sqwora_ModifyAutoextendDBF.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_ModifyAutoextendDBF.lib:
lib for sqwora_ModifyAutoextendDBF.ksh
See the detailed help for sqwora_ModifyAutoextendDBF.lib
sqwora_MonitorArchives.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_MonitorArchives.lib:
lib for sqwora_MonitorWithStatspack.ksh, sqwora_MonitorWithAwr.ksh and sqwora_GatherIndicators.ksh
See the detailed help for sqwora_MonitorArchives.lib
sqwora_MonitorWithAwrLastStat.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_MonitorWithAwrLastStat.lib:
lib for sqwora_MonitorWithAwrLastStat.ksh
See the detailed help for sqwora_MonitorWithAwrLastStat.lib
sqwora_MonitorWithAwr.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_MonitorWithAwr.lib:
lib for sqwora_MonitorWithAwr.ksh
See the detailed help for sqwora_MonitorWithAwr.lib
sqwora_MonitorWithStatspack.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_MonitorWithStatspack.lib:
lib for sqwora_MonitorWithStatspack.ksh
See the detailed help for sqwora_MonitorWithStatspack.lib
sqwora_NetBackup.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_NetBackup.lib:
lib for sqwgen_NetBackup.ksh
See the detailed help for sqwora_NetBackup.lib
sqwora_PartialRefresh.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_PartialRefresh.lib:
lib for sqwora_PartialRefresh.ksh
See the detailed help for sqwora_PartialRefresh.lib
sqwora_PhysicalColdBackup.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_PhysicalColdBackup.lib:
lib for PhysicalColdBackup
See the detailed help for sqwora_PhysicalColdBackup.lib
sqwora_RmanBackup.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_RmanBackup.lib:
lib for RMAN backup
See the detailed help for sqwora_RmanBackup.lib
sqwora_RmanClone.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_RmanClone.lib:
lib for RMAN clone
See the detailed help for sqwora_RmanClone.lib
sqwora_RsyncBackup.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_RsyncBackup.lib:
lib for sqwgen_RsyncBackup.ksh.ksh
See the detailed help for sqwora_RsyncBackup.lib
sqwora_SchemaRefreshExpdp.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_SchemaRefreshExpdp.lib:
lib for sqwora_SchemaRefreshExpdp.ksh
See the detailed help for sqwora_SchemaRefreshExpdp.lib
sqwora_SchemaRefresh.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_SchemaRefresh.lib:
lib for sqwora_SchemaRefresh.ksh
See the detailed help for sqwora_SchemaRefresh.lib
sqwora_SetEnv.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_SetEnv.lib:
fonction to set env for $ORACLE_SID
See the detailed help for sqwora_SetEnv.lib
sqwora_Wallet.lib
shell functions library $gvsqw_OraBin/../lib/sqwora_Wallet.lib:
fonction to manage connection by Wallet for $ORACLE_SID
See the detailed help for sqwora_Wallet.lib
sqwora_MenuRman.ksh
Menu $gvsqw_OraBin/../menu/sqwora_MenuRman.ksh:
menu for RMAN commands
See the detailed help for sqwora_MenuRman.ksh
tools
sql
Script $gvsqw_OraBin/../tools/sql:
sqwora_BackupPasswd.ksh
Script $gvsqw_OraBin/../tools/sqwora_BackupPasswd.ksh:
backup passwd of Oracle users
See the detailed help for sqwora_BackupPasswd.ksh
sqwora_Crypt.ksh
Script $gvsqw_OraBin/../tools/sqwora_Crypt.ksh:
Generic script to crypt file with openssl
See the detailed help for sqwora_Crypt.ksh
sqwora_ExecASMCommand.ksh
Script $gvsqw_OraBin/../tools/sqwora_ExecASMCommand.ksh:
Exec ASM command in batch mode
See the detailed help for sqwora_ExecASMCommand.ksh
sqwora_FixAwrPart.ksh
Script $gvsqw_OraBin/../tools/sqwora_FixAwrPart.ksh:
Lauch fixing cmd for AWR repo. Must be launch daily until it matches configured retention.
See the detailed help for sqwora_FixAwrPart.ksh
sqwora_GenerateCreateInstance.ksh
Script $gvsqw_OraBin/../tools/sqwora_GenerateCreateInstance.ksh:
Generate create database files
See the detailed help for sqwora_GenerateCreateInstance.ksh
sqwora_GetAlertFile.ksh
Script $gvsqw_OraBin/../tools/sqwora_GetAlertFile.ksh:
Get Oracle Alert file
See the detailed help for sqwora_GetAlertFile.ksh
sqwora_ListAsyncFilesGlobal.ksh
Script $gvsqw_OraBin/../tools/sqwora_ListAsyncFilesGlobal.ksh:
List Async files (sql, log, mail) to upload in SQWareCentral (all in a directory)
See the detailed help for sqwora_ListAsyncFilesGlobal.ksh
sqwora_ListAsyncFiles.ksh
Script $gvsqw_OraBin/../tools/sqwora_ListAsyncFiles.ksh:
List Async files (sql, log, mail) to upload in SQWareCentral
See the detailed help for sqwora_ListAsyncFiles.ksh
sqwora_ManageOracle.ksh
Script $gvsqw_OraBin/../tools/sqwora_ManageOracle.ksh:
stop/start instance
See the detailed help for sqwora_ManageOracle.ksh
sqwora_ManageStatspack.ksh
Script $gvsqw_OraBin/../tools/sqwora_ManageStatspack.ksh:
Statspack Snap/Purge script
See the detailed help for sqwora_ManageStatspack.ksh
sqwora_ModifyAutoextendDBF.ksh
Script $gvsqw_OraBin/../tools/sqwora_ModifyAutoextendDBF.ksh:
Modify autoextend DBF
See the detailed help for sqwora_ModifyAutoextendDBF.ksh
sqwora_RmanConfigure.ksh
Script $gvsqw_OraBin/../tools/sqwora_RmanConfigure.ksh:
default paraters for RMAN and block change tracking
See the detailed help for sqwora_RmanConfigure.ksh
sqwora_RmanCrosscheck.ksh
Script $gvsqw_OraBin/../tools/sqwora_RmanCrosscheck.ksh:
Crosscheck and delete expired RMAN
See the detailed help for sqwora_RmanCrosscheck.ksh
sqwora_RmanDeleteObsolete.ksh
Script $gvsqw_OraBin/../tools/sqwora_RmanDeleteObsolete.ksh:
delete obsolete
See the detailed help for sqwora_RmanDeleteObsolete.ksh
sqwora_RmanRegister.ksh
Script $gvsqw_OraBin/../tools/sqwora_RmanRegister.ksh:
default paraters for RMAN and block change tracking
See the detailed help for sqwora_RmanRegister.ksh
sqwora_SetEnv.ksh
Script $gvsqw_OraBin/../tools/sqwora_SetEnv.ksh:
set env for $ORACLE_SID
See the detailed help for sqwora_SetEnv.ksh
sqwora_SetEnv_oratab.ksh
Script $gvsqw_OraBin/../tools/sqwora_SetEnv_oratab.ksh:
example of set env for $ORACLE_SID base on oratab file for standalone based on oratab
See the detailed help for sqwora_SetEnv_oratab.ksh
sqwora_SetEnv_RACASM_oratab.ksh
Script $gvsqw_OraBin/../tools/sqwora_SetEnv_RACASM_oratab.ksh:
example of set env for $ORACLE_SID base on oratab file for RAC/ASM or standalone (no ASM) based on oratab
See the detailed help for sqwora_SetEnv_RACASM_oratab.ksh
sqwora_Spm.ksh
Script $gvsqw_OraBin/../tools/sqwora_Spm.ksh:
Sqlplus tools
See the detailed help for sqwora_Spm.ksh
sqwora_TestInstConnection.ksh
Script $gvsqw_OraBin/../tools/sqwora_TestInstConnection.ksh:
Test instance connection
See the detailed help for sqwora_TestInstConnection.ksh
sqwora_TestMySQL.ksh
Script $gvsqw_OraBin/../tools/sqwora_TestMySQL.ksh:
Generic test MySQL connection script
See the detailed help for sqwora_TestMySQL.ksh
sqwora_TestSendmail.ksh
Script $gvsqw_OraBin/../tools/sqwora_TestSendmail.ksh:
Generic test sendmail script
See the detailed help for sqwora_TestSendmail.ksh
sqwora_Uncrypt.ksh
Script $gvsqw_OraBin/../tools/sqwora_Uncrypt.ksh:
Generic script to uncrypt file with openssl
See the detailed help for sqwora_Uncrypt.ksh
help
Contains help files for "-s" option of bin scripts.
spm
SQL query toolkit
See the detailed help for spm