While runnig duplicate database, oracle can give ORA-17627, ORA-12154, ORA-17629 errors.<\/p>\n
Error<\/strong><\/p>\n [oracle@oracle19cdg2 admin]$ rman target sys@ORA19C auxiliary sys@DG2<\/p>\n Recovery Manager: Release 19.0.0.0.0 – Production on Sat Jul 6 14:21:44 2024 Copyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.<\/p>\n target database Password: RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;<\/p>\n Starting Duplicate Db at 06-JUL-24 contents of Memory Script: Starting backup at 06-JUL-24 Solution<\/strong><\/p>\n You have to change tnsnames.ora file on standby server. You have to use SID instead of SERVICE_NAME.<\/p>\n DG2= While runnig duplicate database, oracle can give ORA-17627, ORA-12154, ORA-17629 errors. Error [oracle@oracle19cdg2 admin]$ rman target sys@ORA19C auxiliary sys@DG2 Recovery Manager: Release 19.0.0.0.0 – Production on Sat Jul 6 14:21:44 2024 Version 19.22.0.0.0 Copyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved. target database Password: connected to target database: ORA19C (DBID=1219995577) auxiliary database…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2976","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-M0","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2976"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2976\/revisions"}],"predecessor-version":[{"id":2978,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2976\/revisions\/2978"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2976"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nVersion 19.22.0.0.0<\/p>\n
\nconnected to target database: ORA19C (DBID=1219995577)
\nauxiliary database Password:
\nconnected to auxiliary database: ORA19C (not mounted)<\/p>\n
\nusing target database control file instead of recovery catalog
\nallocated channel: ORA_AUX_DISK_1
\nchannel ORA_AUX_DISK_1: SID=7 device type=DISK
\ncurrent log archived<\/p>\n
\n{
\nbackup as copy reuse
\npasswordfile auxiliary format ‘\/oracle\/db\/19\/db_home\/dbs\/orapwDG2’ ;
\n}
\nexecuting Memory Script<\/p>\n
\nallocated channel: ORA_DISK_1
\nchannel ORA_DISK_1: SID=28 device type=DISK
\nRMAN-00571: ===========================================================<\/strong>
\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<\/strong>
\nRMAN-00571: ===========================================================<\/strong>
\nRMAN-03002: failure of Duplicate Db command at 07\/06\/2024 14:22:00<\/strong>
\nRMAN-05501: aborting duplication of target database<\/strong>
\nRMAN-03015: error occurred in stored script Memory Script<\/strong>
\nRMAN-03009: failure of backup command on ORA_DISK_1 channel at 07\/06\/2024 14:22:00<\/strong>
\nORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified<\/strong>
\nORA-17629: Cannot connect to the remote database server<\/strong><\/p><\/blockquote>\n
\n(DESCRIPTION =
\n(ADDRESS = (PROTOCOL = TCP)(HOST = oracle19cdg2.fatihacar.com)(PORT = 1521))
\n(CONNECT_DATA =
\n(SERVER = DEDICATED)
\n(SID = DG2)
\n)
\n)<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"