Automatic
Diagnostic Repository(ADR)
Oracle
Database 11g offers a new automatic diagnostic repository (ADR), which provides
a single directory location for all the diagnostic data needed for diagnosing
and repairing database problems. The ADR uses standard methods to store
diagnostic data for the database as well as other Oracle products. Various automatic
diagnostic tools then use this diagnostic data to quickly diagnose and resolve
problems. The ADR also provides a consolidated location for the collection of
all diagnostic data you want to send to Oracle Support for diagnosing and
resolving problems.
The
ADR contains several sub directories such as alert and cdump, where the
traditional diagnostic data as well as new types of diagnostic data are stored.
You have two versions of the alert log in Oracle Database 11g, one a regular
text file and the other an XML-formatted file. You can read the alert log using
a normal text editor, the Enterprise Manager, or the new ADRCI tool, which lets
you perform a variety of tasks pertaining to problem diagnosis.
New Database Components
Oracle Application
Express (APEX)-
Oracle’s browser-based rapid application development tool, known earlier as
Oracle HTML DB, now contains prepackaged applications for blogs, storefronts,
and discussion forums, in addition to new reporting capabilities and support
for drag-and-drop forms layout. APEX is now installed with Oracle database 11g as
part of the base Oracle installation CD instead of the companion CD.
Oracle SQL Developer- Oracle’s free
database development productivity tool, SQL Developer, is installed
automatically when you choose a template-based database installation by
selecting an installation option such as General Purpose/Transaction Processing
and Data Warehousing. SQL Developer contains new tuning enhancements such as database
activity reporting and expanded support for version control and visual query
building.
Oracle Real
Application Testing-
This new component, which consists of two new features— Database Replay and SQL
Performance Analyzer—is automatically installed when you select the Enterprise
Edition installation option.
Oracle Configuration
Manager (OCM)-
This is an optional component. The OCM gathers software configuration
information and uploads it to the Oracle configuration repository.
Oracle Warehouse
Builder-
This tool is installed as part of the Oracle Database server software.
Oracle Database
Vault
This tool is now installed with the Oracle Database 11g, but as an optional
component, instead of as a component of the companion CD. The Oracle Database
Vault installation provides a baseline security policy for the database. When
you install the Oracle Database Vault, all security-related initialization
parameters are assigned default values.
Components which are
not in 11G but in 10g
The
following components aren’t part of the Oracle Database 11ginstallation (but
were part of the Oracle Database 10g release 2):
# iSQL*Plus
# Oracle Workflow
# Oracle Enterprise Manager Java Console
# Oracle Data Mining Scoring
Engine
# Raw storage support for datafiles
(installer only)
Role and Privilege
Changes
Oracle
Database 11g seeks to demarcate database administration and ASM administration.
Oracle now recommends that you create an optional operating system level group
for the users who’ll manage automatic storage management (ASM). You can do this
during the installation or later on. Oracle Database 11g introduces the new
operating system OS group named OSASM, exclusively for users who’ll manage ASM.
Oracle recommends that you grant ASM access only to users who are members of
the OSASM group. There is also a new ASM-related system privilege called
SYSASM, which Oracle recommends that you grant to those users who perform ASM
administrative tasks. The OSASM operating system group and the SYSASM system
privilege are purely optional in this release.
No comments:
Post a Comment