Donald K. Burleson
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
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.