Collecting Data: ITCAM for Applications - Extended Agent for Oracle

Collecting Data documents for Extended Agent for Oracle used to aid problem determination and reduce time resolving PMRs (Problem Management Records)

Identifying the problem

To research the problem prior to submitting a PMR start with these pre-filtered searches

Search Hints:

• Do not use New Search, use search within the existing search, add your own search criteria, use 'back' in your browser to move around
• Right click on link to launch in new tab to reference back to this doc
• You may have to launch the Support Portal Search a second time if 0 results occur on the first attempt

APARS and Fixes(Support Portal Search)

DCF Solutions(Support Portal Search)

PMR Searches for IBMers(CAST search)

L3 and Developers Wiki and Best Practices for Oracle Extended Agent

IEA (IBM Education Assistant) visual aids

Gather Documentation

1. Stop the Oracle Extended Agent
2. Set RAS1 trace settings below
3. Recreate problem and take screen print of issue
4. Stop the Oracle Extended Agent
5. Process <install path>/bin/tacmd pdcollect from the command line or
   refer to this url for pdcollect command,
   https://www.ibm.com/support/docview.wss?uid=swg21284703

Send the pdcollect jar/tar file, screen prints, and all useful Oracle environmental information including oracle logs, listener.ora and tnsnames.ora files if required

ITM Oracle Extended Agent Trace Settings

Update the Oracle Extended Agent environment file: Windows <install path>\TMAITM6\KRZENV Unix/Linux <install path>/config/rz.ini Set trace values for KBB_ RAS1 and KBB_RAS1_LOG KBB_RAS1=ERROR (UNIT:krz ALL) (UNIT:knz ALL) (UNIT:kra ALL) KBB_RAS1_LOG set the following for more and larger log files COUNT=05 LIMIT=10 PRESERVE=1 MAXFILES=9 Further specific filtering options, remove krz above and use only specific UNIT krzalert: the Alert Log component krzbasic: the basic functions component krzcomm: the common connection component krzmutex: the event and mutex component krzora: the OCI(Oracle Call Interface) related functions component krzxml: the XML component

Delivering Collected Data​​

Upload files using the http://www.ecurep.ibm.com/app/upload website along with the PMR number.
Or upload files for review to the following FTP site: ftp.emea.ibm.com. Log in as anonymous and place your files in the directory that corresponds to the IBM Tivoli Monitoring component that you use.