Difference between revisions of "SQWareProduction:oracle"

Latest revision as of 09:58, 18 December 2023

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

Warning:
Do not change the standard scripts and configuration files of dbSQWare.

Use directories *_cust for customizations. This will facilitate version upgrades.

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

Warning:
Do not change the standard scripts and configuration files of dbSQWare.

Use directories *_cust for customizations. This will facilitate version upgrades.

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_ExpdpAllPDB.ksh

Script $gvsqw_OraBin/bin/sqwora_ExpdpAllPDB.ksh:

Generate Oracle expdp for all PDB
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_ExpdpAllPDB.ksh

sqwora_ExpdpAllSchemas.ksh

Script $gvsqw_OraBin/bin/sqwora_ExpdpAllSchemas.ksh:

Generate Oracle expdp for schemas and structure
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_ExpdpAllSchemas.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_FailWithoutMail.ksh

Script $gvsqw_OraBin/bin/sqwora_FailWithoutMail.ksh:

exit with error and display imput parameters See the detailed help for sqwora_FailWithoutMail.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.

Note:
You can overload variables contain in $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg

by the same variables in $gvsqw_OraBin/../etc_cust/sqwora_GlobalVar.cfg for all your environnement
or in $HOME/sqwConfig/sqwora_GlobalVar.cfg specifically for this user.

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.

Note:
You can overload variables contain in $gvsqw_OraBin/../etc/sqwora_IndicatorsVar.cfg

by the same variables in $gvsqw_OraBin/../etc_cust/sqwora_IndicatorsVar.cfg for all your environnement
or in $HOME/sqwConfig/sqwora_IndicatorsVar.cfg specifically for this user.

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.

Note:
You can overload confort environnement $gvsqw_OraBin/../etc/.profile_confort

with $gvsqw_OraBin/../etc_cust/.profile_confort for all your environnement
or with $HOME/edtConfig/.profile_confort specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_ActivateMonitoring.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_ActivateMonitoring.lib for all your environnement
or by $HOME/sqwConfig/sqwora_ActivateMonitoring.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_CopyDmpdp.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_CopyDmpdp.lib for all your environnement
or by $HOME/sqwConfig/sqwora_CopyDmpdp.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_DbmsStats.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_DbmsStats.lib for all your environnement
or by $HOME/sqwConfig/sqwora_DbmsStats.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_ExecSQL.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_ExecSQL.lib for all your environnement
or by $HOME/sqwConfig/sqwora_ExecSQL.lib specifically for this user .

See the detailed help for sqwora_ExecSQL.lib

sqwora_ExpdpAllPDB.lib

shell functions library $gvsqw_OraBin/../lib/sqwora_ExpdpAllPDB.lib:
lib for sqwora_ExpdpAllPDB.ksh

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_ExpdpAllPDB.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_ExpdpAllPDB.lib for all your environnement
or by $HOME/sqwConfig/sqwora_ExpdpAllPDB.lib specifically for this user .

See the detailed help for sqwora_ExpdpAllPDB.lib

sqwora_ExpdpAllSchemas.lib

shell functions library $gvsqw_OraBin/../lib/sqwora_ExpdpAllSchemas.lib:
lib for sqwora_ExpdpAllSchemas.ksh

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_ExpdpAllSchemas.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_ExpdpAllSchemas.lib for all your environnement
or by $HOME/sqwConfig/sqwora_ExpdpAllSchemas.lib specifically for this user .

See the detailed help for sqwora_ExpdpAllSchemas.lib

sqwora_Expdp.lib

shell functions library $gvsqw_OraBin/../lib/sqwora_Expdp.lib:
lib for sqwora_Expdp.ksh

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_Expdp.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_Expdp.lib for all your environnement
or by $HOME/sqwConfig/sqwora_Expdp.lib specifically for this user .

See the detailed help for sqwora_Expdp.lib

sqwora_Export.lib

shell functions library $gvsqw_OraBin/../lib/sqwora_Export.lib:
lib for sqwora_Export.ksh

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_Export.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_Export.lib for all your environnement
or by $HOME/sqwConfig/sqwora_Export.lib specifically for this user .

See the detailed help for sqwora_Export.lib

sqwora_FixAwrPart.lib

shell functions library $gvsqw_OraBin/../lib/sqwora_FixAwrPart.lib:
lib for sqwora_FixAwrPart.ksh

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_FixAwrPart.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_FixAwrPart.lib for all your environnement
or by $HOME/sqwConfig/sqwora_FixAwrPart.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_GatherDistantFsSize.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_GatherDistantFsSize.lib for all your environnement
or by $HOME/sqwConfig/sqwora_GatherDistantFsSize.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_GatherIndicators.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_GatherIndicators.lib for all your environnement
or by $HOME/sqwConfig/sqwora_GatherIndicators.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_GatherIndicators_Overload.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_GatherIndicators_Overload.lib for all your environnement
or by $HOME/sqwConfig/sqwora_GatherIndicators_Overload.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_GatherStructure.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_GatherStructure.lib for all your environnement
or by $HOME/sqwConfig/sqwora_GatherStructure.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_GenerateAwr.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_GenerateAwr.lib for all your environnement
or by $HOME/sqwConfig/sqwora_GenerateAwr.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_GenerateCreateInstance.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_GenerateCreateInstance.lib for all your environnement
or by $HOME/sqwConfig/sqwora_GenerateCreateInstance.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_GenerateStatspack.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_GenerateStatspack.lib for all your environnement
or by $HOME/sqwConfig/sqwora_GenerateStatspack.lib specifically for this user .

See the detailed help for sqwora_GenerateStatspack.lib

sqwora_GenericRefresh.lib

shell functions library $gvsqw_OraBin/../lib/sqwora_GenericRefresh.lib:

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_GenericRefresh.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_GenericRefresh.lib for all your environnement
or by $HOME/sqwConfig/sqwora_GenericRefresh.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_Global.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_Global.lib for all your environnement
or by $HOME/sqwConfig/sqwora_Global.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_Impdp.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_Impdp.lib for all your environnement
or by $HOME/sqwConfig/sqwora_Impdp.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_ManageStatspack.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_ManageStatspack.lib for all your environnement
or by $HOME/sqwConfig/sqwora_ManageStatspack.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_MenuRman.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_MenuRman.lib for all your environnement
or by $HOME/sqwConfig/sqwora_MenuRman.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_ModifyAutoextendDBF.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_ModifyAutoextendDBF.lib for all your environnement
or by $HOME/sqwConfig/sqwora_ModifyAutoextendDBF.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_MonitorArchives.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_MonitorArchives.lib for all your environnement
or by $HOME/sqwConfig/sqwora_MonitorArchives.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_MonitorWithAwrLastStat.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_MonitorWithAwrLastStat.lib for all your environnement
or by $HOME/sqwConfig/sqwora_MonitorWithAwrLastStat.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_MonitorWithAwr.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_MonitorWithAwr.lib for all your environnement
or by $HOME/sqwConfig/sqwora_MonitorWithAwr.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_MonitorWithStatspack.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_MonitorWithStatspack.lib for all your environnement
or by $HOME/sqwConfig/sqwora_MonitorWithStatspack.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_NetBackup.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_NetBackup.lib for all your environnement
or by $HOME/sqwConfig/sqwora_NetBackup.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_PartialRefresh.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_PartialRefresh.lib for all your environnement
or by $HOME/sqwConfig/sqwora_PartialRefresh.lib specifically for this user .

See the detailed help for sqwora_PartialRefresh.lib

sqwora_PhysicalColdBackup.lib

shell functions library $gvsqw_OraBin/../lib/sqwora_PhysicalColdBackup.lib:
lib for PhysicalColdBackup

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_PhysicalColdBackup.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_PhysicalColdBackup.lib for all your environnement
or by $HOME/sqwConfig/sqwora_PhysicalColdBackup.lib specifically for this user .

See the detailed help for sqwora_PhysicalColdBackup.lib

sqwora_PurgeAlert.lib

