We restored a tape back to a new machine HP-ux with 7.3.4 and 8.0.5 database. when we query v$session the machine name is unknown. my hostname is chihpdevs. Why cant i get the value of this view?
SQL> select osuser, machine from v$session;
OSUSER MACHINE
--------------- ------------------------------
oracle unknown
oracle unknown
oracle unknown
oracle unknown
oracle unknown
oracle unknown
-Jigar