prcr 1086 resource

PRCR 1086 resource ora.mgmtdb is already registered

PRCR 1086 resource ora.mgmtdb is already registered

In this article i’m going discuss PRCR 1086 resource which i was facing at the time of grid configuration on Oracle Linux 6.7 platform. I was checked the the logfile for grid configuration which is existing on following path “/u01/app/oraInventory/logs/installActions2019-03-16_09-10-07PM.log“, and got the following information from the log.

You must know how to drop ASM disk group?

INFO: No arguments to pass to stdin
INFO: ... GenericInternalPlugIn: starting read loop.
INFO: Read: Cleaning up failed steps
WARNING: Skipping line: Cleaning up failed steps
INFO: End of argument passing to stdin
INFO: Read: 5% complete
WARNING: Skipping line: 5% complete
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: Registering database with Oracle Grid Infrastructure
WARNING: Skipping line: Registering database with Oracle Grid Infrastructure
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: DBCA Operation failed.
WARNING: Skipping line: DBCA Operation failed.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb5.log" for further details.
WARNING: Skipping line: Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb5.log" for further details.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Completed Plugin named: Creating Container Database for Oracle Grid Infrastructure Management Repository
INFO: Creating Container Database for Oracle Grid Infrastructure Management Repository failed.
INFO: Creating Container Database for Oracle Grid Infrastructure Management Repository failed.
INFO: ConfigClient.executeSelectedToolsInAggregate action performed
INFO: Exiting ConfigClient.executeSelectedToolsInAggregate method

After checking the logfile i’m doing google and found something interesting which i’m going to share with you.

During Grid configuration a one database is created by default with the name of MGMTB so our configuration stuck here then we need to delete this DB configuration, once the configuration is deleted then click on try again.

Go on following path using cd command as a GRID user.

$cd /u01/app/12.1.0/grid/bin

Then run the following command which is delete the configuration of MGMTB db.

$dbca -silent -deleteDatabase -sourceDB -MGMTDB

Output of above Query:

Connecting to database
4% complete
9% complete
14% complete
19% complete
23% complete
28% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instance and datafiles
76% complete
100% complete
Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb.log" for further details.

Now you can go head for your grid configuration, hopefully you will be successfully done your configuration.

I found this solution from “https://www.hhutzler.de/blog/recreate-the-gi-management-repository-database-12-1-0-1/#Delete_old_MGMTDB_database”.

You Can subscribe my YouTube channel

Share this
Share

1 thought on “PRCR 1086 resource ora.mgmtdb is already registered”

Leave a Comment

Share