ORA-12514 error on RAC environment

Hello

i faced ORA-12514 error on RAC environment.

i am able to tnsping but while connecting to db i got below error:

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

Solution:

1) Check tnsnames service and node tnsnames.ora service,port should be same.

2) listener and both node should be up and running.

3) user below command from sys or system users.

alter system set remote_listener='<scanname>:<port>';

Example:

alter system set remote_listener='rac-scan.sigmasys.net:1521';