SQL>
SQL> select utl_inaddr.get_host_address ('Hostnamename') from dual;
select utl_inaddr.get_host_address ('Hostnamename') from dual
       *
ERROR at line 1:
ORA-24248: XML DB extensible security not installed
ORA-06512: at "SYS.UTL_INADDR", line 19
ORA-06512: at "SYS.UTL_INADDR", line 40
ORA-06512: at line 1

SQL>
SQL> select comp_name from dba_registry;

COMP_NAME
-----------------------------------------
Oracle Database Catalog Views
Oracle Database Packages and Types
Oracle Real Application Clusters

SELECT UTL_INADDR.get_host_address from dual;

ORA-24248: XML DB extensible security not installed
 *Cause:    XML DB extensible security necessary for this operation has
            not been installed.
 *Action:   Ensure that XML DB has been installed.

select name from v$database

SQL>
SQL> select global_name from global_name;

GLOBAL_NAME
------------------------------------------------
JACK.WORLD

SQL> show parameter unique_name
ORA-00942: table or view does not exist


SQL> select dbid from v$database;
select dbid from v$database
                 *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> select global_name from global_name;

GLOBAL_NAME
------------------------------------------------
JACK.WORLD

SQL>
SQL> show parameter unique_name

NAME                                 TYPE
------------------------------------ -----------
VALUE
------------------------------
db_unique_name                       string
webcaps
SQL>
SQL> set lines 1000
SQL> /

GLOBAL_NAME
------------------------------------------------

JACK.WORLD

SQL> select dbid from v$database;

      DBID
----------
2205711133

select * from v$instance