Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Latest commit

 

History

History
History
 
 
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.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.