Difference between revisions of "SQWareProduction:oracle"

Revision as of 19:04, 18 December 2010

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

sqwora_CheckIndicators.ksh

Script $gvsqw_OraBin/bin/sqwora_CheckIndicators.ksh:

Checks the indicators collected by sqwora_GatherIndicators.ksh
indicators are stored in SQWareRepository
generates email in html format with links to SQWareWeb
Standards checks:

Instances without indicators
Usage rate of tablespaces
Usage rate of FS
Instances without backup full succeed since ${gvsqw_NbDaysFull} days
Instances without backup inc succeed since ${gvsqw_NbDaysInc} days

See the detailed help for sqwora_CheckIndicators.ksh

sqwora_CheckInstance.ksh

Script $gvsqw_OraBin/bin/sqwora_CheckInstance.ksh:

Check instance (security, parameters, ...)
Results can be put in SQWareRepository
Summary of checks:

Unusable indexes
Recovery Objects in default TBS of instance (prevents partial clone recovery)
Useless quotas (TEMPORARY, ...)
Users objects in SYSTEM TBS
System objects not in SYSTEM TBS
Users with SYSTEM default tablespace
Users with admin role ganted ('DBA', 'IMP_FULL_DATABASE')
Users with deprecated role ganted ('RESOURCE', 'CONNECT')
Users with system privileges ganted ('UNLIMITED TABLESPACE','DROP USER','ALTER SYSTEM')
Users with ANY privileges ganted (like '% ANY%', 'SELECT ANY DICTIONARY')
Dangerous quotas (SYSTEM, default TBS of instance)
Dangerous init parameters ('remote_os_authent','remote_os_roles','O7_DICTIONARY_ACCESSIBILITY')
Plubic execute privilege on ('UTL_TCP','UTL_FILE','UTL_HTTP','UTL_SMTP','DBMS_LOB','DBMS_SQL','DBMS_SCHEDULER','OWA_UTIL')

See the detailed help for sqwora_CheckInstance.ksh

sqwora_SqwArchmon.ksh

Script $gvsqw_OraBin/bin/sqwora_SqwArchmon.ksh:

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

etc

sqwora_Awr.cfg

Configuration file $gvsqw_OraBin/../etc/sqwora_Awr.cfg:
config for AWR report generation

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_Awr.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_Awr.cfg for all your environnement
or by $HOME/edtConfig/sqwora_Awr.cfg specifically for this user..

See the detailed help for sqwora_Awr.cfg

sqwora_CreDb_Create.cfg

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Create.cfg:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_Create.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_Create.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_Create.cfg specifically for this user..

See the detailed help for sqwora_CreDb_Create.cfg

sqwora_CreDb_CrontabRef.cfg

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_CrontabRef.cfg:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_CrontabRef.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_CrontabRef.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_CrontabRef.cfg specifically for this user..

See the detailed help for sqwora_CreDb_CrontabRef.cfg

sqwora_CreDb_Init_101.cfg

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_101.cfg:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_101.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_Init_101.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_Init_101.cfg specifically for this user..

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:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_102.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_Init_102.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_Init_102.cfg specifically for this user..

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:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_111.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_Init_111.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_Init_111.cfg specifically for this user..

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:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_Init_112.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_Init_112.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_Init_112.cfg specifically for this user..

See the detailed help for sqwora_CreDb_Init_112.cfg

sqwora_CreDb_Jobs.cfg

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Jobs.cfg:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_Jobs.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_Jobs.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_Jobs.cfg specifically for this user..

See the detailed help for sqwora_CreDb_Jobs.cfg

sqwora_CreDb_Listener.cfg

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Listener.cfg:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_Listener.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_Listener.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_Listener.cfg specifically for this user..

See the detailed help for sqwora_CreDb_Listener.cfg

sqwora_CreDb_Rman.cfg

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Rman.cfg:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_Rman.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_Rman.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_Rman.cfg specifically for this user..

See the detailed help for sqwora_CreDb_Rman.cfg

