SQL> select instance_name, database_status, instance_role from v$instance;
e..g.
INSTANCE_NAME DATABASE_STATUS INSTANCE_ROLE
---------------- ----------------- ------------------
xe ACTIVE PRIMARY_INSTANCE
e..g.
INSTANCE_NAME DATABASE_STATUS INSTANCE_ROLE
---------------- ----------------- ------------------
xe ACTIVE PRIMARY_INSTANCE