Hello, friends in this article we going to discuss how to find server IP or Hostname using SQL query.
How to check hostname using SQL query in oracle?
The following query will show the hostname where you’re currently connected to in that session.
SQL> SELECT host_name FROM v$instance;
The above query will work only for a single instance, if you are connected on multi-instances then use the following query to check the all the hostnames.
SQL> SELECT host_name FROM gv$instance;
In case, If you don’t have access to the v$ views, there are two alternatives. You can get it from the dual table using the below queries.
SQL> select utl_inaddr.get_host_name from dual; OR SQL> select sys_context('USERENV','SERVER_HOST') from dual;
sys_context() as the easiest and most appropriate solution. The only reason not to use sys_context is that it lower cases the name, which the above 2 don’t.
Find server IP using SQL
You can use sys_context(‘USERENV‘, ‘SERVICE_NAME‘) to get the database service name instead of the machine name. Use the below query to find complete details.
SQL> select sys_context ( 'USERENV', 'DB_NAME' ) db_name, sys_context ( 'USERENV', 'SESSION_USER' ) user_name, sys_context ( 'USERENV', 'SERVER_HOST' ) db_host, sys_context ( 'USERENV', 'HOST' ) user_host from dual;
Hop you fond this article useful, please share your review in comment section below.