sqwora_CreDb_Tnsnames.cfg

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Tnsnames.cfg:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_CreDb_Tnsnames.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_CreDb_Tnsnames.cfg for all your environnement
or by $HOME/edtConfig/sqwora_CreDb_Tnsnames.cfg specifically for this user..

See the detailed help for sqwora_CreDb_Tnsnames.cfg

sqwora_DbRefVar.cfg

Configuration file $gvsqw_OraBin/../etc/sqwora_DbRefVar.cfg:
Global var for indicators
It contains the operating variables of SQWareProduction.

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

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

See the detailed help for sqwora_DbRefVar.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 replace file $gvsqw_OraBin/../etc/sqwora_IndicatorsVar.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_IndicatorsVar.cfg for all your environnement
or by $HOME/edtConfig/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:

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_Rman.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_Rman.cfg for all your environnement
or by $HOME/edtConfig/sqwora_Rman.cfg specifically for this user..

See the detailed help for sqwora_Rman.cfg

sqwora_RmanClone.cfg

Configuration file $gvsqw_OraBin/../etc/sqwora_RmanClone.cfg:
var for RMAN duplicate scripts

Note:
You can replace file $gvsqw_OraBin/../etc/sqwora_RmanClone.cfg

by $gvsqw_OraBin/../etc_cust/sqwora_RmanClone.cfg for all your environnement
or by $HOME/edtConfig/sqwora_RmanClone.cfg specifically for this user..

See the detailed help for sqwora_RmanClone.cfg

tnsnames.ora

Configuration file $gvsqw_OraBin/../etc/tnsnames.ora:
template for sqw tnsnames.ora

Note:
You can replace file $gvsqw_OraBin/../etc/tnsnames.ora

by $gvsqw_OraBin/../etc_cust/tnsnames.ora for all your environnement
or by $HOME/edtConfig/tnsnames.ora specifically for this user..

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 RDBMS 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_CheckIndicators.lib

shell functions librairy $gvsqw_OraBin/../lib/sqwora_CheckIndicators.lib:
lib for sqwora_CheckIndicators.ksh

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

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

See the detailed help for sqwora_CheckIndicators.lib

sqwora_CheckIndicators_Overload.lib

shell functions librairy $gvsqw_OraBin/../lib/sqwora_CheckIndicators_Overload.lib:
template lib for overload sqwora_CheckIndicators.ksh

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

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

See the detailed help for sqwora_CheckIndicators_Overload.lib

sqwora_CheckInstance.lib

shell functions librairy $gvsqw_OraBin/../lib/sqwora_CheckInstance.lib:
lib for sqwora_CheckInstance.ksh

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

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

See the detailed help for sqwora_CheckInstance.lib

sqwora_CheckInstance_Overload.lib

shell functions librairy $gvsqw_OraBin/../lib/sqwora_CheckInstance_Overload.lib:
lib for overload sqwora_CheckInstance.ksh

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

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

See the detailed help for sqwora_CheckInstance_Overload.lib

sqwora_GatherIndicators.lib

shell functions librairy $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 librairy $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_GenerateAwr.lib

shell functions librairy $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_GenerateCreateDatabase.lib

shell functions librairy $gvsqw_OraBin/../lib/sqwora_GenerateCreateDatabase.lib:
lib for generate create database

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

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

See the detailed help for sqwora_GenerateCreateDatabase.lib

sqwora_Global.lib

shell functions librairy $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_InsertIndicators.lib

shell functions librairy $gvsqw_OraBin/../lib/sqwora_InsertIndicators.lib:
generic fonctions to insert into referential

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

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

See the detailed help for sqwora_InsertIndicators.lib

sqwora_MenuRman.lib

shell functions librairy $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_PartialRefresh.lib

shell functions librairy $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_RmanBackup.lib

shell functions librairy $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 librairy $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_SchemaRefresh.lib

shell functions librairy $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 librairy $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

tools

sqwora_BackupPasswd.ksh

