I am trying clone the PDB from remote Oracle host using DATABASE LINK and after creating data base link
SET DEFINE OFF
CREATE PUBLIC DATABASE LINK sourcepdblink2
CONNECT TO SYSTEM IDENTIFIED BY "*******************"
USING '(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.23.X.X)(PORT=1521)(KEEPALIVE=YES))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XDB))
(CONNECT_TIMEOUT=300)
(SEND_TIMEOUT=0)
(RECV_TIMEOUT=0)
(SDU=65535)
(TCP.NODELAY=YES))';
SET DEFINE ON
I am running PDB clone operation using
CREATE PLUGGABLE DATABASE CLONE12
FROM XDBPDB@sourcepdblink2
FILE_NAME_CONVERT = ('/opt/oracle/oradata/XDB/XDBPDB/', '/opt/oracle/oradata/XDB/CLONE12/');
The operation got started and it copied all the data into /opt/oracle/oradata/XDB/CLONE12 but at end failed with
REATE PLUGGABLE DATABASE CLONE12
FROM XDBPDB@sourcepdblink2
FILE_NAME_CONVERT = ('/opt/oracle/oradata/XDB/XDBPDB/', '/opt/oracle/oradata/XDB/CLONE12/')
2025-11-06T15:14:57.490496+00:00
Opatch validation is skipped for PDB CLONE12 (con_id=5)
2025-11-06T15:22:59.285243+00:00
Control autobackup written to DISK device
handle '/opt/oracle/fast_recovery_area/XDB/autobackup/2025_11_06/o1_mf_s_1216480979_njshbm62_.bkp'
2025-11-06T15:36:31.183528+00:00
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 21.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 21.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 21.0.0.0.0 - Production
Version 21.3.0.0.0
Time: 06-NOV-2025 15:36:31
Tracing not turned on. Process Id = 25290
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=XX.145.0.199)(PORT=1521))(connection_id=Qu+GX8+kYsrgYwIAEayMWg==)
2025-11-06T15:36:31.185338+00:00
**************************************************************
Undo Create of Pluggable Database CLONE12 with pdb id - 5.
**************************************************************
ORA-17627 signalled during: CREATE PLUGGABLE DATABASE CLONE12
FROM XDBPDB@sourcepdblink2
FILE_NAME_CONVERT = ('/opt/oracle/oradata/XDB/XDBPDB/', '/opt/oracle/oradata/XDB/CLONE12/')...
2025-11-06T15:38:39.857432+00:00
The interesting this is that if data size around 50 GB it is working fine. I am running Orcale where I am running clone is container image and image tag is oracle-db:21.3.0.0
I have already apply all this setting on Source and Target
cat > /opt/oracle/homes/OraDB21Home1/network/admin/sqlnet.ora <<'EOF'
# ==============================================================
# Oracle Net Configuration File - sqlnet.ora
# Purpose : Prevent ORA-12170 / TNS-12535 during long operations
# ==============================================================
# --- TIMEOUTS (for both inbound and outbound connections) ---
SQLNET.INBOUND_CONNECT_TIMEOUT = 3600
SQLNET.OUTBOUND_CONNECT_TIMEOUT = 3600
SQLNET.SEND_TIMEOUT = 7200
SQLNET.RECV_TIMEOUT = 7200
# --- Keepalive (detect half-open TCP connections) ---
SQLNET.EXPIRE_TIME = 10
# --- Compatibility (ensures newer clients can log in cleanly) ---
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 12
EOF
but still this error.