2 Replies Latest reply: Apr 29, 2014 1:16 PM by ganpat76 RSS

    how to get middle tier host name from database / plsql


      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.