Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle




Donald K. Burleson

Oracle Tips  

The Oracle DBA User Account

The second-largest contributor to a bad install experience is an underprivileged Oracle DBA account. The account must be set up as stated in the installation documentation for the install to be successful. After the installation, some adjustment of account privileges can be done if the system administrator really doesn’t want an account outside of his or her realm of control to have such broad privileges, but no adjustments can be made until the install is complete. In most cases, however, the privileges removed by an overzealous system administrator will have to be periodically reinstated for code relinks, special file work, and, of course, upgrades. This will soon convince most system administrators to set them and leave them. After all, if someone can’t be trusted with the required privileges to do his or her job, should the person be trusted with the job in the first place? It is advised that the Oracle DBA be sent to at least an introductory course in system administration so as to know what not to do with the privileges. A course in system tuning is also advised.

Oracle DBA Training 

It has been said that success in a new venture usually depends on three things: training, training, and training. This is especially true in the realm of the Oracle DBA. Oracle Corporation, and many third-party vendors, offer numerous classes at locations across the United States and Europe. There are also many sources for computer-based training (CBT), as well as online resources such as the RevealNet, Inc. Oracle Administrator (which I helped to author and a part of which can be downloaded from the company Web site). These classes are Oracle-specific and address issues that DBAs, developers, and managers need to be aware of and take into account. With most Oracle purchases you can negotiate training units, or TUs. Use them; they are worth their weight in gold. While there have been a few successful seat-of-the-pants Oracle installations, most end up in trouble.

This is an excerpt by Mike Ault’s book “Oracle Administration & Management”.  If you want more current Oracle tips by Mike Ault, check out his new book “Mike Ault’s Oracle Internals Monitoring & Tuning Scripts” or Ault’s Oracle Scripts Download.




Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



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

Oracle® is the registered trademark of Oracle Corporation.