HP OpenView System Administration Handbook [Electronic resources] : Network Node Manager, Customer Views, Service Information Portal, HP OpenView Operations نسخه متنی

Chapter 18. Oracle for OpenView

The Oracle database is the central repository for the OpenView Operations. The database is part of the overall OpenView systems management environment. After the operating system is installed and configured for OpenView, you can begin the installation of

Oracle for OpenView (OfO) or the Enterprise Edition of Oracle. Installation of OfO was covered in Chapter 13, "Out-of-the-box with OpenView Operations." The product installation follows a standard procedure for installation of an Oracle database. An order for HP OpenView Operations for UNIX does not include the product OfO. OfO must be ordered separately. The installation procedure for OfO is documented in the

OpenView Operations Installation Guide (refer to Appendix C, "Resources," for more information on the documentation). Post-installation of the database, install the OpenView application software components (which include NNM), then execute the database configuration script (opcconfig) for the OpenView environment. During the run-time operations process, applications, scripts, and users interact with the database. The user interface provides the primary connectivity required for database interaction. Database transactions performed through the GUI occur transparent to the operator. External applications and scripts also cause transactions to occur within the database. For example, a report request from within the OpenView GUI (

ActionsUtilitiesReports ) calls for the execution of an SQL script (provided with OpenView) to query the database; collect, format, and present the data in a display window; and save the report to disk or send the report to a printer. This is one example of how the user is allowed to interact with the database transparently. Other interactions with the database may require direct access via the command line.

In some enterprise environments, the OpenView System Administrator is responsible for the role of Database Administrator. The responsibilities of a Database Administrator are similar to the role of a system administrator. The similar tasks include: database backup; add, modify, and delete user accounts; customize scripts to enable users interact with the database transparently; monitor database performance; and install, upgrade, and apply patches as required. In companies that use databases throughout the enterprise, Database Administrators take the responsibility for managing OfO. This ensures a consistent approach to database management across the enterprise.

The OpenView Administrator should learn as much as possible about Oracle for OpenView. This chapter is just a beginning. The sections presented provide an overview of the database environment. Details about the OpenView Operations database help you become familiar with the concepts and terms necessary to successfully interact with the system, peers, and DBA colleagues.