Skip to Content

Hi there.

 

I just created a script for Oracle databases under SAP, that collects different logfiles. It helps either you or SAP Support to analyze issues and get the required details about it.

The tool is called Logca (Log Collector Assistant).

 

Features of this tool is:

– No user interaction is needed

– Reads some env. variables of the actual user (sidadm and orasid or even oracle) like ORACLE_HOME,ORACLE_BASE,ORACLE_SID

– based on the env. variables all the logs are compressed into logca.zip

 

Benefits of this tool:

– easy usage

– all required logfiles are available, so no missing logfiles during your/our analyze

– implementation for WINDOWS Ongoing. (comes later) DONE

 

General usage:

– copy file to the /tmp or %TMP% directory

– execute the script as <sid>adm

– check or attach logca.zip to the incident

– decompress it on your company machine

– enjoy having all the required logfiles 😉

 

Works in AIX,Linux,HP-UX,Solaris and Windows environments and 12c compliant.

 

The script itself is attached in below KBA:

2090832 – Log Collector Assistant (Logca)

 

Regards,

János

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Janos Mucsi-Besze Post author

    Thank you for the updates. I will change the uname command.
    The content of the INFO.txt severs just as a preliminary overview. The other Oracle logfiles contains the Os information anyway.

    But thank you for the update again. I am happy to listen all comments.

    (0) 
    1. Janos Mucsi-Besze Post author

      Hi Sadiq.

      I just finished the Windows version and uploaded the BAT file to the KBA.

      It is not so sophisticated as the SHELL script, but it does the Job well.

      Regards,

      János

      (0) 

Leave a Reply