[ZDM]: Zero Downtime Migration Evaluation Command Fails At "ZDM_GET_TGT_INFO" Step With "TNS-03505: Failed to resolve name"
(Doc ID 2630897.1)
Last updated on FEBRUARY 18, 2020
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]Information in this document applies to any platform.
Symptoms
Executing the ZDMCLI evaluate command to migrate the database from OCI-C to OCI fails with following error:
[zdmuser@<zdm host> bin]$ ./zdmcli migrate database -sourcesid <source database sid> -sourcenode <source host> -srcauth zdmauth -srcarg1 user:opc -srcarg2 identity_file:/home/zdmuser/key/pvt.txt -srcarg3 sudo_location:/usr/bin/sudo -targetnode <target host> -targethome /u01/app/oracle/product/18.0.0.0/dbhome_1 -backupuser <backp user> -rsp /home/zdmuser/respfile/zdm_template_ocic_oci.rsp -tgtauth zdmauth -tgtarg1 user:opc -tgtarg2 identity_file:/home/zdmuser/key/pvt.txt -tgtarg3 sudo_location:/usr/bin/sudo -eval
Enter source database <source database sid> SYS password:
Enter user "<backup user>" password:
Operation "zdmcli migrate database" scheduled with the job ID "1".
From <ZDM_BASE>/chkbase/scheduled/job-<id>-<timestamp>.log:
==========================
PRGZ-3130 : failed to establish connection to target listener from nodes [<source host>]
PRCZ-4001 : failed to execute command "/u01/app/oracle/product/18.0.0/dbhome_1/bin/tnsping" using the privileged execution plugin "zdmauth" on nodes "<source host>" within 15 seconds
PRCZ-2103 : Failed to execute command "/u01/app/oracle/product/18.0.0/dbhome_1/bin/tnsping" on node "<source host>" as user "root". Detailed error:
TNS Ping Utility for Linux: Version 18.0.0.0.0 - Production on 20-JAN-2020 06:42:37
Copyright (c) 1997, 2018, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/18.0.0/dbhome_1/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
==========================
Changes
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 |
Changes |
Cause |
Solution |