Script $gvsqw_OraBin/../tools/sqwora_BackupPasswd.ksh:
backup passwd of Oracle users See the detailed help for sqwora_BackupPasswd.ksh

sqwora_GenerateCreateDatabase.ksh

Script $gvsqw_OraBin/../tools/sqwora_GenerateCreateDatabase.ksh:
Generate create database files See the detailed help for sqwora_GenerateCreateDatabase.ksh

sqwora_ManageOracle.ksh

Script $gvsqw_OraBin/../tools/sqwora_ManageOracle.ksh:
stop/start instance See the detailed help for sqwora_ManageOracle.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_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_Spm.ksh

Script $gvsqw_OraBin/../tools/sqwora_Spm.ksh:
Sqlplus tools See the detailed help for sqwora_Spm.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}}
+{{SQWareProductionPresSgbd|oracle|Ora|ora}}
 == bin ==
@@ Line 5: / Line 5: @@
 Script $gvsqw_OraBin/bin/SqwArchmon:<br>
 {{SQWareProduction_SqwArchmon_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:SqwArchmon|See the detailed help for SqwArchmon]]<br><br>
-[[SQWareProduction:oracle:bin:SqwArchmon|See the detailed help for SqwArchmon]]<br>
 === sqwora_CheckIndicators.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_CheckIndicators.ksh:<br>
 {{SQWareProduction_sqwora_CheckIndicators.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_CheckIndicators.ksh|See the detailed help for sqwora_CheckIndicators.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_CheckIndicators.ksh|See the detailed help for sqwora_CheckIndicators.ksh]]<br>
 === sqwora_CheckInstance.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_CheckInstance.ksh:<br>
 {{SQWareProduction_sqwora_CheckInstance.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_CheckInstance.ksh|See the detailed help for sqwora_CheckInstance.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_CheckInstance.ksh|See the detailed help for sqwora_CheckInstance.ksh]]<br>
 === sqwora_SqwArchmon.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_SqwArchmon.ksh:<br>
 {{SQWareProduction_sqwora_SqwArchmon.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_SqwArchmon.ksh|See the detailed help for sqwora_SqwArchmon.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_SqwArchmon.ksh|See the detailed help for sqwora_SqwArchmon.ksh]]<br>
 === sqwora_Export.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_Export.ksh:<br>
 {{SQWareProduction_sqwora_Export.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_Export.ksh|See the detailed help for sqwora_Export.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_Export.ksh|See the detailed help for sqwora_Export.ksh]]<br>
 === sqwora_GatherIndicators.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_GatherIndicators.ksh:<br>
 {{SQWareProduction_sqwora_GatherIndicators.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_GatherIndicators.ksh|See the detailed help for sqwora_GatherIndicators.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_GatherIndicators.ksh|See the detailed help for sqwora_GatherIndicators.ksh]]<br>
 === sqwora_GenerateAwr.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_GenerateAwr.ksh:<br>
 {{SQWareProduction_sqwora_GenerateAwr.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_GenerateAwr.ksh|See the detailed help for sqwora_GenerateAwr.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_GenerateAwr.ksh|See the detailed help for sqwora_GenerateAwr.ksh]]<br>
 === sqwora_ParallelRun.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_ParallelRun.ksh:<br>
 {{SQWareProduction_sqwora_ParallelRun.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_ParallelRun.ksh|See the detailed help for sqwora_ParallelRun.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_ParallelRun.ksh|See the detailed help for sqwora_ParallelRun.ksh]]<br>
 === sqwora_PartialRefresh.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_PartialRefresh.ksh:<br>
 {{SQWareProduction_sqwora_PartialRefresh.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_PartialRefresh.ksh|See the detailed help for sqwora_PartialRefresh.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_PartialRefresh.ksh|See the detailed help for sqwora_PartialRefresh.ksh]]<br>
 === sqwora_PurgeAlert.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_PurgeAlert.ksh:<br>
 {{SQWareProduction_sqwora_PurgeAlert.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_PurgeAlert.ksh|See the detailed help for sqwora_PurgeAlert.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_PurgeAlert.ksh|See the detailed help for sqwora_PurgeAlert.ksh]]<br>
 === sqwora_RmanBackup.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_RmanBackup.ksh:<br>
 {{SQWareProduction_sqwora_RmanBackup.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_RmanBackup.ksh|See the detailed help for sqwora_RmanBackup.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_RmanBackup.ksh|See the detailed help for sqwora_RmanBackup.ksh]]<br>
 === sqwora_RmanClone.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_RmanClone.ksh:<br>
 {{SQWareProduction_sqwora_RmanClone.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_RmanClone.ksh|See the detailed help for sqwora_RmanClone.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_RmanClone.ksh|See the detailed help for sqwora_RmanClone.ksh]]<br>
 === sqwora_RunJob.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_RunJob.ksh:<br>
 {{SQWareProduction_sqwora_RunJob.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:bin:sqwora_RunJob.ksh|See the detailed help for sqwora_RunJob.ksh]]<br><br>
