My Oracle Support Banner

DUPLICATE DATABASE Fails with ORA-15064 (Doc ID 2732695.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms


Db alert log

Trace Bucket Dump End: default bucket for process 45 (osid: 118954, ASMB)
error 15064 detected in background process
ORA-15064: communication failure with ASM instance
ORA-03135: connection lost contact
ORA-12609: TNS: Receive timeout occurred
2020-10-30T15:54:45.058321+01:00

Trace file has following information


event
----- Abridged Call Stack Trace -----
ksedsts()+426<-kjzduptcctx()+724<-kjzdicrshnfy()+1053<-ksuitm_opt()+1751<-ksbr
dp()+5517<-opirip()+541<-opidrv()+581<-sou2o()+165<-opimai_real()+173<-ssthrdm
ain()+417<-main()+256<-__libc_start_main()+245
----- End of Abridged Call Stack Trace -----
Partial short call stack signature: 0xe338f7946ffd1bcb

 

ASM alert log

// The ASMB process hangs for 181 seconds and fails to communicate with the
ASM instance.

WARNING: ASMB has not responded for 181 seconds

ORA-15064: communication failure with ASM instance
2020-10-30T15:54:38.756968+01:00
Errors in file
<trace file>
ORA-15064: communication failure with ASM instance
2020-10-30T15:54:42.258021+01:00
Errors in file
<trace file>:
ORA-15064: communication failure with ASM instance
2020-10-30T15:54:44.040189+01:00
Errors in file
<trace fie>
ORA-12609: TNS: Receive timeout occurred

 


Sample script used
RUN
{
allocate auxiliary channel ch1 type disk;
allocate auxiliary channel ch2 type disk;
allocate auxiliary channel ch3 type disk;
allocate auxiliary channel ch4 type disk;
allocate auxiliary channel ch5 type disk;
allocate auxiliary channel ch6 type disk;
allocate auxiliary channel ch7 type disk;
allocate auxiliary channel ch8 type disk;
DUPLICATE DATABASE TO <new name>
BACKUP LOCATION '<file system/zfs location>'
NOFILENAMECHECK;
}

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.