Hi,
Current Environment:
OS: Windows 2003 R2 32bit server
Database: 11.2.0.2 32bit
EBS : R12.1.3 32bit
RAM: 7.80gb
Currently am doing EBS R12.1.3/11.2.0.2 migration from windows 32bit to Linux 64bit following the below oracle document,
Export/import process for 12.0 or 12.1 using 11gR1 or 11gR2 (Doc ID 741818.1)
As per the document according to " Section 3: Export the source Release 12 database instance --> Export the Applications database instance" am getting the below error,
E:\oracle\expimp>expdp "'/ as sysdba'" parfile=auexpdp.dat
Export: Release 11.2.0.2.0 - Production on Sun Sep 16 16:35:29 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_06": "/******** AS SYSDBA" parfile=auexpdp.dat
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 24.70 GB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/LIBRARY/LIBRARY
Processing object type DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/XMLSCHEMA/XMLSCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
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 8204 bytes (koh-kghu se
ssi,kgmtlbdl)
ORA-06512: at "SYS.KUPW$WORKER", line 1751
ORA-06512: at line 2
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GR
ANT
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 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 8204 bytes (koh-kghu se
ssi,kgmtlbdl)
ORA-06512: at "SYS.KUPW$WORKER", line 1751
ORA-06512: at line 2
Job "SYS"."SYS_EXPORT_FULL_06" stopped due to fatal error at 17:48:58
Error in the alert log:
Errors in file E:\ORACLE\MHDEV\DB\TECH_ST\11.2.0\ADMIN\MHDEV_WDEVORDB03\diag\rdbms\mhdev\mhdev\trace\mhdev_dw00_1176.trc (incident=24179):
ORA-04030: out of process memory when trying to allocate 8204 bytes (koh-kghu sessi,kgmtlbdl)
ORA-06512: at "SYS.KUPW$WORKER", line 1751
ORA-06512: at line 2
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
DW00 terminating with fatal err=4030, pid=20, wid=2, job SYS.SYS_EXPORT_FULL_06
Mon Sep 16 16:25:27 2013
Process startup failed, error stack:
Errors in file E:\ORACLE\MHDEV\DB\TECH_ST\11.2.0\ADMIN\MHDEV_WDEVORDB03\diag\rdbms\mhdev\mhdev\trace\mhdev_psp0_5192.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: Not enough storage is available to process this command.
ORA-27302: failure occurred at: ssthrddcr
Mon Sep 16 16:25:28 2013
Process m000 died, see its trace file
Mon Sep 16 16:25:30 2013
Errors in file E:\ORACLE\MHDEV\DB\TECH_ST\11.2.0\ADMIN\MHDEV_WDEVORDB03\diag\rdbms\mhdev\mhdev\trace\mhdev_dm00_5516.trc (incident=24167):
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 8204 bytes (koh-kghu sessi,kgmtlbdl)
ORA-06512: at "SYS.KUPW$WORKER", line 1751
ORA-06512: at line 2
Please suggests me to fix this issue,
Regards
Athish