Apps Tier cloning fails , we having 2 node RAC db with SCAN Listerner.
DB Tier: 11.2.0.3 2 node RAC database.
Uses scan listerner.
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=10.3
.110.75)(PORT=1541))))
remote_listener string hqebsuat:1541
---
export TWO_TASK=UATERP
adcfgclone.pl appsTier
Target System Hostname (virtual or normal) [hqtsap64] :
Target System Database SID : UATERP2
Target System Database Server Node [hqtsap64] : hqtsdb64
Target System Database Domain Name [fruit.com] :
..
..
..
errors out at end.
----
Error seen:
Enter value for 1: Enter value for 2: Enter value for 3: Enter value for 4: ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect