After cloning the DB i try to connect using sqlplus username@TNS_Alias, But i get below error.
ORA-12154: TNS:could not resolve the connect identifier specified
Then when i check the local_listener parameter is not set,So after setting local_listener i am able to connect.
Solution:
alter system set local_listener = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<IP>)(PORT=<port>))))' scope=BOTH;
ORA-12154: TNS:could not resolve the connect identifier specified
Then when i check the local_listener parameter is not set,So after setting local_listener i am able to connect.
Solution:
alter system set local_listener = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<IP>)(PORT=<port>))))' scope=BOTH;
No comments:
Post a Comment