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


 

HTML Text

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.

 

 ”call

  
 

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.