-[[SQWareProduction:oracle:bin:sqwora_RunJob.ksh|See the detailed help for sqwora_RunJob.ksh]]<br>
 === sqwora_SchemaRefresh.ksh ===
 Script $gvsqw_OraBin/bin/sqwora_SchemaRefresh.ksh:<br>
 {{SQWareProduction_sqwora_SchemaRefresh.ksh_presentation}}
+[[SQWareProduction:oracle:bin:sqwora_SchemaRefresh.ksh|See the detailed help for sqwora_SchemaRefresh.ksh]]<br><br>
 <br>
-[[SQWareProduction:oracle:bin:sqwora_SchemaRefresh.ksh|See the detailed help for sqwora_SchemaRefresh.ksh]]<br>
-<br><br>
 == etc ==
@@ Line 94: / Line 80: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_Awr.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_Awr.cfg|See the detailed help for sqwora_Awr.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_Awr.cfg|See the detailed help for sqwora_Awr.cfg]]<br>
 === sqwora_CreDb_Create.cfg ===
@@ Line 102: / Line 87: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_Create.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Create.cfg|See the detailed help for sqwora_CreDb_Create.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb_Create.cfg|See the detailed help for sqwora_CreDb_Create.cfg]]<br>
 === sqwora_CreDb_CrontabRef.cfg ===
@@ Line 110: / Line 94: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_CrontabRef.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_CrontabRef.cfg|See the detailed help for sqwora_CreDb_CrontabRef.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb_CrontabRef.cfg|See the detailed help for sqwora_CreDb_CrontabRef.cfg]]<br>
 === sqwora_CreDb_Init_101.cfg ===
@@ Line 118: / Line 101: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_Init_101.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_101.cfg|See the detailed help for sqwora_CreDb_Init_101.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_101.cfg|See the detailed help for sqwora_CreDb_Init_101.cfg]]<br>
 === sqwora_CreDb_Init_102.cfg ===
@@ Line 126: / Line 108: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_Init_102.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_102.cfg|See the detailed help for sqwora_CreDb_Init_102.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_102.cfg|See the detailed help for sqwora_CreDb_Init_102.cfg]]<br>
 === sqwora_CreDb_Init_111.cfg ===
@@ Line 134: / Line 115: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_Init_111.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_111.cfg|See the detailed help for sqwora_CreDb_Init_111.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_111.cfg|See the detailed help for sqwora_CreDb_Init_111.cfg]]<br>
 === sqwora_CreDb_Init_112.cfg ===
@@ Line 142: / Line 122: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_Init_112.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_112.cfg|See the detailed help for sqwora_CreDb_Init_112.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb_Init_112.cfg|See the detailed help for sqwora_CreDb_Init_112.cfg]]<br>
 === sqwora_CreDb_Jobs.cfg ===
