BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

 

 
 

Remote DBA Little Helper

Oracle Tips by Burleson Consulting

This chapter describes a little homegrown utility called Remote DBA_Helper. I wrote the utility because there was a lack of open source utilities for managing Oracle databases. The two most popular open source utilities available are Henrik Johnson’s, Tora (Tool for Oracle) and Andy Duncan’s and Jared Still’s, Orac_Remote DBA. Both of these tools were originally written for Oracle7, and the updates ceased with the Oracle8i. 

As a Remote DBA who utilizes Linux, I needed a new tool to do my job efficiently.  The only solution was to write one myself. Because Orac_Remote DBA and Tora were written using the most popular scripting language of today, Perl; and both tools are large, well thought programs with many options, menus and sub-menus, they were chosen to pattern my tool after.

I wanted the tool to be easily extended and to consist of many small files produced rather quickly by using copy and paste techniques. Colors and menu groupings were kept consistent with the other tools, to retain the familiar interface and options. Remote DBA_Helper is written using PHP, ADOdb, and two PEAR modules: HTML_Table and HTML_Form.  All of the techniques used to write this tool have been amply demonstrated and the reader should be familiar with the techniques by now.

This tool is not a finished program; it is a work in progress. Features of the program are being added and changed as necessary, and many features are still missing. In particular, I am planning to implement the reverse engineering capabilities of Orac_Remote DBA by using DBMS_METADATA.  Remote DBA_Helper and future updates for this tool will be available on the Rampant Books web site.

As this tool was influenced and motivated by great open source tools written by using a scripting language, it is only fair for Remote DBA_Helper to be an open source tool as well. Thus, you are granted the license to use and redistribute the tool under the conditions specified in the FSF’s GNU General Public License (GPL).  The full text of GPL is available on the GNU main site: http://www.gnu.org/licenses/gpl.txt

Here is an overview of material covered in this chapter:

  • Tour of the Tool.

  • Tour through the Source Code.

  • Installation

  • Missing Features

SEE CODE DEPOT FOR FULL SCRIPTS


The above book excerpt is from  "Easy Oracle PHP: Creating Dynamic Web Pages with Oracle Data". 

You can buy it direct from the publisher for 50%-off and get instant access to the code depot of Oracle tuning scripts:

http://www.rampant-books.com/book_2005_2_php_oracle.htm

 


Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.

 

 

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.



Hit Counter