/
esp_collect-master
/Folders and files
| Name | Name | Last commit date | |
|---|---|---|---|
parent directory.. | |||
ESP_COLLECT v1602 (2016-06-01) by Carlos Sierra and Rodrigo Righetti ESP_COLLECT is a "free to use" script that collects Oracle Database(s) Requirements from a Host. Since most of the metadata collected comes from DBA_HIST and ASH Views, the system where it runs must have a valid Oracle Diagnostics Pack License. Steps ~~~~~ 1. Connect to a Host as oracle. 2. Unzip esp_collect-master.zip and change directory to esp_collect-master. 3. Execute shell script corresponding to your system (linux, solaris, aix): $ unzip esp_collect-master.zip $ cd esp_collect-master $ sh run_esp_master_linux.sh 4. Provide to requestor all files generated by this script on current directory (i.e. esp_output.zip and possibly some csv and txt files) Notes ~~~~~ 1. Ignore possible errors like: "SP2-0310: unable to open file "--sql/..." "ORA-01219: database not open:..." "ORA-00604: error occurred at recursive SQL..." "SP2-0546: User requested Interrupt or EOF detected." 2. To collect requirements for just one database, connect into SQL*Plus as SYS or user with query access to the data dictionary (i.e. DBA), then execute sql/esp_master.sql.