{"id":2952687,"date":"2026-01-05T12:12:26","date_gmt":"2026-01-05T20:12:26","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2952687"},"modified":"2026-03-25T13:39:45","modified_gmt":"2026-03-25T20:39:45","slug":"deploy-an-enterprise-geodatabase-in-oracle","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle","title":{"rendered":"Deploy an enterprise geodatabase in Oracle"},"author":156961,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23851],"tags":[763732,767792,766272,781038],"industry":[],"product":[36561],"class_list":["post-2952687","blog","type-blog","status-publish","format-standard","hentry","category-data-management","tag-database","tag-enterprise-geodatabase","tag-oracle","tag-st_geometry","product-arcgis-pro"],"acf":{"short_description":"Learn tips and tricks when working with Oracle and geodatabases in ArcGIS Pro. ","flexible_content":[{"acf_fc_layout":"content","content":"<p><span class=\"TextRun SCXW15506828 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW15506828 BCX8\">This blog article shows the complete process of deploying an enterprise geodatabase in an Oracle database.\u00a0<\/span><span class=\"NormalTextRun SCXW15506828 BCX8\">You\u2019ll<\/span><span class=\"NormalTextRun SCXW15506828 BCX8\">\u00a0learn about databases, ArcGIS support considerations, preparing your Oracle database to be used in ArcGIS, and tools and spatial components. This information is for database or\u00a0<\/span><span class=\"NormalTextRun SCXW15506828 BCX8\">geodatabase<\/span><span class=\"NormalTextRun SCXW15506828 BCX8\">\u00a0administrators in organizations using Oracle.<\/span><\/span><span class=\"EOP SCXW15506828 BCX8\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:257}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"content","content":"<h3><b><span data-contrast=\"none\">Install or upgrade to a\u00a0supported\u00a0Oracle\u00a0database version<\/span><\/b><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:240,&quot;335559739&quot;:0}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">If you plan to install an Oracle database or upgrade a database version, review the following upgrade considerations:\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Ensure that the Oracle version used by your organization is supported by all the ArcGIS clients\u2019 versions you plan to use.<\/span><b><span data-contrast=\"auto\">\u00a0<\/span><\/b><span data-contrast=\"auto\">This\u00a0maintains\u00a0optimal\u00a0performance and workflow functionality.<\/span><\/p>\n<ul>\n<li>Check the <a href=\"https:\/\/support.esri.com\/en-us\/knowledge-base\/is-my-oracle-database-version-supported-by-arcgis-enter-000030041\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">What Oracle database versions are supported by ArcGIS Enterprise and ArcGIS Pro?<\/span><\/a><span data-contrast=\"auto\">\u00a0knowledge article<\/span><span data-ccp-props=\"{&quot;335559685&quot;:720}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">Choose an Oracle\u00a0<\/span><b><span data-contrast=\"auto\">database version with\u00a0long-term\u00a0support<\/span><\/b><span data-contrast=\"auto\">\u00a0to minimize the frequency of upgrades.\u00a0\u00a0<\/span><\/p>\n<ul>\n<li>Check the <a href=\"https:\/\/support.oracle.com\/knowledge\/Oracle%20Database%20Products\/742060_1.html\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Release Schedule of Current Oracle Database Releases<\/span><\/a><span data-contrast=\"auto\"> article<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">Install the\u00a0<\/span><b><span data-contrast=\"auto\">Oracle Database Client at a release that is compatible with the Oracle version<\/span><\/b><span data-contrast=\"auto\">,\u00a0to allow the ArcGIS client applications to communicate with your database.<\/span><\/p>\n<ul>\n<li>Check the <a href=\"https:\/\/www.oracle.com\/database\/technologies\/instant-client\/downloads.html\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Oracle Instant Client Downloads<\/span><\/a><span data-contrast=\"auto\">\u00a0list<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-ccp-props=\"{&quot;335559685&quot;:1080}\">\u00a0<\/span><b><span data-contrast=\"auto\">Note:\u00a0<\/span><\/b><span data-contrast=\"auto\">Follow the\u00a0<\/span><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/data-management\/arcgis-clients-and-dbms-upgrade-considerations\/\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">ArcGIS clients and DBMS upgrade considerations blog article<\/span><\/a><span data-contrast=\"auto\">\u00a0which\u00a0illustrates a common workflow example that many organizations\u00a0use\u00a0when upgrading their systems.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"content","content":"<h3><b><span data-contrast=\"none\">Configure\u00a0Oracle\u00a0database\u00a0for deploying an enterprise geodatabase<\/span><\/b><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:240,&quot;335559739&quot;:0}\">\u00a0<\/span><\/h3>\n<p><span data-ccp-props=\"{}\">\u00a0<\/span><span data-contrast=\"auto\">Oracle\u2019s\u00a0multitenant architecture\u00a0has\u00a0a\u00a0container database (<\/span><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/multi\/glossary.html#GUID-135FF536-DE9B-40CF-9F42-C246762BD77F\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">CDB<\/span><\/a><span data-contrast=\"auto\">), which can store multiple pluggable databases (<\/span><span data-contrast=\"none\">PDBs).\u00a0<\/span><span data-contrast=\"none\">A \u202f<\/span><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/multi\/glossary.html#GUID-D6932E25-775E-4FF1-BB08-F8999629093C\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">PDB<\/span><\/a><span data-contrast=\"none\">\u202fis a portable collection of schemas, schema objects, and non-schema objects that\u00a0appears\u00a0to an Oracle Net client as a\u202fdatabase.<\/span><span data-contrast=\"none\">\u202f<\/span><span data-contrast=\"auto\">In\u00a0Oracle\u00a0multitenant architecture, you can\u00a0<\/span><b><span data-contrast=\"auto\">create geodatabases in\u00a0a\u00a0PDB\u00a0only<\/span><\/b><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2952689,"id":2952689,"title":"diagram","filename":"diagram.png","filesize":52830,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/diagram.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\/diagram-13","alt":"","author":"156961","description":"","caption":"","name":"diagram-13","status":"inherit","uploaded_to":2952687,"date":"2025-12-23 19:08:22","modified":"2025-12-23 19:08:22","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":881,"height":517,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/diagram-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/diagram.png","medium-width":445,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/diagram.png","medium_large-width":768,"medium_large-height":451,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/diagram.png","large-width":881,"large-height":517,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/diagram.png","1536x1536-width":881,"1536x1536-height":517,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/diagram.png","2048x2048-width":881,"2048x2048-height":517,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/diagram-792x465.png","card_image-width":792,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/diagram.png","wide_image-width":881,"wide_image-height":517}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3><b><span data-contrast=\"none\">Considerations\u00a0for\u00a0memory and\u00a0initialization\u00a0parameters<\/span><\/b><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:40,&quot;335559739&quot;:0}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Keep the following in mind:<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:360,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-contrast=\"auto\">The Oracle Text\u00a0component\u00a0must be installed. The Text\u00a0component\u00a0is installed by default in Oracle; however, if you did not perform a default installation, the Text\u00a0component\u00a0may not have been installed.\u00a0This\u00a0component\u00a0is needed<\/span><span data-contrast=\"auto\">\u00a0<\/span><span data-contrast=\"auto\">for certain ArcGIS functionalities, particularly for creating and querying geodatabases with full-text indexing.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:360,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-contrast=\"auto\">Memory tuning\u00a0\u2013 Although the default setting will work for creating an enterprise geodatabase,\u00a0the\u00a0following\u00a0options\u00a0should be taken\u00a0into\u00a0consideration\u00a0for\u00a0improving\u00a0performance.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"2\"><span data-contrast=\"auto\">SGA must not swap\u00a0&#8211; Swapping the SGA to disk significantly degrades performance, as the purpose of the SGA is to hold\u00a0frequently\u00a0accessed data in memory for rapid retrieval.\u00a0The SGA should be configured to fit within the available physical RAM.\u202fWe recommend that the SGA size should\u00a0generally not\u00a0exceed two-thirds of the server&#8217;s physical RAM.\u202fThis allows room for other processes and the operating system.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"2\"><span data-contrast=\"auto\">Avoid excessive paging\u00a0&#8211; Excessive paging, when\u00a0parts of memory are constantly moved to and from disk,\u00a0indicates\u00a0that the SGA or other memory structures are too large for the available physical RAM.\u202fThis leads to\u00a0slow\u00a0performance.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"2\"><span data-contrast=\"auto\">Configure enough virtual memory\u00a0&#8211; While the SGA itself should not swap, the system still requires adequate virtual memory and swap space.\u202fOracle often recommends swap space to be at least three to four times the size of your physical RAM, although other sources suggest different ratios depending on RAM size.\u202fThis swap space acts as a safety net for less\u00a0frequently\u00a0accessed data and other processes, but the critical point is to prevent the SGA from using\u00a0it.\u202f<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"2\"><span data-contrast=\"auto\">Explicit quotas on tablespaces\u00a0\u2013\u00a0Users who create Oracle objects (e.g.,\u00a0sde, data owners) need access to tablespace storage. This can be managed by granting\u00a0the\u00a0UNLIMITED TABLESPACE privilege,\u00a0which grants unrestricted space across all tablespaces. Due to\u00a0the\u00a0risk of exhausting\u00a0the\u00a0storage or crashing the database, this should be reserved for DBAs only.\u00a0The\u00a0recommended\u00a0option\u00a0is to assign quotas, which is\u00a0a\u00a0safer and more controlled\u00a0approach. Users are given specific space limits on designated tablespaces (for example,\u00a0GIS_ADMIN gets quotas on GIS_DATA, not on SYSTEM).\u00a0DBAs\u00a0may\u00a0assign unlimited or no quotas to geodatabase owners, allowing flexibility while keeping data organized and protected. For less experienced users (e.g., editors\/viewers), limited quotas help manage space usage.\u00a0Quota assignments should align with user roles and business needs.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:360,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"6\" data-aria-level=\"1\"><span data-contrast=\"auto\">Database parameters\u00a0\u2013\u00a0The\u00a0following\u00a0parameters\u00a0must be\u00a0changed as\u00a0user that has\u00a0sysdba\u00a0privileges.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"2\"><a href=\"https:\/\/support.esri.com\/en-us\/knowledge-base\/what-is-an-appropriate-value-for-the-oracle-init-ora-pa-000006973\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">OPEN_CURSORS<\/span><\/a><span data-contrast=\"auto\">:\u00a0The default\u00a0value for\u00a0open_cursors\u00a0in\u00a0an\u00a0Oracle database is 300.\u00a0The recommended value is\u00a02000 or higher.\u00a0If it is set\u00a0to a higher value before creating the geodatabase\u00a0using\u00a0the\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/create-enterprise-geodatabase.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Create\u00a0Enterprise Geodatabase<\/span><\/a><span data-contrast=\"auto\">\u00a0geoprocessing\u00a0tool,\u00a0the\u202fopen_cursors\u00a0setting between the\u202fOracle\u202fdatabase and the geodatabase will be synchronized.\u00a0However,\u00a0if the\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/enable-enterprise-geodatabase.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Enable Enterprise\u00a0Geodatabase<\/span><\/a><span data-contrast=\"auto\">\u00a0tool\u00a0is\u00a0used\u00a0or the value\u00a0of\u00a0the\u00a0open_cursors\u00a0parameter is changed after\u00a0creating the geodatabase,\u00a0you\u00a0must update\u00a0to\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/data\/geodatabases\/manage-oracle\/update-open-cursors.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">open_cursors setting in geodatabases in Oracle<\/span><\/a><span data-contrast=\"auto\">.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:360,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"7\" data-aria-level=\"1\"><span data-contrast=\"auto\">Execute\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/data\/geodatabases\/manage-oracle\/privileges-oracle.htm#ESRI_SECTION1_69AC7B98200147AE9A77202410C41C45\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">privileges\u00a0on packages<\/span><\/a><span data-contrast=\"auto\">\u00a0\u2013\u00a0As\u00a0the\u00a0sysdba\u00a0user,\u00a0you\u00a0need to\u00a0grant the execute privilege on the\u00a0following\u00a0packages to the public role to create or upgrade the geodatabase:\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"2\">\n<h6><strong>dbms_lob\u00a0<\/strong><\/h6>\n<\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"2\">\n<h6><strong>dbms_lock\u00a0<\/strong><\/h6>\n<\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"2\">\n<h6><strong>dbms_pipe\u00a0<\/strong><\/h6>\n<\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"2\">\n<h6><strong>dbms_utility\u00a0<\/strong><\/h6>\n<\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"5\" data-aria-level=\"2\">\n<h6><strong>dbms_sql\u00a0<\/strong><\/h6>\n<\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Courier New\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1080,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Courier New&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"6\" data-aria-level=\"2\">\n<h6><strong>utl_raw\u00a0<\/strong><\/h6>\n<\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">After you create or upgrade the geodatabase, you can restrict privileges on these packages by revoking them from the public role and granting them to each individual user who connects to the geodatabase, including the geodatabase administrator.\u00a0Note that\u00a0you cannot grant the\u202fexecute\u202fprivilege to a role and grant the role to all the users because privileges granted through user roles are not applicable when running\u202fOracle\u202fpackages.<\/span><span data-ccp-props=\"{&quot;335559685&quot;:720}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"content","content":"<h3><b><span data-contrast=\"none\">Connect to an Oracle database in ArcGIS Pro<\/span><\/b><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:40,&quot;335559739&quot;:0}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Once the\u00a0Oracle database is installed and configured, you will make a connection to the database using\u00a0ArcGIS\u00a0Client.\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/data\/databases\/connect-oracle.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"auto\">To connect to Oracle from ArcGIS<\/span><\/a><span data-contrast=\"auto\">\u00a0clients,\u00a0you\u00a0must\u00a0install an Oracle client on the ArcGIS client machines. You will need a 64-bit\u00a0client\u00a0for ArcGIS Pro and\u00a0ArcGIS\u00a0Server.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">After installing the\u00a0client\u00a0software, set environment variables that reference the Oracle client\u00a0directory.\u00a0This is\u00a0required\u00a0so that\u00a0the\u00a0ArcGIS clients\u00a0can use the\u00a0Oracle client\u00a0libraries\u00a0to\u00a0connect\u00a0to\u00a0the\u00a0Oracle database.\u00a0\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"15\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">In Microsoft Windows, set the PATH\u00a0environment variable<\/span><span data-contrast=\"none\">\u00a0<\/span><span data-contrast=\"auto\">to the location of\u00a0the\u202fOracle\u202fclient installation. See the\u202fMicrosoft Windows\u202fdocumentation\u00a0for\u00a0instructions\u00a0on\u00a0setting\u00a0the\u202fPATH\u202fenvironment variable<\/span><b><span data-contrast=\"auto\">.<\/span><\/b><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"14\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">To install Oracle for<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/data\/geodatabases\/manage-oracle\/connect-oracle.htm#:~:text=Set%20the%20LD_LIBRARY_PATH%20environment%20variable%20(Linux%20and%20Oracle%20Administrator%2C%20Developer%2C%20or%20Runtime%20client%20only)\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">\u00a0ArcGIS\u00a0Server\u00a0on Linux,\u00a0set the LD_LIBRARY_PATH\u00a0system\u00a0variable.<\/span><\/a><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\"><span class=\"NormalTextRun SCXW47440314 BCX8\">Once the Oracle client is installed and\u00a0<\/span><span class=\"NormalTextRun SCXW47440314 BCX8\">the\u00a0<\/span><span class=\"NormalTextRun SCXW47440314 BCX8\">environment<\/span><span class=\"NormalTextRun SCXW47440314 BCX8\">\u00a0variables<\/span><span class=\"NormalTextRun SCXW47440314 BCX8\">\u00a0<\/span><span class=\"NormalTextRun SCXW47440314 BCX8\">are configured<\/span><span class=\"NormalTextRun SCXW47440314 BCX8\">,<\/span><span class=\"NormalTextRun SCXW47440314 BCX8\">\u00a0<\/span><span class=\"NormalTextRun SCXW47440314 BCX8\">you can <\/span>connect to the database.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">If\u00a0connecting\u00a0from ArcGIS\u00a0Pro,\u00a0you\u00a0can\u00a0create a database connection\u00a0using the Database Connection dialog\u00a0box.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2952695,"id":2952695,"title":"Make a database connection","filename":"db-connection.png","filesize":33194,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/db-connection.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\/db-connection-2","alt":"Make a database connection","author":"156961","description":"Make a database connection","caption":"Make a database connection","name":"db-connection-2","status":"inherit","uploaded_to":2952687,"date":"2025-12-23 19:33:34","modified":"2025-12-23 20:16:08","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":450,"height":483,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/db-connection-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/db-connection.png","medium-width":243,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/db-connection.png","medium_large-width":450,"medium_large-height":483,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/db-connection.png","large-width":450,"large-height":483,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/db-connection.png","1536x1536-width":450,"1536x1536-height":483,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/db-connection.png","2048x2048-width":450,"2048x2048-height":483,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/db-connection-433x465.png","card_image-width":433,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/db-connection.png","wide_image-width":450,"wide_image-height":483}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3><b><span data-contrast=\"none\">Create an Oracle geodatabase\u00a0<\/span><\/b><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:40,&quot;335559739&quot;:0}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">In ArcGIS Pro,\u00a0two geoprocessing tools can help you create\u00a0a new geodatabase in Oracle;\u00a0the\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/create-enterprise-geodatabase.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Create Enterprise Geodatabase<\/span><\/a><span data-contrast=\"auto\">\u00a0and the\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/enable-enterprise-geodatabase.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Enable Enterprise Geodatabase<\/span><\/a><span data-contrast=\"auto\">\u00a0geoprocessing tools.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Both the tools\u00a0create an\u00a0oracle\u00a0enterprise geodatabase\u00a0when run against an\u00a0<\/span><strong>existing pluggable<\/strong><span data-contrast=\"auto\">\u00a0Oracle database, however they\u00a0require\u00a0different\u00a0privileges and initial set up.\u00a0The table summarizes\u00a0the requirements\u00a0for the two approaches.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2952697,"id":2952697,"title":"Comparison table","filename":"tablecomparison.png","filesize":47956,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/tablecomparison.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\/tablecomparison","alt":"Comparison table","author":"156961","description":"Comparison table","caption":"Comparison table","name":"tablecomparison","status":"inherit","uploaded_to":2952687,"date":"2025-12-23 19:35:20","modified":"2025-12-23 20:16:23","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":865,"height":477,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/tablecomparison-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/tablecomparison.png","medium-width":464,"medium-height":256,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/tablecomparison.png","medium_large-width":768,"medium_large-height":424,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/tablecomparison.png","large-width":865,"large-height":477,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/tablecomparison.png","1536x1536-width":865,"1536x1536-height":477,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/tablecomparison.png","2048x2048-width":865,"2048x2048-height":477,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/tablecomparison-826x455.png","card_image-width":826,"card_image-height":455,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/tablecomparison.png","wide_image-width":865,"wide_image-height":477}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3><b><span data-contrast=\"none\">Configure Oracle\u00a0extproc\u00a0<\/span><\/b><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:240,&quot;335559739&quot;:0}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">As part of the geodatabase installation, an\u00a0Esri\u00a0ST_Geometry\u00a0spatial\u00a0data\u00a0type is created in the Oracle database.\u00a0The\u00a0Esri\u202fST_Geometry\u00a0spatial data type is the default geometry storage type for geodatabases in\u202fOracle.\u00a0You also must configure the Oracle external procedure agent (extproc) to access\u00a0the\u202fEsri\u202fST_Geometry\u00a0libraries\u00a0before you do any of the following:<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"16\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Run\u00a0ST_Geometry\u00a0SQL functions from SQL clients.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"16\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Define a\u202f<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/3.5\/help\/mapping\/layer-properties\/what-is-a-query-layer-.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">query layer<\/span><\/a><span data-contrast=\"auto\">\u202fthat runs SQL functions on\u00a0ST_Geometry\u00a0columns.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"16\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">Query\u202f<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/3.5\/help\/mapping\/layer-properties\/work-with-binned-feature-layers.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">binned feature layers<\/span><\/a><span data-contrast=\"auto\">\u202fin\u202fArcGIS Pro.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"16\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"1\"><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/3.5\/help\/sharing\/overview\/introduction-to-sharing-web-layers.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Publish a web layer<\/span><\/a><span data-contrast=\"auto\">\u202fthat\u00a0references data in the\u202fOracle\u202fdatabase.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"16\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-contrast=\"auto\">Run the\u202f<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/3.5\/tool-reference\/data-management\/select-layer-by-location.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Select Layer By Location<\/span><\/a><span data-contrast=\"auto\">\u202fgeoprocessing tool with the\u202f<\/span><b><span data-contrast=\"auto\">Intersect (DBMS)<\/span><\/b><span data-contrast=\"auto\">\u202foption.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">The\u00a0ST_Geometry\u00a0SQL functions in\u202fOracle\u202fuse a shared library that\u202fOracle\u202faccesses through the\u202fOracle\u00a0extproc.\u00a0You must configure the\u202fOracle\u202fexternal procedure framework,\u00a0which\u202frequires access to the physical file\u00a0ST_Geometry\u00a0library\u2014ST_SHAPELIB\u2014to perform the tasks listed above.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The\u00a0ST_Geometry\u00a0library is created for specific operating systems. You can download the library file specific to your operating system and client version from\u202f<\/span><a href=\"https:\/\/my.esri.com\/\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">My Esri<\/span><\/a><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The\u202fOracle\u202finstance must have access to the\u00a0ST_Geometry\u00a0library. Place the library on the\u202fOracle\u202fmachine in a directory that the\u202fOracle\u202finstance can access.\u00a0Follow the\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/data\/geodatabases\/manage-oracle\/configure-oracle-extproc.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">steps<\/span><\/a><span data-contrast=\"auto\">\u00a0for your specific\u00a0operating system (OS)\u00a0to configure\u00a0the\u00a0extproc\u00a0using the shape library that matches the supported OS\u00a0of your Oracle database.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"content","content":"<h3><b><span data-contrast=\"none\">Manage\u00a0users\u00a0and\u00a0roles<\/span><\/b><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:240,&quot;335559739&quot;:0}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">After the geodatabase is created, you can set up users.\u00a0The users may be\u00a0data-owners\u00a0or readers.\u00a0Oracle separates who can log in (authentication) from what they can do (authorization).\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"13\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:360,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Create\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/create-role.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">roles<\/span><\/a><span data-contrast=\"auto\">\u00a0to simplify permission management across multiple users.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":2952700,"id":2952700,"title":"The Create Role geoprocessing tool","filename":"Createrole.png","filesize":19655,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/Createrole.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\/createrole","alt":"The Create Role geoprocessing tool","author":"156961","description":"The Create Role geoprocessing tool","caption":"The Create Role geoprocessing tool","name":"createrole","status":"inherit","uploaded_to":2952687,"date":"2025-12-23 19:41:11","modified":"2025-12-23 20:16:51","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":380,"height":461,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/Createrole-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/Createrole.png","medium-width":215,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/Createrole.png","medium_large-width":380,"medium_large-height":461,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/Createrole.png","large-width":380,"large-height":461,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/Createrole.png","1536x1536-width":380,"1536x1536-height":461,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/Createrole.png","2048x2048-width":380,"2048x2048-height":461,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/Createrole.png","card_image-width":380,"card_image-height":461,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/Createrole.png","wide_image-width":380,"wide_image-height":461}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ul>\n<li><span class=\"TextRun SCXW223457420 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW223457420 BCX8\">Use the\u00a0<\/span><\/span><a class=\"Hyperlink SCXW223457420 BCX8\" href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/create-database-user.htm\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"TextRun Underlined SCXW223457420 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW223457420 BCX8\" data-ccp-charstyle=\"Hyperlink\">Create User<\/span><\/span><\/a><span class=\"TextRun SCXW223457420 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW223457420 BCX8\">\u00a0tool to ensure\u00a0<\/span><span class=\"NormalTextRun SCXW223457420 BCX8\">new users<\/span><span class=\"NormalTextRun SCXW223457420 BCX8\">\u00a0have\u00a0<\/span><span class=\"NormalTextRun SCXW223457420 BCX8\">appropriate privileges<\/span><span class=\"NormalTextRun SCXW223457420 BCX8\">\u00a0to own data.<\/span><\/span><span class=\"EOP SCXW223457420 BCX8\" data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":2952701,"id":2952701,"title":"The Create Database User geoprocessing tool","filename":"create-dbUSER.png","filesize":21450,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/create-dbUSER.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\/create-dbuser","alt":"The Create Database User geoprocessing tool","author":"156961","description":"The Create Database User geoprocessing tool","caption":"The Create Database User geoprocessing tool","name":"create-dbuser","status":"inherit","uploaded_to":2952687,"date":"2025-12-23 19:45:54","modified":"2025-12-23 20:17:17","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":380,"height":461,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/create-dbUSER-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/create-dbUSER.png","medium-width":215,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/create-dbUSER.png","medium_large-width":380,"medium_large-height":461,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/create-dbUSER.png","large-width":380,"large-height":461,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/create-dbUSER.png","1536x1536-width":380,"1536x1536-height":461,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/create-dbUSER.png","2048x2048-width":380,"2048x2048-height":461,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/create-dbUSER.png","card_image-width":380,"card_image-height":461,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/create-dbUSER.png","wide_image-width":380,"wide_image-height":461}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><span data-contrast=\"auto\">If a read-only user is needed,\u00a0you have to create the user\u00a0using DBMS tools.\u00a0<\/span><br \/>\n<span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">Note<\/span><\/b><span data-contrast=\"auto\">: Follow the\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/data\/geodatabases\/manage-oracle\/privileges-oracle.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Privileges for geodatabases in Oracle<\/span><\/a><span data-contrast=\"auto\">\u00a0topic to learn more about privileges for geodatabases in Oracle.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"content","content":"<h3><b><span data-contrast=\"none\">Create\u00a0and manage\u00a0datasets<\/span><\/b><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:240,&quot;335559739&quot;:0}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Once your geodatabase and users are in place, you can create\u00a0datasets or register\u00a0existing data with the geodatabase. Registering your data opens the door to all the advanced capabilities of the enterprise geodatabase, including versioning, topology networks, attribute rules, and more.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2952702,"id":2952702,"title":"Manage datasets","filename":"managedatasets.png","filesize":80874,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/managedatasets.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\/managedatasets","alt":"Manage datasets","author":"156961","description":"Manage datasets","caption":"Manage datasets","name":"managedatasets","status":"inherit","uploaded_to":2952687,"date":"2025-12-23 19:48:54","modified":"2025-12-23 20:17:33","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":780,"height":536,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/managedatasets-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/managedatasets.png","medium-width":380,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/managedatasets.png","medium_large-width":768,"medium_large-height":528,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/managedatasets.png","large-width":780,"large-height":536,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/managedatasets.png","1536x1536-width":780,"1536x1536-height":536,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/managedatasets.png","2048x2048-width":780,"2048x2048-height":536,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/managedatasets-677x465.png","card_image-width":677,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/managedatasets.png","wide_image-width":780,"wide_image-height":536}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><span data-contrast=\"auto\">ArcGIS tools help simplify privilege management by making sure all the supporting tables for each dataset receive the correct permissions.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Use ArcGIS tools to manage\u00a0<\/span><a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/change-privileges.htm\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">privileges<\/span><\/a><span data-contrast=\"auto\">\u2014 Geodatabase datasets may be a collection of database objects. Granting read to write privileges on these datasets using ArcGIS tools it ensures that privileges on ancillary tables for the dataset are handled correctly.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2952703,"id":2952703,"title":"Manage privileges","filename":"grantPriviledges.png","filesize":24744,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/grantPriviledges.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\/grantpriviledges","alt":"Manage privileges","author":"156961","description":"Manage privileges","caption":"Manage privileges","name":"grantpriviledges","status":"inherit","uploaded_to":2952687,"date":"2025-12-23 19:51:57","modified":"2025-12-23 20:17:50","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":376,"height":376,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/grantPriviledges-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/grantPriviledges.png","medium-width":261,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/grantPriviledges.png","medium_large-width":376,"medium_large-height":376,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/grantPriviledges.png","large-width":376,"large-height":376,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/grantPriviledges.png","1536x1536-width":376,"1536x1536-height":376,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/grantPriviledges.png","2048x2048-width":376,"2048x2048-height":376,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/grantPriviledges.png","card_image-width":376,"card_image-height":376,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/grantPriviledges.png","wide_image-width":376,"wide_image-height":376}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><span class=\"TextRun SCXW53046575 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW53046575 BCX8\">Deploying an enterprise geodatabase in Oracle requires choosing a supported Oracle version, configuring your database for\u00a0<\/span><span class=\"NormalTextRun SCXW53046575 BCX8\">optimal<\/span><span class=\"NormalTextRun SCXW53046575 BCX8\">\u00a0performance, installing the right client tools, and setting up the geodatabase with the correct privileges and spatial libraries. After that, you can organize users, build datasets, and support your organization\u2019s workflows. With this set-up process, you can use Oracle for enterprise-level GIS, and your geodatabase can grow with your organization\u2019s data requirements.<\/span><\/span><span class=\"EOP SCXW53046575 BCX8\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:257}\">\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Additional\u00a0resources\u00a0<\/strong><\/h3>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"10\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">For an\u00a0overview of enterprise geodatabases, watch the\u00a0<\/span><a href=\"https:\/\/mediaspace.esri.com\/media\/t\/1_svt4nf35\/309413912\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Enterprise Geodatabase: An Introduction<\/span><\/a><span data-contrast=\"auto\">\u00a0technical workshop presented at the Esri User Conference 2023.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"10\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">To learn how to\u00a0configure a database connection with Oracle on Linux, follow the\u00a0<\/span><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client\/\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Monthly Linux Tip<\/span><\/a><span data-contrast=\"auto\">\u00a0blog article.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"10\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Follow the\u00a0example workflow\u00a0to upgrade\u00a0ArcGIS clients and the database version in an organization\u00a0in the\u00a0<\/span><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/data-management\/arcgis-clients-and-dbms-upgrade-considerations\/\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">ArcGIS clients and DBMS upgrade considerations<\/span><\/a><span data-contrast=\"auto\">\u00a0blog article.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"10\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">For more content on geodatabase and spatial data management, check on the <a href=\"https:\/\/geodatabase-resources-gdbteam.hub.arcgis.com\/\" target=\"_blank\" rel=\"noopener\">Geodatabase Resources Hub<\/a>.<\/li>\n<\/ul>\n<p><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"}],"related_articles":[{"ID":2188072,"post_author":"156961","post_date":"2024-01-11 09:37:33","post_date_gmt":"2024-01-11 17:37:33","post_content":"","post_title":"ArcGIS clients and DBMS upgrade considerations","post_excerpt":"","post_status":"publish","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"arcgis-clients-and-dbms-upgrade-considerations","to_ping":"","pinged":"","post_modified":"2024-01-11 09:37:49","post_modified_gmt":"2024-01-11 17:37:49","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2188072","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":2832232,"post_author":"156961","post_date":"2025-06-13 11:00:00","post_date_gmt":"2025-06-13 18:00:00","post_content":"","post_title":"Manage geodatabase upgrades in a service-based architecture","post_excerpt":"","post_status":"publish","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"manage-geodatabase-upgrades-in-a-service-based-architecture","to_ping":"","pinged":"","post_modified":"2025-07-24 06:39:19","post_modified_gmt":"2025-07-24 13:39:19","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2832232","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1225222,"post_author":"10252","post_date":"2021-05-10 07:46:10","post_date_gmt":"2021-05-10 14:46:10","post_content":"","post_title":"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"monthly-linux-tip-configure-database-connection-with-oracle-instant-client","to_ping":"","pinged":"","post_modified":"2021-05-10 07:46:10","post_modified_gmt":"2021-05-10 14:46:10","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1225222","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"authors":[{"ID":430224,"user_firstname":"Amit","user_lastname":"Kesarwani","nickname":"Amit Kesarwani","user_nicename":"akesarwani","display_name":"Amit Kesarwani","user_email":"AKesarwani@esri.com","user_url":"","user_registered":"2026-01-05 21:07:17","user_description":"Amit has been with Esri since 2008. He works primarily on Oracle Enterprise Geodatabases. He is an avid traveler and loves dogs.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/01\/ak-213x200.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"},{"ID":156961,"user_firstname":"Diana","user_lastname":"Muresan","nickname":"Diana Muresan","user_nicename":"dmuresan","display_name":"Diana Muresan","user_email":"dmuresan@esri.com","user_url":"","user_registered":"2021-01-12 23:13:12","user_description":"Product Engineer on the Geodatabase team, passionate about making a difference in people's lives using GIS. Hiker and a true \u00c9clair and Cr\u00eape lover in her free time.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/02\/Photo_crop-213x200.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"show_article_image":false,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/12\/small-card.jpg","wide_image":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Deploy an enterprise geodatabase in Oracle<\/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:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Deploy an enterprise geodatabase in Oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-25T20:39:45+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\"},\"author\":{\"name\":\"Diana Muresan\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4fd5d4cc17e6b2cf4dede740d9a70ca8\"},\"headline\":\"Deploy an enterprise geodatabase in Oracle\",\"datePublished\":\"2026-01-05T20:12:26+00:00\",\"dateModified\":\"2026-03-25T20:39:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\"},\"wordCount\":6,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"database\",\"enterprise geodatabase\",\"Oracle\",\"ST_Geometry\"],\"articleSection\":[\"Data Management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\",\"name\":\"Deploy an enterprise geodatabase in Oracle\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2026-01-05T20:12:26+00:00\",\"dateModified\":\"2026-03-25T20:39:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Deploy an enterprise geodatabase in Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4fd5d4cc17e6b2cf4dede740d9a70ca8\",\"name\":\"Diana Muresan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/02\/Photo_crop-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/02\/Photo_crop-213x200.jpg\",\"caption\":\"Diana Muresan\"},\"description\":\"Product Engineer on the Geodatabase team, passionate about making a difference in people's lives using GIS. Hiker and a true \u00c9clair and Cr\u00eape lover in her free time.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/dmuresan\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Deploy an enterprise geodatabase in Oracle","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:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle","og_locale":"en_US","og_type":"article","og_title":"Deploy an enterprise geodatabase in Oracle","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2026-03-25T20:39:45+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","twitter_misc":{"Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle"},"author":{"name":"Diana Muresan","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4fd5d4cc17e6b2cf4dede740d9a70ca8"},"headline":"Deploy an enterprise geodatabase in Oracle","datePublished":"2026-01-05T20:12:26+00:00","dateModified":"2026-03-25T20:39:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle"},"wordCount":6,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["database","enterprise geodatabase","Oracle","ST_Geometry"],"articleSection":["Data Management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle","name":"Deploy an enterprise geodatabase in Oracle","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2026-01-05T20:12:26+00:00","dateModified":"2026-03-25T20:39:45+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Deploy an enterprise geodatabase in Oracle"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4fd5d4cc17e6b2cf4dede740d9a70ca8","name":"Diana Muresan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/02\/Photo_crop-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/02\/Photo_crop-213x200.jpg","caption":"Diana Muresan"},"description":"Product Engineer on the Geodatabase team, passionate about making a difference in people's lives using GIS. Hiker and a true \u00c9clair and Cr\u00eape lover in her free time.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/dmuresan"}]}},"text_date":"January 5, 2026","author_name":"Multiple Authors","author_page":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/deploy-an-enterprise-geodatabase-in-oracle","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/Newsroom-Keyart-Wide-1920-x-1080.jpg","primary_product":"ArcGIS Pro","tag_data":[{"term_id":763732,"name":"database","slug":"database","term_group":0,"term_taxonomy_id":763732,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"},{"term_id":767792,"name":"enterprise geodatabase","slug":"enterprise-geodatabase","term_group":0,"term_taxonomy_id":767792,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw"},{"term_id":766272,"name":"Oracle","slug":"oracle","term_group":0,"term_taxonomy_id":766272,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":781038,"name":"ST_Geometry","slug":"st_geometry","term_group":0,"term_taxonomy_id":781038,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"category_data":[{"term_id":23851,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":23851,"taxonomy":"category","description":"","parent":0,"count":920,"filter":"raw"}],"product_data":[{"term_id":36561,"name":"ArcGIS Pro","slug":"arcgis-pro","term_group":0,"term_taxonomy_id":36561,"taxonomy":"product","description":"","parent":0,"count":2035,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-pro","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2952687","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/156961"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=2952687"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2952687\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=2952687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=2952687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=2952687"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=2952687"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=2952687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}