Hostname from v$instance after cluster switch

Hello,

I am trying to get hostname from v$instance after cluster switch.

I use for it trigger "after startup on database". Trigger just runs scheduler job and job executes stored procedure, that contains following row select host_name into v_host_name from v$instance; eventually SELECT sys_context('USERENV', 'SERVER_HOST') into v_host_name from dual; but in both cases I get value/name of the old node, not of the node which is active.

- according to the logs of the scheduler job, the job and procedure are executed successfully

- I tried to execute job manually instead of trigger and I get