I read this not much more than 10 years ago, but it might be much older.
The man was not “super-intelligent”, just someone who, through his faculty of analysis and/or intuition and/or general wisdom, had proven that his advices were usually excellent. When he was in danger of dying, his friends were loath to lose his qualities, and uploaded his mind into a computer, IIRC. He might have been put in suspended animation, but I think rather the computer thing. At some point a crisis happens and they turn the computer on (or revive him?), tell him about the situation, listen to his advice then turn the computer off (or put him back in suspended animation?).
It is all that I remember. It might have been the main theme of a rather short fiction, or just one scene (or maybe several similar scenes) in a full novel.
Now contrary to apparences this is not a duplicate of
though of course it is this question that reminded me of my story. Indeed the latter does not even have an answer accepted by the OP, though it is most probable that Dinae’s answer “The Sleeping God” is the correct one there. (So I granted her my bounty before it expired).
But it is not my story. The “intelligent man” is human. While he was still living “normally”, he belonged to the same community as the people who consult him later, the oldest ones knew him personally when they were younger, or at least heard of him first-hand from their parents. He is not “omniscient and omnipotent, of immense size and gigantic capabilities” only a very bright “normal” person.
Also there are no “morons” about. Those who consult him are clever, they just realise his advices are sound and want him to add his mind to theirs, in an situation of crisis. So not “The Marching Morons”.
Also he is definitely not Hari Seldon. His revivals are not prerecorded holograms. The people who ask him for advice actually tell him of the exact details of the current situation for him to evaluate.
It is also not “The Swarm”, where the hive-mind is not human, when he is, or at least was. But it might still be some other book in Bruce Sterling’s “Shapers/Mechanists” Universe. I feel some, how should I say, “taste” of this universe. But this is just a kind of subliminal feeling that I get, please do not restrict yourself to Bruce Sterling !