While performing an export database export dump the following errors where generated:
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name “DW00” prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 2328 bytes (kxs-heap-c,temporary memory)
ORA-06512: at “SYS.KUPW$WORKER”, line 1887
ORA-06512: at line 2
ORA-4030 indicates a limit has been reached with respect to the Oracle process private memory allocation
check max_map_count and increase it in a Linux environment.
sysctl -w vm.max_map_count=200000
My blog article has been published in the latest Oracle ACE newsletter. its my great pride
that as an IT Professional from Saudi Arabia (the first one 🙂 ) , to have my technical
articles published among the best Oracle technologist from around the world.
The following is a summarized procedure in how to convert from Oracle 12c standard Cluster to Oracle New Flex cluster.
- Execute the following command to check your current cluster mode:
crsctl get cluster mode status
cluster is running in “standard” mode
- Run the command to check that GNS is configured with fixed IP:
srvctl config gns
** if GNS is not configured then you need to do so by executing the following command as “root” after making sure that GNS IP entry is added in DNS server:
srvctl add gns -vip vipname | ip_address
srvctl start gns
- Set the mode of the cluster to “flex” by executing the below command as “root”:
crsctl set cluster mode flex
Cluster mode set to “flex”
- Stop/Start the cluster so the new mode takes affect:
crsctl stop crs
crsctl start crs
Status of cluster mode is “FLEX”
Important Final Remarks:
- The cluster conversion is one direction from standard===> Flex ONLY.
- GNS is required with fixed IP address for Flex setup.
- Oracle Flex cluster works ONLY with Oracle Flex ASM, while Oracle Flex ASM can work with either standard or Flex cluster.
Oracle Flex Cluster Architecture