This should not happen, Opera profile is located in User Application Support directory and should be accessed the same way as before the OS upgrade.

What about other stuff like History, settings, cache?

Perhaps you created a new user after the OS upgrade?