Who is Oscar Tully in House of the Dragon and what happens to him in the books?

Now that HBO's Game of Thrones prequel is finally ready to let its dragons dance, let's take a look at one of the much-changed characters from the source material.