适用范围 适用于Oracle 19c 19.27以前版本数据库 方案概述 重建Management Repository GIMR和启用MGMTDB 实施步骤 1、前置准备 1.1 准备脚本 在官网下载mdbutil.pl脚本并上传到oracle数据库服务器grid用户下。 1.2 检查ASM磁盘组空间 ASM磁盘组有至少80G空间，使用现有ASM磁盘组或者新建ASM磁盘组+MGMTDG
[grid@host01 ~]$ asmcmd lsdg
2、实施步骤 2.1检查集群状态和版本
[grid@host01 ~]$crsctl stat res -t [grid@host01 ~]$ crsctl status res ora.crf -init NAME=ora.crf TYPE=ora.crf.type TARGET=OFFLINE STATE=OFFLINE--检查节点1[grid@host01 ~]$ crsctl query crs softwareversion Oracle Clusterware version on node [host01] is [19.0.0.0.0] [grid@host01 ~]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [19.0.0.0.0] [grid@host01 ~]$ crsctl query crs softwarepatch Oracle Clusterware patch level on node host01 is [1944883066].--检查节点2[grid@host02 ~]$ crsctl query crs softwareversion Oracle Clusterware version on node [host02] is [19.0.0.0.0] [grid@host02 ~]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [19.0.0.0.0] [grid@host02 ~]$ crsctl query crs softwarepatch Oracle Clusterware patch level on node host02 is [1944883066].
2.2关闭ora.crs资源 使用root用户在每个节点执行以下命令
[root@host01 ~]# <GI_HOME>/bin/crsctl stop res ora.crf -init[root@host01 ~]# <GI_HOME>/bin/crsctl modify res ora.crf -attr ENABLED=0 -init
2.3创建MGMTDB数据库 mdbutil.pl脚本是GI Management Repository 管理维护工具，创建MGMTDB数据库也可以使用该脚本，该脚本是Oracle官方提供的维护GIMR的，执行时确保权限正常，生产环境执行该脚本先在测试环境进行充分测试后再实施。 注意：从19.27开始mdbutil.pl脚本已不在支持GIMR。
[grid@host01 ~] ./mdbutil.pl -h Usage: Create/Enable MGMTDB & CHM mdbutil.pl --addmdb --target= Move MGMTDB to another location mdbutil.pl --mvmgmtdb --target= Check MGMTDB status mdbutil.pl --status mdbutil.pl OPTIONS --addmdb Create MGMTDB/CHM and reconfigure related functions --mvmgmtdb Migrate MGMTDB to another location --target='+DATA' MGMTDB Disk Group location --status Check the CHM & MGMTDB status --help Display this help and exit --debug Verbose commands output/trace Example: Create/Enable MGMTDB: mdbutil.pl --addmdb --target=+DATA Move MGMTDB to another location: mdbutil.pl --mvmgmtdb --target=+REDO Check CHM: mdbutil.pl --status
使用grid用户执行以下命令
[grid@host01 ~]./mdbutil.pl --addmdb --target=+MGMTDGmdbutil.pl version : 1.102 2025-08-08 23:34:49: I Starting To Configure MGMTDB at +MGMT... 2025-08-08 23:34:51: I Container database creation in progress... for GI 19.0.0.0.0 2025-08-08 23:46:54: I Plugable database creation in progress... 2025-08-08 23:49:04: I Executing "/tmp/mdbutil.pl --addchm" on host01 as root to configure CHM.2025-08-08 23:50:53: W Not able to execute "/tmp/mdbutil.pl --addchm" on host01 as root to configure CHM.2025-08-08 23:50:53: I Executing "/tmp/mdbutil.pl --addchm" on host01 as root to configure CHM.2025-08-08 23:50:58: W Not able to execute "/tmp/mdbutil.pl --addchm" on host01 as root to configure CHM.2025-08-08 23:50:58: I MGMTDB & CHM configuration done!
2.4检查MGMTDB状态
/mdbutil.pl –status [grid@host01 ~]$ srvctl status mgmtdb Database is enabled Instance -MGMTDB is running on node host01
2.5检查集群状态
$crsctl stat res -t [grid@host01 _mgmtdb]$ crsctl stat res -t---------------------------------------------------------------------------Name Target State Server State details ---------------------------------------------------------------------------Local Resources---------------------------------------------------------------------------ora.LISTENER.lsnr ONLINE ONLINE host01 STABLE ora.chad OFFLINE OFFLINE host01 STABLE ora.net1.network ONLINE ONLINE host01 STABLE ora.ons ONLINE ONLINE host01 STABLE ora.proxy_advm OFFLINE OFFLINE host01 STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE host01 STABLE 2 ONLINE OFFLINE STABLE 3 ONLINE OFFLINE STABLE ora.CESDB_DATA.dg(ora.asmgroup) 1 ONLINE ONLINE host01 STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE host01 STABLE ora.MGMTDG.dg(ora.asmgroup) 1 ONLINE ONLINE host01 STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.MGMTLSNR 1 ONLINE ONLINE host01 10.10.10.191,STABLE ora.OCR.dg(ora.asmgroup) 1 ONLINE ONLINE host01 STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE host01 Started,STABLE 2 ONLINE OFFLINE STABLE 3 ONLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE host01 STABLE 2 ONLINE OFFLINE STABLE 3 ONLINE OFFLINE STABLE ora.cvu 1 OFFLINE OFFLINE STABLE ora.dev19c.db 1 ONLINE ONLINE host01 Open,HOME=/u01/app/oracle/product/19c/db _1,STABLE 2 ONLINE OFFLINE STABLE ora.dev19c.dev19c_ro.svc 1 OFFLINE OFFLINE STABLE 2 OFFLINE OFFLINE STABLE ora.dev19c.dev19c_rw.svc 1 OFFLINE OFFLINE STABLE 2 ONLINE ONLINE host01 STABLE ora.dev19c.devpdb1.svc 1 ONLINE ONLINE host01 STABLE ora.mgmtdb 1 ONLINE ONLINE host01 Open,STABLE ora.qosmserver 1 ONLINE ONLINE host01 STABLE ora.host01.vip 1 ONLINE ONLINE host01 STABLE OVER,STABLE ora.scan1.vip 1 ONLINE ONLINE host01 STABLE
集群中已经有了ora.mgmtdb资源
2.6检查MGMTDB状态
[grid@host01 ~]$ srvctl status MGMTDB Database is enabled Instance -MGMTDB is running on node host01 [grid@ host01 ~]$ srvctl config mgmtdb Database unique name: _mgmtdb Database name: Oracle home: <CRS home> Oracle user: grid Spfile: +MGMTDG/_MGMTDB/PARAMETERFILE/spfile.269.1208613661 Password file: +MGMTDG/_MGMTDB/PASSWORD/pwd_mgmtdb.256.1208612757 Domain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICType: ManagementPDB name: GIMR_DSCREP_10 PDB service: GIMR_DSCREP_10 Cluster name: rac-clusterDatabase instance: -MGMTDB
MGMTDB数据库已启用，数据库状态正常。MGMTDB是多租户架构“单C单P”-一个CDB中一个PDB。 2.7检查监听状态
[grid@host01 ~]$ ps -eaf | grep tns root 15 2 0 20:05 ? 00:00:00 [netns] grid 1168 892 0 22:37 pts/0 00:00:00 grep --color=auto tnsgrid 3974 1 0 20:06 ? 00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit grid 4064 1 0 20:06 ? 00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 4092 1 0 20:06 ? 00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit grid 4103 1 0 20:06 ? 00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit [grid@host01 ~]$ lsnrctl status MGMTLSNR LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 14-MAR-2016 22:38:03 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=MGMTLSNR))) STATUS of the LISTENER------------------------Alias MGMTLSNR Version TNSLSNR for Linux: Version 12.1.0.2.0 - ProductionStart Date 14-MAR-2016 20:06:33Uptime 0 days 2 hr. 31 min. 29 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/12.1.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/host01/mgmtlsnr/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=MGMTLSNR))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.100.61)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=169.254.146.121)(PORT=1521))) Services Summary... Service "-MGMTDBXDB" has 1 instance(s). Instance "-MGMTDB", status READY, has 1 handler(s) for this service... Service "_mgmtdb" has 1 instance(s). Instance "-MGMTDB", status READY, has 1 handler(s) for this service... Service "racnode_cluster" has 1 instance(s). Instance "-MGMTDB", status READY, has 1 handler(s) for this service... The command completed successfully
已经增加了MGMTLSNR监听，服务名_mgmtdb，监听状态正常。
2.8启动ora.crf 分别在两个节点使用root用户执行以下命令
# <GI_HOME>/bin/crsctl modify res ora.crf -attr ENABLED=1 -init# <GI_HOME>/bin/crsctl start res ora.crf -init[root@host01 ~]# $GRID_HOME/bin/crsctl start res ora.crf -initCRS-2672: Attempting to start 'ora.crf' on 'host01'CRS-2676: Start of 'ora.crf' on 'host01' succeeded [root@host01 ~]#[root@host02 bin]# $GRID_HOM/bin/crsctl modify res ora.crf -attr ENABLED=1 -init[root@host02 bin]# $GRID_HOM/bin/crsctl start res ora.crf -initCRS-2672: Attempting to start 'ora.crf' on 'host02'CRS-2676: Start of 'ora.crf' on 'host02' succeeded [root@host02 ~]#
-the end-
------------------------------------------------------------------------------------------------------------------------------------
**MyBologs：**
https://www.myhfxf.com
https://www.xiaofeihuangfu.com
CSDN: https://blog.csdn.net/xfhuangfu
ITPUB: https://blog.itpub.net/28373936/
微信公众号：xfhuangfu
------------------------------------------------------------------------------------------------------------------------------------