@@ Line 150: / Line 129: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_Jobs.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Jobs.cfg|See the detailed help for sqwora_CreDb_Jobs.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb_Jobs.cfg|See the detailed help for sqwora_CreDb_Jobs.cfg]]<br>
 === sqwora_CreDb_Listener.cfg ===
@@ Line 158: / Line 136: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_Listener.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Listener.cfg|See the detailed help for sqwora_CreDb_Listener.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb_Listener.cfg|See the detailed help for sqwora_CreDb_Listener.cfg]]<br>
 === sqwora_CreDb_Rman.cfg ===
@@ Line 166: / Line 143: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_Rman.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Rman.cfg|See the detailed help for sqwora_CreDb_Rman.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb_Rman.cfg|See the detailed help for sqwora_CreDb_Rman.cfg]]<br>
 === sqwora_CreDb_Tnsnames.cfg ===
@@ Line 174: / Line 150: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_CreDb_Tnsnames.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_CreDb_Tnsnames.cfg|See the detailed help for sqwora_CreDb_Tnsnames.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_CreDb_Tnsnames.cfg|See the detailed help for sqwora_CreDb_Tnsnames.cfg]]<br>
 === sqwora_DbRefVar.cfg ===
@@ Line 182: / Line 157: @@
 <br>
 {{SQWareProductionSurchargeVar|oracle|Ora|sqwora_DbRefVar.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_DbRefVar.cfg|See the detailed help for sqwora_DbRefVar.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_DbRefVar.cfg|See the detailed help for sqwora_DbRefVar.cfg]]<br>
 === sqwora_GlobalVar.cfg ===
@@ Line 190: / Line 164: @@
 <br>
 {{SQWareProductionSurchargeVar|oracle|Ora|sqwora_GlobalVar.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_GlobalVar.cfg|See the detailed help for sqwora_GlobalVar.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_GlobalVar.cfg|See the detailed help for sqwora_GlobalVar.cfg]]<br>
 === sqwora_IndicatorsVar.cfg ===
@@ Line 198: / Line 171: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_IndicatorsVar.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_IndicatorsVar.cfg|See the detailed help for sqwora_IndicatorsVar.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_IndicatorsVar.cfg|See the detailed help for sqwora_IndicatorsVar.cfg]]<br>
 === sqwora_Rman.cfg ===
@@ Line 206: / Line 178: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_Rman.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_Rman.cfg|See the detailed help for sqwora_Rman.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_Rman.cfg|See the detailed help for sqwora_Rman.cfg]]<br>
 === sqwora_RmanClone.cfg ===
@@ Line 214: / Line 185: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|sqwora_RmanClone.cfg}}
-<br>
+[[SQWareProduction:oracle:etc:sqwora_RmanClone.cfg|See the detailed help for sqwora_RmanClone.cfg]]<br><br>
-[[SQWareProduction:oracle:etc:sqwora_RmanClone.cfg|See the detailed help for sqwora_RmanClone.cfg]]<br>
 === tnsnames.ora ===
@@ Line 222: / Line 192: @@
 <br>
 {{SQWareProductionSurchargeEtc|oracle|Ora|tnsnames.ora}}
-<br>
+[[SQWareProduction:oracle:etc:tnsnames.ora|See the detailed help for tnsnames.ora]]<br><br>
-[[SQWareProduction:oracle:etc:tnsnames.ora|See the detailed help for tnsnames.ora]]<br>
 === .profile ===
@@ Line 233: / Line 202: @@
 File to put aliases $gvsqw_OraBin/../etc/.profile_confort:<br>
 Contains confort aliases of SQWareProduction for RDBMS oracle.<br>
-<br>
 {{SQWareProductionSurchargeConfort|oracle|Ora}}
 <br>
-[[SQWareProduction:oracle:etc:.profile_confort|See the detailed help for .profile_confort]]<br>
+[[SQWareProduction:oracle:etc:.profile_confort|See the detailed help for .profile_confort]]<br><br>
-<br><br>
+<br>
 == lib ==
