{"id":8841,"date":"2016-10-11T15:22:54","date_gmt":"2016-10-11T13:22:54","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/"},"modified":"2016-10-11T15:22:54","modified_gmt":"2016-10-11T13:22:54","slug":"oswatcher-blackbox","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/","title":{"rendered":"OTN Appreciation Day : OSWatcher Black Box (OSWBB)"},"content":{"rendered":"

In this post, I will present a usefull and easy-to-use Oracle tool : OSWatcher.<\/p>\n

\"Image1\"<\/a>What is it ?<\/h3>\n

OSWatcher Black Box (OSWBB), for its full name, is a free<\/span> Oracle Tool which will help you to diagnose performance issues on the OS side.
\nOf course, it will not solve the issue for you, but it gives a system health state at a given moment.
\nOSWBB is multi-platforms supported (AIX, Solaris, HP-UX, Linux and Windows) and is installed by default on Oracle Database Appliance (ODA).<\/p>\n

How does it work ?<\/h3>\n

OSWatcher invoke OS utilities like vmstat<\/em>, netstat<\/em>, iostat<\/em>, etc. by creating a “Data Collectors” for each of them\u00a0available on the system. The “Data Collectors” works as background processes to collect periodically the data provided by these different OS utilities.
\nOnce collected, all the statistics are stored inside a common destination (archive directory).<\/p>\n

\"Image2\"<\/a><\/h3>\n

Below is the content of the archive directory. As you can see there is a dedicated folder for each type of OS statistics collected :
\noracle@srvtestoel7:\/u01\/app\/oracle\/product\/oswbb\/archive\/ [JOCDB1] ll
\ntotal 36
\n-rw-r--r-- 1 oracle oinstall 1835 28 sept. 16:55 heartbeat
\ndrwxr-xr-x 2 oracle oinstall 4096 28 sept. 16:52 oswifconfig
\ndrwxr-xr-x 2 oracle oinstall 4096 28 sept. 16:52 oswiostat
\ndrwxr-xr-x 2 oracle oinstall 4096 28 sept. 16:52 oswmeminfo
\ndrwxr-xr-x 2 oracle oinstall 4096 28 sept. 16:52 oswmpstat
\ndrwxr-xr-x 2 oracle oinstall 4096 28 sept. 16:52 oswnetstat
\ndrwxr-xr-x 2 oracle oinstall 6 23 sept. 09:18 oswprvtnet
\ndrwxr-xr-x 2 oracle oinstall 4096 28 sept. 16:52 oswps
\ndrwxr-xr-x 2 oracle oinstall 6 23 sept. 09:18 oswslabinfo
\ndrwxr-xr-x 2 oracle oinstall 4096 28 sept. 16:52 oswtop
\ndrwxr-xr-x 2 oracle oinstall 4096 28 sept. 16:52 oswvmstat
\n<\/code><\/p>\n

Downloading<\/h3>\n

You can download OSWatcher from\u00a0My Oracle Support – Doc ID 301137.1<\/a>\u00a0(.tar file – 6Mb)<\/p>\n

Installing<\/h3>\n

To install OSWatcher, you simply have to untar the downloaded file :
\n$ tar -xvf oswbb733.tar<\/code>
\nAll necessary files are stored in the oswbb<\/i> folder.<\/p>\n

Uninstalling<\/h3>\n

To remove OSWatcher from your server, you only have to :
\n– Stop all OSWatcher running processes
\n– Delete the oswbb<\/em> folder<\/p>\n

Starting
\n<\/strong><\/h3>\n

$ nohup .\/OSWatcher.sh P1 P2 P3 P4<\/code><\/p>\n

Parameters<\/h4>\n

– P1 = snapshot interval in seconds (default : 30 seconds)
\n– P2 = number of hours of archive data to store (default : 48 hours)
\n– P3 = name of a compress utility to compress each file automatically (default : none)
\n– P4 = alternate location to store the archive directory (default : oswbb\/archive)<\/p>\n

You can also set the UNIX environment variable oswbb_ARCHIVE_DEST<\/i> to specify a non-default location.<\/p>\n

Startup steps<\/h3>\n

Starting OSWatcher involve 4 steps :<\/p>\n

    \n
  1. Check parameters
    \n$ .\/OSWatcher.sh 60 24 gzip \/tmp\/oswbb\/archive
    \nInfo...Zip option IS specified.
    \nInfo...OSW will use gzip to compress files.
    \n...<\/code><\/li>\n
  2. Discover OS utilities
    \nTesting for discovery of OS Utilities...
    \nVMSTAT found on your system.
    \nIOSTAT found on your system.
    \nMPSTAT found on your system.
    \n...
    \n...
    \nDiscovery completed.<\/code><\/li>\n
  3. Discover CPU count
    \nTesting for discovery of OS CPU COUNT
    \noswbb is looking for the CPU COUNT on your system
    \nCPU COUNT will be used by oswbba to automatically look for cpu problems
    \nCPU COUNT found on your system.
    \nCPU COUNT = 1<\/code><\/li>\n
  4. Data collection
    \nData is stored in directory: \/tmp\/oswbb\/archive
    \nStarting Data Collection...
    \noswbb heartbeat:mar. sept. 13 22:03:33 CEST 2016
    \noswbb heartbeat:mar. sept. 13 22:04:33 CEST 2016
    \noswbb heartbeat:mar. sept. 13 22:05:33 CEST 2016<\/code><\/li>\n<\/ol>\n

    Check if OSWBB is running<\/h3>\n

    $ ps -ef | grep OSWatcher | grep -v grep
    \noracle\u00a0\u00a0\u00a0 8130\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 13:47 pts\/0\u00a0\u00a0\u00a0 00:00:33 \/bin\/sh .\/OSWatcher.sh 5 48
    \noracle\u00a0\u00a0\u00a0 8188\u00a0 8130\u00a0 0 13:47 pts\/0\u00a0\u00a0\u00a0 00:00:00 \/bin\/sh .\/OSWatcherFM.sh 48 \/u01\/app\/oracle\/product\/oswbb\/archive<\/code>
    \nThe\u00a0OSWatcherFM.sh<\/em> process is the\u00a0file manager who delete collected statitstics once they have reached their retention.<\/p>\n

    Stopping<\/h3>\n

    Run the\u00a0stopOSWbb.sh<\/em> to stop all OSWatcher processes
    \n$ .\/stopOSWbb.sh<\/code><\/p>\n

    Configure automatic startup<\/h3>\n

    Oracle provide a RPM package to configure auto-start of OSWatcher when the system starts.
    \nYou can download it here :\u00a0My Oracle Support – Doc ID\u00a0580513.1<\/a>
    \nOnce downloaded, install the package (as root) :
    \n$ rpm -ihv oswbb-service-7.2.0-1.noarch.rpm
    \nPreparing... ######################################### [100%]
    \n1:oswbb-service\u00a0\u00a0\u00a0 ######################################### [100%]<\/code>
    \nYou can adapt the following values in\u00a0\/usr\/libexec\/oswbb-service\/oswbb-helper <\/em>to define the parameters with which OSWatcher will auto-starts :
    \nOSW_HOME='\/u01\/app\/oracle\/product\/oswbb\/'
    \nOSW_INTERVAL='10'
    \nOSW_RETENTION='48'
    \nOSW_USER='oracle'
    \nOSW_COMPRESSION='gzip'
    \nOSW_ARCHIVE='archive'<\/code>
    \nStart the service :
    \n$ service oswbb start
    \nStarting oswbb (via systemctl): [ OK ]
    \n<\/code>
    \nCheck the service :
    \n$ service oswbb status
    \nOSWatcher is running.<\/code><\/p>\n

    Stop the service :
    \n$ service oswbb stop
    \nStopping oswbb (via systemctl):\u00a0 Warning: Unit file of oswbb.service changed on disk, 'systemctl daemon-reload' recommended.
    \n[\u00a0 OK\u00a0 ]<\/code><\/p>\n

    Enable the service when the system start :
    \n$\/sbin\/chkconfig oswbb on<\/code><\/p>\n

    Systemd commands (Linux 7) :
    \n$ systemctl stop oswbb.service
    \n$ systemctl start oswbb.service
    \n$ systemctl status oswbb.service
    \n$ systemctl enable oswbb.service<\/code><\/p>\n

    Inside the archive directory, one dedicated folder is created by type of collected statistics :
    \noracle@srvtestoel7:\/u01\/app\/oracle\/product\/oswbb\/archive\/ [JOCDB1] ll
    \ntotal 0
    \ndrwxr-xr-x 2 oracle oinstall 136 23 sept. 10:00 oswifconfig
    \ndrwxr-xr-x 2 oracle oinstall 132 23 sept. 10:00 oswiostat
    \ndrwxr-xr-x 2 oracle oinstall 134 23 sept. 10:00 oswmeminfo
    \ndrwxr-xr-x 2 oracle oinstall 132 23 sept. 10:00 oswmpstat
    \ndrwxr-xr-x 2 oracle oinstall 134 23 sept. 10:00 oswnetstat
    \ndrwxr-xr-x 2 oracle oinstall 6 23 sept. 09:18 oswprvtnet
    \ndrwxr-xr-x 2 oracle oinstall 124 23 sept. 10:00 oswps
    \ndrwxr-xr-x 2 oracle oinstall 6 23 sept. 09:18 oswslabinfo
    \ndrwxr-xr-x 2 oracle oinstall 126 23 sept. 10:00 oswtop
    \ndrwxr-xr-x 2 oracle oinstall 132 23 sept. 10:00 oswvmstat<\/code><\/p>\n

    In a following blog post, I’ll present OSWatcher Black Box Analyzer (oswbaa), which is a tool used to analyze graphically the collected data.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In this post, I will present a usefull and easy-to-use Oracle tool : OSWatcher. What is it ? OSWatcher Black Box (OSWBB), for its full name, is a free Oracle Tool which will help you to diagnose performance issues on the OS side. Of course, it will not solve the issue for you, but it […]<\/p>\n","protected":false},"author":30,"featured_media":8844,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[42],"tags":[73,919,920],"type_dbi":[],"class_list":["post-8841","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-operating-systems","tag-linux","tag-oswatcher","tag-oswbb"],"acf":[],"yoast_head":"\nOTN Appreciation Day : OSWatcher Black Box (OSWBB) - 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\/oswatcher-blackbox\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OTN Appreciation Day : OSWatcher Black Box (OSWBB)\" \/>\n<meta property=\"og:description\" content=\"In this post, I will present a usefull and easy-to-use Oracle tool : OSWatcher. What is it ? OSWatcher Black Box (OSWBB), for its full name, is a free Oracle Tool which will help you to diagnose performance issues on the OS side. Of course, it will not solve the issue for you, but it […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-11T13:22:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Image1-1.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"241\" \/>\n\t<meta property=\"og:image:height\" content=\"101\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"Jo\u00ebl Cattin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jo\u00ebl Cattin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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\/oswatcher-blackbox\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/\"},\"author\":{\"name\":\"Jo\u00ebl Cattin\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780\"},\"headline\":\"OTN Appreciation Day : OSWatcher Black Box (OSWBB)\",\"datePublished\":\"2016-10-11T13:22:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/\"},\"wordCount\":454,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Image1-1.gif\",\"keywords\":[\"Linux\",\"oswatcher\",\"oswbb\"],\"articleSection\":[\"Operating systems\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/\",\"name\":\"OTN Appreciation Day : OSWatcher Black Box (OSWBB) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Image1-1.gif\",\"datePublished\":\"2016-10-11T13:22:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Image1-1.gif\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Image1-1.gif\",\"width\":241,\"height\":101},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OTN Appreciation Day : OSWatcher Black Box (OSWBB)\"}]},{\"@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\/2c774f00321ee734515f0c2f6a96b780\",\"name\":\"Jo\u00ebl Cattin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"caption\":\"Jo\u00ebl Cattin\"},\"description\":\"Jo\u00ebl Cattin has more than three years of experience in databases management. He is specialized in Oracle solutions such as Data Guard and RMAN and has a good background knowledge of Oracle Database Appliance (ODA), Real Application Cluster (RAC) and applications development on APEX. Jo\u00ebl Cattin\u2019s experience includes other RDBMS, such as PostgreSQL and MySQL. He is Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server 9.5 Certified Professional, RedHat Certified System Administrator and ITILv3 Foundation for Service Management Certified. Jo\u00ebl Cattin holds a degree from the \u00c9cole Sup\u00e9rieure d\u2019Informatique de Gestion (ESIG) in Del\u00e9mont and a Federal Certificate of Proficiency in Computer Science (Certificat f\u00e9d\u00e9ral de Capacit\u00e9 \u2013 CFC).\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/joel-cattin\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"OTN Appreciation Day : OSWatcher Black Box (OSWBB) - 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\/oswatcher-blackbox\/","og_locale":"en_US","og_type":"article","og_title":"OTN Appreciation Day : OSWatcher Black Box (OSWBB)","og_description":"In this post, I will present a usefull and easy-to-use Oracle tool : OSWatcher. What is it ? OSWatcher Black Box (OSWBB), for its full name, is a free Oracle Tool which will help you to diagnose performance issues on the OS side. Of course, it will not solve the issue for you, but it […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/","og_site_name":"dbi Blog","article_published_time":"2016-10-11T13:22:54+00:00","og_image":[{"width":241,"height":101,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Image1-1.gif","type":"image\/gif"}],"author":"Jo\u00ebl Cattin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jo\u00ebl Cattin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/"},"author":{"name":"Jo\u00ebl Cattin","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780"},"headline":"OTN Appreciation Day : OSWatcher Black Box (OSWBB)","datePublished":"2016-10-11T13:22:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/"},"wordCount":454,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Image1-1.gif","keywords":["Linux","oswatcher","oswbb"],"articleSection":["Operating systems"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/","url":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/","name":"OTN Appreciation Day : OSWatcher Black Box (OSWBB) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Image1-1.gif","datePublished":"2016-10-11T13:22:54+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Image1-1.gif","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Image1-1.gif","width":241,"height":101},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oswatcher-blackbox\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"OTN Appreciation Day : OSWatcher Black Box (OSWBB)"}]},{"@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\/2c774f00321ee734515f0c2f6a96b780","name":"Jo\u00ebl Cattin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","caption":"Jo\u00ebl Cattin"},"description":"Jo\u00ebl Cattin has more than three years of experience in databases management. He is specialized in Oracle solutions such as Data Guard and RMAN and has a good background knowledge of Oracle Database Appliance (ODA), Real Application Cluster (RAC) and applications development on APEX. Jo\u00ebl Cattin\u2019s experience includes other RDBMS, such as PostgreSQL and MySQL. He is Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server 9.5 Certified Professional, RedHat Certified System Administrator and ITILv3 Foundation for Service Management Certified. Jo\u00ebl Cattin holds a degree from the \u00c9cole Sup\u00e9rieure d\u2019Informatique de Gestion (ESIG) in Del\u00e9mont and a Federal Certificate of Proficiency in Computer Science (Certificat f\u00e9d\u00e9ral de Capacit\u00e9 \u2013 CFC).","url":"https:\/\/www.dbi-services.com\/blog\/author\/joel-cattin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8841","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\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8841"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8841\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8844"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8841"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}