Scenario Preview :
We recently doing upgrade activity on 12.1.0.2.0 to 12.2.0.1.0 grid 12c . We already executed /u01/app/12.2.0/grid/rootupgrade.sh on both the nodes and executed successfully.
But on 70% we face error [INS-20802] Creating Container Database for Oracle Grid Infrastructure Management Repository failed. After troubleshooting we found there is conflict in mgmtlsnr 1521 during mgmtdb installation due to this we are facing this issue, But when i check at my end the mgmtlsnr port was 1526 , Same issue i faced during 2 node RAC 12c installation on SLES 12 linux. but then mgmtlsnr was 1521. That scenario was different as at that time i have to install grid 12c on existing production databases on same operating system SLES 12 SP4 . So i have changed the port of standalone DB . After that i have install grid 12c on same OS. It goes smoothly without error.
Previously i have done upgrade same scenario on OEL 6.7 opearting system grid upgrade done with out error. There is bug issue in SLES SUSE linux 12 SP4.
In this scenario mgmtlsnr was 1526 there shouldn't be no port conflict. But after so many troubleshooting and try i have follow some blogs and (Doc ID 2191588.1) and installation completed successfully.
At the end cluster verification utility got failed this is the bug on SLES 12SP4 already mentioned in oracle metalink and we have to apply patch to resolve this issue. There is no affect on clusterware performance in my production it is working perfectly fine. In OEL operating system i do not see any cluster verification utility error. I have limitation to work in SUSE linux (:
Reference : 12c Grid Infrastructure Installation Fails While Creating Container Database: GIMR CRS-2800: Cannot start resource 'ora.MGMTLSNR' (Doc ID 2191588.1)
Error :
[INS-20802] Creating Container Database for Oracle Grid Infrastructure Management Repository failed.
Cause - The plug-in failed in its perform method
Action - Refer to the logs or contact Oracle Support Services. Log File Location
/u01/app/oraInventory/logs/GridSetupActions2020-07-24_06-04-56PM/gridSetupActions2020-07-24_06-04-56PM.log
Grid Upgrade log error:
INFO: [Jul 24, 2020 8:56:17 PM] Executing MGMTDBCDB
INFO: [Jul 24, 2020 8:56:17 PM] Command /u01/app/12.2.0/grid/bin/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName CRS -datafileJarLocation /u01/app/12.2.0/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck -oui_internal
INFO: [Jul 24, 2020 8:56:17 PM] ... GenericInternalPlugIn.handleProcess() entered.
INFO: [Jul 24, 2020 8:56:17 PM] ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: [Jul 24, 2020 8:56:17 PM] ... GenericInternalPlugIn: checking secretArguments.
INFO: [Jul 24, 2020 8:56:17 PM] No arguments to pass to stdin
INFO: [Jul 24, 2020 8:56:17 PM] ... GenericInternalPlugIn: starting read loop.
INFO: [Jul 24, 2020 8:59:23 PM] Read: Registering database with Oracle Grid Infrastructure
INFO: [Jul 24, 2020 8:59:23 PM] Registering database with Oracle Grid Infrastructure
WARNING: [Jul 24, 2020 8:59:23 PM] Skipping line: Registering database with Oracle Grid Infrastructure
INFO: [Jul 24, 2020 8:59:23 PM] End of argument passing to stdin
INFO: [Jul 24, 2020 8:59:24 PM] Read: 5% complete
WARNING: [Jul 24, 2020 8:59:24 PM] Skipping line: 5% complete
INFO: [Jul 24, 2020 8:59:24 PM] Read: Copying database files
INFO: [Jul 24, 2020 8:59:24 PM] Copying database files
WARNING: [Jul 24, 2020 8:59:24 PM] Skipping line: Copying database files
INFO: [Jul 24, 2020 8:59:24 PM] Read: 6% complete
WARNING: [Jul 24, 2020 8:59:24 PM] Skipping line: 6% complete
INFO: [Jul 24, 2020 8:59:52 PM] Read: 7% complete
WARNING: [Jul 24, 2020 8:59:52 PM] Skipping line: 7% complete
INFO: [Jul 24, 2020 9:00:49 PM] Read: 22% complete
WARNING: [Jul 24, 2020 9:00:49 PM] Skipping line: 22% complete
INFO: [Jul 24, 2020 9:00:49 PM] Read: 36% complete
WARNING: [Jul 24, 2020 9:00:49 PM] Skipping line: 36% complete
INFO: [Jul 24, 2020 9:00:49 PM] Read: Creating and starting Oracle instance
INFO: [Jul 24, 2020 9:00:49 PM] Creating and starting Oracle instance
WARNING: [Jul 24, 2020 9:00:49 PM] Skipping line: Creating and starting Oracle instance
INFO: [Jul 24, 2020 9:02:10 PM] Read: 37% complete
WARNING: [Jul 24, 2020 9:02:10 PM] Skipping line: 37% complete
INFO: [Jul 24, 2020 9:02:41 PM] Read: 39% complete
WARNING: [Jul 24, 2020 9:02:41 PM] Skipping line: 39% complete
INFO: [Jul 24, 2020 9:06:59 PM] Read: 43% complete
WARNING: [Jul 24, 2020 9:06:59 PM] Skipping line: 43% complete
INFO: [Jul 24, 2020 9:07:36 PM] Read: 44% complete
WARNING: [Jul 24, 2020 9:07:36 PM] Skipping line: 44% complete
INFO: [Jul 24, 2020 9:08:24 PM] Read: 45% complete
WARNING: [Jul 24, 2020 9:08:24 PM] Skipping line: 45% complete
INFO: [Jul 24, 2020 9:09:44 PM] Read: 49% complete
WARNING: [Jul 24, 2020 9:09:44 PM] Skipping line: 49% complete
INFO: [Jul 24, 2020 9:09:45 PM] Read: 53% complete
WARNING: [Jul 24, 2020 9:09:45 PM] Skipping line: 53% complete
INFO: [Jul 24, 2020 9:11:09 PM] Read: 54% complete
WARNING: [Jul 24, 2020 9:11:09 PM] Skipping line: 54% complete
INFO: [Jul 24, 2020 9:11:14 PM] Read: 55% complete
WARNING: [Jul 24, 2020 9:11:14 PM] Skipping line: 55% complete
INFO: [Jul 24, 2020 9:11:50 PM] Read: 58% complete
WARNING: [Jul 24, 2020 9:11:50 PM] Skipping line: 58% complete
INFO: [Jul 24, 2020 9:11:50 PM] Read: Completing Database Creation
INFO: [Jul 24, 2020 9:11:50 PM] Completing Database Creation
WARNING: [Jul 24, 2020 9:11:50 PM] Skipping line: Completing Database Creation
INFO: [Jul 24, 2020 9:11:51 PM] Read: 59% complete
WARNING: [Jul 24, 2020 9:11:51 PM] Skipping line: 59% complete
INFO: [Jul 24, 2020 9:12:08 PM] Read: 62% complete
WARNING: [Jul 24, 2020 9:12:08 PM] Skipping line: 62% complete
INFO: [Jul 24, 2020 9:21:13 PM] Read: 63% complete
WARNING: [Jul 24, 2020 9:21:13 PM] Skipping line: 63% complete
INFO: [Jul 24, 2020 9:22:39 PM] Read: DBCA Operation failed.
INFO: [Jul 24, 2020 9:22:39 PM] DBCA Operation failed.
WARNING: [Jul 24, 2020 9:22:39 PM] Skipping line: DBCA Operation failed.
INFO: [Jul 24, 2020 9:22:39 PM] Read: Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb0.log" for further details.
INFO: [Jul 24, 2020 9:22:39 PM] Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb0.log" for further details.
WARNING: [Jul 24, 2020 9:22:39 PM] Skipping line: Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb0.log" for further details.
INFO: [Jul 24, 2020 9:22:42 PM] Completed Plugin named: Creating Container Database for Oracle Grid Infrastructure Management Repository
INFO: [Jul 24, 2020 10:58:14 PM] Creating Container Database for Oracle Grid Infrastructure Management Repository failed.
INFO: [Jul 24, 2020 10:58:14 PM] Creating Container Database for Oracle Grid Infrastructure Management Repository failed.
MGMTDB logs:
srv1:/u01/app/grid/cfgtoollogs/dbca/_mgmtdb # tail -1000f /u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb2.log
Registering database with Oracle Grid Infrastructure
DBCA_PROGRESS : 5%
Copying database files
DBCA_PROGRESS : 6%
DBCA_PROGRESS : 7%
DBCA_PROGRESS : 22%
DBCA_PROGRESS : 36%
Creating and starting Oracle instance
DBCA_PROGRESS : 37%
DBCA_PROGRESS : 39%
DBCA_PROGRESS : 43%
DBCA_PROGRESS : 44%
DBCA_PROGRESS : 45%
DBCA_PROGRESS : 49%
DBCA_PROGRESS : 53%
DBCA_PROGRESS : 54%
DBCA_PROGRESS : 55%
DBCA_PROGRESS : 58%
Completing Database Creation
DBCA_PROGRESS : 59%
DBCA_PROGRESS : 62%
ORA-01034: ORACLE not available
ORA-01034: ORACLE not available
ORA-01034: ORACLE not available
DBCA_PROGRESS : DBCA Operation failed.
Solution : (Doc ID 2191588.1)
srv1:~ # srvctl config MGMTLSNR
Name: MGMTLSNR
Type: Management Listener
Owner: grid
Home: <CRS home>
End points: TCP:1526
Management listener is enabled.
Management listener is individually enabled on nodes:
Management listener is individually disabled on nodes:
srv1:~ #
srv1:~ # srvctl stop mgmtlsnr -n srv1 -f
srv1:~ # crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.CRS.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.DATA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.FRA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.net1.network
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.ons
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE srv2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.MGMTLSNR
1 OFFLINE OFFLINE 169.254.185.74 192.1
68.10.1,STABLE
ora.asm
1 ONLINE ONLINE srv1 STABLE
2 ONLINE ONLINE srv2 STABLE
ora.cvu
1 ONLINE ONLINE srv2 STABLE
ora.qosmserver
1 ONLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE srv2 STABLE
ora.scan2.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan3.vip
1 ONLINE ONLINE srv1 STABLE
ora.smrplm.db
1 ONLINE ONLINE srv1 Open,HOME=/u01/app/o
racle/product/12.1.0
/dbhome_1,STABLE
2 ONLINE ONLINE srv2 Open,HOME=/u01/app/o
racle/product/12.1.0
/dbhome_1,STABLE
ora.smrplm.pretafplm.svc
1 OFFLINE OFFLINE STABLE
ora.smrplm.pretafplm_preconnect.svc
1 OFFLINE OFFLINE STABLE
ora.srv1.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv2.vip
1 ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
srv1:~ # srvctl modify mgmtlsnr -endpoints "TCP:1531"
srv1:~ # srvctl start MGMTLSNR
srv1:~ # srvctl config MGMTLSNR
Name: MGMTLSNR
Type: Management Listener
Owner: grid
Home: <CRS home>
End points: TCP:1531
Management listener is enabled.
Management listener is individually enabled on nodes:
Management listener is individually disabled on nodes:
INFO: [Jul 25, 2020 12:42:40 AM] Executing MGMTDBCDB
INFO: [Jul 25, 2020 12:42:40 AM] Command /u01/app/12.2.0/grid/bin/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName CRS -datafileJarLocation /u01/app/12.2.0/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck -oui_internal
INFO: [Jul 25, 2020 12:42:40 AM] ... GenericInternalPlugIn.handleProcess() entered.
INFO: [Jul 25, 2020 12:42:40 AM] ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: [Jul 25, 2020 12:42:40 AM] ... GenericInternalPlugIn: checking secretArguments.
INFO: [Jul 25, 2020 12:42:40 AM] No arguments to pass to stdin
INFO: [Jul 25, 2020 12:42:40 AM] ... GenericInternalPlugIn: starting read loop.
INFO: [Jul 25, 2020 12:43:54 AM] Read: Registering database with Oracle Grid Infrastructure
INFO: [Jul 25, 2020 12:43:54 AM] Registering database with Oracle Grid Infrastructure
WARNING: [Jul 25, 2020 12:43:54 AM] Skipping line: Registering database with Oracle Grid Infrastructure
INFO: [Jul 25, 2020 12:43:54 AM] End of argument passing to stdin
INFO: [Jul 25, 2020 12:43:55 AM] Read: 5% complete
WARNING: [Jul 25, 2020 12:43:55 AM] Skipping line: 5% complete
INFO: [Jul 25, 2020 12:43:55 AM] Read: Copying database files
INFO: [Jul 25, 2020 12:43:55 AM] Copying database files
WARNING: [Jul 25, 2020 12:43:55 AM] Skipping line: Copying database files
INFO: [Jul 25, 2020 12:43:56 AM] Read: 6% complete
WARNING: [Jul 25, 2020 12:43:56 AM] Skipping line: 6% complete
INFO: [Jul 25, 2020 12:44:14 AM] Read: 7% complete
WARNING: [Jul 25, 2020 12:44:14 AM] Skipping line: 7% complete
INFO: [Jul 25, 2020 12:45:00 AM] Read: 22% complete
WARNING: [Jul 25, 2020 12:45:00 AM] Skipping line: 22% complete
INFO: [Jul 25, 2020 12:45:00 AM] Read: 36% complete
WARNING: [Jul 25, 2020 12:45:00 AM] Skipping line: 36% complete
INFO: [Jul 25, 2020 12:45:00 AM] Read: Creating and starting Oracle instance
INFO: [Jul 25, 2020 12:45:00 AM] Creating and starting Oracle instance
WARNING: [Jul 25, 2020 12:45:00 AM] Skipping line: Creating and starting Oracle instance
INFO: [Jul 25, 2020 12:45:25 AM] Read: 37% complete
WARNING: [Jul 25, 2020 12:45:25 AM] Skipping line: 37% complete
INFO: [Jul 25, 2020 12:45:56 AM] Read: 39% complete
WARNING: [Jul 25, 2020 12:45:56 AM] Skipping line: 39% complete
INFO: [Jul 25, 2020 12:49:40 AM] Read: 43% complete
WARNING: [Jul 25, 2020 12:49:40 AM] Skipping line: 43% complete
INFO: [Jul 25, 2020 12:50:09 AM] Read: 44% complete
WARNING: [Jul 25, 2020 12:50:09 AM] Skipping line: 44% complete
INFO: [Jul 25, 2020 12:50:40 AM] Read: 45% complete
WARNING: [Jul 25, 2020 12:50:40 AM] Skipping line: 45% complete
INFO: [Jul 25, 2020 12:51:54 AM] Read: 49% complete
WARNING: [Jul 25, 2020 12:51:54 AM] Skipping line: 49% complete
INFO: [Jul 25, 2020 12:51:55 AM] Read: 53% complete
WARNING: [Jul 25, 2020 12:51:55 AM] Skipping line: 53% complete
INFO: [Jul 25, 2020 12:52:57 AM] Read: 54% complete
WARNING: [Jul 25, 2020 12:52:57 AM] Skipping line: 54% complete
INFO: [Jul 25, 2020 12:53:01 AM] Read: 55% complete
WARNING: [Jul 25, 2020 12:53:01 AM] Skipping line: 55% complete
INFO: [Jul 25, 2020 12:53:28 AM] Read: 58% complete
WARNING: [Jul 25, 2020 12:53:28 AM] Skipping line: 58% complete
INFO: [Jul 25, 2020 12:53:28 AM] Read: Completing Database Creation
INFO: [Jul 25, 2020 12:53:28 AM] Completing Database Creation
WARNING: [Jul 25, 2020 12:53:28 AM] Skipping line: Completing Database Creation
INFO: [Jul 25, 2020 12:53:28 AM] Read: 59% complete
WARNING: [Jul 25, 2020 12:53:28 AM] Skipping line: 59% complete
INFO: [Jul 25, 2020 12:53:42 AM] Read: 62% complete
WARNING: [Jul 25, 2020 12:53:42 AM] Skipping line: 62% complete
INFO: [Jul 25, 2020 12:56:33 AM] Read: 65% complete
WARNING: [Jul 25, 2020 12:56:33 AM] Skipping line: 65% complete
INFO: [Jul 25, 2020 12:56:33 AM] Read: 68% complete
WARNING: [Jul 25, 2020 12:56:33 AM] Skipping line: 68% complete
INFO: [Jul 25, 2020 12:56:33 AM] Read: Executing Post Configuration Actions
INFO: [Jul 25, 2020 12:56:33 AM] Executing Post Configuration Actions
WARNING: [Jul 25, 2020 12:56:33 AM] Skipping line: Executing Post Configuration Actions
INFO: [Jul 25, 2020 12:56:33 AM] Read: 100% complete
WARNING: [Jul 25, 2020 12:56:33 AM] Skipping line: 100% complete
INFO: [Jul 25, 2020 12:56:33 AM] Read: Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb3.log" for further details.
INFO: [Jul 25, 2020 12:56:33 AM] Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb3.log" for further details.
WARNING: [Jul 25, 2020 12:56:33 AM] Skipping line: Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb3.log" for further details.
INFO: [Jul 25, 2020 12:56:34 AM] Completed Plugin named: Creating Container Database for Oracle Grid Infrastructure Management Repository
INFO: [Jul 25, 2020 12:56:34 AM] Completed 'Creating Container Database for Oracle Grid Infrastructure Management Repository'
INFO: [Jul 25, 2020 12:56:34 AM] Completed 'Creating Container Database for Oracle Grid Infrastructure Management Repository'
INFO: [Jul 25, 2020 12:56:34 AM] Started Plugin named: GIMR Configuration Assistant
INFO: [Jul 25, 2020 12:56:34 AM] Found associated job
INFO: [Jul 25, 2020 12:56:34 AM] Starting 'GIMR Configuration Assistant'
INFO: [Jul 25, 2020 12:56:34 AM] Starting 'GIMR Configuration Assistant'
INFO: [Jul 25, 2020 12:56:34 AM] Executing MGMTCA
INFO: [Jul 25, 2020 12:56:34 AM] Command /u01/app/12.2.0/grid/bin/mgmtca -local
INFO: [Jul 25, 2020 12:56:34 AM] ... GenericInternalPlugIn.handleProcess() entered.
INFO: [Jul 25, 2020 12:56:34 AM] ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: [Jul 25, 2020 12:56:34 AM] ... GenericInternalPlugIn: checking secretArguments.
INFO: [Jul 25, 2020 12:56:34 AM] No arguments to pass to stdin
INFO: [Jul 25, 2020 12:56:34 AM] ... GenericInternalPlugIn: starting read loop.
Clusterware Commands:
srv2:~ # crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.2.0.1.0]
srv2:~ # crsctl query crs softwareversion
Oracle Clusterware version on node [srv2] is [12.2.0.1.0]
srv2:~ #
We recently doing upgrade activity on 12.1.0.2.0 to 12.2.0.1.0 grid 12c . We already executed /u01/app/12.2.0/grid/rootupgrade.sh on both the nodes and executed successfully.
But on 70% we face error [INS-20802] Creating Container Database for Oracle Grid Infrastructure Management Repository failed. After troubleshooting we found there is conflict in mgmtlsnr 1521 during mgmtdb installation due to this we are facing this issue, But when i check at my end the mgmtlsnr port was 1526 , Same issue i faced during 2 node RAC 12c installation on SLES 12 linux. but then mgmtlsnr was 1521. That scenario was different as at that time i have to install grid 12c on existing production databases on same operating system SLES 12 SP4 . So i have changed the port of standalone DB . After that i have install grid 12c on same OS. It goes smoothly without error.
Previously i have done upgrade same scenario on OEL 6.7 opearting system grid upgrade done with out error. There is bug issue in SLES SUSE linux 12 SP4.
In this scenario mgmtlsnr was 1526 there shouldn't be no port conflict. But after so many troubleshooting and try i have follow some blogs and (Doc ID 2191588.1) and installation completed successfully.
At the end cluster verification utility got failed this is the bug on SLES 12SP4 already mentioned in oracle metalink and we have to apply patch to resolve this issue. There is no affect on clusterware performance in my production it is working perfectly fine. In OEL operating system i do not see any cluster verification utility error. I have limitation to work in SUSE linux (:
Reference : 12c Grid Infrastructure Installation Fails While Creating Container Database: GIMR CRS-2800: Cannot start resource 'ora.MGMTLSNR' (Doc ID 2191588.1)
Error :
[INS-20802] Creating Container Database for Oracle Grid Infrastructure Management Repository failed.
Cause - The plug-in failed in its perform method
Action - Refer to the logs or contact Oracle Support Services. Log File Location
/u01/app/oraInventory/logs/GridSetupActions2020-07-24_06-04-56PM/gridSetupActions2020-07-24_06-04-56PM.log
Screen Shot Reference
Grid Upgrade log error:
INFO: [Jul 24, 2020 8:56:17 PM] Executing MGMTDBCDB
INFO: [Jul 24, 2020 8:56:17 PM] Command /u01/app/12.2.0/grid/bin/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName CRS -datafileJarLocation /u01/app/12.2.0/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck -oui_internal
INFO: [Jul 24, 2020 8:56:17 PM] ... GenericInternalPlugIn.handleProcess() entered.
INFO: [Jul 24, 2020 8:56:17 PM] ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: [Jul 24, 2020 8:56:17 PM] ... GenericInternalPlugIn: checking secretArguments.
INFO: [Jul 24, 2020 8:56:17 PM] No arguments to pass to stdin
INFO: [Jul 24, 2020 8:56:17 PM] ... GenericInternalPlugIn: starting read loop.
INFO: [Jul 24, 2020 8:59:23 PM] Read: Registering database with Oracle Grid Infrastructure
INFO: [Jul 24, 2020 8:59:23 PM] Registering database with Oracle Grid Infrastructure
WARNING: [Jul 24, 2020 8:59:23 PM] Skipping line: Registering database with Oracle Grid Infrastructure
INFO: [Jul 24, 2020 8:59:23 PM] End of argument passing to stdin
INFO: [Jul 24, 2020 8:59:24 PM] Read: 5% complete
WARNING: [Jul 24, 2020 8:59:24 PM] Skipping line: 5% complete
INFO: [Jul 24, 2020 8:59:24 PM] Read: Copying database files
INFO: [Jul 24, 2020 8:59:24 PM] Copying database files
WARNING: [Jul 24, 2020 8:59:24 PM] Skipping line: Copying database files
INFO: [Jul 24, 2020 8:59:24 PM] Read: 6% complete
WARNING: [Jul 24, 2020 8:59:24 PM] Skipping line: 6% complete
INFO: [Jul 24, 2020 8:59:52 PM] Read: 7% complete
WARNING: [Jul 24, 2020 8:59:52 PM] Skipping line: 7% complete
INFO: [Jul 24, 2020 9:00:49 PM] Read: 22% complete
WARNING: [Jul 24, 2020 9:00:49 PM] Skipping line: 22% complete
INFO: [Jul 24, 2020 9:00:49 PM] Read: 36% complete
WARNING: [Jul 24, 2020 9:00:49 PM] Skipping line: 36% complete
INFO: [Jul 24, 2020 9:00:49 PM] Read: Creating and starting Oracle instance
INFO: [Jul 24, 2020 9:00:49 PM] Creating and starting Oracle instance
WARNING: [Jul 24, 2020 9:00:49 PM] Skipping line: Creating and starting Oracle instance
INFO: [Jul 24, 2020 9:02:10 PM] Read: 37% complete
WARNING: [Jul 24, 2020 9:02:10 PM] Skipping line: 37% complete
INFO: [Jul 24, 2020 9:02:41 PM] Read: 39% complete
WARNING: [Jul 24, 2020 9:02:41 PM] Skipping line: 39% complete
INFO: [Jul 24, 2020 9:06:59 PM] Read: 43% complete
WARNING: [Jul 24, 2020 9:06:59 PM] Skipping line: 43% complete
INFO: [Jul 24, 2020 9:07:36 PM] Read: 44% complete
WARNING: [Jul 24, 2020 9:07:36 PM] Skipping line: 44% complete
INFO: [Jul 24, 2020 9:08:24 PM] Read: 45% complete
WARNING: [Jul 24, 2020 9:08:24 PM] Skipping line: 45% complete
INFO: [Jul 24, 2020 9:09:44 PM] Read: 49% complete
WARNING: [Jul 24, 2020 9:09:44 PM] Skipping line: 49% complete
INFO: [Jul 24, 2020 9:09:45 PM] Read: 53% complete
WARNING: [Jul 24, 2020 9:09:45 PM] Skipping line: 53% complete
INFO: [Jul 24, 2020 9:11:09 PM] Read: 54% complete
WARNING: [Jul 24, 2020 9:11:09 PM] Skipping line: 54% complete
INFO: [Jul 24, 2020 9:11:14 PM] Read: 55% complete
WARNING: [Jul 24, 2020 9:11:14 PM] Skipping line: 55% complete
INFO: [Jul 24, 2020 9:11:50 PM] Read: 58% complete
WARNING: [Jul 24, 2020 9:11:50 PM] Skipping line: 58% complete
INFO: [Jul 24, 2020 9:11:50 PM] Read: Completing Database Creation
INFO: [Jul 24, 2020 9:11:50 PM] Completing Database Creation
WARNING: [Jul 24, 2020 9:11:50 PM] Skipping line: Completing Database Creation
INFO: [Jul 24, 2020 9:11:51 PM] Read: 59% complete
WARNING: [Jul 24, 2020 9:11:51 PM] Skipping line: 59% complete
INFO: [Jul 24, 2020 9:12:08 PM] Read: 62% complete
WARNING: [Jul 24, 2020 9:12:08 PM] Skipping line: 62% complete
INFO: [Jul 24, 2020 9:21:13 PM] Read: 63% complete
WARNING: [Jul 24, 2020 9:21:13 PM] Skipping line: 63% complete
INFO: [Jul 24, 2020 9:22:39 PM] Read: DBCA Operation failed.
INFO: [Jul 24, 2020 9:22:39 PM] DBCA Operation failed.
WARNING: [Jul 24, 2020 9:22:39 PM] Skipping line: DBCA Operation failed.
INFO: [Jul 24, 2020 9:22:39 PM] Read: Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb0.log" for further details.
INFO: [Jul 24, 2020 9:22:39 PM] Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb0.log" for further details.
WARNING: [Jul 24, 2020 9:22:39 PM] Skipping line: Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb0.log" for further details.
INFO: [Jul 24, 2020 9:22:42 PM] Completed Plugin named: Creating Container Database for Oracle Grid Infrastructure Management Repository
INFO: [Jul 24, 2020 10:58:14 PM] Creating Container Database for Oracle Grid Infrastructure Management Repository failed.
INFO: [Jul 24, 2020 10:58:14 PM] Creating Container Database for Oracle Grid Infrastructure Management Repository failed.
srv1:/u01/app/grid/cfgtoollogs/dbca/_mgmtdb # tail -1000f /u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb2.log
Registering database with Oracle Grid Infrastructure
DBCA_PROGRESS : 5%
Copying database files
DBCA_PROGRESS : 6%
DBCA_PROGRESS : 7%
DBCA_PROGRESS : 22%
DBCA_PROGRESS : 36%
Creating and starting Oracle instance
DBCA_PROGRESS : 37%
DBCA_PROGRESS : 39%
DBCA_PROGRESS : 43%
DBCA_PROGRESS : 44%
DBCA_PROGRESS : 45%
DBCA_PROGRESS : 49%
DBCA_PROGRESS : 53%
DBCA_PROGRESS : 54%
DBCA_PROGRESS : 55%
DBCA_PROGRESS : 58%
Completing Database Creation
DBCA_PROGRESS : 59%
DBCA_PROGRESS : 62%
ORA-01034: ORACLE not available
ORA-01034: ORACLE not available
ORA-01034: ORACLE not available
DBCA_PROGRESS : DBCA Operation failed.
Solution : (Doc ID 2191588.1)
srv1:~ # srvctl config MGMTLSNR
Name: MGMTLSNR
Type: Management Listener
Owner: grid
Home: <CRS home>
End points: TCP:1526
Management listener is enabled.
Management listener is individually enabled on nodes:
Management listener is individually disabled on nodes:
srv1:~ #
srv1:~ # crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.CRS.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.DATA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.FRA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.net1.network
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.ons
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE srv2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.MGMTLSNR
1 OFFLINE OFFLINE 169.254.185.74 192.1
68.10.1,STABLE
ora.asm
1 ONLINE ONLINE srv1 STABLE
2 ONLINE ONLINE srv2 STABLE
ora.cvu
1 ONLINE ONLINE srv2 STABLE
ora.qosmserver
1 ONLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE srv2 STABLE
ora.scan2.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan3.vip
1 ONLINE ONLINE srv1 STABLE
ora.smrplm.db
1 ONLINE ONLINE srv1 Open,HOME=/u01/app/o
racle/product/12.1.0
/dbhome_1,STABLE
2 ONLINE ONLINE srv2 Open,HOME=/u01/app/o
racle/product/12.1.0
/dbhome_1,STABLE
ora.smrplm.pretafplm.svc
1 OFFLINE OFFLINE STABLE
ora.smrplm.pretafplm_preconnect.svc
1 OFFLINE OFFLINE STABLE
ora.srv1.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv2.vip
1 ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
srv1:~ # srvctl modify mgmtlsnr -endpoints "TCP:1531"
srv1:~ # srvctl start MGMTLSNR
srv1:~ # srvctl config MGMTLSNR
Name: MGMTLSNR
Type: Management Listener
Owner: grid
Home: <CRS home>
End points: TCP:1531
Management listener is enabled.
Management listener is individually enabled on nodes:
Management listener is individually disabled on nodes:
Screen Shot Reference
Upgrade Logs after error:
INFO: [Jul 25, 2020 12:42:40 AM] Executing MGMTDBCDB
INFO: [Jul 25, 2020 12:42:40 AM] Command /u01/app/12.2.0/grid/bin/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName CRS -datafileJarLocation /u01/app/12.2.0/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck -oui_internal
INFO: [Jul 25, 2020 12:42:40 AM] ... GenericInternalPlugIn.handleProcess() entered.
INFO: [Jul 25, 2020 12:42:40 AM] ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: [Jul 25, 2020 12:42:40 AM] ... GenericInternalPlugIn: checking secretArguments.
INFO: [Jul 25, 2020 12:42:40 AM] No arguments to pass to stdin
INFO: [Jul 25, 2020 12:42:40 AM] ... GenericInternalPlugIn: starting read loop.
INFO: [Jul 25, 2020 12:43:54 AM] Read: Registering database with Oracle Grid Infrastructure
INFO: [Jul 25, 2020 12:43:54 AM] Registering database with Oracle Grid Infrastructure
WARNING: [Jul 25, 2020 12:43:54 AM] Skipping line: Registering database with Oracle Grid Infrastructure
INFO: [Jul 25, 2020 12:43:54 AM] End of argument passing to stdin
INFO: [Jul 25, 2020 12:43:55 AM] Read: 5% complete
WARNING: [Jul 25, 2020 12:43:55 AM] Skipping line: 5% complete
INFO: [Jul 25, 2020 12:43:55 AM] Read: Copying database files
INFO: [Jul 25, 2020 12:43:55 AM] Copying database files
WARNING: [Jul 25, 2020 12:43:55 AM] Skipping line: Copying database files
INFO: [Jul 25, 2020 12:43:56 AM] Read: 6% complete
WARNING: [Jul 25, 2020 12:43:56 AM] Skipping line: 6% complete
INFO: [Jul 25, 2020 12:44:14 AM] Read: 7% complete
WARNING: [Jul 25, 2020 12:44:14 AM] Skipping line: 7% complete
INFO: [Jul 25, 2020 12:45:00 AM] Read: 22% complete
WARNING: [Jul 25, 2020 12:45:00 AM] Skipping line: 22% complete
INFO: [Jul 25, 2020 12:45:00 AM] Read: 36% complete
WARNING: [Jul 25, 2020 12:45:00 AM] Skipping line: 36% complete
INFO: [Jul 25, 2020 12:45:00 AM] Read: Creating and starting Oracle instance
INFO: [Jul 25, 2020 12:45:00 AM] Creating and starting Oracle instance
WARNING: [Jul 25, 2020 12:45:00 AM] Skipping line: Creating and starting Oracle instance
INFO: [Jul 25, 2020 12:45:25 AM] Read: 37% complete
WARNING: [Jul 25, 2020 12:45:25 AM] Skipping line: 37% complete
INFO: [Jul 25, 2020 12:45:56 AM] Read: 39% complete
WARNING: [Jul 25, 2020 12:45:56 AM] Skipping line: 39% complete
INFO: [Jul 25, 2020 12:49:40 AM] Read: 43% complete
WARNING: [Jul 25, 2020 12:49:40 AM] Skipping line: 43% complete
INFO: [Jul 25, 2020 12:50:09 AM] Read: 44% complete
WARNING: [Jul 25, 2020 12:50:09 AM] Skipping line: 44% complete
INFO: [Jul 25, 2020 12:50:40 AM] Read: 45% complete
WARNING: [Jul 25, 2020 12:50:40 AM] Skipping line: 45% complete
INFO: [Jul 25, 2020 12:51:54 AM] Read: 49% complete
WARNING: [Jul 25, 2020 12:51:54 AM] Skipping line: 49% complete
INFO: [Jul 25, 2020 12:51:55 AM] Read: 53% complete
WARNING: [Jul 25, 2020 12:51:55 AM] Skipping line: 53% complete
INFO: [Jul 25, 2020 12:52:57 AM] Read: 54% complete
WARNING: [Jul 25, 2020 12:52:57 AM] Skipping line: 54% complete
INFO: [Jul 25, 2020 12:53:01 AM] Read: 55% complete
WARNING: [Jul 25, 2020 12:53:01 AM] Skipping line: 55% complete
INFO: [Jul 25, 2020 12:53:28 AM] Read: 58% complete
WARNING: [Jul 25, 2020 12:53:28 AM] Skipping line: 58% complete
INFO: [Jul 25, 2020 12:53:28 AM] Read: Completing Database Creation
INFO: [Jul 25, 2020 12:53:28 AM] Completing Database Creation
WARNING: [Jul 25, 2020 12:53:28 AM] Skipping line: Completing Database Creation
INFO: [Jul 25, 2020 12:53:28 AM] Read: 59% complete
WARNING: [Jul 25, 2020 12:53:28 AM] Skipping line: 59% complete
INFO: [Jul 25, 2020 12:53:42 AM] Read: 62% complete
WARNING: [Jul 25, 2020 12:53:42 AM] Skipping line: 62% complete
INFO: [Jul 25, 2020 12:56:33 AM] Read: 65% complete
WARNING: [Jul 25, 2020 12:56:33 AM] Skipping line: 65% complete
INFO: [Jul 25, 2020 12:56:33 AM] Read: 68% complete
WARNING: [Jul 25, 2020 12:56:33 AM] Skipping line: 68% complete
INFO: [Jul 25, 2020 12:56:33 AM] Read: Executing Post Configuration Actions
INFO: [Jul 25, 2020 12:56:33 AM] Executing Post Configuration Actions
WARNING: [Jul 25, 2020 12:56:33 AM] Skipping line: Executing Post Configuration Actions
INFO: [Jul 25, 2020 12:56:33 AM] Read: 100% complete
WARNING: [Jul 25, 2020 12:56:33 AM] Skipping line: 100% complete
INFO: [Jul 25, 2020 12:56:33 AM] Read: Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb3.log" for further details.
INFO: [Jul 25, 2020 12:56:33 AM] Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb3.log" for further details.
WARNING: [Jul 25, 2020 12:56:33 AM] Skipping line: Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb3.log" for further details.
INFO: [Jul 25, 2020 12:56:34 AM] Completed Plugin named: Creating Container Database for Oracle Grid Infrastructure Management Repository
INFO: [Jul 25, 2020 12:56:34 AM] Completed 'Creating Container Database for Oracle Grid Infrastructure Management Repository'
INFO: [Jul 25, 2020 12:56:34 AM] Completed 'Creating Container Database for Oracle Grid Infrastructure Management Repository'
INFO: [Jul 25, 2020 12:56:34 AM] Started Plugin named: GIMR Configuration Assistant
INFO: [Jul 25, 2020 12:56:34 AM] Found associated job
INFO: [Jul 25, 2020 12:56:34 AM] Starting 'GIMR Configuration Assistant'
INFO: [Jul 25, 2020 12:56:34 AM] Starting 'GIMR Configuration Assistant'
INFO: [Jul 25, 2020 12:56:34 AM] Executing MGMTCA
INFO: [Jul 25, 2020 12:56:34 AM] Command /u01/app/12.2.0/grid/bin/mgmtca -local
INFO: [Jul 25, 2020 12:56:34 AM] ... GenericInternalPlugIn.handleProcess() entered.
INFO: [Jul 25, 2020 12:56:34 AM] ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: [Jul 25, 2020 12:56:34 AM] ... GenericInternalPlugIn: checking secretArguments.
INFO: [Jul 25, 2020 12:56:34 AM] No arguments to pass to stdin
INFO: [Jul 25, 2020 12:56:34 AM] ... GenericInternalPlugIn: starting read loop.
Clusterware Commands:
srv2:~ # crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.2.0.1.0]
srv2:~ # crsctl query crs softwareversion
Oracle Clusterware version on node [srv2] is [12.2.0.1.0]
srv2:~ #
srv2:~ # crsctl check cluster -all
**************************************************************
srv1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
srv2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
srv2:~ #
srv1:~ # crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.CRS.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.DATA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.FRA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.net1.network
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.ons
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE srv2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE srv1 169.254.185.74 192.1
68.10.1,STABLE
ora.asm
1 ONLINE ONLINE srv1 Started,STABLE
2 ONLINE ONLINE srv2 Started,STABLE
ora.cvu
1 ONLINE ONLINE srv1 STABLE
ora.mgmtdb
1 ONLINE ONLINE srv1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE srv2 STABLE
ora.scan1.vip
1 ONLINE ONLINE srv2 STABLE
ora.scan2.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan3.vip
1 ONLINE ONLINE srv1 STABLE
ora.smrplm.db
1 ONLINE ONLINE srv1 Open,HOME=/u01/app/o
racle/product/12.1.0
/dbhome_1,STABLE
2 ONLINE ONLINE srv2 Open,HOME=/u01/app/o
racle/product/12.1.0
/dbhome_1,STABLE
ora.smrplm.pretafplm.svc
1 ONLINE ONLINE srv1 STABLE
ora.smrplm.pretafplm_preconnect.svc
1 ONLINE ONLINE srv2 STABLE
ora.srv1.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv2.vip
1 ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
srv1:~ #
No comments:
Post a Comment