Database 11g

Wednesday, September 21, 2016

ORA- 31687 / 31688 ERROR While performing Schema Level Backup Using Data-Pump


E:\hmis_schema>IMPDP DUMPFILE=HMIS.DMP DIRECTORY=HMIS_SCHEMA REMAP_SCHEMA=HMIS:HMIS

Import: Release 11.2.0.3.0 - Production on Wed Sep 21 12:52:05 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: system
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31687: error creating worker process  with worker id 1
ORA-31687: error creating worker process  with worker id 1
ORA-31688: Worker process  failed during startup.


Note:- Data-Pump Uses Streams Pool So Increase the Size of Streams Pool, 
           But I increased   total SGA size.

> Check First What is the size of SGA.

SQL> select sum(value)/1024/1024/1024 "TOTAL SGA (GB)" from v$sga;

TOTAL SGA (GB)
--------------
    1.94439697

> Increase the Size of SGA.

SQL> alter system set sga_max_size=10g scope=spfile;

System altered.

SQL>  alter system set memory_max_target=12g scope=spfile;

System altered.

SQL>  alter system set memory_target=12g scope=spfile;

System altered.


Now You Can Start Using Data-Pump Job.......


Happy Learning..











No comments:

Post a Comment