Simply put, a database resides on disk, while an instance resides in memory.
A database is normally managed by an instance. However, when using RAC, multiple instances can be started for a single database (on different nodes of a cluster). Each instance is identified with a unique identifier known as the ORACLE_SID.
|Glossary of Terms|