Dear Erman,
Thanks for posting the blog "
http://ermanarslan.blogspot.com/2014/07/ebs-122-cloning-real-life-example.html" which helped many of us to fix the issue instantly "ORA-12514: TNS:listener does not currently know of service requested in connect"
In our UAT instance,which i have cloned recently.We didnt face any ORA-12514 errors while running adcfgclone dualfs and need to understand the reason
2node rac
sid:UATDB1,UATDB2
databasename:UATDB
From our spfile:
SQL> sho parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string UATDB,ebs_patch
SQL> sho parameter local
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_local_communication_costing_enabled boolean TRUE
local_listener string UATDB1_LOCAL
parallel_force_local boolean TRUE
[orauat@uatdb1 UATDB_uatdb1]$ tnsping UATDB1_LOCAL
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 11-FEB-2019 16:39:54
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/u02/UATDB/12.1.0/network/admin/UATDB_uatdb1/sqlnet_ifile.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=uatdb1-vip.ttd.com)(PORT=1522)))
OK (0 msec)
None of the listeners are listening for service UATDB1_patch,but adcfgclone dualfs completed successfully and no ORA-12514: TNS:listener errors found.I would like to know why we didnt get any errors in this case.
Thank you
Locked
