{"id":2786,"date":"2018-09-25T07:28:12","date_gmt":"2018-09-25T05:28:12","guid":{"rendered":"https:\/\/www.oradba.ch\/?p=2786"},"modified":"2019-02-16T21:40:24","modified_gmt":"2019-02-16T20:40:24","slug":"oracle-unified-directory-access-log-parsing-system-alps","status":"publish","type":"post","link":"https:\/\/www.oradba.ch\/wordpress\/2018\/09\/oracle-unified-directory-access-log-parsing-system-alps\/","title":{"rendered":"Oracle Unified Directory Access Log Parsing System ALPS"},"content":{"rendered":"<p>For one of my customers I had to analyse the log files of Oracle Unified Directory from time to time. In particular the access log file. During my research I came across the MOS note <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=2042620.1\" target=\"_blank\" rel=\"noopener\">2042620.1<\/a> and the Access Log Parsing System or short ALPS. ALPS is a small and handy tool to analyse OUD and OUDSEE access logs. Written in Java it does run an a couple of different environments. The requirements to run it are rather simple. Just make sure you still have Java 8. \ud83d\ude42<\/p>\n<p>A few features:<\/p>\n<ul>\n<li>Graphical dashboard providing an overview of LDAP operations, connections, operations per seconds and elapsed times.<\/li>\n<li>Information on connection with longest etimes<\/li>\n<li>Analysis of LDAP operationen e.g. operations over time, most frequent search base, filters, attributes and more.<\/li>\n<li>Connections and client adresses.<\/li>\n<li>Overview of the result codes that occurred.<\/li>\n<li>Log reader to browse through the logfiles.<\/li>\n<li>Log replay<\/li>\n<li>Load of individual log files, zip archives or entire log directories. Loading multiple access log files allows to simultaneous analysis of access logs from replicated OUD instances. Although this is some kind of a workaround.<\/li>\n<\/ul>\n<p>The following print screen does show an ALPS dashboard. The access log has been taken from my OUD EUS AD proxy instance, which I did used during my TechEvent presentation on OUD and EUS. Not really a heavily loaded OUD instance.<br \/>\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2788\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_Dashboard.png?resize=620%2C457&#038;ssl=1\" alt=\"\" width=\"620\" height=\"457\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_Dashboard.png?resize=300%2C221&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_Dashboard.png?resize=768%2C566&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_Dashboard.png?resize=1024%2C754&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_Dashboard.png?resize=624%2C460&amp;ssl=1 624w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_Dashboard.png?w=1250&amp;ssl=1 1250w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_Dashboard.png?w=1875&amp;ssl=1 1875w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><br \/>\nAn other view of the LDAP operations around 09:30. The time I&#8217;ve rund the demo and created the instance \ud83d\ude42<br \/>\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2789\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_LDAP_operations.png?resize=620%2C421&#038;ssl=1\" alt=\"\" width=\"620\" height=\"421\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_LDAP_operations.png?resize=300%2C203&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_LDAP_operations.png?resize=768%2C520&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_LDAP_operations.png?resize=1024%2C694&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_LDAP_operations.png?resize=624%2C423&amp;ssl=1 624w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_LDAP_operations.png?w=1875&amp;ssl=1 1875w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ALPS_LDAP_operations.png?w=1250&amp;ssl=1 1250w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><br \/>\nIn the context of OUD 12c there are currently some limitations. Oracle changed the default log publisher to the Oracle Loggers using the <a href=\"https:\/\/docs.oracle.com\/en\/middleware\/lifecycle\/12.2.1.3\/asadm\/managing-log-files-and-diagnostic-data.html#GUID-DC9043D3-3418-46BD-842E-BFF957E8F3E3\" target=\"_blank\" rel=\"noopener\">ODL format<\/a>. ALPS can not yet handle the new format. If you plan to analyse OUD access or admin logs you still have to use the legacy log publishers. Beside this, a small info message can cause, that your log&#8217;s are not recognised by ALPS. OUD 12c add&#8217;s the following info to the header of new log files.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">\nThis logger has been deprecated. Recommended to use Oracle Loggers\n[14\/Sep\/2018:09:28:23 +0000] CONNECT CONN_POOL conn=0 protocol=LDAP extension=proxy1 from=te2018_oud.postgasse.org\/172.17.0.4 to=mneme.postgasse.org\/192.168.56.70 s_conn=0\n...\n<\/pre>\n<p>Just remove the line starting with <code class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">This logger has been deprecated...<\/code> and ALPS is fine again. Beside fixing this issue, I do have a couple of more wishes for the next release of ALPS.<\/p>\n<ul>\n<li>Officially support for new ODL format log files.<\/li>\n<li>Support for log files from different sources. e.g. from multiple OUD instance in an replicated environment. The current version of ALPS allows to load multiple files, but there is no possibility to distinct the log file source.<\/li>\n<\/ul>\n<p>Using ALPS to analysis OUD or&nbsp;ODSEE access logs will help to reduce you&#8217;re workload, so you have time to enjoy the real alps.<br \/>\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2793 aligncenter\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_1211.jpeg?resize=300%2C223&#038;ssl=1\" alt=\"\" width=\"300\" height=\"223\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_1211.jpeg?resize=300%2C223&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_1211.jpeg?resize=768%2C571&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_1211.jpeg?resize=1024%2C761&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_1211.jpeg?resize=624%2C464&amp;ssl=1 624w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_1211.jpeg?w=1250&amp;ssl=1 1250w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_1211.jpeg?w=1875&amp;ssl=1 1875w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For one of my customers I had to analyse the log files of Oracle Unified Directory from time to time. In particular the access log file. During my research I came across the MOS note 2042620.1 and the Access Log Parsing System or short ALPS. ALPS is a small and handy tool to analyse OUD [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"Analyse @Oracle #Unified #Directory access log using Access Log Parsing System ALPS","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[142,11,184],"tags":[130,18],"class_list":["post-2786","post","type-post","status-publish","format-standard","hentry","category-oud","category-security","category-troubleshooting","tag-trivadis","tag-trivadiscontent"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1aErb-IW","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3123,"url":"https:\/\/www.oradba.ch\/wordpress\/2019\/07\/sql-developer-19-1-unable-to-use-connection-type-ldap-with-oud\/","url_meta":{"origin":2786,"position":0},"title":"SQL Developer 19.1 unable to use connection type ldap with OUD","author":"Stefan","date":"2. July 2019","format":false,"excerpt":"Due to a tip from a work colleague, I came across a changed behaviour of the latest SQL Developer release. It affects the connection type LDAP respectively the use of an LDAP directory for the database name resolution. After specifying one or more LDAP servers it should actually be possible\u2026","rel":"","context":"In &quot;19c&quot;","block_context":{"text":"19c","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/19c\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2019-07-02-at-08.53.08-1024x281.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2761,"url":"https:\/\/www.oradba.ch\/wordpress\/2018\/08\/oracle-unified-directory-sslhandshakeexception-with-java-1-8-0_181\/","url_meta":{"origin":2786,"position":1},"title":"Oracle Unified Directory SSLHandshakeException with Java 1.8.0_181","author":"Stefan","date":"23. August 2018","format":false,"excerpt":"A couple of days ago I did update my Oracle Unified Directory Docker images with the latest bundle patch for OUD as well the latest java version. With the new Docker images I was about to reproduce a use case from a customer. Everything actually worked at first glance, but\u2026","rel":"","context":"In &quot;Oracle Unified Directory&quot;","block_context":{"text":"Oracle Unified Directory","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oud\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2344,"url":"https:\/\/www.oradba.ch\/wordpress\/2017\/08\/oracle-unified-directory-12-released\/","url_meta":{"origin":2786,"position":2},"title":"Oracle Unified Directory 12 Released","author":"Stefan","date":"31. August 2017","format":false,"excerpt":"Finally end of working day. But while reading some newsletter and mails on my way home, I realised that there will be some work at home. After a long wait, Oracle has finally released Oracle Unified Directory 12c :-) A overview of the new features: Improved performance and scalability Support\u2026","rel":"","context":"In &quot;Oracle Unified Directory&quot;","block_context":{"text":"Oracle Unified Directory","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oud\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2205,"url":"https:\/\/www.oradba.ch\/wordpress\/2016\/11\/environment-scripts-for-oud\/","url_meta":{"origin":2786,"position":3},"title":"Environment Scripts for OUD","author":"Stefan","date":"18. November 2016","format":false,"excerpt":"At Trivadis we do have the TVD-BasEnv\u2122 to standardizes and simplifies the handling of environments for Oracle database and application server landscapes. This inspired me to create something similar for Oracle Unified Directory environments. Although current versions of TVD-BasEnv\u2122 already support OUD and OID environment. I've had the situation, where\u2026","rel":"","context":"In &quot;Oracle Unified Directory&quot;","block_context":{"text":"Oracle Unified Directory","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oud\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2431,"url":"https:\/\/www.oradba.ch\/wordpress\/2017\/11\/install-oracle-unified-directory-12c-the-smart-way\/","url_meta":{"origin":2786,"position":4},"title":"Install Oracle Unified Directory 12c the smart way","author":"Stefan","date":"23. November 2017","format":false,"excerpt":"Installing Oracle Unified Directory has always been easy. The installation guide for OUD 11c as well OUD 12 is simple and straight forward. Additionally Oracle does provide a couple of MOS notes for different deployment scenarios. Nevertheless there is always room for improvement :-) During my work on OUD to\u2026","rel":"","context":"In &quot;Howto&quot;","block_context":{"text":"Howto","link":"https:\/\/www.oradba.ch\/wordpress\/category\/howto\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2921,"url":"https:\/\/www.oradba.ch\/wordpress\/2019\/02\/oud-12c-sslhandshakeexception-with-no-cipher-suites-in-common\/","url_meta":{"origin":2786,"position":5},"title":"OUD 12c &#8211; SSLHandshakeException with &#8220;no cipher suites in common&#8221;","author":"Stefan","date":"22. February 2019","format":false,"excerpt":"Recently I've update the java installation of my Oracle Unified Directory (OUD) 12.2.1.0.3 to the latest release. Java 1.8.0 update 202 to be exact (p28916775_180202_Linux-x86-64.zip). Actually a piece of cake, I've done this a few times in the past. My Enterprise User Security (EUS) test environment is running in Docker.\u2026","rel":"","context":"In &quot;18c&quot;","block_context":{"text":"18c","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/18c\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/2786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/comments?post=2786"}],"version-history":[{"count":7,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/2786\/revisions"}],"predecessor-version":[{"id":2796,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/2786\/revisions\/2796"}],"wp:attachment":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/media?parent=2786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/categories?post=2786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/tags?post=2786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}