{"id":228,"date":"2020-08-21T01:30:40","date_gmt":"2020-08-21T01:30:40","guid":{"rendered":"http:\/\/thedatapup.com\/home\/?page_id=228"},"modified":"2021-01-15T01:50:27","modified_gmt":"2021-01-15T01:50:27","slug":"specifying-a-different-oracle-client-for-data-pup","status":"publish","type":"page","link":"https:\/\/thedatapup.com\/home\/index.php\/data-pup\/specifying-a-different-oracle-client-for-data-pup\/","title":{"rendered":"Specifying a different Oracle Client for Data Pup"},"content":{"rendered":"\n<p>If you are running a 32-bit Oracle Client, and need to leave that in place for other applications, these steps will allow you to run Data Pup using a 64-bit Oracle Client located elsewhere.<\/p>\n\n\n\n<p>Step 1 &#8211; Download Oracle&#8217;s 64-Bit instant client from the <a href=\"https:\/\/www.oracle.com\/database\/technologies\/instant-client\/winx64-64-downloads.html\">Oracle website<\/a>.  The basic client should suffice.<\/p>\n\n\n\n<p>Step 2 &#8211; Using a command prompt, extract it to a folder of your choosing.  Here I&#8217;ve used C:\\oracle\\ and assume you have downloaded it to your Downloads folder.  It should extract your instant client to C:\\Oracle\\instant_client_19_8. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">C:\nmkdir C:\\oracle\ncd oracle\nunzip C:\\users\\your_username\\Downloads\\instantclient-basic-windows.x64-19.8.0.0.0dbru.zip\n<\/code><\/pre>\n\n\n\n<p>Step 3 Optional &#8211; do if you use a tnsnames.ora file and\/or ldap.ora file.  Create a folder under the new client and copy the relevant .ora files into it.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">C:\ncd \\oracle\\instant_client_19_8\nmkdir network\ncd network\ncopy \\path\\to\\tnsnames.ora .\ncopy \\path\\to\\ldap.ora .<\/code><\/pre>\n\n\n\n<p>Step 4 &#8211; Go into your Data Pup installation folder, and create a batch file in that folder that will launch Data Pup after setting some Oracle parameters:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">cd \\\"Program Files (x86)\\Data Pup\"\\\nnotepad datapup.bat\n<\/code><\/pre>\n\n\n\n<p>Put the following in the batch file (check the folder name if you download a newer version of instant client):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">@echo off\nset ORACLE_HOME=C:\\oracle\\instant_client_19_8\nset PATH=C:\\oracle\\instant_client_19_8;%PATH%\ndatapup.exe<\/code><\/pre>\n\n\n\n<p>Step 4 &#8211; Create a shortcut on your desktop to the new batch file &#8220;C:\\Program Files (x86)\\Data Pup\\datapup.bat&#8221; , and use this to run Data Pup.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are running a 32-bit Oracle Client, and need to leave that in place for other applications, these steps will allow you to run Data Pup using a 64-bit Oracle Client located elsewhere. Step 1 &#8211; Download Oracle&#8217;s 64-Bit instant client from the Oracle website. The basic client should suffice. Step 2 &#8211; Using &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/thedatapup.com\/home\/index.php\/data-pup\/specifying-a-different-oracle-client-for-data-pup\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Specifying a different Oracle Client for Data Pup&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":52,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/pages\/228"}],"collection":[{"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/comments?post=228"}],"version-history":[{"count":5,"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/pages\/228\/revisions"}],"predecessor-version":[{"id":488,"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/pages\/228\/revisions\/488"}],"up":[{"embeddable":true,"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/pages\/52"}],"wp:attachment":[{"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/media?parent=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}