ORA-12514: TNS: Listener does not currently know of service requested in connect descriptor

The version of oracle database used in below article is 11.2.0.2.0

Issue:
The below error coming while connecting to RAC database from the application server.
ORA-12514: TNS: Listener does not currently know of service requested in connect descriptor

Investigation:
remote_listener parameter was not set.

Resolution:

Reset remote_listener parameter like below:

alter system set remote_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=<vip of
scan1) (PORT=<scan1 port>))(ADDRESS=(PROTOCOL=TCPS)(HOST=<vip of scan2>)(PORT=<scan2
port>))(ADDRESS=(PROTOCOL=TCPS)(HOST=<vip of scan3>)(PORT=<scan3 port>)))' scope=both ;

Below command can be used to find the scan ips:
srvctl config scan

Below command can be used to find the scan ports:
srvctl config scan_listener

If COST(class of secure transport) is enabled, then use the TCPS port.

Regards
Vineet Arneja