Wednesday, August 08, 2018

ORA-12170: TNS:Connect timeout occurred When Exec Rman Duplicate

Symptom:

    The Error details are blow:
We run below on target DB hosts:

RMAN>  connect target sys/****@testdb
connected to target database: testdb (DBID=1516071651)
RMAN>  connect auxiliary sys/*****@testdbaux
connected to auxiliary database: testdbaux(not mounted)
RMAN> DUPLICATE TARGET DATABASE  TO 'testdbaux' FROM ACTIVE DATABASE ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/30/2018 01:06:30
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/30/2018 01:06:30
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12170: TNS:Connect timeout occurred
ORA-17629: Cannot connect to the remote database server

Diagnosis:

  On Target testdb hosts,   tnsping testdb and testdbaux are both fine.
  It turns out rman duplicate will run sessions from testdbaux hosts to connect to testdb target hosts
  We open fireports from target hosts to aux hosts only.  But rman duplicate need ports open from aux hosts to targets as well.

Solution:

   Open firewall bi-direction firewall ports between target and aux hosts

1 comment:

Unknown said...

Bet365 Casino & Promos 2021 - JTM Hub
Full list หารายได้เสริม of Bet365 Casino & Promos · Up to £100 in 바카라 사이트 Bet Credits for 출장안마 new customers at bet365. Min deposit £5. Bet Credits 메이피로출장마사지 available for use upon settlement of bets jancasino to value of