Just a reminder that I no longer test Oracletool with Oracle versions < 11.1.
All of the legacy HTML tags have been changed to use CSS rather than specifying style data using the old format. The size of the oracletool.pl executable has decreased dramatically, and it looks better. Let me know if there are any pages that are formatted incorrectly, it’s entirely possible that I’ve missed something.
* IMPORTANT!! *
There are changes to the themes variables in the oracletool.sam file that need to be copied into your oracletool.ini file, or you can create a new one from the supplied oracletool.ini. If you don’t do this, your fonts may look very small.
If you have a problem with font rendering, such as your fonts look very small, you may need to remove a browser cookie called “OracletoolProps”. Also, make sure you’ve made the changes to the themes in the oracletol.ini file.
Added a mechanism to search for the oracletool.ini config file on IIS web servers if it’s not in the same directory as Oracletool itself. Thanks to Praveen Hombaiah for the code change.
Added an interface for viewing the alert log, under the DB Admin section (Finally!). This requires the creation of a procedure under the “SYS” schema. Please see the file get_alertlog_lines.sql under /sql for more information. This also checks for “ORA-” messages in the lines displayed, and highlights them in a separate display.
Added a preference setting for the number of lines of the alert log to display.
Changed the displays of generated DDL to use textareas with scroll bars rather than just displaying the code. Much better for cutting and pasting.
Fixed a bug where when you select Session Info / Active and hit the refresh button, it would show all of the sessions. Thanks to Bryce Tutt for pointing it out.