Commodity prices are rallying and U.S. crude production is booming. But when it comes to new powder for the oil patch, private equity’s well may be running dry.