Holiday book sale: Save up to 30% on print and eBooks. No promo code needed.
Save up to 30% on print and eBooks.
DBAs Guide to Databases Under Linux
1st Edition - April 26, 2000
Author: Syngress
eBook ISBN:9780080530291
9 7 8 - 0 - 0 8 - 0 5 3 0 2 9 - 1
In an effort to increase its marketshare and threat to Windows NT, Oracle8 was ported to Linux in late 1998, opening the popular database to an additional 10 million Linux users… Read more
Purchase options
LIMITED OFFER
Save 50% on book bundles
Immediately download your ebook while waiting for your print delivery. No promo code is needed.
In an effort to increase its marketshare and threat to Windows NT, Oracle8 was ported to Linux in late 1998, opening the popular database to an additional 10 million Linux users worldwide. The availability of Oracle8 enables current Linux users to deploy enterprise-class applications at low cost and provides an alternative to Microsoft Windows NT. This book covers that marriage of the most popular database and the fastest growing operating system.
* Complete coverage. Covers both Oracle8i and Oracle8i Lite, as well as Oracle Applications, Oracle Applications Server, and Oracle Developer * Organizations and Oracle database administrators will be looking for information on Linux as is gets adopted - this book fits the bill * Covers two growth markets and fills a need for information not covered elsewhere
Organisations converting to the Linux operating system. Database administrator's using Oracle 8
Preface
Chapter 1. The Linux Operating System
A Brief History of Linux
The Linux Kernel
The Future of Linux Development
Linux Distributions
The Difference between Linux and Other Operating Systems
Feature Rich
Multitasking
Why Choose Linux
When to Use Linux
Servers and Workstations
Recommended Hardware
Migrating to Linux Workstations
Distributions of Linux
Quick Distribution Reviews
Considerations Before Upgrading or Migrating
Hardware Compatibility
Upgrading
Migrating from Another OS
Choosing a Distribution
How to Begin the Process
How to Get Your People Started
Summary
FAQs
Chapter 2. A Basic Red Hat Linux Installation
Introduction
Separate Physical Machine
Choosing a Distribution of Linux
Preliminary Installation Decisions
Hardware
Multiple CPUs
RAM
Disks
RAID
Network Interface(s)
Backup Issues
Support Issues
Installation Preliminaries
Installing Red Hat
A Quick Installation Run-Through
Choosing an Installation Type
Custom (Manual) Installation
Creating the Partitions to Your Specifications
Network Setup
Time Zone Selection
root Account Configuration
Authentication
Package Selection
X Window Installation (Optional)
Package Installation
Linux Loader (LILO) and Boot Disk
Installation Done
Configuring the Server to Run a Database
Things to Watch Out For
Other Flavors of Linux
Summary
FAQs
Chapter 3. Installing and Running Oracle on Linux
Introduction
Concepts
System Global Area
Program Global Area
Tablespace
Datafile
Extent
Segment
Control Files
Redo Logs
Rollback Segments
Parameter Files
Version Identifiers
PL/SQL
Schema
Installation
Pre-Installation
Installing Oracle8
Installing Oracle8i
Post-Installation
Using Oracle8/8i
Startup and Shutdown
Background Processes
Creating an Account
SQL*Plus
Data Dictionary
Import/Export
Third-Party Software
Orasoft
Orac
Perl/DBI
Summary
FAQs
Chapter 4. An Informix Installation on Linux
Introduction
Installation
Part I: Acquisition and Server Placement of the Software
Part II : Installation and Branding
Part III: Disk Setup and Server Operation
Setting Up Data Files for Informer
About Disks
Disks and Directories
Space Considerations
Configuration
$INFORMIXDIR/etc/$ONCONFIG
$INFORMIXDIR/etc/sglhosts
/etc/services
/opt/data/rootdbs
Starting Your Engine with oninit
Stopping Your Engine
Final Configuration
Review
Physdbs
Create a physdbs File
Logsdbs
Create logsdbs
Create New Logical Logs
Tempdbs
Final $ONCONFIG Configuration Settings
Restart Your Engine
Other Tools
Dbaccess
Onmonitor
Resources
Informix Technical Support
Informix Web Site
Usenet News Group comp .databases.informix
International Informix User Group (IIUG)
Informix Press
Informix Training
Summary
FAQ
Chapter 5. Installing and Utilizing Sybase on Linux
Introduction
Installation
Installing SQL Server 11.0.3
Installing Optional Client Software
Configuration
Configuring Sybase Database Server
Configuring Sybase Backup Server
Configuring Sybase Client/Server Libraries
Starting the Database Server and Backup Server on Boot
Setting the System Administrator's Password
Configuring Database Devices and Databases
Creating User Logins and Permissions
Testing the Database
Database Design
Issues
Identity Columns (Auto Increment)
SQL Conformance
Run Environment
Summary
FAQs
Chapter 6: Installing DB2 Universal Database Version 6.1 on Red Hat Linux
Introduction
Preparing Your Red Hat Workstation for a DB2 Installation
Preparing Red Hat Version 5 .2 and Version 6 .0 for a DB2 Installation
Preparing Red Hat Version 6 .1 for a DB2 Installation
Installing DB2
Performing the Installation
Verifying the Installation
Configuring the Control Center
Installing a DB2 Client
Configuring a DB2 Client to Communicate with a DB2 Server
Troubleshooting the Connection
Summary
FAQs
Chapter 7. MySQL on Linux
Introduction
Installation
Naming Conventions
Installation of Binary Distribution
Installation of RPM Distribution
Installation of Source Distribution
Configuration
Security
Privileges
Access Control
System Setup
Performance
Issues
Threads
Run Environment
Summary
FAQs
Chapter 8. Installing and Managing Progress on Linux
Introduction
Installation
Install from Media
Kernel Parameters
Environment Setup
Configuration
Directory Structure
Disk Space versus I/O Throughput
Creating a New Database
Sizing the Buffer Pool
Running Progress
Managing the Database
Troubleshooting
Hung Users, Runaways, and Other Psychos
Strengths and Weaknesses
Summary
FAQs
Chapter 9. PostgreSQL on Linux
Introduction
Internet Power Drives PostgreSQL
Getting PostgreSQL
PostgreSQL Quick-Install Instructions
Detailed Installation
Installation of the Source Distribution
Before You Start
Step-by-Step Procedure
PostgreSQL Examples RPM
Testing Tcl/Tk Interface
Testing Python Interface—PyGreSQL
Testing the Perl Interface
Testing the libpq and libpq++ Interfaces
Testing Java Interfaces
Testing the ecpg Interface
Testing the ODBC Interface
Testing MPSQL Motif-Worksheet Interface
Testing SQL Examples—User-Defined Types and Functions
Verification of PostgreSQL Install
Emergency Bug Fixes
How Can I Trust PostgreSQL
System Layout
Kerberos Authentication
Availability
Installation
Operation
Runtime Environment—Using Postgres from UNIX/LINUX
Starting Postmaster
Using pg_options
Recognized Options
Security
User Authentication
Host-Based Access Control
Authentication Methods
Creating Users
Creating Groups
Access Control
Functions and Rules
Functions
Rules
Caveats
Secure TCP/IP Connection
Adding and Deleting Users
Disk Management—Supporting Large Databases
Alternate Locations
Managing a Database
Creating a Database
Accessing a Database
Destroying a Database
Backup and Restore
Large Databases
Troubleshooting—Postmaster Startup Failures
Client Connection Problems
Debugging Messages
pg_options
Technical Support
Mailing Lists
E-mail Account for PostgreSQL
English Mailing List
Archive of Mailing List
Spanish Mailing List
GUI Front-End Tool for PostgreSQL
ODBC, JDBC, and UDBC Drivers
Perl and DBI Interfaces
Tutorial for PostgreSQL
Internet URL Pointers
PostgreSQL URL References
Summary
FAQs
Chapter 10. Developing a Web-Based Application
Introduction
Web Application Platforms
Active Server Pages
Cold Fusion
Java Server Pages
Zope
Scripting Languages
PHP
Apache
Getting Started
Design Goals
Designing the Schema
Data Flow
PHP, MySQL, and Apache: Installing the Sample Application
PHP Database Connectivity : Making the Connection
Summary
FAQ
Appendix A. PHP Script for Shopping Cart Application
Appendix B. Dump File for Shopping Cart Application