I have a little bit of a problem, I can't unlock the sanctuary, I never had the quest to do it. I have a paladin in my team, I can't do anything in the temple besides donations (which I did), also can't use any angelic powers for some reason.
I have done all tasks besides harem because of it, I saw there was only 3/4 managers but I thought it may come with conquering Orech or something so I dismissed it, now I don't have much more to do but I'm blocked because of it. I assume it is a bug, maybe it is because I recruited the paladin before having the quest, or maybe it's because I'm too corrupted or something...
Building the sanctuary requires completing Raphaelle's quest line. If you've never done her quests, talk to her in town and choose "Ask her about her task". You need to have at least 500 gold before this option becomes available. If you've started her quests, then choose "I've completed your task", "Ask what you can do for her now" or "See the gates of heaven". After you view the "See the gates of heaven" scene, you can build a sanctuary for 2000 gold. Recruiting a paladin early shouldn't affect the quest.
Angelic/Seraphic dreams not working is likely what's causing your overall issue, since part of Raphaelle's quest line requires using it at least 5 times. In order to cast the dream spells, the following need to be true:
Have at least 20 mana (50 for Seraphic)
Must have learned the spell
The girl must have a fetish that can be removed and she can't be dead/in orech
The girl can't have the corrupted trait
If none of that works, let me know. I think there may be a bug in the original game that I can fix.