Shulou(Shulou.com)06/01 Report--

After installing grid in Grid Infrastructure 12.1.0.2, you can see that ora.MGMTLSNR and ora.mgmtdb are added to the resources, and an instance, sid=-MGMTDB.

[grid@prodb1] $crsctl status res-t----Name Target State Server State details-- -Local Resources-- -- ora.LISTENER.lsnr ONLINE ONLINE prodb1 STABLE ONLINE ONLINE prodb2 STABLEora.OCR_VOTE.dg ONLINE ONLINE prodb1 STABLE ONLINE ONLINE prodb2 STABLEora.asm ONLINE ONLINE prodb1 Started STABLE ONLINE ONLINE prodb2 Started STABLEora.net1.network ONLINE ONLINE prodb1 STABLE ONLINE ONLINE prodb2 STABLEora.ons ONLINE ONLINE prodb1 STABLE ONLINE ONLINE prodb2 STABLE- -Cluster Resources -ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE prodb1 STABLEora.MGMTLSNR 1 ONLINE ONLINE prodb1 169.254.124.55 192.1 68.0.101 STABLEora.cvu 1 ONLINE ONLINE prodb1 STABLEora.mgmtdb 1 ONLINE ONLINE prodb1 Open STABLEora.oc4j 1 ONLINE ONLINE prodb1 STABLEora.prodb1.vip 1 ONLINE ONLINE prodb1 STABLEora.prodb2.vip 1 ONLINE ONLINE prodb2 STABLEora.scan1.vip 1 ONLINE ONLINE prodb1 STABLE- -[grid@prodb1 ~] $ps-ef | grep pmongrid 3443 10 20:16? 00:00:00 mdb_pmon_-MGMTDBgrid 10452 10 19:29? 00:00:00 asm_pmon_+ASM1

Management Repository is a single instance database managed by Oracle Clusterware in 12c. Because it is a single instance database, it will start and run on one node in the cluster; because it is managed by GI, if the managed node shuts down, the database will automatically fail over to other nodes. The management database stores a central repository of Cluster Health Monitor (CHM / OS,ora.crf) and other data in 12c. By default, the Management database uses the same shared storage as OCR/Voting File; in 12.2, a fresh installation allows individual disk groups to be specified.

In 12.1.0.1, GIMR is optional, and if you do not choose to configure the management database during installation / upgrade, all features that depend on it (CHM / OS) will be disabled.

GIMR is installed by default in 12.1.0.2 and is not optional. And closing it is not supported except for Exadata.

Start the database:

The management database is managed by GI and can be started and run automatically. If it is closed for some reason, you can start it using the following srvctl command:

Usage: srvctl start mgmtdb [- startoption] [- node] usage: srvctl start mgmtlsnr [- node]

Log in to the database:

[grid@prodb1] $export ORACLE_SID=-MGMTDB [grid@prodb1 ~] $sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on 0 21:04:42 2019Copyright (c) 1982, 2014, Oracle. All rights reserved. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning Automatic Storage Management and Advanced Analytics optionsSQL > show parameter dumpNAME TYPE VALUE -background_core_dump string partialbackground_dump_dest string / u01/app/12.2/grid/rdbms/logcore_dump_dest string / u01/app/grid/diag/rdbms/_mgmt Db/-MGMTDB/cdumpmax_dump_file_size string unlimitedshadow_core_dump string partialuser_dump_dest string / u01/app/12.2/grid/rdbms/logSQL > select file_id File_name from dba_data_files FILE_ID FILE_NAME--4 + OCR_VOTE/_MGMTDB/DATAFILE/undotbs1.259.998942293 1 + OCR_VOTE/_MGMTDB/DATAFILE/system.258.998942257 3 + OCR_VOTE/_MGMTDB/DATAFILE/sysaux.257.998942237

View trc:

[grid@prodb1 ~] $cd / u01/app/grid/diag/rdbms/_mgmtdb/ [grid @ prodb1 _ mgmtdb] $cd-MGMTDB/ # Direct cd will report an error-bash: cd:-M: invalid optioncd: usage: cd [- L | [- P [- e] [dir] [grid@prodb1 _ mgmtdb] $cd. /-MGMTDB/ [grid@prodb1-MGMTDB] $cd trace [grid@prodb1 trace] $ls-MGMTDB_aqpc_30744.trc-MGMTDB_dbw0_23833 .trm-MGMTDB_m000_31720.trc-MGMTDB_ora_1441.trm-MGMTDB_ora_30748.trc-MGMTDB_rbal_3479.trm-MGMTDB_aqpc_30744.trm-MGMTDB_dbw0_24548.trc-MGMTDB_m000_31720.trm-MGMTDB_ora_1568.trc-MGMTDB_ora_30748.trm-MGMTDB_tt00_24976.trc

Clean up trc:

[grid@prodb1 trace] $adrciADRCI: Release 12.1.0.2.0-Production on 0 21:11:07 2019Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.ADR base = "/ u01/app/grid" adrci > show homeADR Homes: diag/rdbms/_mgmtdb/-MGMTDBadrci > purge-age 0adrci > quit [grid@prodb1 trace] $lsalert_-MGMTDB.log

Back up the database:

Oracle does not specify that the database needs to be backed up.

Listening port:

In version 12.2, the default for MGMT listeners is 1525.

Space requirements:

For: Oracle Cluster Registry (OCR) and Grid Infrastructure Management Repository with external redundancy

Minimum: OCR volumes containing Grid Infrastructure Management Repository (4.5 GB + 300 MB voting files + 400 MB OCR) are at least 5.2 GB, plus 500 MB per node for clusters with more than four nodes. For example, the six-node cluster assignment should be 6.2 GB.

Reference: http://docs.oracle.com/database/121/CWLIN/storage.htm#CHDDCAHD

The actual installation process 12.1.0.2 requires a total of about 5.9G space.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.