I'm really confuse with the term instance and database. So, my first question is how database and Instance are related in Oracle, I mean, whether an instance is associated with one/multiple database(s) or a database associated with single/multiple instance(s)?
And, my second question is, one of my friend says we can't have multiple instances in oracle. is it really valid a statement ?