|Index Search Add FAQ Ask Question|
Index > Other 3rd Party Tools > Software Tools > DBAConnect
DBAConnect by DataSparc, Inc.
Topics17 October 2002
Author: Iftikhar Ahmad Lodhi
DBAConnect is a web based Oracle Database management tool that provides
convenient administration of your Oracle database through any web browser.
DBAConnect allows the database administrator to execute any administration
command and to control user sessions. DBAConnect allows the developer to
execute any SQL statement. DBAConnect is designed for fast performance and to
preserve system security.
Once installed and configured, DBAConnect can be used for convenient access to
the Oracle Database from anywhere. The ease of browser-enabled clients allows a
low maintenance method to handle third parties, consultants, or project staffing
fluctuations. DBAConnect provides immediate productivity gains through the
elimination of client license maintenance, improved response time to system
issues, and increased convenience for database administrators.
There are some other remote database administration tools but DBAConnect is a
unique one due to its platform independent architecture, enhanced security
features and its ease of use.
Once installed and configured, DBAConnect can be used for convenient access to the Oracle Database from anywhere. The ease of browser-enabled clients allows a low maintenance method to handle third parties, consultants, or project staffing fluctuations. DBAConnect provides immediate productivity gains through the elimination of client license maintenance, improved response time to system issues, and increased convenience for database administrators.
There are some other remote database administration tools but DBAConnect is a unique one due to its platform independent architecture, enhanced security features and its ease of use.
HistoryDBAConnect 1.0 was released in June 2002, developed by DataSparc, Inc. based in OR, USA. There was "SQL Browser", an earlier product with the same functionality that is modified and renamed to "DBAConnect" with enhanced features.
This review is based on the freeware version of DBAConnect 1.0, with limited technical support.
DataSparc also provides following services:
What is great about this productThe product is ideal to access Oracle database from anywhere using Internet browser. Once installed and configured with your web server and oracle database, you can access as many databases as you want using a single administration console but one at a time.
DBAConnect simplifies the most common database management tasks, such as creating/modifying/deleting schema objects, creating and executing efficient DBA scripts and monitoring process information.
Provides easy security administration for granting, revoking and assigning roles and privileges.
Provides users with an efficient means to view key instance statistics instead of querying V$ views manually. Drilling down to related views really helps in saving a lot of time.
GUI interface with auto-generated scripts allows novice administrators to learn DDL syntax.
Supported Operating Systems and VersionsAs it is developed using Java Technology So it is completely platform independent.
Its flexibility allows you to connect and administer all the oracle database versions ranging from 7.3.x to 9i with TCP/IP protocol and NET8 configuration.
A web server , installed Java Runtime Environment JRE 1.1 or later, is required to run the application again it works with all the web servers including Weblogic, Apache, OAS 8i, OAS 9i, IBM's websphere and Iplanet. You can get a freeware Tomcat web server that is simplest to configure for DBAConnect.
Web browser Internet Explorer 5 or higher, Netscape 6 or higher, is required to run the application.
A Pentium CPU with 64MB of RAM (128 recommended) is sufficient to run the application.
InstallationInstallation was easy and swift. You required to have a web server and Java Runtime Environment JRE1.1 or later, including any Java 2 platform system. I tried it with Tomcat that comes with evaluation version. After installation it opens automatically a readme file in a browser that describes all the installation and configuration process and guide you how to run the application. You also need to have a classes12.zip file in JDBC driver folder that comes with oracle or you can down load it. Now you are ready to run the application. Just start web server and launch the DBAConnect. It opens in your default browser. Enter your Oracle database access parameters that are service name, port and host computer address. If you get a message, requesting to copy classes12.zip file to \DataSparc\lib folder and change its name to classes12.jar, just do it and you are connected.
Remember DBAConnect does not allow the use of TNS names, rather use Oracle SID.
What it doesDBAConnect allows you to access an Oracle database and perform any administrative task over the Internet using web browser. Here are some of the features of DBAConnect:
Who should use it?Oracle DBAs, Consultants and Developers can make a great use of this product, as you don't need to be present there for administrative tasks. You can do it now any time anywhere.
Competitive productsThere are also other tools like InternetDBA from The Net DBA, Hot-Query but they don't have as much features and sound architecture as DBAConnect has. The real competition is with AutoDBA from Insession Technologies, SmartDBA cockpit from BMC Software formerly known as WebDBA.
Oracle also has a product called Oracle DBA studio. It can work from within Enterprise Manager. It has modules like schema manager, security manager, storage manager, etc. The products are well integrated with each other and have gone through significant improvements. It also supports database administration from Web Browser.
The edge DBAConnect has over all above products is, it is free of cost and it does not harm to the features of the product that are compete able with any costly product in the market.
Detailed reviewHere is a detailed review of all the features of DBAConnect:
After connecting users can choose a schema from a drop down list, it pulls all the objects of that schema into related drop down lists. Now you can choose any object to see its details. Wherever further details are present, a link is given to proceed. You can perform following tasks in Object Browser window:
After connecting only users with DBA privileges will be able to see active DBA Utilities link. Using DBA Utilities screen you can perform following tasks:
Instance Monitoring & Space Management: includes active and running jobs, SGA information (Shared pool, Library cache, UGA space used, Data Dictionary, Redo log buffer cache, Database buffer cache), Free space information, Locks, Redo log files, Object and Data files, Rollback segment, Session information, User information, Table Space and Data files. It displays the space usage in two colors. You can change or alter any information by clicking on the active link for example to drop a user or to kill a session or even to change control files.
Tuning and Diagnosis: includes Block information, open cursors, Process information, sharable memory, SQL trace ON / OFF, unused columns. You can work on performance issues. It facilitates users by giving analysis features, you can analyze a schema for getting statistics or validating structure for tables or columns or indexes.
To Create and Manage: Tablespaces, Rollback segments, Users and redo logs. DBAConnect provides a GUI to perform these actions, you can also invoke SQL editor by clicking
Preview SQL: this option gives you to look at SQL syntax and gives you the options to directly execute or save the script.
Dynamic Tables: enables you to retrieve data using user-friendly GUI rather than writing SQL statement to query from V$ views.
These are the utilities for common application developer related tasks. A developer can
ShortcomingsThe product works well, but some new features and improvements can be added.
Cost and where to buy
You can download a 30 day free trial of DBAConnect from
The product costs $799 for the first license copy, $99.00 for additional licenses.
This price includes 3 months E-Mail based support.
General or Business Inquiries:
General or Business Inquiries:
The freeware version of DBAConnect has limited technical support but e-mail or
phone based full technical support can be purchased on a nominal fee.
For purchase or technical support contact
For purchase or technical support contact firstname.lastname@example.org
Can you write reviews and articles like this one? Why not become an editor or reviewer for the Oracle FAQ? Find out how you can make money, get noticed and advance your career click here