- Discworld is an obvious thing here.
- Anathem has a distributed network of libraries of most knowledge with an interesting time-limited distirbution scheme.
- Snow Crash has A Librarian -- and also a hypercard knowledge system.
- If On A Winter's Night, A Traveller by Italo Calvino features books and libraries prominently. They're not exactly magical, but they're not...not magical, either.
edit: it's not a novel, but the library in the sands in Avatar is another fine example of this trope.