AD/TXK Delta 7 - breaks adpreclone.pl appsTier on multi-node RAC environment - connect string longer
After applying AD/TXK delta 7 patches, adpreclone.pl appsTier now fails due to SP2-0640: Not connected
Recreating the actual code from adpreclone.pl and running it manually shows the following error: ORA-12169: TNS:Net service name given as connect identifier is too long
Our jdbc connect string is 399 characters long - which is longer than the 255 allowed. This needs to be corrected for RAC based systems with more than 2 nodes
Our 4-node jdbc connect string:
'jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=exadata02db02-vip.cummins.com)(PORT=xxxx))(ADDRESS=(PROTOCOL=tcp)(HOST=exadata02db03-vip.cummins.com)(PORT=xxxx))(ADDRESS=(PROTOCOL=tcp)(HOST=exadata02db04-vip.cummins.com)(PORT=xxxx))(ADDRESS=(PROTOCOL=tcp)(HOST=exadataa02db01-vip.cummins.com)(PORT=xxxx)))(CONNECT_DATA=(SERVICE_NAME=DBA4X)))'