Check the Windows registry (regedit).
In HKEY_CURRENT_USER\Software\Classes\ you should find "secondlife" shell\open\command
What do you see there? The desired program is correctly registered? If it is it could be a case of a bug in Opera.
Use https://bugs.opera.com/wizarddesktop/ to report.