| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
About Collectors
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...
Pre-requisites
...
Access to K Landing Directory
...
Oracle Access
Create an Collector Server Minimum Requirements
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Oracle Database requirements
Access toOracle
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 (If you do not have Auditing configured, speak to KADA about it.)
dba_tab_privs
dba_role_privs
dba_roles
proxy_users_and_roles
dba_synonyms
Check the MAX_STRING_SIZE option in the database , if it is not of type EXTENDED and you are unable to change it, you will need to alter the DDL_SQL used by the extractor and change from 32767 to the maximum supported value in MAX_STRING_SIZE instead. If this is not aligned you will see an ORA-00910: specified length is too long for its datatype will be thrown.
...
Host/servicename
TNSNAME in the tnsnames.ora file
A connection descriptor
Collector Server Minimum Requirements
...
...
Step 1: Create the Source in K
...