You're getting a lot of answers from Americans. Be aware that CBD oil sold in Germany (Dm, Rossmann, etc.) almost certainly doesn't contain significant levels of THC.
The evidence doesn't seem to suggest CBD alone is effective in pain management:
Cannabis oil that contains THC is almost certainly a different matter.