Oracle System Structure

Features of Oracle architecture data
Content of Oracle architecture data
What can I do after I finish learning?
What preparations do I need to read this document?
How to read this document

Features of Oracle architecture data

This document emphasizes practicality. This document is practical in terms of content selection, emphasizing the main line of Oracle system management and abandoning those who have spent time. However, after learning, the students have not made much progress and are partial to the theoretical aspects.

This document emphasizes practicality. This course is equipped with a hands-on lab. As long as you do exercises, you can complete the corresponding Oracle database management work in your actual work. The exercises can also be used as a reference in the actual oracle database management work.

This document emphasizes authenticity. All examples are verified.

This document provides the basic work required to complete the actual operation. For example, for Oracle Enterprise Manager (OEM), many books only provide OEM functions, but the actual operations in the books cannot be performed. Why? To use OEM, you must first install and start the OEM server, but it is difficult to do this, which is a real difficulty for you to use OEM.

This document provides a clear picture of Oracle system management.
Content of Oracle architecture data

Oracle relational database management system

What is relational database service (RDBMS)

Databases are classified by scale and purpose

Core tasks of the relational database management system

Architecture of Oracle relational database

Oracle disk Resource Structure

Oracle memory and CPU usage: Oracle server instance Structure
System global area (SGA)
ProgramGlobal zone (PGA)
Oracle background process
How do users connect to server processes?
How Oracle processes SQL select statements
Process for Oracle to process SQL DML statements
Oracle commit transaction process

Database Object Types and some basic concepts

Tools for operating Oracle databases
SQL * Plus, a tool available for end users
Start SQL * Plus in Windows
Execute various commands in SQL * Plus
Execute standard SQL commands
Execute PL/SQL Blocks
Execute the SQL * Plus command
Obtain information related to Command Execution
Obtain the definition information.
Get error message

Use Oracle management tools
Oracle Server Manager row Mode
Oracle Enterprise Manager
Use Oracle OEM performance monitoring and tuning packages
Performance Manager
Topsessions
Other tools such as Oracle expert
Use the Oracle Database Configuration tool Database Configuration Assistant
Use the Oracle Network Configuration tool net8 Assistant
Use the Oracle Software Installation Tool universal Installer
Oracle Data Loading tool SQL * Loader
Oracle Data picking and loading tools exp and IMP reorganize data

Database operator's main work
Install and configure the Oracle database software-1: Basic installation and configuration

Installing Oracle with Oracle installer

Install the Oracle8i Server

Install Oracle net8

Install Oracle8i client software

Customer/Server structure configuration

How does the Oracle8i server work on windows?
Oracle service
Directory structure of Oracle database software and data
Install and configure Oracle database software-2: Oracle Network Solution

Network Development Direction and Problems
Host computing mode
Growth of the customer server structure
Emergence of Internet computing
Oracle Network Solution

Basic net8 Structure
How net8 establishes a server connection
Components of net8 AND THEIR INTERACTION

Basic net8 Server Configuration
Use net8 assistant to configure listener
Configure the listening location
Configure Database Service
Configure Other Services
Name listener
Use listener to control LSNRCTL to start net8 listener
Use listener to control LSNRCTL to disable net8 listener
Start/Close net8 listener in Windows Service Manager
Set multiple listener processes on the same node
Configure the second listening process
Start the second listening process
Server Configuration File

Basic net8 client Configuration
Use host naming to establish a connection from the net8 Client
Configure the net8 client file and use the local naming method to establish a connection
Client configuration file
Oracle Distributed Database Configuration

Configure the Oracle Management Server: Oracle Management Server

Oracle machine exercises:

Test on the machine: view the important disk file structure of the Oracle System
Observation and discussion

Computer Test: use of database connection and management tools
Connect to the database using SQL * Plus on the Oracle server
Log on to Server Manager on the Oracle server
Go to the DBA stduio tool on the Oracle server

Computer Test (optional): use Oracle installer to install Database Server Software

Test on the machine (optional): Install the Oracle client software

Computer Test: configure the customer/server on the client

Hands-on test: Observe Oracle's services on the window nt System

Computer Test: Observe the tnsnames. ora file and listener. ora File

Computer Test: Use net8 assistant to observe net8 network listening
What will happen after learning the Oracle system structure?

After reading the documents as required and conducting hands-on experiments, you can:

Learn about Oracle instances, processes, disk resource files, and memory usage.
You can install and configure the Oracle server and client.
You can install the Oracle Management Server required by Oracle Enterprise Manager.
Oracle Registry
Understand Oracle services/threads on NT
You can use major oracle tools: SQL * Plus, net8 assistant, Oracle Server Manager, and Oracle DBA stduio.
What preparations do I need to read this document?

Basic Windows knowledge. No specific database knowledge is required.
How to read this document

While reading and experimenting with computers.