The IP_ADDRESS USERENV context returns the IP of your machine! You need to find the IP or name of the server the database is on.
You can find the IP using utl_inaddr:
select utl_inaddr.get_host_address from dual;
Or the host name in various ways:
select host_name from v$instance;
select utl_inaddr.get_host_name from dual;
select SYS_CONTEXT('USERENV', 'SERVER_HOST') host from dual;
https://oracle-base.com/articles/misc/identifying-host-names-and-addresses But if you've updated your TNSNAMES you can't connect! Hopefully you saved a copy before changing it you can revert to. If not, you'll have to speak to someone else in your organization to find the correct values.