About Collectors
Pre-requisites
Collector Server Minimum Requirements
Oracle Database requirements
-
Access to Oracle
-
Oracle user with read access to following tables: dba_hist_active_sess_history, dba_hist_snapshot, dba_users, dba_hist_sqltext, dba_mviews, dba_views, dba_procedures, dba_constraints, dba_cons_columns, dba_tab_columns, dba_audit_trail, dba_tab_privs, dba_role_privs, dba_roles, proxy_users_and_roles, dba_synonyms
You can connect 3 ways: 1) Host/servicename 2) TNSNAME in the tnsnames.ora file 3) A connection descriptor
Step 1: Create the Source in K
Create a Oracle source in K
-
Go to Settings, Select Sources and click Add Source
-
Select "Load from File" option
-
Give the source a Name - e.g. Oracle Production
-
Add the Host name for the Oracle Server
-
Click Finish Setup
Step 2: Getting Access to the Source Landing Directory
Step 3: Install the Collector
Run the following command to install the collector.
pip install kada_collectors_extractors_<version>-none-any.whl
pip install kada_collectors_lib-<version>-none-any.whl