Database Reference
In-Depth Information
Table 1.2
Software
Category
Note
operating Systems:
• Windows
• unix
• An infrastructure person worth his salt should be conversant with
the command lines of both Windows and unix and application of
operating system patches.
• know how to access Windows event logs and unix system logs and
make sure you have access to them.
Device Drivers
• Device drivers are the glue between an operating System (oS) and
internal server hardware, such as video cards, host bus adaptors,
and printers. Ensure these adaptors are up to date as defective
drivers can cause performance and/or stability issues.
virtual machines (vms):
• vmware ESx
• microsoft hyper-v
• oracle vm Server
• Be aware of issues like overcommitted resources and fully
formatted disks. Administrators of virtual machines have a
tendency to grant less than the requested resources as well as run a
great deal more virtual servers than are efficient for Essbase. many
virtualization technologies support a thin disk provisioning that
formats the disk on the fly. Formatting the disk on the fly will result
in very poor server performance; always ensure the disk allocated
to the Essbase virtual machines is fully formatted.
Java Application Servers:
• Apache tomcat (obsolete)
• oracle WebLogic
• IBm WebSphere
• A Java application server is a middleware component in which key
portions of the oracle delivered hyperion applications execute. In
current and future releases the typical installation automatically
deploys the Java application server. In more complex deployments
there are manual steps that can complicate the installation. In larger
organizations these are often administered by different groups in an
organization than the oS or database. make sure you get everyone
on the same page before implementation begins.
Web Servers:
• microsoft IIS
• oracle httP Server/
Apache httP Server
• know how to troubleshoot basic Web server issues, use of secure
socket layer certificates, and location of and access to log files.
relational Databases:
• oracle DB
• microsoft SQL Server
• IBm DB2
• use of basic SQL commands and the willingness to dive in to the
oracle delivered tables (especially Shared Services in later versions)
is important. know what you can change directly in the database
safely and what to avoid.
• oracle has documented many of the hyperion relational schemas
in their Enterprise Performance management Web resources.
Table 1.3
Operating Systems and Database Demographics
operating System
Windows Server
80%
unix (Linux, Solaris, hPux, AIx)
20%
Database Sotware
microsoft SQL Server
55%
oracle DB
40%
IBm DB2
5%
