Hi,
We are running multiple (around 15-20) impdp processes on same Oracle user simultaneously.
Few of them are failing with below mentioned errors.
During this simultaneous execution few of them are hung, without throwing any errors.
It is not happening, when we run the same command manually on same user accounts individually.
Host is a 256GB machine having 15-20 Unix user accounts.
We have adequate disk space on the VM.
Env. Details:
----------------
RAM : 256 GB
OS : OEL 7.2
DB Server and Client: Oracle 12C - R2
Few of them are failing.
Impdp command being used:
-----------------------------------------
impdp $ORACLE_USER_PIN/$ORACLE_USER_PIN@$ORACLE_SID directory=dumpdir dumpfile=$ORACLE_USER_PIN.dmp logfile=imp_$ORACLE_USER_PIN.log remap_schema=PIN814:PIN701 remap_tablespace=PIN814:PIN701,PINX814:PINX701 transform=lob_storage:default,oid:n ignore=yes full=yes
Log:
---------
| . . imported "PIN101"."JOB_T" | 0 KB | 0 rows |
| . . imported "PIN101"."PROC_AUD_GL_REPORT_T" | 0 KB | 0 rows |
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
UDI-00028: operation generated ORACLE error 28
ORA-00028: your session has been killed
ORA-00028: your session has been killed
ORA-06512: at "SYS.DBMS_AQ", line 1127
ORA-06512: at "SYS.KUPC$QUE_INT", line 556
ORA-06512: at "SYS.KUPC$QUE_INT", line 1703
ORA-06512: at line 1
UDI-03114: operation generated ORACLE error 3114
ORA-03114: not connected to ORACLE
read,write permissions on dumpdir for the user are present
Could you please provide any inputs in solving above issue.
Thanks,
Satya Srikar