How to get Host Address and Servcie Name from Oracle database

 The IP address of the database server:

 select UTL_INADDR.get_host_address from dual

 

Get Service Name

select * from global_name;