setup-oracle.html


<!DOCTYPE html>
<html lang="en-us">
  <head>
    <meta charset="UTF-8">
    <title>Plugins: Setup Oracle | GeoDa on Github</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <style>
    	*{margin:0;padding:0;}
	.shadowfilter {
	-webkit-filter: drop-shadow(12px 12px 7px rgba(0,0,0,0.5));
	filter: url(shadow.svg#drop-shadow);
	}
	.intro1 { margin-left: -45px;}
    </style>
    <link rel="stylesheet" type="text/css" href="stylesheets/normalize.css" media="screen">
    <link href='https://fonts.googleapis.com/css?family=Open+Sans:400,700' rel='stylesheet' type='text/css'>
    <link rel="stylesheet" type="text/css" href="stylesheets/stylesheet.css" media="screen">
    <link rel="stylesheet" type="text/css" href="stylesheets/github-light.css" media="screen">
    <link rel="stylesheet" href="stylesheets/simple-slideshow-styles.css">
    <style>
	figcaption {
	  top: .70em;
   	  left: .35em;
 	  bottom: auto!important;
	  right: auto!important;
	}
    </style>
  </head>
  <body>

<!-- Google Tag Manager -->
<noscript><iframe src="//www.googletagmanager.com/ns.html?id=GTM-53RVF8"
height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>
<script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
'//www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
})(window,document,'script','dataLayer','GTM-53RVF8');</script>
<!-- End Google Tag Manager -->

    <section class="page-header">
      <h1 class="project-name">GeoDa</h1>
      <h2 class="project-tagline">Plugins | Setup Oracle Spatial Database Plugin</h2>
      <a href="//geodacenter.github.io/" class="btn">Homepage</a>
      <a href="//geodacenter.github.io/download.html" class="btn">Download</a>
      <a href="https://github.com/GeoDaCenter/geoda/" class="btn">View on GitHub</a>
      <a href="https://geodacenter.github.io/data-and-lab/"  target="_blank" class="btn">Data</a>
      <a href="//geodacenter.github.io/cheatsheet.html" class="btn">Cheat Sheet</a>
       <a href="documentation.html" class="btn">Documentation</a>
       <a href="//geodacenter.github.io/support.html" class="btn">Support</a>
       <a href="//geodacenter.github.io/index-cn.html" class="btn">中文</a>
    </section>

    <section class="main-content">
      <h3>
<a id="welcome-to-github-pages" class="anchor" href="#welcome-to-github-pages" aria-hidden="true">
  <span class="octicon octicon-link"></span></a>Plugins | Setup Oracle Spatial Database Plugin</h3>

<p>
<p><a href="#win32">Windows (32-bit)</a> &nbsp; &nbsp;<a href="#win64">Windows (64-bit)</a> &nbsp; &nbsp; <a href="#osx64">Mac OSX (64-bit)</a> &nbsp; &nbsp; <a href="#ubu32">Ubuntu (32-bit)</a> &nbsp; &nbsp;<a href="#ubu64">Ubuntu (64-bit)</a></p>
<hr />
<p><a name="win32"></a></p>
<h2>Windows (32-bit)</h2>
<p>1. Download Oracle Instant Client 32-bit for Windows (version &le;11.2.x) from&nbsp;<a href="http://www.oracle.com/technetwork/topics/winsoft-085727.html">http://www.oracle.com/technetwork/topics/winsoft-085727.html</a></p>
<p><a href="http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html">(</a>Note: You have to register to get Oracle Instant Client)</p>
<p>&quot;Version 11.2.0.3.0 (32-bit)<br />
	&nbsp; &nbsp; Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OIC applications<br />
	&nbsp; &nbsp;&nbsp;<img src="//www.oracle.com/ocom/groups/public/@otn/documents/digitalasset/115899.gif" />instantclient-basic-windows.x86-11.2.0.3.0.zip&quot;</p>
