Why they are needed
A blockchain is a deterministic system. Every node must reach the same result using only data on the chain. ethereum.org explains that Ethereum-based smart contracts cannot by default access information stored outside the blockchain, and that nodes reach consensus on simple true or false questions using only data stored on the chain itself. A contract that needs the current price of an asset, the weather or a sports score has no way to find it alone.
What an oracle does
An oracle is an application that produces data feeds making off-chain data available to the blockchain for smart contracts. Operators fetch the data, sign or publish it, and a contract reads it as it would any other on-chain value. Price oracles are the most common: lending protocols use them to value collateral and decide when to liquidate.
The oracle problem
ethereum.org states that data from an oracle must be correct for a smart contract to execute correctly, and that having to trust oracle operators undermines the trustless aspect of smart contracts. A single data source is a single point of failure. Good designs combine many sources and many operators, use medians and add checks for stale or extreme values.
Why users should care
If a protocol relies on a weak or manipulable price feed, an attacker can distort the price for a moment, trigger liquidations or borrow against inflated collateral and drain funds. When evaluating a DeFi application, find out where its prices come from, how many sources it combines and what happens if the feed stops updating. Prices shown in your wallet or on a website come from their own sources, which should be explained too.