{"id":10247,"date":"2017-06-14T07:14:15","date_gmt":"2017-06-14T05:14:15","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/"},"modified":"2017-06-14T07:14:15","modified_gmt":"2017-06-14T05:14:15","slug":"oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/","title":{"rendered":"Oracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) – Follow Up"},"content":{"rendered":"

By William Sescu<\/h2>\n

My blog about listener rotation caused some discussion, which is great. \ud83d\ude42 It sounds like an easy stuff, but in case of listener logging it isn’t.<\/p>\n

https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off\/<\/a><\/p>\n

Many ways do exist to rotate the listener log, but I was trying to point out some issues, because there are a few, e.g.<\/p>\n

    \n
  1. What happens when the log file reaches 4G?<\/li>\n
  2. What are the performance implications?<\/li>\n
  3. What happens if I move the listener.log while the listener is running (Open file descriptor)?<\/li>\n
  4. And how to rotate the listener log with minimal impact?<\/li>\n<\/ol>\n

    The first two points have been discussed already in the previous post, so, I’m not going deeper into those one’s. Let’s take a look at the other ones, and start with the file descriptor issue. In the output below, you can see that the listener has an open file descriptor “3w” which is pointing to “\/u01\/app\/oracle\/network\/log\/listener.log”. It can be quite easily identified by using the lsof utility (list open files).<\/p>\n

    oracle@dbidg01:\/u01\/app\/oracle\/ [DBIT122] ps -ef | grep tnslsnr | grep -v grep\noracle    4686     1  0 07:59 ?        00:00:00 \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/bin\/tnslsnr LISTENER -inherit\n\noracle@dbidg01:\/u01\/app\/oracle\/ [DBIT122] lsof -p 4686 | grep listener.log\nCOMMAND  PID   USER   FD      TYPE             DEVICE SIZE\/OFF      NODE NAME\ntnslsnr 4686 oracle    3w      REG              251,4    55239 141607653 \/u01\/app\/oracle\/network\/log\/listener.log<\/pre>\n
    So .. what happens if I move the listener log, while the listener is running.<\/p>\n
    oracle@dbidg01:\/u01\/app\/oracle\/network\/log\/ [DBIT122] mv listener.log listener.log.1\noracle@dbidg01:\/u01\/app\/oracle\/network\/log\/ [DBIT122]<\/pre>\n
    And to have some data, I’m doing some sqlplus sessions here to generate more log entries …<\/p>\n
    oracle@dbidg01:\/u01\/app\/oracle\/network\/log\/ [DBIT122] sqlplus hr\/hr@DBIT122_SITE1\n... \n\noracle@dbidg01:\/u01\/app\/oracle\/network\/log\/ [DBIT122] sqlplus hr\/hr@DBIT122_SITE1\n... \n\noracle@dbidg01:\/u01\/app\/oracle\/network\/log\/ [DBIT122] ls -l listener.log\nls: cannot access listener.log: No such file or directory\n\noracle@dbidg01:\/u01\/app\/oracle\/network\/log\/ [DBIT122] lsof -p 4686 | grep listener.log\nCOMMAND  PID   USER   FD      TYPE             DEVICE SIZE\/OFF      NODE NAME\ntnslsnr 4686 oracle    3w      REG              251,4    56143 141607653 \/u01\/app\/oracle\/network\/log\/listener.log.1\n\n<\/pre>\n
    As you can see. A new listener.log is not automatically created, and the file descriptor “3w” is pointing now to \/u01\/app\/oracle\/network\/log\/listener.log.1.<\/p>\n
    That’s why it is not a good idea to move the listener log, without stopping the listener logging first. And please don’t try to send a hang up signal to the listener. The listener does not understand the hang up signal (kill -HUP) and you would kill it immediately. \ud83d\ude09<\/p>\n
    Ok. Let’s get back to the question about how to rotate the listener log with minimal impact?<\/p>\n
    If you have activated the listener logging, then there is a reason for doing that and you don’t want to lose data out of that log file. In case that losing any listener log data is not acceptable, you have to stop the listener, rotate the log and start the listener. There is no way out of that. Of course it has the disadvantage that new sessions cannot be established during that time.<\/p>\n
    However, if you want the listener to be up and running, and rotate the listener log with an absolute minimum of log data loss (taking here about milliseconds), then I would use the approach which I have described already in my previous post.<\/p>\n
    I have written quickly a listener rotate script which demonstrates how it can look like. I know that the script is not baby save, and a lot of extra checks and tweaks can be built in, but you will get an idea how it can look like. The script takes two parameters. The first one is the listener name, and the second one is the number of days about how long the listener logs should be kept on disk. Everything older than that will be removed.<\/p>\n
    oracle@dbidg01:\/home\/oracle\/ [DBIT122] .\/rotate_listener.sh LISTENER 7\nINFO: Check if Listener LISTENER is running\nINFO: Start Listener Rotating for LISTENER\nINFO: Current Listener Logging for LISTENER is: ON\nINFO: Tuning Listener Logging for LISTENER OFF\nINFO: Current Listener Logging for LISTENER is: OFF\nINFO: Rotating Listener Log \/u01\/app\/oracle\/network\/log\/listener.log to \/u01\/app\/oracle\/network\/log\/listener.log.1497363899\nINFO: Turning on Listener Logging for LISTENER\nINFO: Current Listener Logging for LISTENER is: ON\nINFO: Rotated successfully Listener Log for LISTENER\nINFO: Starting cleanup of old listener log files\nINFO: Will delete the following log files\n\/u01\/app\/oracle\/network\/log\/listener.log.1497354123\n\/u01\/app\/oracle\/network\/log\/listener.log.1497354122\n\/u01\/app\/oracle\/network\/log\/listener.log.1497354121\nINFO: Finished cleanup<\/pre>\n
    And here are the contents of the script.<\/p>\n
    oracle@dbidg01:\/home\/oracle\/ [DBIT122] cat rotate_listener.sh\n#!\/bin\/bash\n#\n#-- Listener Name => parameter 1\n#-- Delete listener log files older than number of days => parameter 2\n#\n\n#-- set -x\n\nListenerName=$1\nNumberOfDays=$2\n#-- %s  seconds since 1970-01-01 00:00:00 UTC\nDate=`date +%s`\n\n#-- Check if variable $1 and $2 are empty\nif [ -z ${ListenerName} ]; then\n        echo \"\"\n        echo \"INFO: Please specify the listener name\"\n        echo \"INFO: e.g. .\/rotate_listener.sh LISTENER 7\"\n        echo \"\"\n        exit\nfi\n\nif [ -z ${NumberOfDays} ]; then\n        echo \"\"\n        echo \"INFO: Please specify the number of days\"\n        echo \"INFO: e.g. .\/rotate_listener.sh LISTENER 7\"\n        echo \"\"\n        exit\nfi\n\necho \"INFO: Check if Listener ${ListenerName} is running\"\n\nps -ef | grep \"tnslsnr ${ListenerName} -inherit\" | grep -v grep >\/dev\/null 2>&1\nif [ $? != 0 ]; then\n        echo \"INFO: Listener ${ListenerName} is not running ... will exit here\"\n        exit\nfi\n\n#-- Set the listener log file\nListenerLogFile=`lsnrctl status ${ListenerName} | grep \"Listener Log File\" | awk '{ print $4 }'`\n\n\necho \"INFO: Start Listener Rotating for ${ListenerName}\"\n\n#-- Check listener log status\nListenerLogStatus=`lsnrctl <<-EOF  | grep log_status | awk '{ print $6 }'\nset displaymode normal\nset current_listener ${ListenerName}\nshow log_status\nEOF`\n\nif [ ${ListenerLogStatus} = \"ON\" ]; then\necho \"INFO: Current Listener Logging for ${ListenerName} is: ${ListenerLogStatus}\"\necho \"INFO: Tuning Listener Logging for ${ListenerName} OFF\"\n\nListenerLogStatus=`lsnrctl <<-EOF | grep log_status | awk '{ print $6 }'\nset displaymode normal\nset current_listener ${ListenerName}\nset log_status off\nEOF`\n\necho \"INFO: Current Listener Logging for ${ListenerName} is: ${ListenerLogStatus}\"\n if [ ${ListenerLogStatus} = \"OFF\" ]; then\n   echo \"INFO: Rotating Listener Log ${ListenerLogFile} to ${ListenerLogFile}.${Date}\"\n        mv ${ListenerLogFile} ${ListenerLogFile}.${Date}\n    echo \"INFO: Turning on Listener Logging for ${ListenerName}\"\n\nListenerLogStatus=`lsnrctl <<-EOF | grep log_status | awk '{ print $6 }'\nset displaymode normal\nset current_listener ${ListenerName}\nset log_status on\nEOF`\n\necho \"INFO: Current Listener Logging for ${ListenerName} is: ${ListenerLogStatus}\"\necho \"INFO: Rotated successfully Listener Log for ${ListenerName}\"\n fi\nfi\n\necho \"INFO: Starting cleanup of old listener log files\"\necho \"INFO: Will delete the following log files\"\nListenerLogDirectory=`dirname $ListenerLogFile`\nfind ${ListenerLogDirectory} -name \"listener.log.*\" -mtime +${2} -print\nfind ${ListenerLogDirectory} -name \"listener.log.*\" -mtime +${2} -print | xargs rm -f\n\necho \"INFO: Finished cleanup\"\n\n#-- EOF<\/pre>\n
    Conclusion<\/h3>\n
    If you run that rotate listener log script during a time (e.g. in the middle of night), where you expect minimal activity on the DB, you can minimize the chance of losing listener log entries even further.<\/p>\n","protected":false},"excerpt":{"rendered":"
    By William Sescu My blog about listener rotation caused some discussion, which is great. \ud83d\ude42 It sounds like an easy stuff, but in case of listener logging it isn’t. https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off\/ Many ways do exist to rotate the listener log, but I was trying to point out some issues, because there are a few, e.g. What […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[988],"type_dbi":[],"class_list":["post-10247","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-oracle-12-2"],"acf":[],"yoast_head":"\nOracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) - Follow Up - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) - Follow Up\" \/>\n<meta property=\"og:description\" content=\"By William Sescu My blog about listener rotation caused some discussion, which is great. \ud83d\ude42 It sounds like an easy stuff, but in case of listener logging it isn’t. https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off\/ Many ways do exist to rotate the listener log, but I was trying to point out some issues, because there are a few, e.g. What […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-14T05:14:15+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) – Follow Up\",\"datePublished\":\"2017-06-14T05:14:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/\"},\"wordCount\":580,\"commentCount\":0,\"keywords\":[\"Oracle 12.2\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/\",\"name\":\"Oracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) - Follow Up - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-06-14T05:14:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) – Follow Up\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) - Follow Up - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) - Follow Up","og_description":"By William Sescu My blog about listener rotation caused some discussion, which is great. \ud83d\ude42 It sounds like an easy stuff, but in case of listener logging it isn’t. https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off\/ Many ways do exist to rotate the listener log, but I was trying to point out some issues, because there are a few, e.g. What […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/","og_site_name":"dbi Blog","article_published_time":"2017-06-14T05:14:15+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) – Follow Up","datePublished":"2017-06-14T05:14:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/"},"wordCount":580,"commentCount":0,"keywords":["Oracle 12.2"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/","name":"Oracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) - Follow Up - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-06-14T05:14:15+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off-follow-up\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12.2 \u2013 How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) – Follow Up"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10247"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10247\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10247"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}