@@ Line 244: / Line 212: @@
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_CheckIndicators.lib:<br>
 {{SQWareProduction_sqwora_CheckIndicators.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_CheckIndicators.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_CheckIndicators.lib|See the detailed help for sqwora_CheckIndicators.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_CheckIndicators.lib|See the detailed help for sqwora_CheckIndicators.lib]]<br><br>
 === sqwora_CheckIndicators_Overload.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_CheckIndicators_Overload.lib:<br>
 {{SQWareProduction_sqwora_CheckIndicators_Overload.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_CheckIndicators_Overload.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_CheckIndicators_Overload.lib|See the detailed help for sqwora_CheckIndicators_Overload.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_CheckIndicators_Overload.lib|See the detailed help for sqwora_CheckIndicators_Overload.lib]]<br><br>
 === sqwora_CheckInstance.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_CheckInstance.lib:<br>
 {{SQWareProduction_sqwora_CheckInstance.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_CheckInstance.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_CheckInstance.lib|See the detailed help for sqwora_CheckInstance.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_CheckInstance.lib|See the detailed help for sqwora_CheckInstance.lib]]<br><br>
 === sqwora_CheckInstance_Overload.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_CheckInstance_Overload.lib:<br>
 {{SQWareProduction_sqwora_CheckInstance_Overload.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_CheckInstance_Overload.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_CheckInstance_Overload.lib|See the detailed help for sqwora_CheckInstance_Overload.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_CheckInstance_Overload.lib|See the detailed help for sqwora_CheckInstance_Overload.lib]]<br><br>
 === sqwora_GatherIndicators.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_GatherIndicators.lib:<br>
 {{SQWareProduction_sqwora_GatherIndicators.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GatherIndicators.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_GatherIndicators.lib|See the detailed help for sqwora_GatherIndicators.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_GatherIndicators.lib|See the detailed help for sqwora_GatherIndicators.lib]]<br><br>
 === sqwora_GatherIndicators_Overload.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_GatherIndicators_Overload.lib:<br>
 {{SQWareProduction_sqwora_GatherIndicators_Overload.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GatherIndicators_Overload.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_GatherIndicators_Overload.lib|See the detailed help for sqwora_GatherIndicators_Overload.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_GatherIndicators_Overload.lib|See the detailed help for sqwora_GatherIndicators_Overload.lib]]<br><br>
 === sqwora_GenerateAwr.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_GenerateAwr.lib:<br>
 {{SQWareProduction_sqwora_GenerateAwr.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GenerateAwr.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_GenerateAwr.lib|See the detailed help for sqwora_GenerateAwr.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_GenerateAwr.lib|See the detailed help for sqwora_GenerateAwr.lib]]<br><br>
 === sqwora_GenerateCreateDatabase.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_GenerateCreateDatabase.lib:<br>
 {{SQWareProduction_sqwora_GenerateCreateDatabase.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_GenerateCreateDatabase.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_GenerateCreateDatabase.lib|See the detailed help for sqwora_GenerateCreateDatabase.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_GenerateCreateDatabase.lib|See the detailed help for sqwora_GenerateCreateDatabase.lib]]<br><br>
 === sqwora_Global.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_Global.lib:<br>
 {{SQWareProduction_sqwora_Global.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_Global.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_Global.lib|See the detailed help for sqwora_Global.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_Global.lib|See the detailed help for sqwora_Global.lib]]<br><br>
 === sqwora_InsertIndicators.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_InsertIndicators.lib:<br>
 {{SQWareProduction_sqwora_InsertIndicators.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_InsertIndicators.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_InsertIndicators.lib|See the detailed help for sqwora_InsertIndicators.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_InsertIndicators.lib|See the detailed help for sqwora_InsertIndicators.lib]]<br><br>
 === sqwora_MenuRman.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_MenuRman.lib:<br>
 {{SQWareProduction_sqwora_MenuRman.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_MenuRman.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_MenuRman.lib|See the detailed help for sqwora_MenuRman.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_MenuRman.lib|See the detailed help for sqwora_MenuRman.lib]]<br><br>
 === sqwora_PartialRefresh.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_PartialRefresh.lib:<br>
 {{SQWareProduction_sqwora_PartialRefresh.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_PartialRefresh.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_PartialRefresh.lib|See the detailed help for sqwora_PartialRefresh.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_PartialRefresh.lib|See the detailed help for sqwora_PartialRefresh.lib]]<br><br>
 === sqwora_RmanBackup.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_RmanBackup.lib:<br>
 {{SQWareProduction_sqwora_RmanBackup.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_RmanBackup.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_RmanBackup.lib|See the detailed help for sqwora_RmanBackup.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_RmanBackup.lib|See the detailed help for sqwora_RmanBackup.lib]]<br><br>
 === sqwora_RmanClone.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_RmanClone.lib:<br>
 {{SQWareProduction_sqwora_RmanClone.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_RmanClone.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_RmanClone.lib|See the detailed help for sqwora_RmanClone.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_RmanClone.lib|See the detailed help for sqwora_RmanClone.lib]]<br><br>
 === sqwora_SchemaRefresh.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_SchemaRefresh.lib:<br>
 {{SQWareProduction_sqwora_SchemaRefresh.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_SchemaRefresh.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_SchemaRefresh.lib|See the detailed help for sqwora_SchemaRefresh.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_SchemaRefresh.lib|See the detailed help for sqwora_SchemaRefresh.lib]]<br><br>
 === sqwora_SetEnv.lib ===
 shell functions librairy $gvsqw_OraBin/../lib/sqwora_SetEnv.lib:<br>
 {{SQWareProduction_sqwora_SetEnv.lib_presentation}}
