The database is the set of files where application data and meta data is
stored or you can say that Database is collection of data stored together
as a unit. Databases are useful for storing data and making it available for
retrieval. Within the database, data is organized into different tables


An instance is the software(tools) that Oracle uses to manipulate the data
in the database. In order for the instance to be able to manipulate that
data, the instance must open the database. A database can be opened (or
mounted) by more than one instance, however, an instance can open at most
one database.


with kind Regards
Rajendra kumar Bal
--Database developer--




-----Original Message-----
From: shivas
[mailto:oracledba-ezmlmshield-x32961588.[Email address protected]
Sent: Monday, March 31, 2008 11:17 AM
To: LazyDBA Discussion
Subject: different between Instance and Database
Importance: High

Hi Gurus

What r the main different between Instance and Database.
When is ASM should instalised or activated.

thanks.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page