I'm trying to setup a dblink, but its not working. After troubleshooting, I notice that my EZCONNECT string is incorrect:
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=orcldev.com))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.228)(PORT=1521)))
TNS-12541: TNS:no listener
The port is supposed to say 1522
How do I update this. I tried deleting and recreating the listener. I made sure the entry in my tnsnames.ora was correct. I tried modifying the local_listener parameter, I don't know what else to do at this point can someone advise.