{"id":400,"date":"2023-11-15T18:59:42","date_gmt":"2023-11-15T18:59:42","guid":{"rendered":"https:\/\/test.samplewebsitelink.com\/ordba\/?p=400"},"modified":"2023-11-23T17:16:59","modified_gmt":"2023-11-23T17:16:59","slug":"oracle-tutorials-2","status":"publish","type":"post","link":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/","title":{"rendered":"Oracle Tutorials"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The architecture of Oracle RDBMS is client server architecture.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This architecture is supported by network communications based on the client communications with RDBMS (Database). Shared Memory created and allocated by Operating Syastem (OS) for inter process communication (IPC).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The network configuration is supported by<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. listener.ora<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. tnsnames.ora<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3. sqlnet.ora<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Based on the Oracle Docs, the process configuration:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;Listener.ora<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp; &nbsp;Listener for the RDBMS Confifuration is to be done to validate the incoming client process for communication with the database server. The listener configuration depends on<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp; &nbsp; 01. protocol of the communication &#8211; TCP\/IP or IPC<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp; &nbsp; 02. hostname &#8211; the server that is hosting the RDBMS<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp; &nbsp; 03. port &#8211; port on which the listener is hearing the taps by the client processes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp; &nbsp; The host is identified by name or physical\/virtual IP on TCP protocol.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is achieved by the configuration of &#8220;Network Interface Controller (NIC)&#8221; configuration and activating the service<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The incoming client process, initiates another in the server with the details of the listener protocol, host, and port (as identified in the configuration of oracle listener process) number. The server process carrying the process (TCP supported) port number establishes (with a shake hand with listener process). The listener after due validation communicates with the RDBMS Server and the server (RDBMS) creates a session within the database. That session excutes<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">the DDL, DML commands as required by client and hands over the output to the client process and completes its role. Even after satisfying the query, the session can continue the session for further queries and communications.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/ordba.net\/assets\/pdf\/Oracle-Tutorials.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Read more >><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The architecture of Oracle RDBMS is client server architecture. This architecture is supported by network communications based on the client communications with RDBMS (Database). Shared Memory created and allocated by Operating Syastem (OS) for inter process communication (IPC). The network configuration is supported by 1. listener.ora 2. tnsnames.ora 3. sqlnet.ora Based on the Oracle Docs, &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/\"> <span class=\"screen-reader-text\">Oracle Tutorials<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":403,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[16],"tags":[],"class_list":["post-400","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-tutorials"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Tutorials - Ordba<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Tutorials - Ordba\" \/>\n<meta property=\"og:description\" content=\"The architecture of Oracle RDBMS is client server architecture. This architecture is supported by network communications based on the client communications with RDBMS (Database). Shared Memory created and allocated by Operating Syastem (OS) for inter process communication (IPC). The network configuration is supported by 1. listener.ora 2. tnsnames.ora 3. sqlnet.ora Based on the Oracle Docs, &hellip; Oracle Tutorials Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Ordba\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-15T18:59:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-23T17:16:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/oracle.png\" \/>\n\t<meta property=\"og:image:width\" content=\"680\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"ordba\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ordba\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/\",\"name\":\"Oracle Tutorials - Ordba\",\"isPartOf\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\"},\"datePublished\":\"2023-11-15T18:59:42+00:00\",\"dateModified\":\"2023-11-23T17:16:59+00:00\",\"author\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\"},\"breadcrumb\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Tutorials\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\",\"name\":\"Ordba\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\",\"name\":\"ordba\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"caption\":\"ordba\"},\"sameAs\":[\"https:\/\/test.samplewebsitelink.com\/ordba\"],\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Tutorials - Ordba","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:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Tutorials - Ordba","og_description":"The architecture of Oracle RDBMS is client server architecture. This architecture is supported by network communications based on the client communications with RDBMS (Database). Shared Memory created and allocated by Operating Syastem (OS) for inter process communication (IPC). The network configuration is supported by 1. listener.ora 2. tnsnames.ora 3. sqlnet.ora Based on the Oracle Docs, &hellip; Oracle Tutorials Read More &raquo;","og_url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/","og_site_name":"Ordba","article_published_time":"2023-11-15T18:59:42+00:00","article_modified_time":"2023-11-23T17:16:59+00:00","og_image":[{"width":680,"height":600,"url":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/oracle.png","type":"image\/png"}],"author":"ordba","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ordba","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/","url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/","name":"Oracle Tutorials - Ordba","isPartOf":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website"},"datePublished":"2023-11-15T18:59:42+00:00","dateModified":"2023-11-23T17:16:59+00:00","author":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f"},"breadcrumb":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/oracle-tutorials-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.samplewebsitelink.com\/ordba\/"},{"@type":"ListItem","position":2,"name":"Oracle Tutorials"}]},{"@type":"WebSite","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website","url":"https:\/\/test.samplewebsitelink.com\/ordba\/","name":"Ordba","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f","name":"ordba","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","caption":"ordba"},"sameAs":["https:\/\/test.samplewebsitelink.com\/ordba"],"url":"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/"}]}},"_links":{"self":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/comments?post=400"}],"version-history":[{"count":4,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/400\/revisions"}],"predecessor-version":[{"id":720,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/400\/revisions\/720"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media\/403"}],"wp:attachment":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media?parent=400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/categories?post=400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/tags?post=400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}