ORA-04030: out of process memory and RAC service are disabled !!
Dear Friends ,
I am using RAC in Oracle Database (11.2.0.1) , in AIX-6.1 platform . Few days ago, I got the below two problems , one is related with "expdp" and other is related with RAC services .
1) Recenlty when I take expdp backup , then I got the below error :
--------------------------------------------------------------------------------------------------------------
;;;
Export: Release 11.2.0.1.0 - Production on Tue Jan 3 23:08:01 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** schemas=JBLLIVE directory=test_dir dumpfile=JBLLIVE.03Jan2012.11.08PM.dmp logfile=JBLLIVE.03Jan2012.11.08PM.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 8.194 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
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 4032 bytes (kolaGetRfcHeap,kghsseg: kolaslCreateCtx)
ORA-06512: at "SYS.KUPW$WORKER", line 1714
ORA-06512: at line 2
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 23:57:48
Job SYS_EXPORT_SCHEMA_01 has been reopened at Wednesday, 04 January, 2012 8:08
ORA-39012: Client detached before the job started.
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 08:08:39
Job SYS_EXPORT_SCHEMA_01 has been reopened at Wednesday, 04 January, 2012 8:08
ORA-39012: Client detached before the job started.
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 08:10:26
Job SYS_EXPORT_SCHEMA_01 has been reopened at Wednesday, 04 January, 2012 8:10
ORA-39012: Client detached before the job started.
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 08:11:25
Job SYS_EXPORT_SCHEMA_01 has been reopened at Wednesday, 04 January, 2012 8:11
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 08:11:49
--------------------------------------------------------------------------------------------------------------------------------------
My os user's ulimit is all set unlimited , pga_aggreagate_size=4G , sga_taget=20G and RAM is 32G , SWAP = 25GB.
Is there anybody experienced this problem then plz give me advice ..
2) My second query is related with rac services ....
some times I found that some services are not working (disabled) in my RAC nodes . If I start all the services again, after few hours some will be unabled . Like :
---------------------------------------------------------------------
srvctl status nodeapps
VIP DCDBSVR1-VIP is enabled
VIP DCDBSVR1-VIP is running on nede:dcdbsvr2
VIP DCDBSVR2-VIP is enabled
VIP DCDBSVR2-VIP is running on node: dcdbsvr2
network is enabled
network is not running on node:dcdbsvr1
network is runing on node: dcdbsvr2
GSD is disabled
GSD is not running on node : dcdbsvr1
GSD is not running on node : dcdbsvr2
ONS is disabled
ONS daemo is not running on node: dcdbsvr1
ONS daemon is running on node : dcdbsvr2
eONS is enabled
ONS daemo is running on node: dcdbsvr1
ONS daemon is running on node : dcdbsvr2
-------------------------------------------------------------------------
Since I am new in RAC environment, so I need some suggestion regarding this issue . Here I can up the VIP service using srvctl but How can I start the NETWORK ?
Thx .. ...
Edited by: shipon_97 on Jan 6, 2012 5:37 PM