-<br>
 {{SQWareProductionSurchargeLib|oracle|Ora|sqwora_SetEnv.lib}}
 <br>
-[[SQWareProduction:oracle:lib:sqwora_SetEnv.lib|See the detailed help for sqwora_SetEnv.lib]]<br>
+[[SQWareProduction:oracle:lib:sqwora_SetEnv.lib|See the detailed help for sqwora_SetEnv.lib]]<br><br>
-<br><br>
+<br>
 == menu ==
@@ Line 375: / Line 327: @@
 Menu $gvsqw_OraBin/../menu/sqwora_MenuRman.ksh:<br>
 {{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|See the detailed help for sqwora_MenuRman.ksh]]<br>
-<br><br>
 == tools ==
@@ Line 384: / Line 335: @@
 Script $gvsqw_OraBin/../tools/sqwora_BackupPasswd.ksh:<br>
 {{SQWareProduction_sqwora_BackupPasswd.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:tools:sqwora_BackupPasswd.ksh|See the detailed help for sqwora_BackupPasswd.ksh]]<br><br>
-[[SQWareProduction:oracle:tools:sqwora_BackupPasswd.ksh|See the detailed help for sqwora_BackupPasswd.ksh]]<br>
 === sqwora_GenerateCreateDatabase.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_GenerateCreateDatabase.ksh:<br>
 {{SQWareProduction_sqwora_GenerateCreateDatabase.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:tools:sqwora_GenerateCreateDatabase.ksh|See the detailed help for sqwora_GenerateCreateDatabase.ksh]]<br><br>
-[[SQWareProduction:oracle:tools:sqwora_GenerateCreateDatabase.ksh|See the detailed help for sqwora_GenerateCreateDatabase.ksh]]<br>
 === sqwora_ManageOracle.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_ManageOracle.ksh:<br>
 {{SQWareProduction_sqwora_ManageOracle.ksh_presentation}}