shell functions library $gvsqw_OraBin/../lib/sqwora_PurgeAlert.lib:
lib for sqwora_PurgeAlert.ksh

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_PurgeAlert.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_PurgeAlert.lib for all your environnement
or by $HOME/sqwConfig/sqwora_PurgeAlert.lib specifically for this user .

See the detailed help for sqwora_PurgeAlert.lib

sqwora_RmanBackup.lib

shell functions library $gvsqw_OraBin/../lib/sqwora_RmanBackup.lib:
lib for RMAN backup

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_RmanBackup.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_RmanBackup.lib for all your environnement
or by $HOME/sqwConfig/sqwora_RmanBackup.lib specifically for this user .

See the detailed help for sqwora_RmanBackup.lib

sqwora_RmanClone.lib

shell functions library $gvsqw_OraBin/../lib/sqwora_RmanClone.lib:
lib for RMAN clone

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_RmanClone.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_RmanClone.lib for all your environnement
or by $HOME/sqwConfig/sqwora_RmanClone.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_RsyncBackup.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_RsyncBackup.lib for all your environnement
or by $HOME/sqwConfig/sqwora_RsyncBackup.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_SchemaRefreshExpdp.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_SchemaRefreshExpdp.lib for all your environnement
or by $HOME/sqwConfig/sqwora_SchemaRefreshExpdp.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_SchemaRefresh.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_SchemaRefresh.lib for all your environnement
or by $HOME/sqwConfig/sqwora_SchemaRefresh.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_SetEnv.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_SetEnv.lib for all your environnement
or by $HOME/sqwConfig/sqwora_SetEnv.lib specifically for this user .

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

Note:
You can overload functions contained in $gvsqw_OraBin/../lib/sqwora_Wallet.lib

by function with same name in $gvsqw_OraBin/../lib_cust/sqwora_Wallet.lib for all your environnement
or by $HOME/sqwConfig/sqwora_Wallet.lib specifically for this user .

See the detailed help for sqwora_Wallet.lib

tools

sql

Script $gvsqw_OraBin/../tools/sql:

See the detailed help for 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

Note:
You can replace the file in $gvsqw_OraBin/../tools/sqwora_SetEnv.ksh

by $gvsqw_OraBin/../tools_cust/sqwora_SetEnv.ksh for all your environnement
or by $HOME/edtConfig/sqwora_SetEnv.ksh specifically for this user .

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

Note:
You can replace the file in $gvsqw_OraBin/../tools/sqwora_SetEnv_oratab.ksh

by $gvsqw_OraBin/../tools_cust/sqwora_SetEnv_oratab.ksh for all your environnement
or by $HOME/edtConfig/sqwora_SetEnv_oratab.ksh specifically for this user .

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

Note:
You can replace the file in $gvsqw_OraBin/../tools/sqwora_SetEnv_RACASM_oratab.ksh

by $gvsqw_OraBin/../tools_cust/sqwora_SetEnv_RACASM_oratab.ksh for all your environnement
or by $HOME/edtConfig/sqwora_SetEnv_RACASM_oratab.ksh specifically for this user .

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

@@ Line 1: / Line 1: @@
-{{SQWareProductionPresSgbd|Oracle|Ora|ora|
+{{SQWareProductionPresSgbd|oracle|Ora|ora}}
-Exemple d'utilisations de l'outil:
-*Sauvegardes RMAN
-*Restaurations RMAN
-*Collecte d'indicateurs qui sont remontés sur le référentiel bdd [[SQWareRepository:oracle|SQWareRepository]]
-*Purge des logs
-*Collecte de rapports AWR qui sont remontés sur le référentiel bdd [[SQWareRepository:oracle|SQWareRepository]]
-*....
-}}
 == bin ==
