We were not able to create the container database and it encountered following Error:
[pool-1-thread-1] [ 2021-08-17 15:25:52.277 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName [pool-1-thread-1] [ 2021-08-17 15:25:52.277 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName:nodenumber: 1 [pool-1-thread-1] [ 2021-08-17 15:25:52.279 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName:nodename: erp-preprod-db01 INFO: Aug 17, 2021 3:25:52 PM oracle.assistants.dbca.util.NodeSelectionHelper reorderLocalNodeIndex INFO: Local node found at index:0 localnode:erp-preprod-db01 INFO: Aug 17, 2021 3:25:52 PM oracle.assistants.dbca.action.DBIdentificationAction updateRACConfiguration INFO: Added: [erp-preprod-db01, erp-preprod-db02] to the node list in the bean [pool-1-thread-1] [ 2021-08-17 15:25:52.280 AST ] [has.UtilNative.Native] prsr_trace: Native: getCRSHome [pool-1-thread-1] [ 2021-08-17 15:25:52.280 AST ] [has.UtilNative.Native] prsr_trace: Native: getCRSHome crs_home=/u01/app/19.0.0/grid(**) [pool-1-thread-1] [ 2021-08-17 15:25:52.280 AST ] [HASContext.getCRSHome:645] /u01/app/19.0.0/grid [pool-1-thread-1] [ 2021-08-17 15:25:52.280 AST ] [Util.getCRSHome:614] getCRSHome: ret=/u01/app/19.0.0/grid [pool-1-thread-1] [ 2021-08-17 15:25:52.281 AST ] [Version.isPre:757] version to be checked 19.0.0.0.0 major version to check against 10 [pool-1-thread-1] [ 2021-08-17 15:25:52.281 AST ] [Version.isPre:768] isPre.java: Returning FALSE [pool-1-thread-1] [ 2021-08-17 15:25:52.281 AST ] [ClusterInfo.:248] m_olsnodesPath=/u01/app/19.0.0/grid/bin/olsnodes [pool-1-thread-1] [ 2021-08-17 15:25:52.283 AST ] [RuntimeExec.runCommand:294] runCommand: Waiting for the process [Thread-166] [ 2021-08-17 15:25:52.283 AST ] [StreamReader.run:62] In StreamReader.run [Thread-167] [ 2021-08-17 15:25:52.283 AST ] [StreamReader.run:62] In StreamReader.run [Thread-166] [ 2021-08-17 15:25:52.327 AST ] [StreamReader.run:66] OUTPUT>Oracle Clusterware infrastructure warning in OLSNODES (OS PID 7031): Non-fatal error (22) during NLS data loading initialization [Thread-166] [ 2021-08-17 15:25:52.355 AST ] [StreamReader.run:66] OUTPUT>erp-preprod-db01 1 [Thread-166] [ 2021-08-17 15:25:52.356 AST ] [StreamReader.run:66] OUTPUT>erp-preprod-db02 2 [pool-1-thread-1] [ 2021-08-17 15:25:52.362 AST ] [RuntimeExec.runCommand:296] runCommand: process returns 0 [pool-1-thread-1] [ 2021-08-17 15:25:52.362 AST ] [RuntimeExec.runCommand:323] RunTimeExec: error> [pool-1-thread-1] [ 2021-08-17 15:25:52.363 AST ] [RuntimeExec.runCommand:349] Returning from RunTimeExec.runCommand [pool-1-thread-1] [ 2021-08-17 15:25:52.363 AST ] [ClusterInfo.getClusterNodeMap:1023] Number of nodes=3 [pool-1-thread-1] [ 2021-08-17 15:25:52.363 AST ] [ClusterInfo.getClusterNodeMap:1035] i=0 nodeName=Oracle nodeNum=Clusterware [pool-1-thread-1] [ 2021-08-17 15:25:52.363 AST ] [ClusterInfo.getClusterNodeMap:1035] i=1 nodeName=erp-preprod-db01 nodeNum=1 [pool-1-thread-1] [ 2021-08-17 15:25:52.363 AST ] [ClusterInfo.getClusterNodeMap:1035] i=2 nodeName=erp-preprod-db02 nodeNum=2 INFO: Aug 17, 2021 3:25:52 PM oracle.install.commons.flow.AbstractFlowExecutor completeBackgroundOperations INFO: Terminating all background operations INFO: Aug 17, 2021 3:25:52 PM oracle.install.commons.flow.AbstractFlowExecutor completeBackgroundOperations INFO: Terminated all background operations WARNING: Aug 17, 2021 3:25:52 PM oracle.install.commons.util.exception.AbstractErrorAdvisor getDetailedMessage WARNING: [WARNING] [INS-08102] Unexpected error occurred while transitioning from state 'DBIdentification' CAUSE: No additional information available. ACTION: Contact Oracle Support Services or refer to the software manual. SUMMARY: Relevant Information Collection
Cause:
ORA_NLS10 Parameter was not set properly and it was pointing to the wrong location.
Solution:
Unset the ORA_NLS10 parameter and proceed. The runInstaller/DBCA will work without any issues.
$ unset ORA_NLS10 $ runInstaller
Hope it helps :)
Thanks for reading.
regards,
Zaheer
Comments