https://universal-logging-system.org/dokuwiki/ 2026-04-07T08:42:31+0200 https://universal-logging-system.org/dokuwiki/ https://universal-logging-system.org/dokuwiki/lib/exe/fetch.php?media=wiki:favicon.ico text/html 2015-01-13T16:24:49+0200 Anonymous (anonymous@undisclosed.example.com) https://universal-logging-system.org/dokuwiki/doku.php?id=uls:agents:oracle_tools:ora_awr_addm&rev=1421162689&do=diff ora_awr_addm Provided that the Oracle system parameter CONTROL_MANAGEMENT_PACK_ACCESS is set at least to DIAGNOSTIC, Oracle will take performance snapshots at each hour. The ora_awr_addm script will create each night a report for the day from 08:00 to 17:00 as defined in the oracle_tools.conf. The resulting report is sent to text/html 2014-02-13T14:51:10+0200 Anonymous (anonymous@undisclosed.example.com) https://universal-logging-system.org/dokuwiki/doku.php?id=uls:agents:oracle_tools:ora_dbinfo&rev=1392299470&do=diff ora_dbinfo This script collects a lot of useful facts about an Oracle database instance and builds a text report and an inventory file, which are sent to the ULS. This script may not cover everything that YOU are interested in, especially no RAC specifics (currently), but it gives quite an overview. Collected facts are e.g.: text/html 2014-02-13T14:51:50+0200 Anonymous (anonymous@undisclosed.example.com) https://universal-logging-system.org/dokuwiki/doku.php?id=uls:agents:oracle_tools:ora_statspack&rev=1392299510&do=diff ora_statspack Provided STATSPACK is installed in the current Oracle database, the ora_statspack script will take STATSPACK snapshots at each hour and generate, by default, each night a report for the day from 08:00 to 17:00. The resulting report is sent to text/html 2014-02-13T14:51:38+0200 Anonymous (anonymous@undisclosed.example.com) https://universal-logging-system.org/dokuwiki/doku.php?id=uls:agents:oracle_tools:orabackup&rev=1392299498&do=diff orabackup This script does an online backup of an Oracle database instance. This script (orabackup.pl) makes an online backup of an Oracle instance and writes: * all datafiles, * a control file (binary and readable), * the initSID.ora (derived from the therefore required spfile), text/html 2014-02-13T14:51:25+0200 Anonymous (anonymous@undisclosed.example.com) https://universal-logging-system.org/dokuwiki/doku.php?id=uls:agents:oracle_tools:orarman&rev=1392299485&do=diff orarman This script does an online backup of an oracle database instance by using the RMAN utility. This script runs the RMAN against an Oracle database and performs a full backup. It saves the backup to files in a directory, which is specified in a configuration file or to the fast recovery area. text/html 2015-01-13T11:25:25+0200 Anonymous (anonymous@undisclosed.example.com) https://universal-logging-system.org/dokuwiki/doku.php?id=uls:agents:oracle_tools:watch_oracle&rev=1421144725&do=diff watch_oracle This is a monitoring script for Oracle 9i, 10g, 11g and 12c database instances. It only does SELECTs on system tables, definitely no changes to anything! No *_HIST_* tables are used. “watch_oracle” may not cover everything that YOU