-=== SqwArchmon ===
+=== sqwArchmon ===
-Script $gvsqw_OraBin/SqwArchmon:<br>
+Script $gvsqw_OraBin/bin/sqwArchmon:<br>
-Polling de sauvergarde par RMAN des archivelogs.<br>
+{{SQWareProduction_sqwArchmon_presentation}}
-[[SQWareProduction:oracle:bin:SqwArchmon|Voir l'aide détaillée pour SqwArchmon]]<br>
+[[SQWareProduction:oracle:bin:sqwArchmon|See the detailed help for sqwArchmon]]<br><br>
-<br>
+=== sqwArchmon.ksh ===
+Script $gvsqw_OraBin/bin/sqwArchmon.ksh:<br>
+{{SQWareProduction_sqwArchmon.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwArchmon.ksh|See the detailed help for sqwArchmon.ksh]]<br><br>
+=== sqwora_ActivateMonitoring.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_ActivateMonitoring.ksh:<br>
+{{SQWareProduction_sqwora_ActivateMonitoring.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_ActivateMonitoring.ksh|See the detailed help for sqwora_ActivateMonitoring.ksh]]<br><br>
+=== sqwora_CopyDmpdp.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_CopyDmpdp.ksh:<br>
+{{SQWareProduction_sqwora_CopyDmpdp.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_CopyDmpdp.ksh|See the detailed help for sqwora_CopyDmpdp.ksh]]<br><br>
+=== sqwora_DbmsStats.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_DbmsStats.ksh:<br>
+{{SQWareProduction_sqwora_DbmsStats.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_DbmsStats.ksh|See the detailed help for sqwora_DbmsStats.ksh]]<br><br>
+=== sqwora_ExecSQL.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_ExecSQL.ksh:<br>
+{{SQWareProduction_sqwora_ExecSQL.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_ExecSQL.ksh|See the detailed help for sqwora_ExecSQL.ksh]]<br><br>
-=== sqwora_CheckIndicators.ksh ===
+=== sqwora_ExpdpAllPDB.ksh ===
-Script $gvsqw_OraBin/sqwora_CheckIndicators.ksh:<br>
+Script $gvsqw_OraBin/bin/sqwora_ExpdpAllPDB.ksh:<br>
-Check des indicateurs DBA:
+{{SQWareProduction_sqwora_ExpdpAllPDB.ksh_presentation}}
-*Présence des indicateurs
+[[SQWareProduction:oracle:bin:sqwora_ExpdpAllPDB.ksh|See the detailed help for sqwora_ExpdpAllPDB.ksh]]<br><br>
-*Taux de remplissage des FS
-*Taux de remplissage des TBS
-*Présence de backups réussis
-*...
-[[SQWareProduction:oracle:bin:sqwora_CheckIndicators.ksh|Voir l'aide détaillée pour sqwora_CheckIndicators.ksh]]<br>
-<br>
-=== sqwora_CheckInstance.ksh ===
+=== sqwora_ExpdpAllSchemas.ksh ===
-Script $gvsqw_OraBin/bin/sqwora_CheckInstance.ksh:<br>
+Script $gvsqw_OraBin/bin/sqwora_ExpdpAllSchemas.ksh:<br>
-Check instance avec remontée des anomalies dans expdbDB:<br>
+{{SQWareProduction_sqwora_ExpdpAllSchemas.ksh_presentation}}
-*Droits systèmes
+[[SQWareProduction:oracle:bin:sqwora_ExpdpAllSchemas.ksh|See the detailed help for sqwora_ExpdpAllSchemas.ksh]]<br><br>
-*Objets non SYS/SYTEM dans TBS SYSTEM
-*Quotas dangeureux
-*Droits/Roles dangeureux ou trop forts
-*...
-[[SQWareProduction:oracle:bin:sqwora_CheckInstance.ksh|Voir l'aide détaillée pour sqwora_CheckInstance.ksh]]<br>
-<br>
-=== sqwora_SqwArchmon.ksh ===
+=== sqwora_Expdp.ksh ===
-Script $gvsqw_OraBin/bin/sqwora_SqwArchmon.ksh:<br>
+Script $gvsqw_OraBin/bin/sqwora_Expdp.ksh:<br>
-Permet de commander le polling SqwArchmon, accessible par l'alias edtarchmon:<br>
+{{SQWareProduction_sqwora_Expdp.ksh_presentation}}
-*edtarchmon stop
+[[SQWareProduction:oracle:bin:sqwora_Expdp.ksh|See the detailed help for sqwora_Expdp.ksh]]<br><br>
-*edtarchmon start
-*edtarchmon status
-*edtarchmon reload
-[[SQWareProduction:oracle:bin:sqwora_SqwArchmon.ksh|Voir l'aide détaillée pour sqwora_SqwArchmon.ksh]]<br>
-<br>
 === sqwora_Export.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_Export.ksh:<br>
-Permet de faire des exports (exp) de différents types (compressés ou pas):<br>
+{{SQWareProduction_sqwora_Export.ksh_presentation}}
-*full
+[[SQWareProduction:oracle:bin:sqwora_Export.ksh|See the detailed help for sqwora_Export.ksh]]<br><br>
-*schéma
-*structure
+=== sqwora_FailWithoutMail.ksh ===
-*parfile
+Script $gvsqw_OraBin/bin/sqwora_FailWithoutMail.ksh:<br>
-[[SQWareProduction:oracle:bin:sqwora_Export.ksh|Voir l'aide détaillée pour sqwora_Export.ksh]]<br>
+{{SQWareProduction_sqwora_FailWithoutMail.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_FailWithoutMail.ksh|See the detailed help for sqwora_FailWithoutMail.ksh]]<br><br>
+=== sqwora_GatherDistantFsSize.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_GatherDistantFsSize.ksh:<br>
+{{SQWareProduction_sqwora_GatherDistantFsSize.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_GatherDistantFsSize.ksh|See the detailed help for sqwora_GatherDistantFsSize.ksh]]<br><br>
 === sqwora_GatherIndicators.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_GatherIndicators.ksh:<br>
-Collecte un certain nombre d'indicateurs et les remonte dans SQWareRepository:<br>
+{{SQWareProduction_sqwora_GatherIndicators.ksh_presentation}}
-*Volumétrie et paramètres généreaux
+[[SQWareProduction:oracle:bin:sqwora_GatherIndicators.ksh|See the detailed help for sqwora_GatherIndicators.ksh]]<br><br>
-*Volumétrie par TBS
-*Volumétrie par FS
+=== sqwora_GatherStructure.ksh ===
-*Volumétrie par SCHEMA >= x Mo
+Script $gvsqw_OraBin/bin/sqwora_GatherStructure.ksh:<br>
-*Volumétrie par SEGMENTS >= y Mo
+{{SQWareProduction_sqwora_GatherStructure.ksh_presentation}}
-*...
+[[SQWareProduction:oracle:bin:sqwora_GatherStructure.ksh|See the detailed help for sqwora_GatherStructure.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_GatherIndicators.ksh|Voir l'aide détaillée pour sqwora_GatherIndicators.ksh]]<br>
-<br>
 === sqwora_GenerateAwr.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_GenerateAwr.ksh:<br>
-Génération automatique de rapports AWR entre dates définies avec remontée d'indicateurs dans SQWareRepository et accessibilité des rapports dans SQWareWeb:<br>
+{{SQWareProduction_sqwora_GenerateAwr.ksh_presentation}}
-*Rapports complets text+html
+[[SQWareProduction:oracle:bin:sqwora_GenerateAwr.ksh|See the detailed help for sqwora_GenerateAwr.ksh]]<br><br>
-*Résumé du rapport avec tops elapsed, CPU, Gets, Physicals, Execution
-*Rapports AWR par sql_id apparaissants dans le résumé
+=== sqwora_GenerateStatspack.ksh ===
-*...
+Script $gvsqw_OraBin/bin/sqwora_GenerateStatspack.ksh:<br>
-[[SQWareProduction:oracle:bin:sqwora_GenerateAwr.ksh|Voir l'aide détaillée pour sqwora_GenerateAwr.ksh]]<br>
+{{SQWareProduction_sqwora_GenerateStatspack.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_GenerateStatspack.ksh|See the detailed help for sqwora_GenerateStatspack.ksh]]<br><br>
+=== sqwora_Impdp.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_Impdp.ksh:<br>
+{{SQWareProduction_sqwora_Impdp.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_Impdp.ksh|See the detailed help for sqwora_Impdp.ksh]]<br><br>
+=== sqwora_MonitorWithAwr.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_MonitorWithAwr.ksh:<br>
+{{SQWareProduction_sqwora_MonitorWithAwr.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_MonitorWithAwr.ksh|See the detailed help for sqwora_MonitorWithAwr.ksh]]<br><br>
+=== sqwora_MonitorWithAwrLastStat.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_MonitorWithAwrLastStat.ksh:<br>
+{{SQWareProduction_sqwora_MonitorWithAwrLastStat.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_MonitorWithAwrLastStat.ksh|See the detailed help for sqwora_MonitorWithAwrLastStat.ksh]]<br><br>
+=== sqwora_MonitorWithStatspack.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_MonitorWithStatspack.ksh:<br>
+{{SQWareProduction_sqwora_MonitorWithStatspack.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_MonitorWithStatspack.ksh|See the detailed help for sqwora_MonitorWithStatspack.ksh]]<br><br>
+=== sqwora_NetBackup.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_NetBackup.ksh:<br>
+{{SQWareProduction_sqwora_NetBackup.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_NetBackup.ksh|See the detailed help for sqwora_NetBackup.ksh]]<br><br>
 === sqwora_ParallelRun.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_ParallelRun.ksh:<br>
-Permet l'exécution de commandes Unix mises dans un fichier en //<br>
+{{SQWareProduction_sqwora_ParallelRun.ksh_presentation}}
-Utilisé notamment dans les copies de backups pour clone d'environnement et dans bien d'autres cas ...<br>
+[[SQWareProduction:oracle:bin:sqwora_ParallelRun.ksh|See the detailed help for sqwora_ParallelRun.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_ParallelRun.ksh|Voir l'aide détaillée pour sqwora_ParallelRun.ksh]]<br>
-<br>
 === sqwora_PartialRefresh.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_PartialRefresh.ksh:<br>
-Permet le refresh partiel (d'une liste de tables) par exp/imp.<br>
+{{SQWareProduction_sqwora_PartialRefresh.ksh_presentation}}
-[[SQWareProduction:oracle:bin:sqwora_PartialRefresh.ksh|Voir l'aide détaillée pour sqwora_PartialRefresh.ksh]]<br>
+[[SQWareProduction:oracle:bin:sqwora_PartialRefresh.ksh|See the detailed help for sqwora_PartialRefresh.ksh]]<br><br>
-<br>
+=== sqwora_PhysicalColdBackup.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_PhysicalColdBackup.ksh:<br>
+{{SQWareProduction_sqwora_PhysicalColdBackup.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_PhysicalColdBackup.ksh|See the detailed help for sqwora_PhysicalColdBackup.ksh]]<br><br>
 === sqwora_PurgeAlert.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_PurgeAlert.ksh:<br>
-Archage/purge des fichiers de traces, logs, alerte, core, audit, ...<br>
+{{SQWareProduction_sqwora_PurgeAlert.ksh_presentation}}
-[[SQWareProduction:oracle:bin:sqwora_PurgeAlert.ksh|Voir l'aide détaillée pour sqwora_PurgeAlert.ksh]]<br>
+[[SQWareProduction:oracle:bin:sqwora_PurgeAlert.ksh|See the detailed help for sqwora_PurgeAlert.ksh]]<br><br>
-<br>
 === sqwora_RmanBackup.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_RmanBackup.ksh:<br>
-Gère les backups RMAN:<br>
+{{SQWareProduction_sqwora_RmanBackup.ksh_presentation}}
-*full/incrémentaux/log
+[[SQWareProduction:oracle:bin:sqwora_RmanBackup.ksh|See the detailed help for sqwora_RmanBackup.ksh]]<br><br>
-*hot/cold
-*gestion catalogue
-*gestion historiques
-*...
-[[SQWareProduction:oracle:bin:sqwora_RmanBackup.ksh|Voir l'aide détaillée pour sqwora_RmanBackup.ksh]]<br>
-<br>
 === sqwora_RmanClone.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_RmanClone.ksh:<br>
-Permet de faire des clones d'instances par RMAN.<br>
+{{SQWareProduction_sqwora_RmanClone.ksh_presentation}}
-[[SQWareProduction:oracle:bin:sqwora_RmanClone.ksh|Voir l'aide détaillée pour sqwora_RmanClone.ksh]]<br>
+[[SQWareProduction:oracle:bin:sqwora_RmanClone.ksh|See the detailed help for sqwora_RmanClone.ksh]]<br><br>
-<br>
+=== sqwora_RsyncBackup.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_RsyncBackup.ksh:<br>
+{{SQWareProduction_sqwora_RsyncBackup.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_RsyncBackup.ksh|See the detailed help for sqwora_RsyncBackup.ksh]]<br><br>
 === sqwora_RunJob.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_RunJob.ksh:<br>
-Lancement de jobs Oracle à partir des action paramétrées dans le fichier $gvsqw_RootAdmin/sqwora_Jobs.cfg, permet la gestion transparente des logs (compression/purge) et de décoréler le lancement de job de son paramétrage.<br>
+{{SQWareProduction_sqwora_RunJob.ksh_presentation}}
-[[SQWareProduction:oracle:bin:sqwora_RunJob.ksh|Voir l'aide détaillée pour sqwora_RunJob.ksh]]<br>
+[[SQWareProduction:oracle:bin:sqwora_RunJob.ksh|See the detailed help for sqwora_RunJob.ksh]]<br><br>
-<br>
+=== sqwora_SchemaRefreshExpdp.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_SchemaRefreshExpdp.ksh:<br>
+{{SQWareProduction_sqwora_SchemaRefreshExpdp.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_SchemaRefreshExpdp.ksh|See the detailed help for sqwora_SchemaRefreshExpdp.ksh]]<br><br>
 === sqwora_SchemaRefresh.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_SchemaRefresh.ksh:<br>
-Permet le rafraichissement de shéma par exp/imp.<br>
+{{SQWareProduction_sqwora_SchemaRefresh.ksh_presentation}}
-[[SQWareProduction:oracle:bin:sqwora_SchemaRefresh.ksh|Voir l'aide détaillée pour sqwora_SchemaRefresh.ksh]]<br>
+[[SQWareProduction:oracle:bin:sqwora_SchemaRefresh.ksh|See the detailed help for sqwora_SchemaRefresh.ksh]]<br><br>
-<br><br>
+=== sqwora_SqwArchmon.ksh ===
+Script $gvsqw_OraBin/bin/sqwora_SqwArchmon.ksh:<br>
+{{SQWareProduction_sqwora_SqwArchmon.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_SqwArchmon.ksh|See the detailed help for sqwora_SqwArchmon.ksh]]<br><br>
+<br>
 == etc ==
 === sqwora_Awr.cfg ===
-Fichier de configuration $gvsqw_OraBin/../etc/sqwora_Awr.cfg:<br>
+Configuration file $gvsqw_OraBin/../etc/sqwora_Awr.cfg:<br>
-config for AWR report generation
+{{SQWareProduction_sqwora_Awr.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_Awr.cfg|See the detailed help for sqwora_Awr.cfg]]<br><br>
+=== sqwora_CreDb_Create.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Create.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Create.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Create.cfg|See the detailed help for sqwora_CreDb_Create.cfg]]<br><br>
+=== sqwora_CreDb_CrontabRef.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_CrontabRef.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_CrontabRef.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_CrontabRef.cfg|See the detailed help for sqwora_CreDb_CrontabRef.cfg]]<br><br>
+=== sqwora_CreDb_Init_101.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_101.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Init_101.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_101.cfg|See the detailed help for sqwora_CreDb_Init_101.cfg]]<br><br>
+=== sqwora_CreDb_Init_102.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_102.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Init_102.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_102.cfg|See the detailed help for sqwora_CreDb_Init_102.cfg]]<br><br>
+=== sqwora_CreDb_Init_111.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_111.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Init_111.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_111.cfg|See the detailed help for sqwora_CreDb_Init_111.cfg]]<br><br>
+=== sqwora_CreDb_Init_112.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_112.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Init_112.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_112.cfg|See the detailed help for sqwora_CreDb_Init_112.cfg]]<br><br>
+=== sqwora_CreDb_Init_121.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_121.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Init_121.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_121.cfg|See the detailed help for sqwora_CreDb_Init_121.cfg]]<br><br>
+=== sqwora_CreDb_Init_122.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_122.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Init_122.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_122.cfg|See the detailed help for sqwora_CreDb_Init_122.cfg]]<br><br>
+=== sqwora_CreDb_Init_190.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_190.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Init_190.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_190.cfg|See the detailed help for sqwora_CreDb_Init_190.cfg]]<br><br>
+=== sqwora_CreDb_Init_210.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_210.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Init_210.cfg_presentation}}
 <br>
-{{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_Awr.cfg}}
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_210.cfg|See the detailed help for sqwora_CreDb_Init_210.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_Awr.cfg|Voir l'aide détaillée pour sqwora_Awr.cfg]]<br><br>
-=== sqwora_CreDb_*.cfg ===
+=== sqwora_CreDb_Jobs.cfg ===
-Fichiers de configuration $gvsqw_OraBin/../etc/sqwora_CreDb_*.cfg:<br>
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Jobs.cfg:<br>
-Templates servants à la génération des fichiers de configuration lors de la création d'une instance.<br>
+{{SQWareProduction_sqwora_CreDb_Jobs.cfg_presentation}}
-{{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_*.cfg}}
+<br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb.cfg|Voir l'aide détaillée pour sqwora_CreDb_*.cfg]]<br><br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Jobs.cfg|See the detailed help for sqwora_CreDb_Jobs.cfg]]<br><br>
-=== sqwora_DbRefVar.cfg ===
+=== sqwora_CreDb_Listener.cfg ===
-Fichier de configuration $gvsqw_OraBin/../etc/sqwora_DbRefVar.cfg:<br>
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Listener.cfg:<br>
-Il contient les variables de cponnexion à SQWareRepository pour SQWareProduction.<br>
+{{SQWareProduction_sqwora_CreDb_Listener.cfg_presentation}}
-{{SQWareProductionSurchargeVar|oracle|Ora|sqwora_DbRefVar.cfg}}
+<br>
-[[SQWareProduction:oracle:etc:sqwora_DbRefVar.cfg|Voir l'aide détaillée pour sqwora_DbRefVar.cfg]]<br><br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Listener.cfg|See the detailed help for sqwora_CreDb_Listener.cfg]]<br><br>
+=== sqwora_CreDb_Rman.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Rman.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Rman.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Rman.cfg|See the detailed help for sqwora_CreDb_Rman.cfg]]<br><br>
+=== sqwora_CreDb_Sqlnet.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Sqlnet.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Sqlnet.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Sqlnet.cfg|See the detailed help for sqwora_CreDb_Sqlnet.cfg]]<br><br>
+=== sqwora_CreDb_Tnsnames.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Tnsnames.cfg:<br>
+{{SQWareProduction_sqwora_CreDb_Tnsnames.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Tnsnames.cfg|See the detailed help for sqwora_CreDb_Tnsnames.cfg]]<br><br>
+=== sqwora_DbmsStats.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_DbmsStats.cfg:<br>
+{{SQWareProduction_sqwora_DbmsStats.cfg_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:sqwora_DbmsStats.cfg|See the detailed help for sqwora_DbmsStats.cfg]]<br><br>
 === sqwora_GlobalVar.cfg ===
-Fichier de configuration $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:<br>
+Configuration file $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg:<br>
-Il contient les variables globales au fonctionnement de SQWareProduction.<br>
+{{SQWareProduction_sqwora_GlobalVar.cfg_presentation}}
+<br>
 {{SQWareProductionSurchargeVar|oracle|Ora|sqwora_GlobalVar.cfg}}
-[[SQWareProduction:oracle:etc:sqwora_GlobalVar.cfg|Voir l'aide détaillée pour sqwora_GlobalVar.cfg]]<br><br>
+[[SQWareProduction:oracle:etc:sqwora_GlobalVar.cfg|See the detailed help for sqwora_GlobalVar.cfg]]<br><br>
+=== sqwora_IndicatorsVar.cfg ===
+Configuration file $gvsqw_OraBin/../etc/sqwora_IndicatorsVar.cfg:<br>
+{{SQWareProduction_sqwora_IndicatorsVar.cfg_presentation}}
+<br>
+{{SQWareProductionSurchargeVar|oracle|Ora|sqwora_IndicatorsVar.cfg}}
+[[SQWareProduction:oracle:etc:sqwora_IndicatorsVar.cfg|See the detailed help for sqwora_IndicatorsVar.cfg]]<br><br>
 === sqwora_Rman.cfg ===
-Fichier de configuration $gvsqw_OraBin/../etc/sqwora_Rman.cfg:<br>
+Configuration file $gvsqw_OraBin/../etc/sqwora_Rman.cfg:<br>
-Contient les variables servants aux différents scripts RMAN.<br>
+{{SQWareProduction_sqwora_Rman.cfg_presentation}}
-{{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_Rman.cfg}}
+<br>
-[[SQWareProduction:oracle:etc:sqwora_Rman.cfg|Voir l'aide détaillée pour sqwora_Rman.cfg]]<br><br>
+[[SQWareProduction:oracle:etc:sqwora_Rman.cfg|See the detailed help for sqwora_Rman.cfg]]<br><br>
 === sqwora_RmanClone.cfg ===
-Fichier de configuration $gvsqw_OraBin/../etc/sqwora_RmanClone.cfg:<br>
+Configuration file $gvsqw_OraBin/../etc/sqwora_RmanClone.cfg:<br>
-Contient les variables servant au script de clone RMAN.<br>
+{{SQWareProduction_sqwora_RmanClone.cfg_presentation}}
-{{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_RmanClone.cfg}}
+<br>
-[[SQWareProduction:oracle:etc:sqwora_RmanClone.cfg|Voir l'aide détaillée pour sqwora_RmanClone.cfg]]<br><br>
+[[SQWareProduction:oracle:etc:sqwora_RmanClone.cfg|See the detailed help for sqwora_RmanClone.cfg]]<br><br>
+=== tnsnames.ora ===
+Configuration file $gvsqw_OraBin/../etc/tnsnames.ora:<br>
+{{SQWareProduction_tnsnames.ora_presentation}}
+<br>
+[[SQWareProduction:oracle:etc:tnsnames.ora|See the detailed help for tnsnames.ora]]<br><br>
 === .profile ===
-Fichier d'exemple $gvsqw_OraBin/../etc/.profile:<br>
+Sample file for .profile $gvsqw_OraBin/../etc/.profile:<br>
-Exemple de .profile pour un user propriétaire d'une instance Oracle.<br>
+Sample of lines to add to .profile of oracle users.<br>
-[[SQWareProduction:oracle:etc:.profile|Voir l'aide détaillée pour .profile]]<br><br>
+[[SQWareProduction:oracle:etc:.profile|See the detailed help for .profile]]<br>
 === .profile_confort ===
-Fichier de positionnement d'alias $gvsqw_OraBin/../etc/.profile_confort:<br>
+File to put aliases $gvsqw_OraBin/../etc/.profile_confort:<br>
-Variables et alias de confort pour le user unix.
+Contains confort aliases of SQWareProduction for oracle.<br>
 {{SQWareProductionSurchargeConfort|oracle|Ora}}
-[[SQWareProduction:oracle:etc:.profile_confort|Voir l'aide détaillée pour .profile_confort]]<br>
+<br>
+[[SQWareProduction:oracle:etc:.profile_confort|See the detailed help for .profile_confort]]<br><br>
-<br><br>
+<br>
 == lib ==
-=== sqwora_CheckIndicators.lib ===
+=== sqwora_ActivateMonitoring.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_CheckIndicators.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_ActivateMonitoring.lib:<br>
-Lib pour le script sqwora_CheckIndicators.ksh
+{{SQWareProduction_sqwora_ActivateMonitoring.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_ActivateMonitoring.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_ActivateMonitoring.lib|See the detailed help for sqwora_ActivateMonitoring.lib]]<br><br>
+=== sqwora_CopyDmpdp.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_CopyDmpdp.lib:<br>
+{{SQWareProduction_sqwora_CopyDmpdp.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_CopyDmpdp.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_CopyDmpdp.lib|See the detailed help for sqwora_CopyDmpdp.lib]]<br><br>
+=== sqwora_DbmsStats.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_DbmsStats.lib:<br>
+{{SQWareProduction_sqwora_DbmsStats.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_DbmsStats.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_CheckIndicators.lib}}
+[[SQWareProduction:oracle:lib:sqwora_DbmsStats.lib|See the detailed help for sqwora_DbmsStats.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_CheckIndicators.lib|Voir l'aide détaillée pour sqwora_CheckIndicators.lib]]<br><br>
-=== sqwora_CheckIndicators_Overload.lib ===
+=== sqwora_ExecSQL.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_CheckIndicators_Overload.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_ExecSQL.lib:<br>
-template lib de surcharge pour le script sqwora_CheckIndicators.ksh
+{{SQWareProduction_sqwora_ExecSQL.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_ExecSQL.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_CheckIndicators_Overload.lib}}
+[[SQWareProduction:oracle:lib:sqwora_ExecSQL.lib|See the detailed help for sqwora_ExecSQL.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_CheckIndicators_Overload.lib|Voir l'aide détaillée pour sqwora_CheckIndicators_Overload.lib]]<br><br>
-=== sqwora_CheckInstance.lib ===
+=== sqwora_ExpdpAllPDB.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_CheckInstance.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_ExpdpAllPDB.lib:<br>
-Lib pour le script sqwora_CheckInstance.ksh
+{{SQWareProduction_sqwora_ExpdpAllPDB.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_ExpdpAllPDB.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_CheckInstance.lib}}
+[[SQWareProduction:oracle:lib:sqwora_ExpdpAllPDB.lib|See the detailed help for sqwora_ExpdpAllPDB.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_CheckInstance.lib|Voir l'aide détaillée pour sqwora_CheckInstance.lib]]<br><br>
-=== sqwora_CheckInstance_Overload.lib ===
+=== sqwora_ExpdpAllSchemas.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_CheckInstance_Overload.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_ExpdpAllSchemas.lib:<br>
-Lib pour surcharge du script sqwora_CheckInstance.ksh
+{{SQWareProduction_sqwora_ExpdpAllSchemas.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_ExpdpAllSchemas.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_CheckInstance_Overload.lib}}
+[[SQWareProduction:oracle:lib:sqwora_ExpdpAllSchemas.lib|See the detailed help for sqwora_ExpdpAllSchemas.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_CheckInstance_Overload.lib|Voir l'aide détaillée pour sqwora_CheckInstance_Overload.lib]]<br><br>
+=== sqwora_Expdp.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_Expdp.lib:<br>
+{{SQWareProduction_sqwora_Expdp.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_Expdp.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_Expdp.lib|See the detailed help for sqwora_Expdp.lib]]<br><br>
+=== sqwora_Export.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_Export.lib:<br>
+{{SQWareProduction_sqwora_Export.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_Export.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_Export.lib|See the detailed help for sqwora_Export.lib]]<br><br>
+=== sqwora_FixAwrPart.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_FixAwrPart.lib:<br>
+{{SQWareProduction_sqwora_FixAwrPart.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_FixAwrPart.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_FixAwrPart.lib|See the detailed help for sqwora_FixAwrPart.lib]]<br><br>
+=== sqwora_GatherDistantFsSize.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_GatherDistantFsSize.lib:<br>
+{{SQWareProduction_sqwora_GatherDistantFsSize.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GatherDistantFsSize.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_GatherDistantFsSize.lib|See the detailed help for sqwora_GatherDistantFsSize.lib]]<br><br>
 === sqwora_GatherIndicators.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_GatherIndicators.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_GatherIndicators.lib:<br>
-Lib pour le script sqwora_GatherIndicators.ksh
+{{SQWareProduction_sqwora_GatherIndicators.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GatherIndicators.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GatherIndicators.lib}}
+[[SQWareProduction:oracle:lib:sqwora_GatherIndicators.lib|See the detailed help for sqwora_GatherIndicators.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_GatherIndicators.lib|Voir l'aide détaillée pour sqwora_GatherIndicators.lib]]<br><br>
 === sqwora_GatherIndicators_Overload.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_GatherIndicators_Overload.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_GatherIndicators_Overload.lib:<br>
-Lib pour surcharge du script sqwora_GatherIndicators.ksh
+{{SQWareProduction_sqwora_GatherIndicators_Overload.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GatherIndicators_Overload.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GatherIndicators_Overload.lib}}
+[[SQWareProduction:oracle:lib:sqwora_GatherIndicators_Overload.lib|See the detailed help for sqwora_GatherIndicators_Overload.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_GatherIndicators_Overload.lib|Voir l'aide détaillée pour sqwora_GatherIndicators_Overload.lib]]<br><br>
+=== sqwora_GatherStructure.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_GatherStructure.lib:<br>
+{{SQWareProduction_sqwora_GatherStructure.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GatherStructure.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_GatherStructure.lib|See the detailed help for sqwora_GatherStructure.lib]]<br><br>
 === sqwora_GenerateAwr.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_GenerateAwr.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_GenerateAwr.lib:<br>
-Lib pour le script sqwora_GenerateAwr.ksh
+{{SQWareProduction_sqwora_GenerateAwr.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GenerateAwr.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_GenerateAwr.lib|See the detailed help for sqwora_GenerateAwr.lib]]<br><br>
+=== sqwora_GenerateCreateInstance.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_GenerateCreateInstance.lib:<br>
+{{SQWareProduction_sqwora_GenerateCreateInstance.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GenerateCreateInstance.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_GenerateCreateInstance.lib|See the detailed help for sqwora_GenerateCreateInstance.lib]]<br><br>
+=== sqwora_GenerateStatspack.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_GenerateStatspack.lib:<br>
+{{SQWareProduction_sqwora_GenerateStatspack.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GenerateStatspack.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GenerateAwr.lib}}
+[[SQWareProduction:oracle:lib:sqwora_GenerateStatspack.lib|See the detailed help for sqwora_GenerateStatspack.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_GenerateAwr.lib|Voir l'aide détaillée pour sqwora_GenerateAwr.lib]]<br><br>
-=== sqwora_GenerateCreateDatabase.lib ===
+=== sqwora_GenericRefresh.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_GenerateCreateDatabase.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_GenericRefresh.lib:<br>
-Lib pour le script sqwora_GenerateCreateDatabase.ksh<br>
+{{SQWareProduction_sqwora_GenericRefresh.lib_presentation}}
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GenerateCreateDatabase.lib}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GenericRefresh.lib}}
-[[SQWareProduction:oracle:lib:sqwora_GenerateCreateDatabase.lib|Voir l'aide détaillée pour sqwora_GenerateCreateDatabase.lib]]<br><br>
+<br>
+[[SQWareProduction:oracle:lib:sqwora_GenericRefresh.lib|See the detailed help for sqwora_GenericRefresh.lib]]<br><br>
 === sqwora_Global.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_Global.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_Global.lib:<br>
-Lib centrale pour l'ensemble des scripts.<br>
+{{SQWareProduction_sqwora_Global.lib_presentation}}
-[[SQWareProduction:oracle:lib:sqwora_Global.lib|Voir l'aide détaillée pour sqwora_Global.lib]]<br><br>
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_Global.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_Global.lib|See the detailed help for sqwora_Global.lib]]<br><br>
-=== sqwora_InsertIndicators.lib ===
+=== sqwora_Impdp.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_InsertIndicators.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_Impdp.lib:<br>
-Lib générique de fonctions pour insert des indicateurs dans SQWareRepository.
+{{SQWareProduction_sqwora_Impdp.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_Impdp.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_InsertIndicators.lib}}
+[[SQWareProduction:oracle:lib:sqwora_Impdp.lib|See the detailed help for sqwora_Impdp.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_InsertIndicators.lib|Voir l'aide détaillée pour sqwora_InsertIndicators.lib]]<br><br>
+=== sqwora_ManageStatspack.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_ManageStatspack.lib:<br>
+{{SQWareProduction_sqwora_ManageStatspack.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_ManageStatspack.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_ManageStatspack.lib|See the detailed help for sqwora_ManageStatspack.lib]]<br><br>
+=== sqwora_MenuRman.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_MenuRman.lib:<br>
+{{SQWareProduction_sqwora_MenuRman.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_MenuRman.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_MenuRman.lib|See the detailed help for sqwora_MenuRman.lib]]<br><br>
+=== sqwora_ModifyAutoextendDBF.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_ModifyAutoextendDBF.lib:<br>
+{{SQWareProduction_sqwora_ModifyAutoextendDBF.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_ModifyAutoextendDBF.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_ModifyAutoextendDBF.lib|See the detailed help for sqwora_ModifyAutoextendDBF.lib]]<br><br>
+=== sqwora_MonitorArchives.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_MonitorArchives.lib:<br>
+{{SQWareProduction_sqwora_MonitorArchives.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_MonitorArchives.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_MonitorArchives.lib|See the detailed help for sqwora_MonitorArchives.lib]]<br><br>
+=== sqwora_MonitorWithAwrLastStat.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_MonitorWithAwrLastStat.lib:<br>
+{{SQWareProduction_sqwora_MonitorWithAwrLastStat.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_MonitorWithAwrLastStat.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_MonitorWithAwrLastStat.lib|See the detailed help for sqwora_MonitorWithAwrLastStat.lib]]<br><br>
+=== sqwora_MonitorWithAwr.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_MonitorWithAwr.lib:<br>
+{{SQWareProduction_sqwora_MonitorWithAwr.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_MonitorWithAwr.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_MonitorWithAwr.lib|See the detailed help for sqwora_MonitorWithAwr.lib]]<br><br>
+=== sqwora_MonitorWithStatspack.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_MonitorWithStatspack.lib:<br>
+{{SQWareProduction_sqwora_MonitorWithStatspack.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_MonitorWithStatspack.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_MonitorWithStatspack.lib|See the detailed help for sqwora_MonitorWithStatspack.lib]]<br><br>
+=== sqwora_NetBackup.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_NetBackup.lib:<br>
+{{SQWareProduction_sqwora_NetBackup.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_NetBackup.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_NetBackup.lib|See the detailed help for sqwora_NetBackup.lib]]<br><br>
+=== sqwora_PartialRefresh.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_PartialRefresh.lib:<br>
+{{SQWareProduction_sqwora_PartialRefresh.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_PartialRefresh.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_PartialRefresh.lib|See the detailed help for sqwora_PartialRefresh.lib]]<br><br>
+=== sqwora_PhysicalColdBackup.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_PhysicalColdBackup.lib:<br>
+{{SQWareProduction_sqwora_PhysicalColdBackup.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_PhysicalColdBackup.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_PhysicalColdBackup.lib|See the detailed help for sqwora_PhysicalColdBackup.lib]]<br><br>
+=== sqwora_PurgeAlert.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_PurgeAlert.lib:<br>
+{{SQWareProduction_sqwora_PurgeAlert.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_PurgeAlert.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_PurgeAlert.lib|See the detailed help for sqwora_PurgeAlert.lib]]<br><br>
 === sqwora_RmanBackup.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_RmanBackup.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_RmanBackup.lib:<br>
-Lib pour le script sqwora_RmanBackup.ksh
+{{SQWareProduction_sqwora_RmanBackup.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_RmanBackup.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_RmanBackup.lib}}
+[[SQWareProduction:oracle:lib:sqwora_RmanBackup.lib|See the detailed help for sqwora_RmanBackup.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_RmanBackup.lib|Voir l'aide détaillée pour sqwora_RmanBackup.lib]]<br><br>
 === sqwora_RmanClone.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_RmanClone.lib:<br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_RmanClone.lib:<br>
-Lib pour le script sqwora_RmanClone.ksh.
+{{SQWareProduction_sqwora_RmanClone.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_RmanClone.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_RmanClone.lib}}
+[[SQWareProduction:oracle:lib:sqwora_RmanClone.lib|See the detailed help for sqwora_RmanClone.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_RmanClone.lib|Voir l'aide détaillée pour sqwora_RmanClone.lib]]<br><br>
+=== sqwora_RsyncBackup.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_RsyncBackup.lib:<br>
+{{SQWareProduction_sqwora_RsyncBackup.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_RsyncBackup.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_RsyncBackup.lib|See the detailed help for sqwora_RsyncBackup.lib]]<br><br>
+=== sqwora_SchemaRefreshExpdp.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_SchemaRefreshExpdp.lib:<br>
+{{SQWareProduction_sqwora_SchemaRefreshExpdp.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_SchemaRefreshExpdp.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_SchemaRefreshExpdp.lib|See the detailed help for sqwora_SchemaRefreshExpdp.lib]]<br><br>
+=== sqwora_SchemaRefresh.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_SchemaRefresh.lib:<br>
+{{SQWareProduction_sqwora_SchemaRefresh.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_SchemaRefresh.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_SchemaRefresh.lib|See the detailed help for sqwora_SchemaRefresh.lib]]<br><br>
 === sqwora_SetEnv.lib ===
-Librairie de fonctions shell $gvsqw_OraBin/../lib/sqwora_SetEnv.lib:<br><br>
+shell functions library $gvsqw_OraBin/../lib/sqwora_SetEnv.lib:<br>
-Lib de positionnement de l'environnement pour $ORACLE_SID.
+{{SQWareProduction_sqwora_SetEnv.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_SetEnv.lib}}
 <br>
-{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_SetEnv.lib}}
+[[SQWareProduction:oracle:lib:sqwora_SetEnv.lib|See the detailed help for sqwora_SetEnv.lib]]<br><br>
-[[SQWareProduction:oracle:lib:sqwora_SetEnv.lib|Voir l'aide détaillée pour sqwora_SetEnv.lib]]<br>
+=== sqwora_Wallet.lib ===
+shell functions library $gvsqw_OraBin/../lib/sqwora_Wallet.lib:<br>
+{{SQWareProduction_sqwora_Wallet.lib_presentation}}
+{{SQWareProductionSurchargeLib|oracle|Ora|sqwora_Wallet.lib}}
+<br>
+[[SQWareProduction:oracle:lib:sqwora_Wallet.lib|See the detailed help for sqwora_Wallet.lib]]<br><br>
-<br><br>
+<br>
 == menu ==
 === sqwora_MenuRman.ksh ===
 Menu $gvsqw_OraBin/../menu/sqwora_MenuRman.ksh:<br>
-menu for RMAN commands
+{{SQWareProduction_sqwora_MenuRman.ksh_presentation}}
+[[SQWareProduction:oracle:menu:sqwora_MenuRman.ksh|See the detailed help for sqwora_MenuRman.ksh]]<br><br>
 <br>
-[[SQWareProduction:oracle:menu:sqwora_MenuRman.ksh|Voir l'aide détaillée pour sqwora_MenuRman.ksh]]<br>
-<br><br>
+== tools ==
+=== sql ===
+Script $gvsqw_OraBin/../tools/sql:<br>
+{{SQWareProduction_sql_presentation}}
+[[SQWareProduction:oracle:tools:sql|See the detailed help for sql]]<br><br>
+=== sqwora_BackupPasswd.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_BackupPasswd.ksh:<br>
+{{SQWareProduction_sqwora_BackupPasswd.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_BackupPasswd.ksh|See the detailed help for sqwora_BackupPasswd.ksh]]<br><br>
+=== sqwora_Crypt.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_Crypt.ksh:<br>
+{{SQWareProduction_sqwora_Crypt.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_Crypt.ksh|See the detailed help for sqwora_Crypt.ksh]]<br><br>
+=== sqwora_ExecASMCommand.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_ExecASMCommand.ksh:<br>
+{{SQWareProduction_sqwora_ExecASMCommand.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_ExecASMCommand.ksh|See the detailed help for sqwora_ExecASMCommand.ksh]]<br><br>
+=== sqwora_FixAwrPart.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_FixAwrPart.ksh:<br>
+{{SQWareProduction_sqwora_FixAwrPart.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_FixAwrPart.ksh|See the detailed help for sqwora_FixAwrPart.ksh]]<br><br>
+=== sqwora_GenerateCreateInstance.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_GenerateCreateInstance.ksh:<br>
+{{SQWareProduction_sqwora_GenerateCreateInstance.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_GenerateCreateInstance.ksh|See the detailed help for sqwora_GenerateCreateInstance.ksh]]<br><br>
+=== sqwora_GetAlertFile.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_GetAlertFile.ksh:<br>
+{{SQWareProduction_sqwora_GetAlertFile.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_GetAlertFile.ksh|See the detailed help for sqwora_GetAlertFile.ksh]]<br><br>
+=== sqwora_ListAsyncFilesGlobal.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_ListAsyncFilesGlobal.ksh:<br>
+{{SQWareProduction_sqwora_ListAsyncFilesGlobal.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_ListAsyncFilesGlobal.ksh|See the detailed help for sqwora_ListAsyncFilesGlobal.ksh]]<br><br>
+=== sqwora_ListAsyncFiles.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_ListAsyncFiles.ksh:<br>
+{{SQWareProduction_sqwora_ListAsyncFiles.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_ListAsyncFiles.ksh|See the detailed help for sqwora_ListAsyncFiles.ksh]]<br><br>
+=== sqwora_ManageOracle.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_ManageOracle.ksh:<br>
+{{SQWareProduction_sqwora_ManageOracle.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_ManageOracle.ksh|See the detailed help for sqwora_ManageOracle.ksh]]<br><br>
+=== sqwora_ManageStatspack.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_ManageStatspack.ksh:<br>
+{{SQWareProduction_sqwora_ManageStatspack.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_ManageStatspack.ksh|See the detailed help for sqwora_ManageStatspack.ksh]]<br><br>
-== tools ==
+=== sqwora_ModifyAutoextendDBF.ksh ===
-=== sqwora_GenerateCreateDatabase.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_ModifyAutoextendDBF.ksh:<br>
-Script $gvsqw_OraBin/../tools/sqwora_GenerateCreateDatabase.ksh:<br>
+{{SQWareProduction_sqwora_ModifyAutoextendDBF.ksh_presentation}}
-Generate create database files
+[[SQWareProduction:oracle:tools:sqwora_ModifyAutoextendDBF.ksh|See the detailed help for sqwora_ModifyAutoextendDBF.ksh]]<br><br>
-<br>
-[[SQWareProduction:oracle:tools:sqwora_GenerateCreateDatabase.ksh|Voir l'aide détaillée pour sqwora_GenerateCreateDatabase.ksh]]<br>
 === sqwora_RmanConfigure.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_RmanConfigure.ksh:<br>
-default paraters for RMAN and block change tracking
+{{SQWareProduction_sqwora_RmanConfigure.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:tools:sqwora_RmanConfigure.ksh|See the detailed help for sqwora_RmanConfigure.ksh]]<br><br>
-[[SQWareProduction:oracle:tools:sqwora_RmanConfigure.ksh|Voir l'aide détaillée pour sqwora_RmanConfigure.ksh]]<br>
 === sqwora_RmanCrosscheck.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_RmanCrosscheck.ksh:<br>
-Crosscheck and delete expired RMAN
+{{SQWareProduction_sqwora_RmanCrosscheck.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:tools:sqwora_RmanCrosscheck.ksh|See the detailed help for sqwora_RmanCrosscheck.ksh]]<br><br>
-[[SQWareProduction:oracle:tools:sqwora_RmanCrosscheck.ksh|Voir l'aide détaillée pour sqwora_RmanCrosscheck.ksh]]<br>
+=== sqwora_RmanDeleteObsolete.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_RmanDeleteObsolete.ksh:<br>
+{{SQWareProduction_sqwora_RmanDeleteObsolete.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_RmanDeleteObsolete.ksh|See the detailed help for sqwora_RmanDeleteObsolete.ksh]]<br><br>
 === sqwora_RmanRegister.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_RmanRegister.ksh:<br>
-default paraters for RMAN and block change tracking
+{{SQWareProduction_sqwora_RmanRegister.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:tools:sqwora_RmanRegister.ksh|See the detailed help for sqwora_RmanRegister.ksh]]<br><br>
-[[SQWareProduction:oracle:tools:sqwora_RmanRegister.ksh|Voir l'aide détaillée pour sqwora_RmanRegister.ksh]]<br>
 === sqwora_SetEnv.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_SetEnv.ksh:<br>
-set env for $ORACLE_SID
+{{SQWareProduction_sqwora_SetEnv.ksh_presentation}}
 <br>
 {{SQWareProductionSurchargeToo|oracle|Ora|sqwora_SetEnv.ksh}}
+[[SQWareProduction:oracle:tools:sqwora_SetEnv.ksh|See the detailed help for sqwora_SetEnv.ksh]]<br><br>
+=== sqwora_SetEnv_oratab.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_SetEnv_oratab.ksh:<br>
+{{SQWareProduction_sqwora_SetEnv_oratab.ksh_presentation}}
 <br>
-[[SQWareProduction:oracle:tools:sqwora_SetEnv.ksh|Voir l'aide détaillée pour sqwora_SetEnv.ksh]]<br>
+{{SQWareProductionSurchargeToo|oracle|Ora|sqwora_SetEnv_oratab.ksh}}
+[[SQWareProduction:oracle:tools:sqwora_SetEnv_oratab.ksh|See the detailed help for sqwora_SetEnv_oratab.ksh]]<br><br>
+=== sqwora_SetEnv_RACASM_oratab.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_SetEnv_RACASM_oratab.ksh:<br>
+{{SQWareProduction_sqwora_SetEnv_RACASM_oratab.ksh_presentation}}
+<br>
+{{SQWareProductionSurchargeToo|oracle|Ora|sqwora_SetEnv_RACASM_oratab.ksh}}
+[[SQWareProduction:oracle:tools:sqwora_SetEnv_RACASM_oratab.ksh|See the detailed help for sqwora_SetEnv_RACASM_oratab.ksh]]<br><br>
 === sqwora_Spm.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_Spm.ksh:<br>
-Sqlplus tools
+{{SQWareProduction_sqwora_Spm.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_Spm.ksh|See the detailed help for sqwora_Spm.ksh]]<br><br>
+=== sqwora_TestInstConnection.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_TestInstConnection.ksh:<br>
+{{SQWareProduction_sqwora_TestInstConnection.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_TestInstConnection.ksh|See the detailed help for sqwora_TestInstConnection.ksh]]<br><br>
+=== sqwora_TestMySQL.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_TestMySQL.ksh:<br>
+{{SQWareProduction_sqwora_TestMySQL.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_TestMySQL.ksh|See the detailed help for sqwora_TestMySQL.ksh]]<br><br>
+=== sqwora_TestSendmail.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_TestSendmail.ksh:<br>
+{{SQWareProduction_sqwora_TestSendmail.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_TestSendmail.ksh|See the detailed help for sqwora_TestSendmail.ksh]]<br><br>
+=== sqwora_Uncrypt.ksh ===
+Script $gvsqw_OraBin/../tools/sqwora_Uncrypt.ksh:<br>
+{{SQWareProduction_sqwora_Uncrypt.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_Uncrypt.ksh|See the detailed help for sqwora_Uncrypt.ksh]]<br><br>
 <br>
-[[SQWareProduction:oracle:tools:sqwora_Spm.ksh|Voir l'aide détaillée pour sqwora_Spm.ksh]]<br>
+== help ==
+Contains help files for "-s" option of bin scripts.<br>
 <br><br>
 == spm ==
-Ensemble de requêtes sql usuelles déjà écrites<br>
+SQL query toolkit<br>
-[[SQWareProduction:oracle:spm|Voir l'aide détaillée pour spm]]<br>
+[[SQWareProduction:oracle:spm|See the detailed help for spm]]<br>
-<br><br>
+<br>

Difference between revisions of "SQWareProduction:oracle"

Latest revision as of 09:58, 18 December 2023

Contents

Presentation

Usage

Explanation of directories

Naming convention of files

Naming convention in scripts

bin

sqwArchmon

sqwArchmon.ksh

sqwora_ActivateMonitoring.ksh

sqwora_CopyDmpdp.ksh

sqwora_DbmsStats.ksh

sqwora_ExecSQL.ksh

sqwora_ExpdpAllPDB.ksh

sqwora_ExpdpAllSchemas.ksh

sqwora_Expdp.ksh

sqwora_Export.ksh

sqwora_FailWithoutMail.ksh

sqwora_GatherDistantFsSize.ksh

sqwora_GatherIndicators.ksh

sqwora_GatherStructure.ksh

sqwora_GenerateAwr.ksh

sqwora_GenerateStatspack.ksh

sqwora_Impdp.ksh

sqwora_MonitorWithAwr.ksh

sqwora_MonitorWithAwrLastStat.ksh

sqwora_MonitorWithStatspack.ksh

sqwora_NetBackup.ksh

sqwora_ParallelRun.ksh

sqwora_PartialRefresh.ksh

sqwora_PhysicalColdBackup.ksh

sqwora_PurgeAlert.ksh

sqwora_RmanBackup.ksh

sqwora_RmanClone.ksh

sqwora_RsyncBackup.ksh

sqwora_RunJob.ksh

sqwora_SchemaRefreshExpdp.ksh

sqwora_SchemaRefresh.ksh

sqwora_SqwArchmon.ksh

etc

sqwora_Awr.cfg

sqwora_CreDb_Create.cfg

sqwora_CreDb_CrontabRef.cfg

sqwora_CreDb_Init_101.cfg

sqwora_CreDb_Init_102.cfg

sqwora_CreDb_Init_111.cfg

sqwora_CreDb_Init_112.cfg

sqwora_CreDb_Init_121.cfg

sqwora_CreDb_Init_122.cfg

sqwora_CreDb_Init_190.cfg

sqwora_CreDb_Init_210.cfg

sqwora_CreDb_Jobs.cfg

sqwora_CreDb_Listener.cfg

sqwora_CreDb_Rman.cfg

sqwora_CreDb_Sqlnet.cfg

sqwora_CreDb_Tnsnames.cfg

sqwora_DbmsStats.cfg

sqwora_GlobalVar.cfg

sqwora_IndicatorsVar.cfg

sqwora_Rman.cfg

sqwora_RmanClone.cfg

tnsnames.ora

.profile

.profile_confort

lib

sqwora_ActivateMonitoring.lib

sqwora_CopyDmpdp.lib

sqwora_DbmsStats.lib

sqwora_ExecSQL.lib

sqwora_ExpdpAllPDB.lib

sqwora_ExpdpAllSchemas.lib

sqwora_Expdp.lib

sqwora_Export.lib

sqwora_FixAwrPart.lib

sqwora_GatherDistantFsSize.lib

sqwora_GatherIndicators.lib

sqwora_GatherIndicators_Overload.lib

sqwora_GatherStructure.lib