Transcript Introduction of Week 2

Fall 2012
ITEC 450
MODULE 2
DATABASE INSTALLATION AND
CONFIGURATION
1
Section 1: DBMS Installation
DBMS INSTALLATION BASICS
Understand the prerequisites for the specific
version of DBMS
Fall 2012

Version of the operating system
 Hardware components: cpu, memory, available
storage
 Related software: java, network

ITEC 450

Read the installation guide
Understand the installation process and procedure
 Follow the explicit instructions


Mechanics of the installation process is a relative
simple affair
2
HARDWARE REQUIREMENTS

Fall 2012

 Memory
ITEC 450
Basic CPU requirements: minimum processor speed
Storage requirements: available free space, backup
 DBMS software itself: 1 – 2 GB depending on OS
 Database: size of applications and data
requirements: amount of memory
Memory structures: data cache, data dictionary,
SGA
 Application data request -> read the data in the
disk -> copy the data to the memory -> process the
data -> write the modified data from memory to
disk
 Available swap space

3
DBMS CONFIGURATION
Understand DBMS components




Installation user privilege: Windows – administration
role; UNIX – unlimited resource, a special group
Licensed DBMS components: partition, spatial,
enterprise
Platform version requirement: Windows XP or
higher, HP-UX 11, Solaris 10, AIX
Operating system requirement: patches, kernel
parameters, message queue, DLL files
Program requirement: C++, Cobol, Perl
Define the initial settings
 Inputs during the installation process
 Installation configuration file
ITEC 450


Fall 2012

4
DBMS INSTALLATION VERIFICATION
Fall 2012
Ensure the clear understanding of all error
messages or popup windows
 Take screen shots of all questionable error
messages or popup windows
 Review installation log files
 Run tests if possible

ITEC 450
5
UPGRADE AND PATCH
Fall 2012
DBMS version – major change, such as Oracle
11g or SQL Server 2008
 Release – major function enhancement
 Patch – bug fixes
 Example:

ITEC 450
Oracle 11.2.1 (Version 11, Release number 2, Patch
release number 1)
 SQL Server 2008 SP1 CU6 (Version 2008, Release of
Service Patch 1, Patch of Cumulative Update
package 6)

6
DBMS CHANGE CONSIDERATION
Database structure changes, application features
changes
Planning for DBMS changes
ITEC 450

Fall 2012

Testing environment establishment
 Regression testing of applications: functions, performance
 Downtime and lost business opportunities during the
DBMS change.



Supporting software products may lack immediate support:
purchased applications, DBA tools, query tools, interface
programs
Cost of Change
Cost of the new version might be changed
 Planning, installing, testing, and deploying in both DBMS
and applications using databases

7
DATABASE STANDARDS AND
PROCEDURES
Fall 2012


ITEC 450
Standards – common practices that ensure the
consistency and effectiveness of the database
environment
Database naming conventions



Names of database, data files, objects (table, index,
procedure, trigger, etc.)
Length of names
Abbreviation
Roles and responsibilities
 Database application development standards: coding
standards, performance tips and techniques


Procedures – scripts and processes for handling
specific events
Application migration procedures
 Design review process

8
Fall 2012
ITEC 450
MODULE 2
DATABASE INSTALLATION AND
CONFIGURATION
9
Section 2: Oracle Installation
OPTIMAL FLEXIBLE ARCHITECTURE
(OFA)
Fall 2012
ITEC 450
Organize large amounts of complicated software
and data on disk, to avoid device bottlenecks and
poor performance
 Facilitate routine administrative tasks such as
software and data backup, which are often
vulnerable to data corruption
 Facilitate switching between multiple Oracle
databases
 Adequately manage and administer database
growth
 Help eliminate fragmentation of free space in the
data dictionary, isolate other fragmentation, and
minimize resource contention

10
FILE NAMING STANDARDS
Fall 2012
ITEC 450
11
FILE STRUCTURES FOR ORACLE
Fall 2012
ITEC 450
Windows – Take defaults as much as possible
 UNIX – Company standards, examples
 Software - /u01/app/oracle/product/10.2.0
 Administrative files /u01/app/oracle/admin/hrdb
 Database files - /u02/oradata/hrdb/control01.ctl

12
FILE STRUCTURES FOR ORACLE
Path to Oracle software is called
ORACLE_HOME containing Oracle binaries
Defined as a variable within your system

E.g. ORACLE_HOME/bin/runnit.exe
ITEC 450

Fall 2012

Each installation has its own ORACLE_HOME
 Examples:

C:\oracle\product\11.2.0\db1
 c:\oracle\product\11.2.0\client1


Contains a bin directory that holds most of the
executables
13
ORACLE HOME
Fall 2012
ITEC 450
14
INSTALLING THE SOFTWARE
Fall 2012
ITEC 450
Advanced Installation
 Select Installation Type: Enterprise Edition
 Select Configuration Option: Install database
software only

Note: Some of the slides are from Oracle 10g Database
Administrator: Implementation and Administration by
Gavin Powell and Carol McCullough-Dieter
15