{"id":21,"date":"2015-02-10T11:09:15","date_gmt":"2015-02-10T11:09:15","guid":{"rendered":"https:\/\/dbadave.co.uk\/?p=21"},"modified":"2016-02-09T23:14:36","modified_gmt":"2016-02-09T23:14:36","slug":"oracle-training-what-is-an-oracle-database","status":"publish","type":"post","link":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/","title":{"rendered":"Oracle Training – What Is An Oracle Database?"},"content":{"rendered":"

If you asked a selection of people, “What is an Oracle database?” you’d probably get a range of answers as there is some confusion about what exactly it is and people often mix up their terminology.<\/p>\n

Oracle Database Tutorial<\/h2>\n

In this article, the first in a series of introductory Oracle training articles that will eventually form a complete Oracle DBA training course, I’m going to explain the difference between an Oracle database server, an Oracle database and an Oracle instance.<\/p>\n

The Oracle Database Server<\/h2>\n

An Oracle database server consists of two elements:<\/p>\n

    \n
  1. An Oracle database.<\/li>\n
  2. An Oracle instance.<\/li>\n<\/ol>\n

    Each of these elements is made up of multiple elements themselves – see the diagram below for a full picture of the Oracle database architecture. Each part of the architecture will be covered in detail throughout this series of DBA 101 articles.<\/p>\n

    \"Oracle<\/a><\/h2>\n

     <\/p>\n

    Oracle Database<\/h2>\n

    The Oracle database is basically the physical files on disk that store the actual data and also the meta-data. The files that store the actual data are called datafiles. Other files include the database control files and the redo logs. We’ll cover these in more details in the next article in this series.<\/p>\n

    As we delve deeper into our study of Oracle in later articles, we’ll see that the database consists of both physical and logical structures:<\/p>\n

      \n
    1. Physical structures are actual tangible structures such as data blocks on disk, and extents (groups of data blocks).<\/li>\n
    2. Logical structures are conceptual elements such as tablespaces, tables and indexes.<\/li>\n<\/ol>\n

      For now, you really just need to understand that the database consists of the physical files on disk.<\/p>\n

      Oracle Instance<\/h2>\n

      The second component of a database server is the Oracle instance. This consists of the memory structures used when the database server is running, and the Oracle background processes.<\/p>\n

      The background processes are the programs that handle the actual running of the database such as the Process Monitor and the Database Writer.<\/p>\n

      Every time an instance is started a shared memory area called the System Global Area, or SGA for short, is allocated and the background processes are started.<\/p>\n

      The instance is then associated with a specific database (i.e. specific datafiles on disk). This is known as\u00a0mounting the database<\/em>. The database is then ready to be opened, which in turn makes it accessible to users.<\/p>\n

      Each instance is associated with just one database. If you have more than one database on a server, there is a separate instance for each one.<\/p>\n

      Again, we’ll cover the Oracle instance in more depth in a later article. For now, you just need to know that the instance consists of the memory structures and the background processes.<\/p>\n

      Summary<\/h2>\n

      To summarise the key points to take away from this article:<\/p>\n

        \n
      1. An Oracle database server consists of the Oracle database and the Oracle instance.<\/li>\n
      2. The database is the actual physical files on disk.<\/li>\n
      3. The instance is the memory structures and the background processes.<\/li>\n
      4. When an instance is started it, it is associated with a specific database. This is called mounting the database.<\/li>\n
      5. An instance is associated with one, and only one, specific database – an instance cannot be shared.<\/li>\n<\/ol>\n

        In the next article, which you can read here<\/a>, we’ll cover the Oracle database memory structures in more detail.<\/p>\n","protected":false},"excerpt":{"rendered":"

        If you asked a selection of people, “What is an Oracle database?” you’d probably get a range of answers as there is some confusion about what exactly it is and people often mix up their terminology. Oracle Database Tutorial In this article, the first in a series of introductory Oracle training articles that will eventually … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":386,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[4,6],"yoast_head":"\nOracle Training - What Is An Oracle Database?<\/title>\n<meta name=\"description\" content=\"Oracle Training - An Oracle Database Tutorial. The 1st article in a complete Oracle DBA training course - everything you need to know to be an Oracle DBA.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Training - What Is An Oracle Database?\" \/>\n<meta property=\"og:description\" content=\"Oracle Training - An Oracle Database Tutorial. The 1st article in a complete Oracle DBA training course - everything you need to know to be an Oracle DBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"DBA Dave - Oracle Training\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-10T11:09:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-02-09T23:14:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/02\/oracle-training-DBA-101-part-1-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"770\" \/>\n\t<meta property=\"og:image:height\" content=\"340\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40\"},\"headline\":\"Oracle Training – What Is An Oracle Database?\",\"datePublished\":\"2015-02-10T11:09:15+00:00\",\"dateModified\":\"2016-02-09T23:14:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/\"},\"wordCount\":556,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbadave.co.uk\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/02\/oracle-training-DBA-101-part-1-1.jpg\",\"keywords\":[\"Oracle Database\",\"Oracle DBA 101\"],\"articleSection\":[\"Oracle Training\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/\",\"url\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/\",\"name\":\"Oracle Training - What Is An Oracle Database?\",\"isPartOf\":{\"@id\":\"https:\/\/dbadave.co.uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/02\/oracle-training-DBA-101-part-1-1.jpg\",\"datePublished\":\"2015-02-10T11:09:15+00:00\",\"dateModified\":\"2016-02-09T23:14:36+00:00\",\"description\":\"Oracle Training - An Oracle Database Tutorial. The 1st article in a complete Oracle DBA training course - everything you need to know to be an Oracle DBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#primaryimage\",\"url\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/02\/oracle-training-DBA-101-part-1-1.jpg\",\"contentUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/02\/oracle-training-DBA-101-part-1-1.jpg\",\"width\":770,\"height\":340,\"caption\":\"Oracle Training - DBA 101 Part 1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbadave.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Training – What Is An Oracle Database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbadave.co.uk\/#website\",\"url\":\"https:\/\/dbadave.co.uk\/\",\"name\":\"DBA Dave - Oracle Training\",\"description\":\"Expert DBA Tips & Advice\",\"publisher\":{\"@id\":\"https:\/\/dbadave.co.uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbadave.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbadave.co.uk\/#organization\",\"name\":\"DBA Dave\",\"url\":\"https:\/\/dbadave.co.uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png\",\"contentUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png\",\"width\":170,\"height\":50,\"caption\":\"DBA Dave\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/dbadave.co.uk\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Training - What Is An Oracle Database?","description":"Oracle Training - An Oracle Database Tutorial. The 1st article in a complete Oracle DBA training course - everything you need to know to be an Oracle DBA.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Training - What Is An Oracle Database?","og_description":"Oracle Training - An Oracle Database Tutorial. The 1st article in a complete Oracle DBA training course - everything you need to know to be an Oracle DBA.","og_url":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/","og_site_name":"DBA Dave - Oracle Training","article_published_time":"2015-02-10T11:09:15+00:00","article_modified_time":"2016-02-09T23:14:36+00:00","og_image":[{"width":770,"height":340,"url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/02\/oracle-training-DBA-101-part-1-1.jpg","type":"image\/jpeg"}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#article","isPartOf":{"@id":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/"},"author":{"name":"admin","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40"},"headline":"Oracle Training – What Is An Oracle Database?","datePublished":"2015-02-10T11:09:15+00:00","dateModified":"2016-02-09T23:14:36+00:00","mainEntityOfPage":{"@id":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/"},"wordCount":556,"commentCount":0,"publisher":{"@id":"https:\/\/dbadave.co.uk\/#organization"},"image":{"@id":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/02\/oracle-training-DBA-101-part-1-1.jpg","keywords":["Oracle Database","Oracle DBA 101"],"articleSection":["Oracle Training"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/","url":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/","name":"Oracle Training - What Is An Oracle Database?","isPartOf":{"@id":"https:\/\/dbadave.co.uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#primaryimage"},"image":{"@id":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/02\/oracle-training-DBA-101-part-1-1.jpg","datePublished":"2015-02-10T11:09:15+00:00","dateModified":"2016-02-09T23:14:36+00:00","description":"Oracle Training - An Oracle Database Tutorial. The 1st article in a complete Oracle DBA training course - everything you need to know to be an Oracle DBA.","breadcrumb":{"@id":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#primaryimage","url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/02\/oracle-training-DBA-101-part-1-1.jpg","contentUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/02\/oracle-training-DBA-101-part-1-1.jpg","width":770,"height":340,"caption":"Oracle Training - DBA 101 Part 1"},{"@type":"BreadcrumbList","@id":"https:\/\/dbadave.co.uk\/oracle-training-what-is-an-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbadave.co.uk\/"},{"@type":"ListItem","position":2,"name":"Oracle Training – What Is An Oracle Database?"}]},{"@type":"WebSite","@id":"https:\/\/dbadave.co.uk\/#website","url":"https:\/\/dbadave.co.uk\/","name":"DBA Dave - Oracle Training","description":"Expert DBA Tips & Advice","publisher":{"@id":"https:\/\/dbadave.co.uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbadave.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbadave.co.uk\/#organization","name":"DBA Dave","url":"https:\/\/dbadave.co.uk\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/","url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png","contentUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png","width":170,"height":50,"caption":"DBA Dave"},"image":{"@id":"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/dbadave.co.uk\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/21"}],"collection":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/comments?post=21"}],"version-history":[{"count":26,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/21\/revisions"}],"predecessor-version":[{"id":387,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/21\/revisions\/387"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/media\/386"}],"wp:attachment":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/media?parent=21"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/categories?post=21"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/tags?post=21"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}