I think the main reason Amazon chose Oracle over databases like PostgreSQL is that it also makes it easier for a lot of people to convince their boss to move to AWS.
I think the main reason Amazon chose Oracle was a deal between them.
I think parent and GP both have an element of truth, but that the ultimate situation is more nuanced than either suggests. Customer demand is likely the biggest factor, but I'd be surprised if Oracle managed an exclusivity deal on RDS. Of the major RDBMS players, Oracle, for all their weirdness, all their proprietary functionality, all the damn-the-relational-model-here's-your-physical-row-identifiers, is a pretty logical choice as the first commercial offering.