Realizando una tarea que consist\u00eda en cambiar el compatible.rdbms de los diskgroups de ASM a versi\u00f3n 18c me encontr\u00e9 que la GIMR se vi\u00f3 afectada, a pesar de ser la GI versi\u00f3n 19c.<\/p>\n\n\n\n
ORA-00202: control file: '+DGMGMTDB\/_MGMTDB\/CONTROLFILE\/current.262.1018190533'\nORA-17503: ksfdopn:2 Failed to open file +DGMGMTDB\/_MGMTDB\/CONTROLFILE\/current.262.1018190533\nORA-15001: diskgroup \"DGMGMTDB\" does not exist or is not mounted\nORA-15204: database version 12.2.0.0.0 is incompatible with diskgroup DGMGMTDB<\/code><\/pre>\n\n\n\nLlama la atenci\u00f3n que no haya ninguna menci\u00f3n en la documentaci\u00f3n de Oracle sobre dicha compatibilidad m\u00e1s all\u00e1 de notas en soporte como respuesta a operaciones de movimiento de la GIMR de diskgroup, donde a grandes rasgos mencionan<\/p>\n\n\n\n
NOTE: It's recommended to set both compatible.asm and compatible.rdbms to 12.1 for the new ASM diskgroup when creating or altering and existing diskgroup.\nEx: CREATE DISKGROUP \u2026 ATTRIBUTE 'compatible.rdbms' = '12.1', 'compatible.asm' = '12.1';<\/code><\/pre>\n\n\n\nUna vez encontrada la desagradable sorpresa no me queda otra que recrear la GIMR y el diskgroup con la compatibilidad indicada tras la incidencia, as\u00ed que comenzamos.<\/p>\n\n\n\n
El primer paso consiste en detener y deshabilitar en ambos nodos el Cluster Health Monitor<\/p>\n\n\n\n
[root@nodo01 ~]# . oraenv <<< +ASM1\nORACLE_SID = [root] ? The Oracle base has been set to \/u01\/app\/oracle\n[root@nodo01 ~]# crsctl stop res ora.crf -init\nCRS-2673: Attempting to stop 'ora.crf' on 'nodo01'\nCRS-2677: Stop of 'ora.crf' on 'nodo01' succeeded\n[root@nodo01 ~]# crsctl modify res ora.crf -attr ENABLED=0 -init\n\n\n[root@nodo02 ~]# . oraenv <<< +ASM2\nORACLE_SID = [root] ? The Oracle base has been set to \/u01\/app\/oracle\n[root@nodo02 ~]# crsctl stop res ora.crf -init\nCRS-2673: Attempting to stop 'ora.crf' on 'nodo02'\nCRS-2677: Stop of 'ora.crf' on 'nodo02' succeeded\n[root@nodo02 ~]# crsctl modify res ora.crf -attr ENABLED=0 -init<\/code><\/pre>\n\n\n\nUna vez deshabilitado y detenido procedemos a eliminar la base de datos de la GIMR si seguimos la documentaci\u00f3n de Oracle al pie de la letra, pero no seremos capaces puesto que nos dar\u00e1 un error<\/p>\n\n\n\n
[oracle@nodo01 ~]$ srvctl remove mgmtdb\n\u00bfDesea eliminar la base de datos _mgmtdb? (y\/[n]) y\nPRKO-3077 : Fallo al eliminar base de datos _mgmtdb: PRCD-1032 : Fallo al eliminar el recurso de la base de datos _mgmtdb\nPRCR-1028 : Fallo al eliminar el recurso ora.mgmtdb\nPRCR-1072 : Fallo al anular el registro resource ora.mgmtdb\nCRS-2730: Resource 'ora.rhpserver' depends on resource 'ora.mgmtdb'\n<\/code><\/pre>\n\n\n\nExiste una dependencia con el recurso relativo a Rapid Home Provisioning Server, el cual eliminaremos ya que fu\u00e9 instalado por defecto con la GI y no lo precisamos en nuestro entorno.<\/p>\n\n\n\n
[root@nodo01 ~]# srvctl remove rhpserver\nPRCT-1470 : failed to reset the Rapid Home Provisioning (RHP) repository\n PRCT-1011 : Failed to run \"mgmtca\". Detailed error: [MGTCA-1105 : The GIMR is not running in this cluster.]\n[root@node1 ~]# srvctl remove rhpserver -f\n<\/code><\/pre>\n\n\n\nUna vez eliminado estaremos en disposici\u00f3n de eliminar la BBDD<\/p>\n\n\n\n
[oracle@nodo01 ~]$ srvctl remove mgmtdb\n\u00bfDesea eliminar la base de datos _mgmtdb? (y\/[n]) Y<\/code><\/pre>\n\n\n\nEn mi caso recreo el DG, por lo que lo desmonto en todos los nodos menos uno y procedo a su eliminaci\u00f3n y recreaci\u00f3n<\/p>\n\n\n\n
[oracle@nodo02 ~]$ asmcmd umount DGMGMTDB\n[oracle@nodo01 ~]$ asmcmd dropdg -r DGMGMTDB\n\n[oracle@nodo01 ~]$ sqlplus \/ as sysasm\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 9 14:37:09 2019\nVersion 19.3.1.0.0\n\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.1.0.0\n\nSYS@+ASM1> CREATE DISKGROUP DGMGMTDB EXTERNAL REDUNDANCY \n DISK 'AFD:DGMGMTDB01' SIZE 51199M\n DISK 'AFD:DGMGMTDB02' SIZE 51199M\n DISK 'AFD:DGMGMTDB03' SIZE 51199M\n DISK 'AFD:DGMGMTDB04' SIZE 51199M\n ATTRIBUTE 'compatible.asm'='19.0.0.0','compatible.rdbms'='12.2','compatible.advm'='19.0.0.0','au_size'='4M'<\/code><\/pre>\n\n\n\nPerfecto, ya hemos eliminado la base de datos, hemos recreado el DG con la compatibilidad correcta as\u00ed que vamos a recrear la base de datos MGMTDB<\/p>\n\n\n\n
[oracle@nodo01 ~]$ \/u01\/app\/19c\/grid\/bin\/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName DGMGMTDB -datafileJarLocation \/u01\/app\/19c\/grid\/assistants\/dbca\/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck\nPreparar para funcionamiento de base de datos\n10% finalizado\nRegistrando base de datos con Oracle Grid Infrastructure\n14% finalizado\nCopiando archivos de base de datos\n43% finalizado\nCreando e iniciando instancia Oracle\n45% finalizado\n49% finalizado\n54% finalizado\n58% finalizado\n62% finalizado\nTerminando creaci\u00f3n de base de datos\n66% finalizado\n69% finalizado\n71% finalizado\nEjecutando acciones posteriores a la configuraci\u00f3n\n100% finalizado\nCreaci\u00f3n de la base de datos terminada. Consulte los archivos log de \/u01\/app\/oracle\/cfgtoollogs\/dbca\/_mgmtdb\n para obtener m\u00e1s informaci\u00f3n.\nInformaci\u00f3n de Base de Datos:\nNombre de la Base de Datos Global:_mgmtdb\nIdentificador del Sistema (SID):-MGMTDB\nPara obtener informaci\u00f3n detallada, consulte el archivo log \"\/u01\/app\/oracle\/cfgtoollogs\/dbca\/_mgmtdb\/_mgmtdb.log\".<\/code><\/pre>\n\n\n\nY finalmente creamos la GIMR<\/p>\n\n\n\n
[oracle@nodo01 ~]$ \/u01\/app\/19c\/grid\/bin\/mgmtca -local<\/code><\/pre>\n\n\n\nComprobamos la configuraci\u00f3n y el estado<\/p>\n\n\n\n
[oracle@nodo01 ~]$ srvctl config mgmtdb\nNombre \u00fanico de la base de datos: _mgmtdb\nNombre de la base de datos: \nDirectorio ra\u00edz de Oracle: <CRS home>\nUsuario de Oracle: oracle\nSpfile: +DGMGMTDB\/_MGMTDB\/PARAMETERFILE\/spfile.270.1018525787\nArchivo de contrase\u00f1a: +DGMGMTDB\/_MGMTDB\/PASSWORD\/pwd_mgmtdb.257.1018525045\nDominio: \nOpciones de inicio: open\nOpciones de parada: immediate\nRol de base de datos: PRIMARY\nPol\u00edtica de gesti\u00f3n: AUTOMATIC\nTipo: Management\nNombre de PDB: GIMR_DSCREP_10\nServicio de PDB: GIMR_DSCREP_10\nNombre de cluster: racdummy\nInstancia de base de datos: -MGMTDB\n\n[oracle@nodo01 ~]$ srvctl status mgmtdb\nLa base de datos est\u00e1 activada\nLa instancia -MGMTDB se est\u00e1 ejecutando en el nodo nodo01\n<\/code><\/pre>\n\n\n\nHabilitamos en ambos nodos el CLuster Health Monitor<\/p>\n\n\n\n
[root@nodo01 ~]# . oraenv <<< +ASM1\nORACLE_SID = [root] ? The Oracle base has been set to \/u01\/app\/oracle\n[root@nodo01 ~]# crsctl modify res ora.crf -attr ENABLED=1 -init\n[root@nodo01 ~]# crsctl start res ora.crf -init\nCRS-2672: Attempting to start 'ora.crf' on 'nodo01'\nCRS-2676: Start of 'ora.crf' on 'nodo01' succeeded\n\n\n[root@nodo02 ~]# . oraenv <<< +ASM2\nORACLE_SID = [root] ? The Oracle base has been set to \/u01\/app\/oracle\n[root@nodo02 ~]# crsctl modify res ora.crf -attr ENABLED=1 -init\n[root@nodo02 ~]# crsctl start res ora.crf -init\nCRS-2672: Attempting to start 'ora.crf' on 'nodo02'\nCRS-2676: Start of 'ora.crf' on 'nodo02' succeeded<\/code><\/pre>\n\n\n\nConcluimos de esta manera la recreaci\u00f3n de la GIMR.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"
\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t<\/div> Realizando una tarea que consist\u00eda en cambiar el compatible.rdbms de los diskgroups de ASM a versi\u00f3n 18c me encontr\u00e9 que la GIMR se vi\u00f3 afectada, a pesar de ser la GI versi\u00f3n 19c. ORA-00202: control file: ‘+DGMGMTDB\/_MGMTDB\/CONTROLFILE\/current.262.1018190533’ ORA-17503: ksfdopn:2 Failed to open file +DGMGMTDB\/_MGMTDB\/CONTROLFILE\/current.262.1018190533 ORA-15001: diskgroup \u00abDGMGMTDB\u00bb does not exist or is not mounted […]<\/p>\n","protected":false},"author":13,"featured_media":181,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\nRealizando una tarea que consist\u00eda en cambiar el compatible.rdbms de los diskgroups de ASM a versi\u00f3n 18c me encontr\u00e9 que la GIMR se vi\u00f3 afectada, a pesar de ser la GI versi\u00f3n 19c.<\/p>\n\n\n\n
ORA-00202: control file: '+DGMGMTDB\/_MGMTDB\/CONTROLFILE\/current.262.1018190533'\nORA-17503: ksfdopn:2 Failed to open file +DGMGMTDB\/_MGMTDB\/CONTROLFILE\/current.262.1018190533\nORA-15001: diskgroup \"DGMGMTDB\" does not exist or is not mounted\nORA-15204: database version 12.2.0.0.0 is incompatible with diskgroup DGMGMTDB<\/code><\/pre>\n\n\n\nLlama la atenci\u00f3n que no haya ninguna menci\u00f3n en la documentaci\u00f3n de Oracle sobre dicha compatibilidad m\u00e1s all\u00e1 de notas en soporte como respuesta a operaciones de movimiento de la GIMR de diskgroup, donde a grandes rasgos mencionan<\/p>\n\n\n\n
NOTE: It's recommended to set both compatible.asm and compatible.rdbms to 12.1 for the new ASM diskgroup when creating or altering and existing diskgroup.\nEx: CREATE DISKGROUP \u2026 ATTRIBUTE 'compatible.rdbms' = '12.1', 'compatible.asm' = '12.1';<\/code><\/pre>\n\n\n\nUna vez encontrada la desagradable sorpresa no me queda otra que recrear la GIMR y el diskgroup con la compatibilidad indicada tras la incidencia, as\u00ed que comenzamos.<\/p>\n\n\n\n
El primer paso consiste en detener y deshabilitar en ambos nodos el Cluster Health Monitor<\/p>\n\n\n\n
[root@nodo01 ~]# . oraenv <<< +ASM1\nORACLE_SID = [root] ? The Oracle base has been set to \/u01\/app\/oracle\n[root@nodo01 ~]# crsctl stop res ora.crf -init\nCRS-2673: Attempting to stop 'ora.crf' on 'nodo01'\nCRS-2677: Stop of 'ora.crf' on 'nodo01' succeeded\n[root@nodo01 ~]# crsctl modify res ora.crf -attr ENABLED=0 -init\n\n\n[root@nodo02 ~]# . oraenv <<< +ASM2\nORACLE_SID = [root] ? The Oracle base has been set to \/u01\/app\/oracle\n[root@nodo02 ~]# crsctl stop res ora.crf -init\nCRS-2673: Attempting to stop 'ora.crf' on 'nodo02'\nCRS-2677: Stop of 'ora.crf' on 'nodo02' succeeded\n[root@nodo02 ~]# crsctl modify res ora.crf -attr ENABLED=0 -init<\/code><\/pre>\n\n\n\nUna vez deshabilitado y detenido procedemos a eliminar la base de datos de la GIMR si seguimos la documentaci\u00f3n de Oracle al pie de la letra, pero no seremos capaces puesto que nos dar\u00e1 un error<\/p>\n\n\n\n
[oracle@nodo01 ~]$ srvctl remove mgmtdb\n\u00bfDesea eliminar la base de datos _mgmtdb? (y\/[n]) y\nPRKO-3077 : Fallo al eliminar base de datos _mgmtdb: PRCD-1032 : Fallo al eliminar el recurso de la base de datos _mgmtdb\nPRCR-1028 : Fallo al eliminar el recurso ora.mgmtdb\nPRCR-1072 : Fallo al anular el registro resource ora.mgmtdb\nCRS-2730: Resource 'ora.rhpserver' depends on resource 'ora.mgmtdb'\n<\/code><\/pre>\n\n\n\nExiste una dependencia con el recurso relativo a Rapid Home Provisioning Server, el cual eliminaremos ya que fu\u00e9 instalado por defecto con la GI y no lo precisamos en nuestro entorno.<\/p>\n\n\n\n
[root@nodo01 ~]# srvctl remove rhpserver\nPRCT-1470 : failed to reset the Rapid Home Provisioning (RHP) repository\n PRCT-1011 : Failed to run \"mgmtca\". Detailed error: [MGTCA-1105 : The GIMR is not running in this cluster.]\n[root@node1 ~]# srvctl remove rhpserver -f\n<\/code><\/pre>\n\n\n\nUna vez eliminado estaremos en disposici\u00f3n de eliminar la BBDD<\/p>\n\n\n\n
[oracle@nodo01 ~]$ srvctl remove mgmtdb\n\u00bfDesea eliminar la base de datos _mgmtdb? (y\/[n]) Y<\/code><\/pre>\n\n\n\nEn mi caso recreo el DG, por lo que lo desmonto en todos los nodos menos uno y procedo a su eliminaci\u00f3n y recreaci\u00f3n<\/p>\n\n\n\n
[oracle@nodo02 ~]$ asmcmd umount DGMGMTDB\n[oracle@nodo01 ~]$ asmcmd dropdg -r DGMGMTDB\n\n[oracle@nodo01 ~]$ sqlplus \/ as sysasm\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 9 14:37:09 2019\nVersion 19.3.1.0.0\n\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.1.0.0\n\nSYS@+ASM1> CREATE DISKGROUP DGMGMTDB EXTERNAL REDUNDANCY \n DISK 'AFD:DGMGMTDB01' SIZE 51199M\n DISK 'AFD:DGMGMTDB02' SIZE 51199M\n DISK 'AFD:DGMGMTDB03' SIZE 51199M\n DISK 'AFD:DGMGMTDB04' SIZE 51199M\n ATTRIBUTE 'compatible.asm'='19.0.0.0','compatible.rdbms'='12.2','compatible.advm'='19.0.0.0','au_size'='4M'<\/code><\/pre>\n\n\n\nPerfecto, ya hemos eliminado la base de datos, hemos recreado el DG con la compatibilidad correcta as\u00ed que vamos a recrear la base de datos MGMTDB<\/p>\n\n\n\n
[oracle@nodo01 ~]$ \/u01\/app\/19c\/grid\/bin\/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName DGMGMTDB -datafileJarLocation \/u01\/app\/19c\/grid\/assistants\/dbca\/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck\nPreparar para funcionamiento de base de datos\n10% finalizado\nRegistrando base de datos con Oracle Grid Infrastructure\n14% finalizado\nCopiando archivos de base de datos\n43% finalizado\nCreando e iniciando instancia Oracle\n45% finalizado\n49% finalizado\n54% finalizado\n58% finalizado\n62% finalizado\nTerminando creaci\u00f3n de base de datos\n66% finalizado\n69% finalizado\n71% finalizado\nEjecutando acciones posteriores a la configuraci\u00f3n\n100% finalizado\nCreaci\u00f3n de la base de datos terminada. Consulte los archivos log de \/u01\/app\/oracle\/cfgtoollogs\/dbca\/_mgmtdb\n para obtener m\u00e1s informaci\u00f3n.\nInformaci\u00f3n de Base de Datos:\nNombre de la Base de Datos Global:_mgmtdb\nIdentificador del Sistema (SID):-MGMTDB\nPara obtener informaci\u00f3n detallada, consulte el archivo log \"\/u01\/app\/oracle\/cfgtoollogs\/dbca\/_mgmtdb\/_mgmtdb.log\".<\/code><\/pre>\n\n\n\nY finalmente creamos la GIMR<\/p>\n\n\n\n
[oracle@nodo01 ~]$ \/u01\/app\/19c\/grid\/bin\/mgmtca -local<\/code><\/pre>\n\n\n\nComprobamos la configuraci\u00f3n y el estado<\/p>\n\n\n\n
[oracle@nodo01 ~]$ srvctl config mgmtdb\nNombre \u00fanico de la base de datos: _mgmtdb\nNombre de la base de datos: \nDirectorio ra\u00edz de Oracle: <CRS home>\nUsuario de Oracle: oracle\nSpfile: +DGMGMTDB\/_MGMTDB\/PARAMETERFILE\/spfile.270.1018525787\nArchivo de contrase\u00f1a: +DGMGMTDB\/_MGMTDB\/PASSWORD\/pwd_mgmtdb.257.1018525045\nDominio: \nOpciones de inicio: open\nOpciones de parada: immediate\nRol de base de datos: PRIMARY\nPol\u00edtica de gesti\u00f3n: AUTOMATIC\nTipo: Management\nNombre de PDB: GIMR_DSCREP_10\nServicio de PDB: GIMR_DSCREP_10\nNombre de cluster: racdummy\nInstancia de base de datos: -MGMTDB\n\n[oracle@nodo01 ~]$ srvctl status mgmtdb\nLa base de datos est\u00e1 activada\nLa instancia -MGMTDB se est\u00e1 ejecutando en el nodo nodo01\n<\/code><\/pre>\n\n\n\nHabilitamos en ambos nodos el CLuster Health Monitor<\/p>\n\n\n\n
[root@nodo01 ~]# . oraenv <<< +ASM1\nORACLE_SID = [root] ? The Oracle base has been set to \/u01\/app\/oracle\n[root@nodo01 ~]# crsctl modify res ora.crf -attr ENABLED=1 -init\n[root@nodo01 ~]# crsctl start res ora.crf -init\nCRS-2672: Attempting to start 'ora.crf' on 'nodo01'\nCRS-2676: Start of 'ora.crf' on 'nodo01' succeeded\n\n\n[root@nodo02 ~]# . oraenv <<< +ASM2\nORACLE_SID = [root] ? The Oracle base has been set to \/u01\/app\/oracle\n[root@nodo02 ~]# crsctl modify res ora.crf -attr ENABLED=1 -init\n[root@nodo02 ~]# crsctl start res ora.crf -init\nCRS-2672: Attempting to start 'ora.crf' on 'nodo02'\nCRS-2676: Start of 'ora.crf' on 'nodo02' succeeded<\/code><\/pre>\n\n\n\nConcluimos de esta manera la recreaci\u00f3n de la GIMR.<\/p>\n","_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":[62],"tags":[400,401],"class_list":["post-9759","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-gimr","tag-mgmtdb"],"yoast_head":"\n
Recreando la GIMR en Oracle 19c (MGMTDB) - 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\/recreando-la-gimr-en-oracle-19c-mgmtdb\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Recreando la GIMR en Oracle 19c (MGMTDB) - Arumel\" \/>\n<meta property=\"og:description\" content=\"Realizando una tarea que consist\u00eda en cambiar el compatible.rdbms de los diskgroups de ASM a versi\u00f3n 18c me encontr\u00e9 que la GIMR se vi\u00f3 afectada, a pesar de ser la GI versi\u00f3n 19c. ORA-00202: control file: '+DGMGMTDB\/_MGMTDB\/CONTROLFILE\/current.262.1018190533' ORA-17503: ksfdopn:2 Failed to open file +DGMGMTDB\/_MGMTDB\/CONTROLFILE\/current.262.1018190533 ORA-15001: diskgroup "DGMGMTDB" does not exist or is not mounted […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/\" \/>\n<meta property=\"og:site_name\" content=\"Arumel\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-09T13:04:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-09T13:30:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/banner112.jpg?fit=1440%2C700&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"1440\" \/>\n\t<meta property=\"og:image:height\" content=\"700\" \/>\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=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/\"},\"author\":{\"name\":\"Carla Mu\u00f1oz L\u00f3pez\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/ad6b4e40f9cf337835a3c478b69e425d\"},\"headline\":\"Recreando la GIMR en Oracle 19c (MGMTDB)\",\"datePublished\":\"2019-09-09T13:04:39+00:00\",\"dateModified\":\"2019-09-09T13:30:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/\"},\"wordCount\":314,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/banner112.jpg?fit=1440%2C700&ssl=1\",\"keywords\":[\"GIMR\",\"MGMTDB\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/\",\"url\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/\",\"name\":\"Recreando la GIMR en Oracle 19c (MGMTDB) - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/banner112.jpg?fit=1440%2C700&ssl=1\",\"datePublished\":\"2019-09-09T13:04:39+00:00\",\"dateModified\":\"2019-09-09T13:30:59+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/ad6b4e40f9cf337835a3c478b69e425d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/banner112.jpg?fit=1440%2C700&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/banner112.jpg?fit=1440%2C700&ssl=1\",\"width\":1440,\"height\":700},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/recreando-la-gimr-en-oracle-19c-mgmtdb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/arumel.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recreando la GIMR en Oracle 19c (MGMTDB)\"}]},{\"@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":"Recreando la GIMR en Oracle 19c (MGMTDB) - 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\/recreando-la-gimr-en-oracle-19c-mgmtdb\/","og_locale":"es_ES","og_type":"article","og_title":"Recreando la GIMR en Oracle 19c (MGMTDB) - Arumel","og_description":"Realizando una tarea que consist\u00eda en cambiar el compatible.rdbms de los diskgroups de ASM a versi\u00f3n 18c me encontr\u00e9 que la GIMR se vi\u00f3 afectada, a pesar de ser la GI versi\u00f3n 19c. ORA-00202: control file: '+DGMGMTDB\/_MGMTDB\/CONTROLFILE\/current.262.1018190533' ORA-17503: ksfdopn:2 Failed to open file +DGMGMTDB\/_MGMTDB\/CONTROLFILE\/current.262.1018190533 ORA-15001: diskgroup \"DGMGMTDB\" does not exist or is not mounted […]","og_url":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/","og_site_name":"Arumel","article_published_time":"2019-09-09T13:04:39+00:00","article_modified_time":"2019-09-09T13:30:59+00:00","og_image":[{"width":1440,"height":700,"url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/banner112.jpg?fit=1440%2C700&ssl=1","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":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/#article","isPartOf":{"@id":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/"},"author":{"name":"Carla Mu\u00f1oz L\u00f3pez","@id":"http:\/\/arumel.com\/#\/schema\/person\/ad6b4e40f9cf337835a3c478b69e425d"},"headline":"Recreando la GIMR en Oracle 19c (MGMTDB)","datePublished":"2019-09-09T13:04:39+00:00","dateModified":"2019-09-09T13:30:59+00:00","mainEntityOfPage":{"@id":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/"},"wordCount":314,"commentCount":0,"image":{"@id":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/banner112.jpg?fit=1440%2C700&ssl=1","keywords":["GIMR","MGMTDB"],"articleSection":["Oracle"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/","url":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/","name":"Recreando la GIMR en Oracle 19c (MGMTDB) - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/#primaryimage"},"image":{"@id":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/banner112.jpg?fit=1440%2C700&ssl=1","datePublished":"2019-09-09T13:04:39+00:00","dateModified":"2019-09-09T13:30:59+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/ad6b4e40f9cf337835a3c478b69e425d"},"breadcrumb":{"@id":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/#primaryimage","url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/banner112.jpg?fit=1440%2C700&ssl=1","contentUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/banner112.jpg?fit=1440%2C700&ssl=1","width":1440,"height":700},{"@type":"BreadcrumbList","@id":"https:\/\/arumel.com\/es\/recreando-la-gimr-en-oracle-19c-mgmtdb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/arumel.com\/es\/"},{"@type":"ListItem","position":2,"name":"Recreando la GIMR en Oracle 19c (MGMTDB)"}]},{"@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-2xp","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":9586,"url":"https:\/\/arumel.com\/es\/anadir-gimr-manualmente-version-12-2-0-x\/","url_meta":{"origin":9759,"position":0},"title":"A\u00f1adir GIMR manualmente versi\u00f3n 12.2.0.X","author":"sm","date":"19 de julio de 2019","format":false,"excerpt":"Tras una instalaci\u00f3n vimos en un cliente que no estaba la base de datos del MGMTDB creada pero que ten\u00eda el diskgroup. Revisando la nota \"MDBUtil: GI Management Repository configuration tool (Doc ID 2065175.1)\" decidimos a\u00f1adirla a mano. Comprobamos que no existe: [root@nodo01 tmp]# crsctl stat res -w \"NAME =\u2026","rel":"","context":"En "Oracle"","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":8324,"url":"https:\/\/arumel.com\/es\/cambiar-ocr-de-diskgroup\/","url_meta":{"origin":9759,"position":1},"title":"Cambiar ocr de diskgroup","author":"sm","date":"11 de agosto de 2017","format":false,"excerpt":"","rel":"","context":"En "Oracle"","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":9592,"url":"https:\/\/arumel.com\/en\/adding-manually-the-gimr-in-12-2-0-x-version\/","url_meta":{"origin":9759,"position":2},"title":"Adding manually the GIMR in 12.2.0.X version","author":"sm","date":"19 de julio de 2019","format":false,"excerpt":"Now you can add the internal database MGMTDB after the GI installation. Follow the note \u00abMDBUtil: GI Management Repository configuration tool (Doc ID 2065175.1)\u00bb In our case we check that the GIMR not exist: [root@nodo01 tmp]# crsctl stat res -w \"NAME = ora.mgmtdb\" Check where is the path for this\u2026","rel":"","context":"En "Oracle"","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/en\/oracle-en\/"},"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":8331,"url":"https:\/\/arumel.com\/en\/change-ocr-diskgroup\/","url_meta":{"origin":9759,"position":3},"title":"Change ocr of diskgroup","author":"sm","date":"11 de agosto de 2017","format":false,"excerpt":"","rel":"","context":"En "Oracle"","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/en\/oracle-en\/"},"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":8373,"url":"https:\/\/arumel.com\/en\/response-file-gi-12-2\/","url_meta":{"origin":9759,"position":4},"title":"Response file GI 12.2","author":"sm","date":"12 de agosto de 2017","format":false,"excerpt":"","rel":"","context":"En "Oracle"","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/en\/oracle-en\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8371,"url":"https:\/\/arumel.com\/es\/response-file-gi-12-2\/","url_meta":{"origin":9759,"position":5},"title":"Response file GI 12.2","author":"sm","date":"12 de agosto de 2017","format":false,"excerpt":"","rel":"","context":"En "Oracle"","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2016\/11\/banner112.jpg?fit=1440%2C700&ssl=1","_links":{"self":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/9759","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=9759"}],"version-history":[{"count":15,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/9759\/revisions"}],"predecessor-version":[{"id":9774,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/9759\/revisions\/9774"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media\/181"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media?parent=9759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/categories?post=9759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/tags?post=9759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}