"Fossies" - the Fresh Open Source Software Archive

Member "oracletool-3.0.2/doc/index.htm" (18 Nov 2014, 39759 Bytes) of package /linux/privat/oracletool-3.0.2.tgz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) HTML source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    2 <html xmlns:o="urn:schemas-microsoft-com:office:office"
    3  xmlns:w="urn:schemas-microsoft-com:office:word"
    4  xmlns="http://www.w3.org/TR/REC-html40">
    5 <head>
    6   <meta http-equiv="Content-Type"
    7  content="text/html; charset=windows-1252">
    8   <meta name="ProgId" content="Word.Document">
    9   <meta name="Generator" content="Microsoft Word 9">
   10   <meta name="Originator" content="Microsoft Word 9">
   11   <link rel="File-List" href="./index_files/filelist.xml">
   12   <title>Oracletool v2</title>
   13 <!--[if gte mso 9]><xml>
   14  <o:DocumentProperties>
   15   <o:Author>Adam vonNieda</o:Author>
   16   <o:Template>Normal</o:Template>
   17   <o:LastAuthor>Adam vonNieda</o:LastAuthor>
   18   <o:Revision>37</o:Revision>
   19   <o:TotalTime>489</o:TotalTime>
   20   <o:Created>2002-02-20T10:28:00Z</o:Created>
   21   <o:LastSaved>2002-03-11T22:58:00Z</o:LastSaved>
   22   <o:Pages>10</o:Pages>
   23   <o:Words>4763</o:Words>
   24   <o:Characters>27153</o:Characters>
   25   <o:Lines>226</o:Lines>
   26   <o:Paragraphs>54</o:Paragraphs>
   27   <o:CharactersWithSpaces>33345</o:CharactersWithSpaces>
   28   <o:Version>9.3821</o:Version>
   29  </o:DocumentProperties>
   30 </xml><![endif]-->
   31   <style>
   32 <!--
   33  /* Style Definitions */
   34 p.MsoNormal, li.MsoNormal, div.MsoNormal
   35     {mso-style-parent:"";
   36     margin:0in;
   37     margin-bottom:.0001pt;
   38     mso-pagination:widow-orphan;
   39     font-size:12.0pt;
   40     font-family:"Times New Roman";
   41     mso-fareast-font-family:"Times New Roman";}
   42 h1
   43     {mso-style-next:Normal;
   44     margin:0in;
   45     margin-bottom:.0001pt;
   46     text-align:center;
   47     mso-pagination:widow-orphan;
   48     page-break-after:avoid;
   49     mso-outline-level:1;
   50     font-size:16.0pt;
   51     mso-bidi-font-size:12.0pt;
   52     font-family:"Times New Roman";
   53     mso-font-kerning:0pt;
   54     font-weight:bold;}
   55 h2
   56     {mso-style-next:Normal;
   57     margin:0in;
   58     margin-bottom:.0001pt;
   59     mso-pagination:widow-orphan;
   60     page-break-after:avoid;
   61     mso-outline-level:2;
   62     font-size:12.0pt;
   63     font-family:"Times New Roman";
   64     font-weight:bold;}
   65 a:link, span.MsoHyperlink
   66     {color:blue;
   67     text-decoration:underline;
   68     text-underline:single;}
   69 a:visited, span.MsoHyperlinkFollowed
   70     {color:purple;
   71     text-decoration:underline;
   72     text-underline:single;}
   73 p
   74     {margin-right:0in;
   75     mso-margin-top-alt:auto;
   76     mso-margin-bottom-alt:auto;
   77     margin-left:0in;
   78     mso-pagination:widow-orphan;
   79     font-size:12.0pt;
   80     font-family:"Times New Roman";
   81     mso-fareast-font-family:"Times New Roman";}
   82 pre
   83     {margin:0in;
   84     margin-bottom:.0001pt;
   85     mso-pagination:widow-orphan;
   86     tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
   87     font-size:10.0pt;
   88     font-family:"Courier New";
   89     mso-fareast-font-family:"Courier New";}
   90 @page Section1
   91     {size:8.5in 11.0in;
   92     margin:1.0in 1.25in 1.0in 1.25in;
   93     mso-header-margin:.5in;
   94     mso-footer-margin:.5in;
   95     mso-paper-source:0;}
   96 div.Section1
   97     {page:Section1;}
   98  /* List Definitions */
   99 @list l0
  100     {mso-list-id:1158761759;
  101     mso-list-type:hybrid;
  102     mso-list-template-ids:1634610692 1357254844 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
  103 @list l0:level1
  104     {mso-level-text:"%1\)";
  105     mso-level-tab-stop:45.0pt;
  106     mso-level-number-position:left;
  107     margin-left:45.0pt;
  108     text-indent:-.25in;}
  109 ol
  110     {margin-bottom:0in;}
  111 ul
  112     {margin-bottom:0in;}
  113 -->
  114   </style>
  115 </head>
  116 <body style="" link="blue" lang="EN-US" vlink="purple">
  117 <div class="Section1">
  118 <p class="MsoNormal"><o:p></o:p></p>
  119 <h1>Oracletool documentation</h1>
  120 <p class="MsoNormal"><o:p></o:p></p>
  121 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Note that the
  122 most
  123 recent version of this document can be found <a
  124  href="http://www.oracletool.com/docs/index.htm">here</a>.</p>
  125 <p class="MsoNormal"><o:p></o:p></p>
  126 <h2><a href="#_Introduction_to_Oracletool:">Introduction</a></h2>
  127 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  128  href="#_The_standard_disclaimer,">The standard disclaimer</a></p>
  129 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  130  href="#_Copyright">Copyright</a></p>
  131 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  132  href="#_Overview">Overview</a></p>
  133 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  134  href="#_FAQ:_Frequently_Asked">Frequently Asked Questions</a></p>
  135 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><a
  136  href="#_Q:_What_versions">What versions of Oracle will Oracletool work
  137 with?</a></p>
  138 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><a
  139  href="#_Q:_Does_Oracletool">Does Oracletool work with Windows NT as
  140 the web
  141 server?</a></p>
  142 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><a
  143  href="#_Q:_Does_the">Does the web server need to be running on the
  144 machine that
  145 Oracletool is installed on?</a></p>
  146 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><a
  147  href="#_Q:_Can_Oracletool">Can Oracletool connect to databases on
  148 other
  149 machines?</a></p>
  150 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><a
  151  href="#_Q:_Can%27t_you">Can't you make Oracletool look nicer? Why
  152 aren't there
  153 any graphics?</a></p>
  154 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><a
  155  href="#_Q:_I%92m_getting">I&rsquo;m getting the following error (or a
  156 similar error)..
  157 Can't load
  158 '/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/Oracle/Oracle.so'</a></p>
  159 <p class="MsoNormal"><o:p></o:p></p>
  160 <h2><a href="#_Oracletool_installation:">Installation</a></h2>
  161 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  162  href="#_Requirements">Requirements</a></p>
  163 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  164  href="#_Privileges_for_the">Required privileges for a connecting user</a></p>
  165 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  166  href="#_Installation:_The_short">The short version, if you already
  167 have the DBI
  168 and DBD::Oracle Perl modules installed</a></p>
  169 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  170  href="#_Installation:_The_long">The long version, if the above does
  171 not
  172 pertain..</a></p>
  173 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  174  href="#_The_oracletool.ini_file.">Setting parameters in the
  175 oracletool.ini file</a></p>
  176 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  177  href="#_Executing_Oracletool_for">Executing Oracletool for the first
  178 time.</a></p>
  179 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  180  href="#_Troubleshooting_Oracletool_installation">Troubleshooting
  181 Oracletool
  182 installation problems</a></p>
  183 <p class="MsoNormal"><o:p></o:p></p>
  184 <h2><a href="#_Oracletool_and_security">Security</a></h2>
  185 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  186  href="#_Q:_What_are">What are cookies?</a></p>
  187 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  188  href="#_Q:_Where_do">Where do they come from?</a></p>
  189 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  190  href="#_Q:_Are_cookies">Are cookies secure?</a></p>
  191 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  192  href="#_Oracletool_cookie_encryption">Oracletool cookie encryption</a></p>
  193 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><a
  194  href="#_Level_0:">Level 0</a></p>
  195 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><a
  196  href="#_Level_1:">Level 1</a></p>
  197 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><a
  198  href="#_Level_2:">Level 2</a></p>
  199 <p class="MsoNormal"><o:p></o:p></p>
  200 <h2><a name="_Introduction_to_Oracletool:"></a>Introduction to
  201 Oracletool:<span style="font-weight: normal;"><o:p></o:p></span></h2>
  202 <p class="MsoNormal"><o:p></o:p></p>
  203 <h2><a name="_The_standard_disclaimer,"></a><span style="">&nbsp;&nbsp;
  204 </span>The standard disclaimer...</h2>
  205 <p class="MsoNormal"><o:p></o:p></p>
  206 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Oracletool is
  207 provided as is, without warranty of any kind. The author takes no
  208 responsibility for events which may be caused by the use or misuse of
  209 this
  210 software.</p>
  211 <p class="MsoNormal"><o:p></o:p></p>
  212 <h2><a name="_Copyright"></a><span style="">&nbsp;&nbsp;
  213 </span>Copyright</h2>
  214 <p class="MsoNormal"><o:p></o:p></p>
  215 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Copyright (c)
  216 1998
  217 &ndash; 2014 Adam vonNieda, Kansas USA</p>
  218 <p class="MsoNormal"><o:p></o:p></p>
  219 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>You may
  220 distribute
  221 under the terms of either the GNU General Public License or the
  222 Artistic
  223 License, as specified in the Perl README file, with the exception that
  224 it
  225 cannot be placed on a CD-ROM or similar media for commercial
  226 distribution
  227 without the prior approval of the author.</p>
  228 <p class="MsoNormal"><o:p></o:p></p>
  229 <h2><a name="_Overview"></a><span style="">&nbsp;&nbsp; </span>Overview</h2>
  230 <p class="MsoNormal"><o:p></o:p></p>
  231 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Oracletool can
  232 be
  233 a challenge to install the first time, especially if you are not
  234 familiar with
  235 how web based apps, particularly CGI, work. So why bother? Well, once
  236 installed, Oracletool can be a very handy addition to your toolbox.
  237 Most tools
  238 limit you to your personal workstation, meaning that&rsquo;s where they
  239 are
  240 installed. If you have to leave your desk to work a problem, your tools
  241 stay
  242 there. Because Oracletool is server based, it doesn&rsquo;t matter
  243 where you are; If
  244 you have a web browser, you can connect to Oracletool and use it to
  245 help you
  246 debug problems. Also, while Oracletool may be challenging to some on
  247 the first
  248 installation, that&rsquo;s the only one you have to do. Oracletool is
  249 installed once,
  250 in one place, and everyone who can access your web server (and has the
  251 proper
  252 Oracle accounts) can use it from that point. In addition, any scripts
  253 or
  254 information you store in &ldquo;MyOracletool&rdquo; are accessible from
  255 anywhere. The fact
  256 that Oracletool is not client based is one of its greatest strengths,
  257 and
  258 that&rsquo;s why it&rsquo;s written this way.</p>
  259 <p class="MsoNormal"><o:p></o:p></p>
  260 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Oracletool is
  261 written more from a DBA standpoint than developer. In the past, the
  262 tool
  263 checked for the explicit "SELECT ANY TABLE" privilege upon a user
  264 logging in. This is no longer true. But, because Oracletool depends on
  265 so many
  266 'DBA%', 'V$%' views, and system level tables, a user needs some degree
  267 of
  268 authority, albeit select only, on these data dictionary objects. In
  269 order to
  270 make the tool available to both DBA and developer, you may want to run
  271 the included
  272 'create_role.sql' script, which will prompt you for a role name, which
  273 will be
  274 created, and may be granted to users who are allowed to access data
  275 dictionary
  276 views, but not rows from all tables in the database (SELECT ANY TABLE).
  277 The
  278 exception is that it will not grant privileges to any '%LINK%' views or
  279 tables,
  280 thus preventing said user from obtaining passwords for existing
  281 database links.
  282 Having said this, Oracletool is targeted more to the Oracle DBA than
  283 the
  284 developer, and always will be. </p>
  285 <p class="MsoNormal"><span style="">&nbsp;</span></p>
  286 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span
  287  style="">&nbsp;</span>There are better tools than Oracletool for
  288 developers. As a DBA, however, after learning about all of the sections
  289 within
  290 Oracletool, you will be pleasantly surprised at just how handy it can
  291 be. </p>
  292 <p class="MsoNormal"><o:p></o:p></p>
  293 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  294 </span>Oracletool has
  295 functionality that may not be readily apparent until you use it on a
  296 variety of
  297 databases. If a particular function is not configured on your database,
  298 you
  299 will not see menu items for it. Here are some examples..</p>
  300 <p class="MsoNormal"><o:p></o:p></p>
  301 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  302 </span><span style="font-family: Symbol;"><span style="">&middot;</span></span>
  303 If
  304 your database is not RAC, that section will not appear.</p>
  305 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  306 </span><span style="font-family: Symbol;"><span style="">&middot;</span></span>
  307 If
  308 you are not using replication, it will not appear.</p>
  309 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  310 </span><span style="font-family: Symbol;"><span style="">&middot;</span></span>
  311 If
  312 your database is not backed up via RMAN, that will not appear.</p>
  313 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  314 </span><span style="font-family: Symbol;"><span style="">&middot;</span></span>
  315 You
  316 will only see RMAN catalog repository information if you are connected
  317 to a
  318 database where a catalog exists.</p>
  319 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp; </span><span
  320  style="">&nbsp;&nbsp;</span><span style="font-family: Symbol;"><span
  321  style="">&middot;</span></span> You will not see Oracle statspack
  322 information unless
  323 it&rsquo;s being used.</p>
  324 <p class="MsoNormal"><o:p></o:p></p>
  325 <h2><a name="_FAQ:_Frequently_Asked"></a><span style="">&nbsp;&nbsp;
  326 </span>FAQ: Frequently Asked Questions..<span
  327  style="font-weight: normal;"><o:p></o:p></span></h2>
  328 <p class="MsoNormal"><o:p></o:p></p>
  329 <h2><a name="_Q:_What_versions"></a>Q: What versions of Oracle will
  330 Oracletool
  331 work with?</h2>
  332 <p class="MsoNormal"><b>A</b>: All versions 7.3 and above. As of 2.3,
  333 only 10g and above are "supported".</p>
  334 <p class="MsoNormal"><o:p></o:p></p>
  335 <h2><a name="_Q:_Does_Oracletool"></a><span style="font-weight: normal;">Q</span>:
  336 Does Oracletool work with Windows NT as the web server?</h2>
  337 <p class="MsoNormal">A: Yes. In fact, using Activestate Perl (<a
  338  href="http://www.activestate.com/">http://www.activestate.com</a>) and
  339 the Perl
  340 Package Manager, DBI and DBD::Oracle are very easy to install on
  341 Windows
  342 platforms.</p>
  343 <p class="MsoNormal"><o:p></o:p></p>
  344 <h2><a name="_Q:_Does_the"></a><span style="font-weight: normal;">Q</span>:
  345 Does
  346 the web server need to be running on the machine that Oracletool is
  347 installed
  348 on?</h2>
  349 <p class="MsoNormal"><b>A</b>: Yes. Oracletool, Perl (with required
  350 modules), and
  351 web server must all be on the same machine.</p>
  352 <p class="MsoNormal"><o:p></o:p></p>
  353 <h2><a name="_Q:_Can_Oracletool"></a><span style="font-weight: normal;">Q</span>:
  354 Can Oracletool connect to databases on other machines?</h2>
  355 <p class="MsoNormal"><b>A</b>: Yes, Oracletool only needs to be
  356 installed in one
  357 place, and all of your users can use it to connect to all of your
  358 Oracle
  359 databases.</p>
  360 <p class="MsoNormal"><o:p></o:p></p>
  361 <h2><a name="_Q:_Can't_you"></a><span style="font-weight: normal;">Q</span>:
  362 Can't you make Oracletool look nicer? Why aren't there any graphics?</h2>
  363 <p class="MsoNormal"><b>A</b>: Oracletool is designed to get the job
  364 done in the
  365 easiest way possible. I&rsquo;ve not found a good reason to bloat it
  366 with graphics.
  367 You can set the background image for your theme in the <a
  368  href="#_The_oracletool.ini_file.">oracletool.ini</a> file, however.
  369 There are
  370 several "themes" to choose from to make the tool more to your
  371 preferences as far as colors etc.</p>
  372 <p class="MsoNormal"><o:p></o:p></p>
  373 <h2><a name="_Q:_I&rsquo;m_getting"></a><span style="font-weight: normal;">Q</span>:
  374 I&rsquo;m getting the following error (or a similar error).. Can't load
  375 '/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/Oracle/Oracle.so'
  376 for
  377 module DBD::Oracle: libclntsh.so.9.0: cannot open shared object file:
  378 No such
  379 file or directory at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm</h2>
  380 <p class="MsoNormal"><b><span style="color: black;">A</span></b><span
  381  style="color: black;">: This is generally a permissions problem. Most
  382 likely your
  383 web server cannot access the libraries it needs to in order to load the
  384 DBD::Oracle module. There is a more detailed explanation <a
  385  href="#_What_if_it">here</a>.<o:p></o:p></span></p>
  386 <p class="MsoNormal"><span style="color: black;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  387 </span></span></p>
  388 <p style="margin: 0in 0in 0.0001pt;"><o:p></o:p></p>
  389 <h2><a name="_Oracletool_installation:"></a>Oracletool installation:</h2>
  390 <p class="MsoNormal"><o:p></o:p></p>
  391 <h2><a name="_Requirements"></a><span style="">&nbsp;&nbsp;
  392 </span>Requirements</h2>
  393 <p class="MsoNormal"><o:p></o:p></p>
  394 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  395  href="http://www.perl.com/CPAN/src/stable.tar.gz">Perl v5.004 or
  396 greater.</a> </p>
  397 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  398  href="http://www.cpan.org/modules/by-authors/Tim_Bunce/">DBI v1.12 or
  399 greater.</a></p>
  400 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  401  href="http://www.cpan.org/modules/by-authors/Tim_Bunce/">DBD::Oracle
  402 v1.02 or
  403 greater.</a></p>
  404 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span
  405  style="">Please go to <a
  406  href="http://www.symbolstone.org/technology/perl/DBI/">symbolstone.org</a>
  407 for
  408 more information about installing / using the DBI and DBD::Oracle
  409 modules.</span></p>
  410 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>A web server
  411 that
  412 allows CGI. I use the <a href="http://www.apache.org/">Apache</a> web
  413 server, and
  414 so do millions of others.</p>
  415 <p class="MsoNormal"><o:p></o:p></p>
  416 <h2><a name="_Privileges_for_the"></a><span style="">&nbsp;&nbsp;
  417 </span>Privileges for the connecting user</h2>
  418 <p class="MsoNormal"><o:p></o:p></p>
  419 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>The user that
  420 you
  421 choose to connect to each of the databases you use Oralcetool with
  422 needs to
  423 have authority to see the underlying data dictionary views, and of
  424 course
  425 permission to connect to the database. Granting &ldquo;CREATE
  426 SESSION&rdquo; to these users
  427 will fill the connecting requirement, and granting the following
  428 privileges
  429 will allow the user to select the data dictionary views.</p>
  430 <p class="MsoNormal"><o:p></o:p></p>
  431 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Oracle7,
  432 Oracle8,
  433 Oracle8i:<span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  434 </span>SELECT ANY TABLE</p>
  435 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Oracle9i<span
  436  style=""> and &gt;
  437 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  438 </span>SELECT
  439 ANY TABLE, SELECT ANY DICTIONARY</p>
  440 <p class="MsoNormal"><o:p></o:p></p>
  441 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Granting the
  442 privileges above will give you the capability to see all of the
  443 information
  444 that Oracletool selects from the database. It does not give you
  445 permission to use
  446 the DBA functions of Oracletool. You may or may not want to grant the
  447 DBA role
  448 to your connecting user. </p>
  449 <p class="MsoNormal"><span style=""><span style="">&nbsp;&nbsp; </span><o:p></o:p></span></p>
  450 <h2><a name="_Installation:_The_short"></a><span style="">&nbsp;&nbsp;
  451 </span>Installation: The short version.</h2>
  452 <p class="MsoNormal"><b><span style=""><o:p></o:p></span></b></p>
  453 <p style="margin: 0in 0in 0.0001pt;"><span style="">&nbsp;&nbsp;
  454 </span>Instructions for those who already have DBI and DBD::Oracle</p>
  455 <p class="MsoNormal">compiled into their perl. </p>
  456 <p class="MsoNormal"><o:p></o:p></p>
  457 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>1) Copy
  458 oracletool.pl
  459 to your CGI directory.</p>
  460 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>2) Copy
  461 oracletool.sam to oracletool.ini, in the same</p>
  462 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>directory
  463 as
  464 Oracletool.</p>
  465 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>3) Set a few
  466 parameters at the top of the ini file.</p>
  467 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>4) Set the
  468 path to
  469 perl correctly at the top of oracletool.pl</p>
  470 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>5) Execute it
  471 like
  472 so... </p>
  473 <p class="MsoNormal"><o:p></o:p></p>
  474 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  475 </span>http://yourhost/yourcgidir/oracletool.pl</p>
  476 <p class="MsoNormal"><o:p></o:p></p>
  477 <h2><a name="_Installation:_The_long"></a><span style="">&nbsp;&nbsp;
  478 </span>Installation: The long version.</h2>
  479 <p class="MsoNormal"><o:p></o:p></p>
  480 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Installation
  481 of
  482 Oracletool is pretty straightforward, especially if you have<span
  483  style="">&nbsp; </span>installed stuff on your web server before.
  484 The main thing is that you need to have the DBI and DBD::Oracle modules
  485 compiled into your Perl BEFORE you attempt to install Oracletool. These
  486 instructions will assume that you have already done so. If you have not
  487 done
  488 that yet, download the required Perl modules and follow the
  489 instructions to
  490 install them. I have compiled the DBI and DBD::Oracle modules many
  491 times and
  492 have had very few problems. If you do encounter problems with DBI or
  493 the
  494 DBD::Oracle module, there are mailing lists devoted to the subject,
  495 please use them.&nbsp; </p>
  496 <p class="MsoNormal"><o:p></o:p></p>
  497 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>OK, let's get
  498 to
  499 it! At this point, you should have a recent version of Perl with the
  500 DBI and
  501 DBD::Oracle modules compiled in and tested. You also have a functional
  502 web
  503 server in place, right? If not, back up and come back here when you've
  504 got
  505 those things in place. Download Oracletool if you have not already. </p>
  506 <p class="MsoNormal"><a name="_CGI_permissions"></a><o:p></o:p></p>
  507 <p class="MsoNormal"><b>Make sure you change this to the path to your
  508 perl binary
  509 with<o:p></o:p></b></p>
  510 <p class="MsoNormal"><b>DBI and DBD::Oracle compiled in!<span style="">&nbsp;
  511 </span>AND make sure you do a chmod<o:p></o:p></b></p>
  512 <p class="MsoNormal"><b>755 oracletool.pl !!</b><span style="">&nbsp;
  513 </span></p>
  514 <p class="MsoNormal"><o:p></o:p></p>
  515 <p class="MsoNormal"><b>#!/usr/bin/perl <o:p></o:p></b></p>
  516 <p class="MsoNormal"><o:p></o:p></p>
  517 <p class="MsoNormal">OK, on to the less obvious stuff </p>
  518 <p class="MsoNormal"><o:p></o:p></p>
  519 <h2><a name="_The_oracletool.ini_file."></a><span style="">&nbsp;&nbsp;
  520 </span>The oracletool.ini file. </h2>
  521 <p class="MsoNormal"><o:p></o:p></p>
  522 <p class="MsoNormal">Copy oracletool.sam to oracletool.ini, and put it
  523 in the
  524 same directory as oracletool.pl. </p>
  525 <p class="MsoNormal"><o:p></o:p></p>
  526 <p style="margin: 0in 0in 0.0001pt;">There are several variables in
  527 oracletool.ini that may need to be set. These are at the very top of
  528 the script
  529 and there is an explanation of each variable above it.</p>
  530 <p class="MsoNormal"><o:p></o:p></p>
  531 <p class="MsoNormal">You will see a section at the top of the
  532 oracletool.ini that
  533 looks like this... </p>
  534 <p class="MsoNormal"><o:p></o:p></p>
  535 <p class="MsoNormal">#=============================================================================
  536 </p>
  537 <p class="MsoNormal"># Begin user editable section. You may need to
  538 change some
  539 things in this</p>
  540 <p class="MsoNormal"># section </p>
  541 <p class="MsoNormal">#=============================================================================
  542 </p>
  543 <p class="MsoNormal"><o:p></o:p></p>
  544 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>The
  545 first
  546 variable you may want to set is for your $ORACLE_HOME. </p>
  547 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Set
  548 this in the
  549 line that looks like this.</p>
  550 <p class="MsoNormal"><span style="">&nbsp;</span></p>
  551 <p class="MsoNormal"><span style="">&nbsp;</span>ORACLE_HOME =
  552 /apps/oracle/product/10.2</p>
  553 <p class="MsoNormal"><o:p></o:p></p>
  554 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp; </span><span
  555  style="">&nbsp;&nbsp;</span>Next, set your $TNS_ADMIN variable, if you
  556 use one that is not default. </p>
  557 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>The
  558 default is
  559 $ORACLE_HOME/network/admin.</p>
  560 <p class="MsoNormal"><span style="">&nbsp;</span></p>
  561 <p class="MsoNormal"><span style="">&nbsp;</span>TNS_ADMIN =
  562 /home/oracle/admin/sqlnet</p>
  563 <p class="MsoNormal"><o:p></o:p></p>
  564 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  565 </span>The rest of
  566 the variables in this section are self explanatory, and you </p>
  567 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  568 </span>can mess with
  569 them if you choose to. The default colors work OK for</p>
  570 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  571 </span>me. </p>
  572 <p class="MsoNormal"><o:p></o:p></p>
  573 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  574 </span>When you see
  575 the following... </p>
  576 <p class="MsoNormal">#========================================================================
  577 </p>
  578 <p class="MsoNormal"># End user editable section. Do not edit below
  579 this point. </p>
  580 <p class="MsoNormal">#========================================================================
  581 </p>
  582 <p class="MsoNormal"><o:p></o:p></p>
  583 <p class="MsoNormal">Then you're almost ready to go!.<span style="">&nbsp;&nbsp;
  584 </span></p>
  585 <p class="MsoNormal"><o:p></o:p></p>
  586 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Copy
  587 oracletool.pl
  588 to a directory that is defined to the web server as a<span style="">&nbsp;&nbsp;&nbsp;
  589 </span></p>
  590 <p class="MsoNormal">cgi directory. For instance, under Redhat Linux,
  591 the default
  592 CGI directory</p>
  593 <p class="MsoNormal">is /home/httpd/cgi-bin.</p>
  594 <p class="MsoNormal"><o:p></o:p></p>
  595 <h2><a name="_Executing_Oracletool_for"></a><span style="">&nbsp;&nbsp;
  596 </span>Executing Oracletool for the first time.</h2>
  597 <p class="MsoNormal"><span style="">&nbsp;</span></p>
  598 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Make sure that
  599 oracletool.pl is executable by the web server, meaning that, </p>
  600 <p class="MsoNormal">the web server may not run as the same user id
  601 that
  602 installed oracletool.pl.</p>
  603 <p class="MsoNormal">Doing a chmod 755 oracletool.pl is safe. There is
  604 no info
  605 stored in the script</p>
  606 <p class="MsoNormal">that people shouldn't see for any reason. When you
  607 are
  608 finished with all of the </p>
  609 <p class="MsoNormal">above, you should be able to execute oracletool.pl
  610 by
  611 putting something like the</p>
  612 <p class="MsoNormal">following into your browser address window. Let's
  613 assume
  614 that your web server </p>
  615 <p class="MsoNormal">is named 'webserver' and that you copied
  616 oracletool.pl into
  617 the default CGI </p>
  618 <p class="MsoNormal">directory on your web server.</p>
  619 <p class="MsoNormal"><o:p></o:p></p>
  620 <p class="MsoNormal">http://webserver/cgi-bin/oracletool.pl </p>
  621 <p class="MsoNormal"><o:p></o:p></p>
  622 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>And you should
  623 get
  624 back a window with entries from your tnsnames.ora file in a drop down
  625 list. </p>
  626 <p class="MsoNormal"><o:p></o:p></p>
  627 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>If you have
  628 problems, I can be reached at <a href="mailto:adam@oracletool.com">adam@oracletool.com</a>,
  629 but please read the following first..</p>
  630 <p class="MsoNormal"><o:p></o:p></p>
  631 <h2><a name="_What_if_it"></a><a
  632  name="_Troubleshooting_Oracletool_installation"></a><span style="">&nbsp;&nbsp;
  633 </span>Troubleshooting Oracletool installation
  634 problems.</h2>
  635 <p class="MsoNormal"><o:p></o:p></p>
  636 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>It&rsquo;s
  637 important to
  638 understand the way Oracletool will be executed by the web server. The
  639 web
  640 server is executing at the OS level as a user that is probably not the
  641 same
  642 user that installed Oracletool. For instance, if you log into a UNIX
  643 server as
  644 &ldquo;adam&rdquo;, and put the oracletool.pl and oracletool.ini files
  645 into your web
  646 servers CGI directory, say. &ldquo;/var/www/cgi-bin&rdquo;, those files
  647 may be owned by
  648 you. That&rsquo;s fine, but they will be executed by the user that the
  649 web server
  650 runs as. This user is often named &ldquo;nobody&rdquo;, or
  651 &ldquo;apache&rdquo;, or something else, but
  652 it is likely NOT running as &ldquo;adam&rdquo;. So, you need to make
  653 sure that &ldquo;apache&rdquo;,
  654 for instance, has permission not only to read oracletool.ini, and
  655 execute
  656 oracletool.pl, but also to access the required Oracle libraries that
  657 are installed
  658 on the server which make DBD::Oracle use possible.</p>
  659 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>If you have
  660 done
  661 all the prerequisites prior to executing Oracletool and are still
  662 having
  663 problems, try running the &ldquo;example.cgi&rdquo; script which came
  664 with the Oracletool
  665 distribution. Edit the variables at the top of the script and run it by
  666 hand.
  667 It should display some raw HTML text, and SYSDATE, which was selected
  668 from your
  669 database. If this script works, then DBI and DBD::Oracle are installed
  670 and
  671 working correctly. Next, try running it as a CGI script from your web
  672 browser.
  673 If it does not work, look at your web server.s error log and try to
  674 determine
  675 the problem. You might also want to try logging in to the server as the
  676 same
  677 user that the web server runs as, and try executing the script </p>
  678 <p class="MsoNormal"><o:p></o:p></p>
  679 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>If you are
  680 getting
  681 an error that looks similar to the following..</p>
  682 <p class="MsoNormal"><o:p></o:p></p>
  683 <p class="MsoNormal"><span style="color: black;">Can't load
  684 '/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/Oracle/Oracle.so'
  685 for
  686 module DBD::Oracle: libclntsh.so.9.0: cannot open shared object file:
  687 No such
  688 file or directory at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm<o:p></o:p></span></p>
  689 <p class="MsoNormal"><span style="color: black;"><o:p></o:p></span></p>
  690 <p class="MsoNormal"><span style="color: black;"><span style="">&nbsp;&nbsp;
  691 </span>This is generally a permissions problem. Most likely your web
  692 server
  693 cannot access the libraries it needs to in order to load the
  694 DBD::Oracle
  695 module. Sometimes, on Linux, the full path to $ORACLE_HOME/lib (not the
  696 variable),
  697 needs to be added to the /etc/ld.so.conf file and then
  698 &ldquo;ldconfig&rdquo; run as root.<o:p></o:p></span></p>
  699 <p class="MsoNormal"><span style="color: black;"><o:p></o:p></span></p>
  700 <p class="MsoNormal"><span style="color: black;"><span style="">&nbsp;&nbsp;
  701 </span>If you&rsquo;ve tried everything above, and are still having
  702 problems, gather
  703 up as much error information as you can and send it to me at <a
  704  href="mailto:adam@oracletool.com">adam@oracletool.com</a>.<o:p></o:p></span></p>
  705 <p class="MsoNormal"><span style="color: black;"><o:p></o:p></span></p>
  706 <h2><a name="_Oracletool_and_security"></a>Oracletool and security</h2>
  707 <p class="MsoNormal"><o:p></o:p></p>
  708 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Web based
  709 applications are hard to secure. I&rsquo;ve made the best effort I can
  710 to make
  711 Oracletool secure by adding the option to encrypt the cookies that are
  712 stored
  713 on your PC, and transferred back and forth from Oracletool.</p>
  714 <p class="MsoNormal"><o:p></o:p></p>
  715 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>I decided to
  716 provide some information about cookies because many people do not want
  717 to use a
  718 cookie based application, like Oracletool. Let me know if I have left
  719 anything
  720 out.</p>
  721 <p class="MsoNormal"><o:p></o:p></p>
  722 <h2><a name="_Q:_What_are"></a><span style="">&nbsp;&nbsp; </span>Q:
  723 What are cookies?</h2>
  724 <p class="MsoNormal"><b><span style="">&nbsp;&nbsp; </span>A</b>:
  725 Cookies
  726 are files that are stored on your PC. Your PC being the machine that
  727 you are
  728 running your browser on. When you start your browser it reads these
  729 files and
  730 puts the information in memory.</p>
  731 <p class="MsoNormal"><o:p></o:p></p>
  732 <h2><a name="_Q:_Where_do"></a><span style="">&nbsp;&nbsp; </span>Q:
  733 Where do they come from? </h2>
  734 <p class="MsoNormal"><b><span style="">&nbsp;&nbsp; </span>A</b>: They
  735 come from web servers, or sites. When you access a site, it will often
  736 write a
  737 cookie to your browser, which writes the file to your PC when you close
  738 the
  739 browser. By writing a cookie, the site can access it later, and that's
  740 how
  741 sites seem to know who you are when you return. It goes like this...</p>
  742 <p class="MsoNormal"><o:p></o:p></p>
  743 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>You access
  744 yahoo.com</p>
  745 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Yahoo.com
  746 askes
  747 you for your name.</p>
  748 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>You type it in.</p>
  749 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Yahoo.com
  750 sends a
  751 cookie to your browser with that information.</p>
  752 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Your browser
  753 saves
  754 it. </p>
  755 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>One week
  756 later,
  757 you access Yahoo.com again.</p>
  758 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Yahoo.com
  759 reads the
  760 cookie, and knows who you are. It says &ldquo;Welcome back Mr.
  761 Smuckatelly</p>
  762 <p class="MsoNormal"></p>
  763 <h2><a name="_Q:_Are_cookies"></a><span style="">&nbsp;&nbsp; </span>Q:
  764 Are cookies secure?</h2>
  765 <p class="MsoNormal"><b><span style="">&nbsp;&nbsp; </span>A</b>: It
  766 depends on how they are used, and your views on security. Cookies can
  767 only be
  768 as secure as your PC. If someone walks up to your PC, starts your
  769 browser, and
  770 accesses Yahoo.com, the steps above occur and that person in
  771 essentially you
  772 now. Cookies are stored in text files, so they can be read by any text
  773 editor
  774 on your PC if you know where to look for them. In versions prior to
  775 1.05,
  776 Oracletool stored usernames and passwords in plain text which was very
  777 unsecure. These cookies can now be encrypted by adding a few Perl
  778 modules to
  779 your system. I feel that this is a very secure method of storing this
  780 information provided there is no security loopholes in your browser.
  781 Internet
  782 Explorer (4,5) has one such loophole. </p>
  783 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>The
  784 description of
  785 the problem is at (As of May 26, 2000)</p>
  786 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span><a
  787  href="http://peacefire.org/security/iecookies">http://peacefire.org/security/iecookies</a></p>
  788 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>and the fix is
  789 at <a
  790  href="http://www.microsoft.com/technet/security/bulletin/ms00-033.asp">http://www.microsoft.com/technet/security/bulletin/ms00-033.asp</a></p>
  791 <p class="MsoNormal"><o:p></o:p></p>
  792 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Keep in mind
  793 that
  794 not only do they have to have your information, they need to have
  795 access to
  796 your network. This means that most databases are already protected from
  797 everyone but your co-workers.</p>
  798 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span></p>
  799 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>If someone was
  800 to
  801 break into your computer and read your cookie file, a typical entry
  802 will look
  803 like this if you are using the Oracletool encryption...</p>
  804 <p class="MsoNormal"><o:p></o:p></p>
  805 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>toolbox.sessionid52616e646f6d4956d503c1af9bca21e8338a2a8786cc25f74fc098e88047fc3c</p>
  806 <p class="MsoNormal"><o:p></o:p></p>
  807 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>And will look
  808 like
  809 this if you are not...</p>
  810 <p class="MsoNormal"><o:p></o:p></p>
  811 <p class="MsoNormal"><span style="">&nbsp;&nbsp;
  812 </span>toolbox.sessionidsystem~manager</p>
  813 <p class="MsoNormal"><o:p></o:p></p>
  814 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>That's a big
  815 difference! I will always suggest using the encryption if possible. The
  816 only
  817 way that someone can decode the top string is if they know what type of
  818 encryption is being used, and if they know the encryption key, which is
  819 a
  820 parameter in the oracletool.ini that is set by the administrator.</p>
  821 <p class="MsoNormal"><o:p></o:p></p>
  822 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Some people
  823 are
  824 extremely security concious, and will never trust a cookie based
  825 application.
  826 That's just the way it is. The fact is, your cookies are but one of
  827 many things
  828 that a malicous person will have access to if he or she breaks into
  829 your
  830 computer. I hope this has helped to explain how Oracletool protects
  831 your
  832 passwords.</p>
  833 <p class="MsoNormal"><o:p></o:p></p>
  834 <h2><a name="_Oracletool_cookie_encryption"></a><span style="">&nbsp;&nbsp;
  835 </span>Oracletool cookie encryption</h2>
  836 <p class="MsoNormal"><o:p></o:p></p>
  837 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Thanks
  838 to
  839 Richard Chen for code contributions pertaining to encryption</p>
  840 <p class="MsoNormal">========================================================</p>
  841 <p class="MsoNormal"><o:p></o:p></p>
  842 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>Usernames and
  843 passwords
  844 for the database instances you access can now be encrypted before they
  845 are sent
  846 to your PC as a cookie. These were being written in plain text prior to
  847 v1.2.0.
  848 There are 3 different levels of security available in Oracletool now.
  849 These
  850 levels will be enabled automatically depending on which Perl modules
  851 you have
  852 installed. To find out what level you are at, click on the "About"
  853 menu item after installing Oracletool. Here are the differences between
  854 the
  855 different levels, and the dependencies for each...</p>
  856 <p class="MsoNormal"><o:p></o:p></p>
  857 <h2><a name="_Level_0:"></a><span style="">&nbsp;&nbsp; </span>Level 0:</h2>
  858 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>This
  859 is the
  860 level that Oracletool is at prior to v1.2.0.<span style="">&nbsp;
  861 </span>If you are at level 0 then there is no encryption of any kind
  862 taking
  863 place. If you do not have any of the modules discussed below installed,
  864 this
  865 will be your level. The cookie which stores the username and password
  866 for the
  867 databases you access will be stored in plain text on your PC.</p>
  868 <p class="MsoNormal"><o:p></o:p></p>
  869 <h2><a name="_Level_1:"></a><span style="">&nbsp;&nbsp; </span>Level 1:</h2>
  870 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>This
  871 level uses
  872 the MIME::Base64 method of encoding. With this level, the username,
  873 password,
  874 and encryption string are encoded into a single string. The encryption
  875 string
  876 is set in the oracletool.ini, and is MD5 encoded before being added to
  877 the
  878 string. This level requires the following Perl modules... These modules
  879 are
  880 available at CPAN (<a href="http://www.cpan.org/">http://www.cpan.org</a>)
  881 and
  882 Activestate (<a href="http://www.activestate.com/">http://www.activestate.com</a>)</p>
  883 <p class="MsoNormal"><o:p></o:p></p>
  884 <p class="MsoNormal">1) Digest-MD5</p>
  885 <p class="MsoNormal">2) Mime-Base64</p>
  886 <p class="MsoNormal"><o:p></o:p></p>
  887 <h2><a name="_Level_2:"></a><span style="">&nbsp;&nbsp; </span>Level 2:</h2>
  888 <p class="MsoNormal"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>This
  889 level uses
  890 the cipher block chaining mode with the IDEA or Blowfish block cipher,
  891 and is
  892 extremely secure. It encodes the username and password into a single
  893 encrypted
  894 string based on a keyword stored in the oracletool.ini. This level
  895 requires the
  896 following Perl modules... These modules are available at CPAN
  897 (http://www.cpan.org), but not all are on the Activestate site when I
  898 checked
  899 prior to this release. This is the only reason that Level 1 encryption
  900 exists
  901 at all. Oracletool defaults to the IDEA method. If you would like to
  902 use
  903 Blowfish, set the ENCRYPTION_METHOD parameter accordingly in the
  904 oracletool.ini.</p>
  905 <p class="MsoNormal"><o:p></o:p></p>
  906 <p class="MsoNormal">1) Digest-MD5</p>
  907 <p class="MsoNormal">2) Crypt-IDEA or Crypt-Blowfish</p>
  908 <p class="MsoNormal">3) Crypt-CBC</p>
  909 <p class="MsoNormal"><o:p></o:p></p>
  910 <p class="MsoNormal"><span style="">&nbsp;&nbsp; </span>If you choose
  911 to
  912 use these security features, simply install the required Perl modules.
  913 Oracletool will see the modules and start using them for each
  914 subsequent cookie
  915 that is created. See your browser documentation if you want to remove
  916 the
  917 cookies currently on your hard drive.</p>
  918 <p class="MsoNormal">__END__</p>
  919 <p class="MsoNormal" style=""><o:p></o:p></p>
  920 </div>
  921 </body>
  922 </html>