<p>2. Unzip the downloaded ZIP package to your local hard drive. For example: C:\instantclient_11_2</p>
<p>3. Setup your Windows system environment for Oracle Instant Client</p>
<div>&nbsp; &nbsp; Add the path of Oracle Instant Client to PATH system variable in &quot;System Properties&quot; dialog (see following example)<br />
	&nbsp; &nbsp; (Note: you need to add ; before the Oracle Path)</div>
<div><img alt="" src="images/ev-oracle.png" /></div>
<div>
	<p>4. Restart GeoDa program, then you should be able to connect to the Oracle Spatial database by using GeoDa-Oracle-Plugin</p>
	<div>&nbsp;</div>
</div>
<div>&nbsp;</div>
<div>
	<hr /><a name="win64"></a>
	<div>
		<h2>Windows (64-bit)</h2>
	</div>
	<p>1. Download Oracle Instant Client 64-bit for Windows (version &le;11.2.x) from http://www.oracle.com/technetwork/topics/winx64soft-089540.html<br />
		<a href="http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html">(</a>Note: You have to register to get Oracle Instant Client)</p>
	<p>&quot;Version 11.2.0.3.0 (64-bit)<br />
		&nbsp; &nbsp; Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OIC applications<br />
		&nbsp; &nbsp;&nbsp;<img src="//www.oracle.com/ocom/groups/public/@otn/documents/digitalasset/115899.gif" />instantclient-basic-windows.x64-11.2.0.3.0.zip&quot;</p>
	<p>2. Unzip the downloaded ZIP package to your local hard drive. For example: C:\instantclient_11_2</p>
	<p>3. Setup your Windows system environment for Oracle Instant Client</p>
	<div>&nbsp; &nbsp; Add the path of Oracle Instant Client to PATH system variable in &quot;System Properties&quot; dialog (see following example)<br />
		&nbsp; &nbsp; (Note: you need to add ; before the Oracle Path)</div>
	<div><img alt="" src="images/ev-oracle.png" style="width: 424px; height: 475px;" /></div>
	<div>
		<p>4. Restart the GeoDa program, then you should be able to connect to the Oracle Spatial database by using the GeoDa-Oracle-Plugin</p>
		<div>&nbsp;</div>
	</div>
	<hr />
	<p>&nbsp;</p>
	<p><a name="osx64"></a></p>
	<div>
		<h2>Mac OSX &ge;10.6 (64-bit)</h2>
	</div>
	<p>1. Download Oracle Instant Client Package - Basic, 64-bit (version &le;11.2.x) from&nbsp;<a href="http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html">http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html<br />
		(</a>Note: You have to register to get Oracle Instant Client)</p>
	<p>&quot;Version 11.2.0.3.0 (64-bit)<br />
		&nbsp; &nbsp; Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OIC applications<br />
		&nbsp; &nbsp; <img src="//www.oracle.com/ocom/groups/public/@otn/documents/digitalasset/115899.gif" />instantclient-basic-macosx.x64-11.2.0.3.0.zip&quot;</p>
	<p>2. Unzip the downloaded ZIP package to your local hard drive. For example: /Users/yourname/Downloads/instantclient_11_2</p>
	<p>3. Open a new terminal, run the following 2 commands to configure Oracle client for GeoDa</p>
	<div style="margin: 20px; padding: 5px; background-color: black; color: rgb(0, 204, 0);">&nbsp; &nbsp; export ORACLE_HOME=/Users/yourname/Downloads/instantclient_11_2<br />
		&nbsp; &nbsp; ./install_plugins.sh /path/to/downloaded_GeoDa.app/</div>
	<p>&nbsp; &nbsp; &nbsp;The command in the first line stores the Oracle Instant Client location to a variable ORACLE_HOME.<br />
		&nbsp; &nbsp; &nbsp;The command in the second line updates the configuration of the Oracle Plugin for GeoDa.</p>
	<p>4. Restart the GeoDa program, then you should be able to connect to the Oracle Spatial database using the GeoDa-Oracle-Plugin</p>
	<hr />
	<p>&nbsp;</p>
	<a name="ubu32"></a>
	<div>
		<h2>Ubuntu &ge;12 (32-bit)</h2>
	</div>
	<p>1. Download Oracle Instant Client 32-bit (version &le;11.2.x) from&nbsp;http://www.oracle.com/technetwork/topics/linuxsoft-082809.html<br />
		<a href="http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html">(</a>Note: You have to register to get Oracle Instant Client)</p>
	<p>&quot;Version 11.2.0.3.0 (32-bit)<br />
		&nbsp; &nbsp; Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OIC applications<br />
		&nbsp; &nbsp;&nbsp;<img src="//www.oracle.com/ocom/groups/public/@otn/documents/digitalasset/115899.gif" />instantclient-basic-linux-11.2.0.3.0.zip&quot;</p>
	<p>2. Unzip the downloaded ZIP package to your local hard drive. For example: /home/yourname/Downloads/instantclient_11_2</p>
	<p>3. Setup your Ubuntu system environment for Oracle Instant Client</p>
	<p>&nbsp; &nbsp; Run the following command in a terminal (Note: remember to replace &quot;yourname&quot; )&nbsp;</p>
	<div style="margin: 20px; padding: 5px; background-color: black; color: rgb(0, 204, 0);">&nbsp; &nbsp; echo &quot;export ORACLE_HOME=/home/yourname/Downloads/instantclient_11_2&quot; &gt;&gt; ~/.bashrc</div>
	<p>4. Restart the GeoDa program, then you should be able to connect to the Oracle Spatial database using the GeoDa-Oracle-Plugin</p>
	<hr />
	<p>&nbsp;</p>
	<a name="ubu64"></a>
	<div>
		<h2>Ubuntu &ge;12 (64-bit)</h2>
	</div>
	<div>
		<p>1. Download Oracle Instant Client 64-bit (version &le;11.2.x) from&nbsp;http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html<br />
			<a href="http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html">(</a>Note: You have to register to get Oracle Instant Client)</p>
		<p>&quot;Version 11.2.0.3.0 (64-bit)<br />
			&nbsp; &nbsp; Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OIC applications<br />
			&nbsp; &nbsp;&nbsp;<img src="//www.oracle.com/ocom/groups/public/@otn/documents/digitalasset/115899.gif" />instantclient-basic-linux.x64-11.2.0.3.0.zip&quot;</p>
		<p>2. Unzip the downloaded ZIP package to your local hard drive. For example: /home/yourname/Downloads/instantclient_11_2</p>
		<p>3. Setup your Ubuntu system environment for Oracle Instant Client</p>
		<p>&nbsp; &nbsp; Run the following command in a terminal (Note: remember to replace &quot;yourname&quot; )&nbsp;</p>
		<div style="margin: 20px; padding: 5px; background-color: black; color: rgb(0, 204, 0);">&nbsp; &nbsp; echo &quot;export ORACLE_HOME=/home/yourname/Downloads/instantclient_11_2&quot; &gt;&gt; ~/.bashrc</div>
		<p>4. Restart the GeoDa program, then you should be able to connect to the Oracle Spatial database using the GeoDa-Oracle-Plugin</p>
		<div>&nbsp;</div>
	</div>
</div>
<p>&nbsp;</p>

</p>

<h3>
<a id="intro-contact" class="anchor" href="#intro-contact" aria-hidden="true"><span class="octicon octicon-link"></span></a>Contact</h3>
<p>Questions? Contact <a href="mailto:spatial@uchicago.edu">us</a>.</p>


      <footer class="site-footer">
        <span class="site-footer-owner"><a href="https://github.com/lixun910/geoda">GeoDa</a> is maintained by <a href="https://github.com/lixun910">lixun910</a>.</span>

        <span class="site-footer-credits">This page was generated by <a href="https://pages.github.com">GitHub Pages</a> using the <a href="https://github.com/jasonlong/cayman-theme">Cayman theme</a> by <a href="https://twitter.com/jasonlong">Jason Long</a>.</span>
      </footer>

    </section>

            <script type="text/javascript">
            var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
            document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
          </script>
          <script type="text/javascript">
            try {
              var pageTracker = _gat._getTracker("UA-72724100-1");
            pageTracker._trackPageview();
            } catch(err) {}
          </script>

  </body>
</html>