DUPLICATE DATABASE Fails with ORA-15064
(Doc ID 2732695.1)
Last updated on SEPTEMBER 26, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
- Grid and the database from version 12.2 to 19.8.
- Source database was on ASM and duplicate db will be on non ASM
- Customer attempting to create duplicate database from ZFS/Fielsystem backup, failing with ASMB process timing out.
Db alert log
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
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 |