The single point of failure problem raises if the smart-contracts use centralized oracle.
A centralized oracle means that one entity has the power over your smart contract, and your smart contract is now no better than a regular contract.
The solution to this problem is to use Decentralized Oracle Network.