No, assuming the fundamentals haven't changed oil stocks become a good investment for other entities until the price is back to where it was (assuming it's negatively affected at all).

Oil may or may not have a bright near to mid term financial future, but Norway's move is either virtue signaling at the national level or diversification of a portfolio that's too heavily invested in that sector. In itself it won't change the oil market one iota.