This discussion is archived
13 Replies Latest reply: Jan 24, 2012 10:43 PM by Varma RSS

Difference between Oracle Instance & Database.

chesplay Newbie
Currently Being Moderated
Hi,

I wanted to know the difference between oracle Instance and oracle Database, Also between ORacle database and relational database.

Please use simple terminology to explain.

Thanks.
  • 1. Re: Difference between Oracle Instance & Database.
    AlexAnd Guru
    Currently Being Moderated
    >
    I wanted to know the difference between oracle Instance and oracle Database,
    >
    Difference between a database and an instance [Oracle]
    and
    Difference between Service and Instance in Oracle Net Services




    >
    Also between ORacle database and relational database.
    >
    >
    The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS)
  • 2. Re: Difference between Oracle Instance & Database.
    Vedant.. Journeyer
    Currently Being Moderated
    Pls refer the follwoing links:

    http://docs.oracle.com/cd/B19306_01/server.102/b14220/intro.htm#i60813 -- instance
    http://docs.oracle.com/cd/B19306_01/server.102/b14220/intro.htm#sthref35 -- database
  • 3. Re: Difference between Oracle Instance & Database.
    NikolayIvankin Expert
    Currently Being Moderated
    Instance is a number of foreground and background processes with parameters files.
    Database is a number of datafiles (data files, log files,control files etc)
  • 4. Re: Difference between Oracle Instance & Database.
    Mohamed Houri Pro
    Currently Being Moderated
    Hi,
    
    I wanted to know the difference between oracle Instance and oracle Database, Also between ORacle database and relational database.
    
    Please use simple terminology to explain.
    
    Thanks. 
    Put in its simplest explanation it could be summarized as follows:

    1. Database = data files where your data are located
    2. Instance = background process and runing programs combined with a shared memory (SGA)


    Hope this helps

    Mohamed Houri
  • 5. Re: Difference between Oracle Instance & Database.
    Varma Explorer
    Currently Being Moderated
    Hi,

    What is a Database?


    We already know that a database is a collection of data. And this data is stored in form of tables at logical level, and in the datafiles at the physical level. There are some other files as well like Redo log files, Control files, Initialization files which stores important information about the database.

    What is an Instance?


    To view or update data stored in tables/datafiles, Oracle must start a set of background processes, and must allocate some memory to be used during database operation. The background processes and memory allocated by Oracle together make up an Instance.
  • 6. Re: Difference between Oracle Instance & Database.
    chesplay Newbie
    Currently Being Moderated
    Thanks everyone for the prompt reply.Also as said "The background processes and memory allocated by Oracle together make up an Instance." then as database holds database files will it not hold memory?








    "
  • 7. Re: Difference between Oracle Instance & Database.
    Varma Explorer
    Currently Being Moderated
    Hi,

    The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle).

    A relational database is a database that conforms to relational model theory. The software used in a relational database is called a relational database management system (RDBMS). Colloquial use of the term "relational database" may refer to the RDBMS software, or the relational database itself. A relational database is the predominant choice in storing data, over other models like the hierarchical database model or the network model.
  • 8. Re: Difference between Oracle Instance & Database.
    Varma Explorer
    Currently Being Moderated
    Thanks everyone for the prompt reply.Also as said "The background processes and memory allocated by Oracle together make up an Instance." then as database holds database files will it not hold memory?
    There are two terms that are used with Oracle

    Database - A collection of physical operating system files
    Instance - A set of Oracle processes and a SGA (allocation of memory) .


    These two are very closely related but a database can be mounted and opened by allocating set of background process and memory.

    Edited by: kcv on Jan 24, 2012 2:41 PM
  • 9. Re: Difference between Oracle Instance & Database.
    user2661571 Newbie
    Currently Being Moderated
    Hi,

    Instance is combination of memory and background processes.
    Database is physical structure of Oracle Database like Controlfile , redolog file and datafiles.

    Thanks and Regards
    Jagatsing
  • 10. Re: Difference between Oracle Instance & Database.
    rp0428 Guru
    Currently Being Moderated
    In the early days (when Oracle came on floppies - for those of you that know what those are) members of some tight-knit groups of DBAs that hadn't seen each other for a while would sometimes greet each other with a joke that went:

    1st DBA: How do you startup a database?
    2nd DBA: How do you get down off of an elephant?
    Both DBAs together: YOU CAN"T

    Then they would laugh. Anyone that knew this joke was one of the gang.

    The 'how do you startup a database' is a good interview question for a newbie DBA candidate too.

    It was a joke because you can't startup a database. You startup an instance. And you can't get down off of an elephant you get down off of a duck.

    The "you can't" was a take-off on the 'third base' line of Abbot and Constello's classic old baseball routine.

    Oh well, showing my age I guess.
  • 11. Re: Difference between Oracle Instance & Database.
    912102 Newbie
    Currently Being Moderated
    chesplay wrote:
    Hi,

    I wanted to know the difference between oracle Instance and oracle Database, Also between ORacle database and relational database.

    Please use simple terminology to explain.

    Thanks.
    Oracle instance
    The combination of the background processes and memory buffers is called an Oracle instance.

    Oracle database
    An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data.

    Regards,
    Varinder Sandhu
  • 12. Re: Difference between Oracle Instance & Database.
    Pavan Kumar N Newbie
    Currently Being Moderated
    Hi,

    I will put in slightly different way..I hope you would get understood.

    Oracle Instance - As being an computer professional, you might know that RAM is part of your System. Oracle require some RAM in order to work (work like processing the requests - like queries which end users fires/executes), So Oracle gets allocate some RAM with in available memory with in your system. Now, further - as every other program even Oracle product have some programs are used (mandatory) runs as part of instance, in order to server the requests of end users (example - processing your results in order give back results to end -users)

    So - It's combination of memory @RAM allocated for Oracle + some programs runs in support = Instance (Oracle Instance).

    Oracle Database - As being an computer professional you might search for jobs for better salary or better work as per your needs. So, in order to get an interview calls or further processing at-least at first step the Customer must see through profile - of-course you must have saved or holding a copy in your hard disk. Similary so many business are running all around the world and even they do that their details of their business needs and they do store it similarly, perhaps oracle stores the data in different format which is not read directly but read through sql queries and we can them as data files,as they hold actual data.

    I hope you have understood the different between the Oracle Instance and database.

    - Thanks & Regards
    Oracle DBA
  • 13. Re: Difference between Oracle Instance & Database.
    Varma Explorer
    Currently Being Moderated
    Hi,

    hope the information i provided was helpful to you.

    if you need any more details on this,let me know.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points