{"id":10124,"date":"2021-01-20T16:38:32","date_gmt":"2021-01-20T15:38:32","guid":{"rendered":"http:\/\/arumel.com\/?p=10124"},"modified":"2021-01-20T16:39:21","modified_gmt":"2021-01-20T15:39:21","slug":"hackeando-dbstart","status":"publish","type":"post","link":"https:\/\/arumel.com\/es\/hackeando-dbstart\/","title":{"rendered":"Hackeando dbstart"},"content":{"rendered":"<p>Todos nos hemos encontrado en un escenario donde no tengamos configurado Oracle Restart o Clusterware, donde tenemos que automatiozar el arranque de las bases de datos mediante scripts.<br \/>\nHablando claro, caso de Single Instance sobre filesystem o Single Instance no configurada como recurso.<\/p>\n<p>Oracle nos ofrece los scripts dbstart y dbshut para facilitar dicha tarea, que se basa en la configuraci\u00f3n que tengamos en \/etc\/oratab para arrancarlas (\/var\/opt\/oracle\/oratab en el caso de Solaris), pudiendo definir cuales queremos que arranquen en el caso de tener varias en el mismo servidor.<\/p>\n<p>Es script dbstart iniciar\u00e1 las bases de datos en modo OPEN, pero y si queremos que abran en modo mount? Por ejemplo teniendo configurada una standby (si no queremos pasar por caja).<\/p>\n<p>Pues f\u00e1cil, modificando el script propio de Oracle \ud83d\ude42<\/p>\n<p>Para ello buscaremos en el script $ORACLE_HOME\/bin\/dbstart el siguiente apartado y moficamos las l\u00edneas se\u00f1aladas por startup mount.<\/p>\n<pre># Starts a Database Instance\r\nstartinst() {\r\n# Called programs use same database ID\r\nexport ORACLE_SID\r\n\r\n# Put $ORACLE_HOME\/bin into PATH and export.\r\nPATH=$ORACLE_HOME\/bin:${SAVE_PATH} ; export PATH\r\n# add for bug # 652997\r\nLD_LIBRARY_PATH=${ORACLE_HOME}\/lib:${SAVE_LLP} ; export LD_LIBRARY_PATH\r\nPFILE=${ORACLE_HOME}\/dbs\/init${ORACLE_SID}.ora\r\nSPFILE=${ORACLE_HOME}\/dbs\/spfile${ORACLE_SID}.ora\r\nSPFILE1=${ORACLE_HOME}\/dbs\/spfile.ora\r\n\r\necho \"\"\r\necho \"$0: Starting up database \\\\\"$ORACLE_SID\\\\\"\"\r\ndate\r\necho \"\"\r\n\r\ncheckversionmismatch\r\n\r\n# See if it is a V6 or V7 database\r\nVERSION=undef\r\nif [ -f $ORACLE_HOME\/bin\/sqldba ] ; then\r\nSQLDBA=sqldba\r\nVERSION=`$ORACLE_HOME\/bin\/sqldba command=exit | awk '\r\n\/SQL\\\\*DBA: (Release|Version)\/ {split($3, V, \".\") ;\r\nprint V[1]}'`\r\ncase $VERSION in\r\n\"6\") ;;\r\n*) VERSION=\"internal\" ;;\r\nesac\r\nelse\r\nif [ -f $ORACLE_HOME\/bin\/svrmgrl ] ; then\r\nSQLDBA=svrmgrl\r\nVERSION=\"internal\"\r\nelse\r\nSQLDBA=\"sqlplus \/nolog\"\r\nfi\r\nfi\r\n\r\nSTATUS=1\r\nif [ -f $ORACLE_HOME\/dbs\/sgadef${ORACLE_SID}.dbf ] ; then\r\nSTATUS=\"-1\"\r\nfi\r\nif [ -f $ORACLE_HOME\/dbs\/sgadef${ORACLE_SID}.ora ] ; then\r\nSTATUS=\"-1\"\r\nfi\r\npmon=`ps -ef | grep -w \"ora_pmon_$ORACLE_SID\" | grep -v grep`\r\nif [ \"$pmon\" != \"\" ] ; then\r\nSTATUS=\"-1\"\r\n$LOGMSG \"Warning: ${INST} \\\\\"${ORACLE_SID}\\\\\" already started.\"\r\nfi\r\n\r\nif [ $STATUS -eq -1 ] ; then\r\n$LOGMSG \"Warning: ${INST} \\\\\"${ORACLE_SID}\\\\\" possibly left running when system went down (system crash?).\"\r\n$LOGMSG \"Action: Notify Database Administrator.\"\r\ncase $VERSION in\r\n\"6\") sqldba \"command=shutdown abort\" ;;\r\n\"internal\") $SQLDBA $args &lt;&lt;EOF\r\nconnect internal\r\nshutdown abort\r\nEOF\r\n;;\r\n*) $SQLDBA $args &lt;&lt;EOF\r\nconnect \/ as sysdba\r\nshutdown abort\r\nquit\r\nEOF\r\n;;\r\nesac\r\n\r\nif [ $? -eq 0 ] ; then\r\nSTATUS=1\r\nelse\r\n$LOGMSG \"Error: ${INST} \\\\\"${ORACLE_SID}\\\\\" NOT started.\"\r\nfi\r\nfi\r\n\r\nif [ $STATUS -eq 1 ] ; then\r\nif [ -e $SPFILE -o -e $SPFILE1 -o -e $PFILE ] ; then\r\ncase $VERSION in\r\n\"6\") sqldba command=startup ;;\r\n\"internal\") $SQLDBA &lt;&lt;EOF \r\nconnect internal\r\n<strong>startup mount &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;---------------------------------<\/strong>\r\nEOF\r\n;;\r\n*) $SQLDBA &lt;&lt;EOF \r\nconnect \/ as sysdba\r\n<strong>startup mount &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;---------------------------------<\/strong>\r\nquit\r\nEOF\r\n;;\r\nesac<\/pre>\n<p>Ahora la parte f\u00e1cil, creaci\u00f3n de un script para integrar con la parada y arranque del servidor<\/p>\n<pre>cat\u00a0\/etc\/init.d\/dbora19c\r\n\r\n#! \/bin\/sh\r\n# description: Oracle auto start-stop script.\r\n#\r\n# Set ORACLE_HOME to be equivalent to the $ORACLE_HOME\r\n# from which you wish to execute dbstart and dbshut;\r\n#\r\n# Set ORA_OWNER to the user id of the owner of the\r\n# Oracle database in ORACLE_HOME.\r\n#chkconfig: 345 99 03\r\n# description: Start\/Stop the Databases...\r\n\r\nORA_HOME=\/u01\/app\/oracle\/product\/19.5.0\/dbhome_pro\r\nORA_OWNER=oracle\r\n\r\ncase \"$1\" in\r\n'start')\r\n# Start the Oracle databases:\r\n# The following command assumes that the oracle login\r\n# will not prompt the user for any values\r\n# Remove \"&amp;\" if you don't want startup as a background process.\r\nsu - $ORA_OWNER -c \"$ORA_HOME\/bin\/dbstart $ORA_HOME\" &amp;\r\ntouch \/var\/lock\/subsys\/dbora\r\n;;\r\n\r\n'stop')\r\n# Stop the Oracle databases:\r\n# The following command assumes that the oracle login\r\n# will not prompt the user for any values\r\nsu - $ORA_OWNER -c \"$ORA_HOME\/bin\/dbshut $ORA_HOME\" &amp;\r\nrm -f \/var\/lock\/subsys\/dbora\r\n;;\r\nesac<\/pre>\n<pre>Otorgamos los permisos adecuados\r\nchgrp dba \/etc\/init.d\/dbora19c\r\nchmod 750 \/etc\/init.d\/dbora19c<\/pre>\n<pre>Creamos enlaces simb\u00f3licos\u00a0\r\nln -s \/etc\/init.d\/dbora19c \/etc\/rc.d\/rc0.d\/K01dbora19c\r\nln -s \/etc\/init.d\/dbora19c \/etc\/rc.d\/rc3.d\/S99dbora19c\r\nln -s \/etc\/init.d\/dbora19c \/etc\/rc.d\/rc5.d\/S99dbora19c<\/pre>\n<p>Y finalmente integramos el script\u00a0 con el arranque\/parada del servidor a nivel de SO<\/p>\n<pre>[root@servidor ~]# chkconfig --add dbora19c\u00a0\r\n[root@servidor ~]# chkconfig --level 345 dbora19c on\r\n[root@servidor ~]# chkconfig --list |grep dbora19c\u00a0\r\nNota: Esta salida muestra s\u00f3lo servicios SysV y no incluye servicios nativos\u00a0\u00a0 \u00a0 \u00a0\r\nde systemd. Los datos de configuraci\u00f3n SysV pueden verse invalidados por\u00a0\u00a0 \u00a0 \u00a0 \r\nla configuraci\u00f3n nativa de systemd.\r\n\u00a0\r\nSi desea una lista de servicios systemd use 'systemctl list-unit-files'.\u00a0 \u00a0 \u00a0\r\nPara ver los servicios que se activan para un objetivo concreto use\u00a0 \u00a0 \u00a0 'systemctl list-dependencies [objetivo]'.\r\n\r\ndbora19c\u00a0 \u00a0 \u00a0 \u00a0 0:desactivado 1:desactivado 2:desactivado 3:activo 4:activo 5:activo 6:desactivado<\/pre>\n<p>Ahora solo queda editar el oratab indicando Y, reiniciar el servidor y ver la m\u00e1gia del autoarranque en modo mount \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Todos nos hemos encontrado en un escenario donde no tengamos configurado Oracle Restart o Clusterware, donde tenemos que automatiozar el arranque de las bases de datos mediante scripts. Hablando claro, caso de Single Instance sobre filesystem o Single Instance no configurada como recurso. Oracle nos ofrece los scripts dbstart y dbshut para facilitar dicha tarea, [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":9578,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"off","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","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},"jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-10124","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sin-categorizar"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hackeando dbstart - Arumel<\/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:\/\/arumel.com\/es\/hackeando-dbstart\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hackeando dbstart - Arumel\" \/>\n<meta property=\"og:description\" content=\"Todos nos hemos encontrado en un escenario donde no tengamos configurado Oracle Restart o Clusterware, donde tenemos que automatiozar el arranque de las bases de datos mediante scripts. Hablando claro, caso de Single Instance sobre filesystem o Single Instance no configurada como recurso. Oracle nos ofrece los scripts dbstart y dbshut para facilitar dicha tarea, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arumel.com\/es\/hackeando-dbstart\/\" \/>\n<meta property=\"og:site_name\" content=\"Arumel\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-20T15:38:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-20T15:39:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo-1024x749.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"749\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Carla Mu\u00f1oz L\u00f3pez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Carla Mu\u00f1oz L\u00f3pez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/\"},\"author\":{\"name\":\"Carla Mu\u00f1oz L\u00f3pez\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/ad6b4e40f9cf337835a3c478b69e425d\"},\"headline\":\"Hackeando dbstart\",\"datePublished\":\"2021-01-20T15:38:32+00:00\",\"dateModified\":\"2021-01-20T15:39:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/\"},\"wordCount\":215,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1\",\"articleSection\":[\"Sin categorizar\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/\",\"url\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/\",\"name\":\"Hackeando dbstart - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1\",\"datePublished\":\"2021-01-20T15:38:32+00:00\",\"dateModified\":\"2021-01-20T15:39:21+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/ad6b4e40f9cf337835a3c478b69e425d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1\",\"width\":2391,\"height\":1748},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/hackeando-dbstart\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/arumel.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hackeando dbstart\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\",\"url\":\"http:\\\/\\\/arumel.com\\\/\",\"name\":\"Arumel\",\"description\":\"Outro sitio WordPress m\u00e1is\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/arumel.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/ad6b4e40f9cf337835a3c478b69e425d\",\"name\":\"Carla Mu\u00f1oz L\u00f3pez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g\",\"caption\":\"Carla Mu\u00f1oz L\u00f3pez\"},\"sameAs\":[\"www.linkedin.com\\\/in\\\/carla-munoz-lopez\"],\"url\":\"https:\\\/\\\/arumel.com\\\/es\\\/author\\\/carla\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hackeando dbstart - Arumel","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:\/\/arumel.com\/es\/hackeando-dbstart\/","og_locale":"es_ES","og_type":"article","og_title":"Hackeando dbstart - Arumel","og_description":"Todos nos hemos encontrado en un escenario donde no tengamos configurado Oracle Restart o Clusterware, donde tenemos que automatiozar el arranque de las bases de datos mediante scripts. Hablando claro, caso de Single Instance sobre filesystem o Single Instance no configurada como recurso. Oracle nos ofrece los scripts dbstart y dbshut para facilitar dicha tarea, [&hellip;]","og_url":"https:\/\/arumel.com\/es\/hackeando-dbstart\/","og_site_name":"Arumel","article_published_time":"2021-01-20T15:38:32+00:00","article_modified_time":"2021-01-20T15:39:21+00:00","og_image":[{"width":1024,"height":749,"url":"https:\/\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo-1024x749.jpg","type":"image\/jpeg"}],"author":"Carla Mu\u00f1oz L\u00f3pez","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Carla Mu\u00f1oz L\u00f3pez","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arumel.com\/es\/hackeando-dbstart\/#article","isPartOf":{"@id":"https:\/\/arumel.com\/es\/hackeando-dbstart\/"},"author":{"name":"Carla Mu\u00f1oz L\u00f3pez","@id":"http:\/\/arumel.com\/#\/schema\/person\/ad6b4e40f9cf337835a3c478b69e425d"},"headline":"Hackeando dbstart","datePublished":"2021-01-20T15:38:32+00:00","dateModified":"2021-01-20T15:39:21+00:00","mainEntityOfPage":{"@id":"https:\/\/arumel.com\/es\/hackeando-dbstart\/"},"wordCount":215,"commentCount":0,"image":{"@id":"https:\/\/arumel.com\/es\/hackeando-dbstart\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1","articleSection":["Sin categorizar"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arumel.com\/es\/hackeando-dbstart\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arumel.com\/es\/hackeando-dbstart\/","url":"https:\/\/arumel.com\/es\/hackeando-dbstart\/","name":"Hackeando dbstart - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arumel.com\/es\/hackeando-dbstart\/#primaryimage"},"image":{"@id":"https:\/\/arumel.com\/es\/hackeando-dbstart\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1","datePublished":"2021-01-20T15:38:32+00:00","dateModified":"2021-01-20T15:39:21+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/ad6b4e40f9cf337835a3c478b69e425d"},"breadcrumb":{"@id":"https:\/\/arumel.com\/es\/hackeando-dbstart\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arumel.com\/es\/hackeando-dbstart\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/arumel.com\/es\/hackeando-dbstart\/#primaryimage","url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1","contentUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1","width":2391,"height":1748},{"@type":"BreadcrumbList","@id":"https:\/\/arumel.com\/es\/hackeando-dbstart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/arumel.com\/es\/"},{"@type":"ListItem","position":2,"name":"Hackeando dbstart"}]},{"@type":"WebSite","@id":"http:\/\/arumel.com\/#website","url":"http:\/\/arumel.com\/","name":"Arumel","description":"Outro sitio WordPress m\u00e1is","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/arumel.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"http:\/\/arumel.com\/#\/schema\/person\/ad6b4e40f9cf337835a3c478b69e425d","name":"Carla Mu\u00f1oz L\u00f3pez","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g","caption":"Carla Mu\u00f1oz L\u00f3pez"},"sameAs":["www.linkedin.com\/in\/carla-munoz-lopez"],"url":"https:\/\/arumel.com\/es\/author\/carla\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uvW6-2Di","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":9743,"url":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/","url_meta":{"origin":10124,"position":0},"title":"AWR Warehouse? Por supuesto!","author":"Carla Mu\u00f1oz L\u00f3pez","date":"13 de agosto de 2019","format":false,"excerpt":"Resulta emocionante, y es lo que pretendo trasladar en este art\u00edculo, la idea de disponer de un repositorio centralizado de awr de todas las bases de datos Oracle de la compa\u00f1\u00eda. Realmente pienso\u2026 c\u00f3mo has podido vivir sin uno?! Para entender qu\u00e9 nos puede aportar comienzo explicando qu\u00e9 es AWR.\u2026","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=1200%2C877&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=1200%2C877&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=1200%2C877&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=1200%2C877&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=1200%2C877&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7231,"url":"https:\/\/arumel.com\/es\/bug-rconfig-ao-converter-unha-bd-10g-single-instance-rac-sobre-grid-infrastructure-11gr2\/","url_meta":{"origin":10124,"position":1},"title":"Bug rconfig al convertir una BD 10g single instance a RAC sobre Grid Infrastructure 11gR2","author":"Alberto Pereiro","date":"11 de marzo de 2016","format":false,"excerpt":"\u00a0 \u00a0","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/photo-1455539002418-a4cd5aa3ec04.jpg?fit=1200%2C563&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/photo-1455539002418-a4cd5aa3ec04.jpg?fit=1200%2C563&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/photo-1455539002418-a4cd5aa3ec04.jpg?fit=1200%2C563&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/photo-1455539002418-a4cd5aa3ec04.jpg?fit=1200%2C563&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/photo-1455539002418-a4cd5aa3ec04.jpg?fit=1200%2C563&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":8360,"url":"https:\/\/arumel.com\/es\/instalacion-oracle-gi-standalone-restart-12-2-con-fichero-respuesta-modo-silencioso\/","url_meta":{"origin":10124,"position":2},"title":"Instalaci\u00f3n Oracle GI standalone (Restart) 12.2 con fichero respuesta modo silencioso","author":"sm","date":"12 de agosto de 2017","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":8197,"url":"https:\/\/arumel.com\/ca\/recomendaciones-para-la-red-de-interconexion-en-rac\/","url_meta":{"origin":10124,"position":3},"title":"Recomendaciones para la red de interconexi\u00f3n en RAC","author":"Alberto Pereiro","date":"21 de julio de 2017","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/ca\/oracle-ca\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":8199,"url":"https:\/\/arumel.com\/es\/recomendaciones-para-la-de-la-red-de-interconexion-en-rac\/","url_meta":{"origin":10124,"position":4},"title":"Recomendaciones para la red de interconexi\u00f3n en RAC","author":"Alberto Pereiro","date":"21 de julio de 2017","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":8211,"url":"https:\/\/arumel.com\/eu\/recomendaciones-para-la-red-de-interconexion-en-rac\/","url_meta":{"origin":10124,"position":5},"title":"Recomendaciones para la red de interconexi\u00f3n en RAC","author":"Alberto Pereiro","date":"21 de julio de 2017","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/eu\/oracle-eu\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=700%2C400 2x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1","_links":{"self":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/10124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/comments?post=10124"}],"version-history":[{"count":41,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/10124\/revisions"}],"predecessor-version":[{"id":10264,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/10124\/revisions\/10264"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media\/9578"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media?parent=10124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/categories?post=10124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/tags?post=10124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}