"Did you know that his name is James?" is correct, assuming two things:
1: The listener did not know before; it might well be that the speaker just told them.
2: "His" name is James, as it was (presumably) since his birth and as will be (also presumably) until his death.
Student or Learner