This is more about the political economics of the resource curse than the specific histories of Norway and Canada, but hopefully you will find it helpful.

A few things that make Canada & Norway different from Venezuela and Iraq are the percent of the economy that is based on petroleum extraction, the establishment of a stable government with a functioning tax and legal system before the rise in importance of petroleum globally, and a state monopoly on petroleum profits.

One of the thoughts in the economic development community is that the resource curse causes a separation between the ruled and the rulers. A resource state is not dependent upon taxes for funding. While governments collecting taxes can still be oppressive and anti democratic there is at least some mild incentives to keep people happy enough for the broader economy to function. In a resource state you only need to keep the wells open, which you could do with the military and/or contractors who you then pay with the money you make from keeping the wells open.