1 / 15

Module 2 Database Installation and Configuration

Module 2 Database Installation and Configuration. Section 1: DBMS Installation. DBMS Installation Basics. Understand the prerequisites for the specific version of DBMS Version of the operating system Hardware components: cpu , memory, available storage Related software: java, network

hali
Download Presentation

Module 2 Database Installation and Configuration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Module 2Database Installation and Configuration ITEC 450 Section 1: DBMS Installation

  2. DBMS Installation Basics • Understand the prerequisites for the specific version of DBMS • Version of the operating system • Hardware components: cpu, memory, available storage • Related software: java, network • Read the installation guide • Understand the installation process and procedure • Follow the explicit instructions • Mechanics of the installation process is a relative simple affair ITEC 450

  3. Hardware Requirements • 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 • Memory 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 ITEC 450

  4. 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

  5. DBMS Installation Verification • 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

  6. Upgrade and Patch • DBMS version – major change, such as Oracle 11g or SQL Server 2008 • Release – major function enhancement • Patch – bug fixes • Example: • 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) ITEC 450

  7. DBMS Change Consideration • Database structure changes, application features changes • Planning for DBMS changes • 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 ITEC 450

  8. Database Standards and Procedures • 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 ITEC 450

  9. Module 2Database Installation and Configuration ITEC 450 Section 2: Oracle Installation

  10. Optimal Flexible Architecture (OFA) • 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 ITEC 450

  11. FILE NAMING STANDARDS ITEC 450

  12. File Structures for Oracle • 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 ITEC 450

  13. 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 • 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 ITEC 450

  14. Oracle HOME ITEC 450

  15. Installing the Software • 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 ITEC 450

More Related