-<br>
+[[SQWareProduction:oracle:tools:sqwora_ManageOracle.ksh|See the detailed help for sqwora_ManageOracle.ksh]]<br><br>
-[[SQWareProduction:oracle:tools:sqwora_ManageOracle.ksh|See the detailed help for sqwora_ManageOracle.ksh]]<br>
 === sqwora_RmanConfigure.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_RmanConfigure.ksh:<br>
 {{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|See the detailed help for sqwora_RmanConfigure.ksh]]<br>
 === sqwora_RmanCrosscheck.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_RmanCrosscheck.ksh:<br>
 {{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|See the detailed help for sqwora_RmanCrosscheck.ksh]]<br>
 === sqwora_RmanRegister.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_RmanRegister.ksh:<br>
 {{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|See the detailed help for sqwora_RmanRegister.ksh]]<br>
 === sqwora_SetEnv.ksh ===
@@ Line 422: / Line 367: @@
 <br>
 {{SQWareProductionSurchargeToo|oracle|Ora|sqwora_SetEnv.ksh}}
-<br>
+[[SQWareProduction:oracle:tools:sqwora_SetEnv.ksh|See the detailed help for sqwora_SetEnv.ksh]]<br><br>
-[[SQWareProduction:oracle:tools:sqwora_SetEnv.ksh|See the detailed help for sqwora_SetEnv.ksh]]<br>
 === sqwora_Spm.ksh ===
 Script $gvsqw_OraBin/../tools/sqwora_Spm.ksh:<br>
 {{SQWareProduction_sqwora_Spm.ksh_presentation}}
+[[SQWareProduction:oracle:tools:sqwora_Spm.ksh|See the detailed help for sqwora_Spm.ksh]]<br><br>
 <br>
-[[SQWareProduction:oracle:tools:sqwora_Spm.ksh|See the detailed help for sqwora_Spm.ksh]]<br>
-<br><br>
 == help ==
@@ Line 441: / Line 384: @@
 [[SQWareProduction:oracle:spm|See the detailed help for spm]]<br>
-<br><br>
+<br>

Difference between revisions of "SQWareProduction:oracle"

Revision as of 19:04, 18 December 2010

Contents

Presentation

Usage

Explanation of directories

Naming convention of files

Naming convention in scripts

bin

SqwArchmon

sqwora_CheckIndicators.ksh

sqwora_CheckInstance.ksh

sqwora_SqwArchmon.ksh

sqwora_Export.ksh

sqwora_GatherIndicators.ksh

sqwora_GenerateAwr.ksh

sqwora_ParallelRun.ksh

sqwora_PartialRefresh.ksh

sqwora_PurgeAlert.ksh

sqwora_RmanBackup.ksh

sqwora_RmanClone.ksh

sqwora_RunJob.ksh

sqwora_SchemaRefresh.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_Jobs.cfg

sqwora_CreDb_Listener.cfg

sqwora_CreDb_Rman.cfg

sqwora_CreDb_Tnsnames.cfg

sqwora_DbRefVar.cfg

sqwora_GlobalVar.cfg

sqwora_IndicatorsVar.cfg

sqwora_Rman.cfg

sqwora_RmanClone.cfg

tnsnames.ora

.profile

.profile_confort

lib

sqwora_CheckIndicators.lib

sqwora_CheckIndicators_Overload.lib

sqwora_CheckInstance.lib

sqwora_CheckInstance_Overload.lib

sqwora_GatherIndicators.lib

sqwora_GatherIndicators_Overload.lib

sqwora_GenerateAwr.lib

sqwora_GenerateCreateDatabase.lib

sqwora_Global.lib

sqwora_InsertIndicators.lib

sqwora_MenuRman.lib

sqwora_PartialRefresh.lib

sqwora_RmanBackup.lib

sqwora_RmanClone.lib

sqwora_SchemaRefresh.lib

sqwora_SetEnv.lib

menu

sqwora_MenuRman.ksh

tools

sqwora_BackupPasswd.ksh

sqwora_GenerateCreateDatabase.ksh

sqwora_ManageOracle.ksh

sqwora_RmanConfigure.ksh

sqwora_RmanCrosscheck.ksh

sqwora_RmanRegister.ksh

sqwora_SetEnv.ksh

sqwora_Spm.ksh

help

spm

Navigation menu

Search