{"id":1225222,"date":"2021-05-10T07:46:10","date_gmt":"2021-05-10T14:46:10","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1225222"},"modified":"2021-05-10T07:46:10","modified_gmt":"2021-05-10T14:46:10","slug":"monthly-linux-tip-configure-database-connection-with-oracle-instant-client","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client","title":{"rendered":"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client"},"author":10252,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[37501],"tags":[],"industry":[],"product":[36571],"class_list":["post-1225222","blog","type-blog","status-publish","format-standard","hentry","category-administration","product-arcgis-enterprise"],"acf":{"short_description":"To discuss how to easily configure an Oracle database connection in Linux environments.","flexible_content":[{"acf_fc_layout":"content","content":"<p>Database registration is a key GIS workflow, regardless of your preferred OS or system architecture. Specific to ArcGIS Server on Linux, we dedicate a file to configure database connections within your ArcGIS Server installation. In this Monthly Linux Tip, we will explore how to establish a database connection using an open source Oracle instant client.<\/p>\n<p>Please see the table of contents we will follow below:<\/p>\n<ol>\n<li>Understanding the init_user_param.sh script<\/li>\n<li>Configure Oracle Instant Client<\/li>\n<li>Register an Oracle Database in Server Manager<\/li>\n<\/ol>\n<p><em>NOTE: This blog assumes that you have a compatible Oracle instant client downloaded on your Linux machine. The Oracle instant client version 21_1 and ArcGIS Server 10.9 will be used in this blog.<\/em><\/p>\n<p><strong>1. Understanding the init_user_param.sh script<\/strong><\/p>\n<p>Inside the ArcGIS Server installation, there exists a file known as the <strong><em>init_user_param.sh<\/em><\/strong> script. You can locate it here: <em>&lt;ArcGIS Server installation directory&gt;\/arcgis\/server\/usr\/init_user_param.sh<\/em>.<\/p>\n<p>This script is used when you wish to override environmental variables that directly impact the ArcGIS Server startup process. There are preset environmental variables you can override, or you have the option to provide user-defined variables.<\/p>\n<p><strong>2. Configure Oracle Instant Client Connection<\/strong><\/p>\n<p>Navigate to the above specified directory and edit the <em>init_user_param.sh<\/em> script. Keep going until you see the following:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/05\/init-user-param.png\" \/><\/p>\n<p>Take notice of line #35; that is what we will be modifying. Should you use an Oracle Instant Client to establish a database connection, perform the following:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/05\/instant-client.png\" \/><\/p>\n<p>As seen, all we have done is uncommented line #35 and specify the path where the instant client folder exists. After that is done, save the file and restart ArcGIS Server:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/05\/restart-server.png\" \/><\/p>\n<p><strong>3. Register an Oracle Database in Server Manager<\/strong><\/p>\n<p>Now that we have successfully configured our Oracle database connection, we can test out registering a database! In a browser, navigate over to your Server Manager and over to the Data Stores tab:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/05\/register-database.png\" \/><\/p>\n<p>Once there, attempt to register your Oracle database. If successful, it should register and validation will indicate a green checkmark as shown below:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/05\/validate-database.png\" \/><\/p>\n<p>To wrap up, we have discussed the following: purpose of the <em>init_user_param.sh<\/em> script, how to configure an Oracle instant client connection and verifying we can register an Oracle database.<\/p>\n<p>In the comments, please let me know if this was helpful to you. Also, share your thoughts on what should be covered for next month. As always, thank you for reading this Monthly Linux Tip!<\/p>\n"}],"authors":[{"ID":10252,"user_firstname":"Markus","user_lastname":"Walker","nickname":"MWalker","user_nicename":"mwalker","display_name":"Markus Walker","user_email":"MWalker@esri.com","user_url":"","user_registered":"2019-12-03 14:04:26","user_description":"Markus is a Product Engineer on the ArcGIS Enterprise team, where he specializes with Linux architectures.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/31161cb9-c3aa-493e-8ff2-5b3a3ff46361-213x200.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"related_articles":"","card_image":false,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/ArcGIS-Enterprise-wide.jpg"},"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>Monthly Linux Tip: Configure Database Connection with Oracle Instant Client<\/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-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\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-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client\"},\"author\":{\"name\":\"Markus Walker\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/457f3d786c7c12c3d37d57b3d6f2702f\"},\"headline\":\"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client\",\"datePublished\":\"2021-05-10T14:46:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client\"},\"wordCount\":10,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"articleSection\":[\"Administration\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client\",\"name\":\"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2021-05-10T14:46:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client\"}]},{\"@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\/457f3d786c7c12c3d37d57b3d6f2702f\",\"name\":\"Markus Walker\",\"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\/04\/31161cb9-c3aa-493e-8ff2-5b3a3ff46361-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/31161cb9-c3aa-493e-8ff2-5b3a3ff46361-213x200.jpg\",\"caption\":\"Markus Walker\"},\"description\":\"Markus is a Product Engineer on the ArcGIS Enterprise team, where he specializes with Linux architectures.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/mwalker\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client","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-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client","og_locale":"en_US","og_type":"article","og_title":"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","twitter_card":"summary_large_image","twitter_site":"@ESRI","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client"},"author":{"name":"Markus Walker","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/457f3d786c7c12c3d37d57b3d6f2702f"},"headline":"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client","datePublished":"2021-05-10T14:46:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client"},"wordCount":10,"commentCount":0,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"articleSection":["Administration"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client","name":"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2021-05-10T14:46:10+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/administration\/monthly-linux-tip-configure-database-connection-with-oracle-instant-client#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Monthly Linux Tip: Configure Database Connection with Oracle Instant Client"}]},{"@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\/457f3d786c7c12c3d37d57b3d6f2702f","name":"Markus Walker","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\/04\/31161cb9-c3aa-493e-8ff2-5b3a3ff46361-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/31161cb9-c3aa-493e-8ff2-5b3a3ff46361-213x200.jpg","caption":"Markus Walker"},"description":"Markus is a Product Engineer on the ArcGIS Enterprise team, where he specializes with Linux architectures.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/mwalker"}]}},"text_date":"May 10, 2021","author_name":"Markus Walker","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/mwalker","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/ArcGIS-Enterprise-wide.jpg","primary_product":"ArcGIS Enterprise","tag_data":[],"category_data":[{"term_id":37501,"name":"Administration","slug":"administration","term_group":0,"term_taxonomy_id":37501,"taxonomy":"category","description":"","parent":0,"count":428,"filter":"raw"}],"product_data":[{"term_id":36571,"name":"ArcGIS Enterprise","slug":"arcgis-enterprise","term_group":0,"term_taxonomy_id":36571,"taxonomy":"product","description":"","parent":0,"count":979,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-enterprise","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1225222","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\/10252"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1225222"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1225222\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1225222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1225222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1225222"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1225222"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1225222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}