This course introduces users to the major components of an Oracle server.
Objectives:
Explain the Oracle server architecture
Identify how users connect to the Oracle server
List tools used by DBAs to administer Oracle
Describe the benefits of Optimal Flexible Architecture
Install Oracle using Oracle Universal Installer
Topics:
Oracle Server Architecture
The Server Process
Connecting to Oracle Servers
Processing Queries
Processing DML Statements
Processing Commit Statements
Common Database Administration Tools
Oracle Universal Installer
Installing Oracle9i Database
Optimal Flexible Architecture
Oracle Authentication
Using Operating System Authentication
Using Password File Authentication
Oracle Enterprise Manager Components
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.