Database Reference
In-Depth Information
databases in a cluster. Moreover, OEM is Web-accessible; through it, you can access
your database from any computer that has an internet connection via the URL address
http://<Machine.Domain>:5500/em
(you supply the machine name and domain name
for your network).
When you access a database through OEM, all its component objects (schemas,
users, tablespaces, tables, procedures, triggers, indexes, constraints, etc.) are available in
a hierarchical manner. Each of these database components can be accessed, and their
properties changed. OEM then generates the required SQL code or database scripts,
in order to effect these changes, and executes them. OEM can also be used to create
database objects (user accounts, tables, views, tablespaces, indexes, constraints, etc.).
The productivity of the DBA is therefore greatly enhanced. Of course, you will need a valid
user account, password, and appropriate privileges.
Oracle also provides a GUI-based component called Oracle SQL Developer
(OSQLD). It provides functions similar to OEM. Students as well as practitioners will find
this component very effective in providing a shield from the slightly gorier rigor of SQL
syntax (but the truth is, SQL syntax is by no means a tragedy; we could live with it).
Still, Oracle provides another GUI-based component called iSQL *Plus, which
facilitates Web-accessibility to the database in a manner that is similar to OEM. You can
also access your database server from any machine that has an internet connection, via
name and domain name for your network).
16.2.5 Oracle Enterprise Manager Grid Control
Oracle Enterprise Manager Grid Control is an HTML-based interface that provides
complete monitoring across the entire Oracle technology stack — business applications,
application servers, databases, and the E-Business Suite — as well as non Oracle
components. The components of Grid Control include:
•
Oracle Management Service (OMS)
•
Oracle Management Agents
•
Oracle Management Repository
These components communicate with each other through HTTP and we can achieve
secure communications between tiers within firewall-protected environments by enabling
the secure socket layer (SSL) protocol. Using Grid Control, an administrator can view
alerts, overall system status, performance metrics, and be alerted when failure occurs.
16.2.6 Oracle Database Configuration Assistant
Earlier versions of Oracle did not have OEM, only Oracle Database Configuration
Assistant (DBCA). Unfortunately, creating, configuring and managing Oracle databases
can be quite complex. DBCA helps to take some complexity out of this by automating
the process. The user is shielded from gory syntactical details via a user interface,
which generates the requisite SQL and database scripts, based on the user responses to
friendly prompts.
