The Greatwall is a quest based location and will only open when the prerequisites are met. Near end-game the Duke will give you a quest to go to the Greatwall. The events of this are covered by the quest Reward and Responsibility and Deny Salvation.
** IF YOU DO NOT WANT TO READ SPOILERS STOP READING NOW **
-Spoilers Start Now:
When you return to this castle outside of Deny Salvation, there is little to be done here. A rear exit, at the northern end of the first floor, is actually a way into the Tainted Mountain. That is where you eventually confront the Dragon. Unless you're feeling really lucky, don't go there. Your party should be on very high level before doing so. Also, finish all of your existing quests before confronting the Dragon.