This content has been marked as final. Show 2 replies
we have split tier install of oracle apps.
I wanted to know how to get the host name of the middle tier(where apache and other middle tier components live).
I know that database host name can be obtained by host_name from v$instance.
I wanted to know how from pl/sql to get the middle tier's host name.
both the database and the apache sits on separate boxes.