<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>3.6.3. Oracle — Bugzilla 5.0.4 documentation</title>
<link rel="stylesheet" href="../_static/bugzilla.css" type="text/css" />
<link rel="stylesheet" href="../_static/pygments.css" type="text/css" />
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT: '../',
VERSION: '5.0.4',
COLLAPSE_INDEX: false,
FILE_SUFFIX: '.html',
HAS_SOURCE: true,
SOURCELINK_SUFFIX: '.txt'
};
</script>
<script type="text/javascript" src="../_static/jquery.js"></script>
<script type="text/javascript" src="../_static/underscore.js"></script>
<script type="text/javascript" src="../_static/doctools.js"></script>
<link rel="shortcut icon" href="../_static/favicon.ico"/>
<link rel="search" title="Search" href="../search.html" />
<link rel="next" title="3.6.4. SQLite" href="sqlite.html" />
<link rel="prev" title="3.6.2. PostgreSQL" href="postgresql.html" />
</head>
<body>
<div class="related" role="navigation" aria-label="related navigation">
<h3>Navigation</h3>
<ul>
<li class="right" style="margin-right: 10px">
<a href="sqlite.html" title="3.6.4. SQLite"
accesskey="N">next</a></li>
<li class="right" >
<a href="postgresql.html" title="3.6.2. PostgreSQL"
accesskey="P">previous</a> |</li>
<li class="nav-item nav-item-0"><a href="../index.html">Bugzilla 5.0.4 documentation</a> »</li>
<li class="nav-item nav-item-1"><a href="index.html" >3. Installation and Maintenance Guide</a> »</li>
<li class="nav-item nav-item-2"><a href="db_server.html" accesskey="U">3.6. Database Server</a> »</li>
</ul>
</div>
<div class="document">
<div class="documentwrapper">
<div class="bodywrapper">
<div class="body" role="main">
<div class="section" id="oracle">
<span id="id1"></span><h1>3.6.3. Oracle<a class="headerlink" href="#oracle" title="Permalink to this headline">¶</a></h1>
<div class="admonition warning">
<p class="first admonition-title">Warning</p>
<p class="last">Bugzilla supports Oracle, but none of the current developers run
it. Your mileage may vary.</p>
</div>
<p>You need Oracle version 10.02.0 or later.</p>
<div class="section" id="create-a-new-tablespace">
<span id="oracle-tablespace"></span><h2>3.6.3.1. Create a New Tablespace<a class="headerlink" href="#create-a-new-tablespace" title="Permalink to this headline">¶</a></h2>
<p>You can use the existing tablespace or create a new one for Bugzilla.
To create a new tablespace, run the following command:</p>
<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">CREATE</span> <span class="n">TABLESPACE</span> <span class="n">bugs</span>
<span class="n">DATAFILE</span> <span class="s1">'*$path_to_datafile*'</span> <span class="n">SIZE</span> <span class="mi">500</span><span class="n">M</span>
<span class="n">AUTOEXTEND</span> <span class="n">ON</span> <span class="n">NEXT</span> <span class="mi">30</span><span class="n">M</span> <span class="n">MAXSIZE</span> <span class="n">UNLIMITED</span>
</pre></div>
</div>
<p>Here, the name of the tablespace is 'bugs', but you can
choose another name. <em>$path_to_datafile</em> is
the path to the file containing your database, for instance
<code class="file docutils literal"><span class="pre">/u01/oradata/bugzilla.dbf</span></code>.
The initial size of the database file is set in this example to 500 Mb,
with an increment of 30 Mb everytime we reach the size limit of the file.</p>
</div>
<div class="section" id="add-a-user-to-oracle">
<span id="oracle-add-user"></span><h2>3.6.3.2. Add a User to Oracle<a class="headerlink" href="#add-a-user-to-oracle" title="Permalink to this headline">¶</a></h2>
<p>The user name and password must match what you set in <code class="file docutils literal"><span class="pre">localconfig</span></code>
(<code class="docutils literal"><span class="pre">$db_user</span></code> and <code class="docutils literal"><span class="pre">$db_pass</span></code>, respectively). Here, we assume that
the user name is 'bugs' and the tablespace name is the same
as above.</p>
<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">CREATE</span> <span class="n">USER</span> <span class="n">bugs</span>
<span class="n">IDENTIFIED</span> <span class="n">BY</span> <span class="s2">"$db_pass"</span>
<span class="n">DEFAULT</span> <span class="n">TABLESPACE</span> <span class="n">bugs</span>
<span class="n">TEMPORARY</span> <span class="n">TABLESPACE</span> <span class="n">TEMP</span>
<span class="n">PROFILE</span> <span class="n">DEFAULT</span><span class="p">;</span>
<span class="o">--</span> <span class="n">GRANT</span><span class="o">/</span><span class="n">REVOKE</span> <span class="n">ROLE</span> <span class="n">PRIVILEGES</span>
<span class="n">GRANT</span> <span class="n">CONNECT</span> <span class="n">TO</span> <span class="n">bugs</span><span class="p">;</span>
<span class="n">GRANT</span> <span class="n">RESOURCE</span> <span class="n">TO</span> <span class="n">bugs</span><span class="p">;</span>
<span class="o">--</span> <span class="n">GRANT</span><span class="o">/</span><span class="n">REVOKE</span> <span class="n">SYSTEM</span> <span class="n">PRIVILEGES</span>
<span class="n">GRANT</span> <span class="n">UNLIMITED</span> <span class="n">TABLESPACE</span> <span class="n">TO</span> <span class="n">bugs</span><span class="p">;</span>
<span class="n">GRANT</span> <span class="n">EXECUTE</span> <span class="n">ON</span> <span class="n">CTXSYS</span><span class="o">.</span><span class="n">CTX_DDL</span> <span class="n">TO</span> <span class="n">bugs</span><span class="p">;</span>
</pre></div>
</div>
</div>
<div class="section" id="configure-the-web-server">
<span id="oracle-webserver"></span><h2>3.6.3.3. Configure the Web Server<a class="headerlink" href="#configure-the-web-server" title="Permalink to this headline">¶</a></h2>
<p>If you use Apache, append these lines to <code class="file docutils literal"><span class="pre">httpd.conf</span></code>
to set ORACLE_HOME and LD_LIBRARY_PATH. For instance:</p>
<div class="highlight-apache"><div class="highlight"><pre><span></span><span class="nb">SetEnv</span> ORACLE_HOME <span class="sx">/u01/app/oracle/product/10.2.0/</span>
<span class="nb">SetEnv</span> LD_LIBRARY_PATH <span class="sx">/u01/app/oracle/product/10.2.0/lib/</span>
</pre></div>
</div>
<p>When this is done, restart your web server.</p>
<hr class="docutils" />
<p>This documentation undoubtedly has bugs; if you find some, please file
them <a class="reference external" href="https://bugzilla.mozilla.org/enter_bug.cgi?product=Bugzilla&component=Documentation">here</a>.</p>
</div>
</div>
</div>
</div>
</div>
<div class="sphinxsidebar" role="navigation" aria-label="main navigation">
<div class="sphinxsidebarwrapper">
<p class="logo"><a href="../index.html">
<img class="logo" src="../_static/bugzilla.png" alt="Logo"/>
</a></p>
<h3><a href="../index.html">Table Of Contents</a></h3>
<ul>
<li><a class="reference internal" href="#">3.6.3. Oracle</a><ul>
<li><a class="reference internal" href="#create-a-new-tablespace">3.6.3.1. Create a New Tablespace</a></li>
<li><a class="reference internal" href="#add-a-user-to-oracle">3.6.3.2. Add a User to Oracle</a></li>
<li><a class="reference internal" href="#configure-the-web-server">3.6.3.3. Configure the Web Server</a></li>
</ul>
</li>
</ul>
<h4>Previous topic</h4>
<p class="topless"><a href="postgresql.html"
title="previous chapter">3.6.2. PostgreSQL</a></p>
<h4>Next topic</h4>
<p class="topless"><a href="sqlite.html"
title="next chapter">3.6.4. SQLite</a></p>
<div id="searchbox" style="display: none" role="search">
<h3>Quick search</h3>
<form class="search" action="../search.html" method="get">
<div><input type="text" name="q" /></div>
<div><input type="submit" value="Go" /></div>
<input type="hidden" name="check_keywords" value="yes" />
<input type="hidden" name="area" value="default" />
</form>
</div>
<script type="text/javascript">$('#searchbox').show(0);</script>
</div>
</div>
<div class="clearer"></div>
</div>
<div class="related" role="navigation" aria-label="related navigation">
<h3>Navigation</h3>
<ul>
<li class="right" style="margin-right: 10px">
<a href="sqlite.html" title="3.6.4. SQLite"
>next</a></li>
<li class="right" >
<a href="postgresql.html" title="3.6.2. PostgreSQL"
>previous</a> |</li>
<li class="nav-item nav-item-0"><a href="../index.html">Bugzilla 5.0.4 documentation</a> »</li>
<li class="nav-item nav-item-1"><a href="index.html" >3. Installation and Maintenance Guide</a> »</li>
<li class="nav-item nav-item-2"><a href="db_server.html" >3.6. Database Server</a> »</li>
</ul>
</div>
<div class="footer" role="contentinfo">
Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.6.6.
</div>
</body>
</html>
