select * from v$instance

and for you the SID = instance name

define what you mean by tnsname?