Please enable JavaScript.
Coggle requires JavaScript to display documents.
Installing and Running Oracle - Coggle Diagram
Installing and Running Oracle
Oracle installer
Window system
Unix
Java-based
portability of Java
installation fails
logfile
memory and disk
quick and easy way to create,
modify, or delete a database
pre-configured database
Optimal Flexible Architecture
OFA
Oracle environment to quickly find the software and files used for the database and
the instance
included
in the Oracle installation guide
Supporting Multiple Oracle Versions on a Machine
run multiple versions of Oracle
single-server machine
ORACLE_HOME
Unix and Windows
Upgrading an Oracle Database
Upgrade Assistant and support
rolling upgrade
Creating a Database
Planning the Database
hardware
number and type of CPUs
disks
10 TB to 90 TB in 2 years
Clusters easier to scale
workload
type of work
CRUD matrix
Read
Update
Create
Delete
Tools for Creating Databases
Run character-mode scripts
Use the graphical installer tool
Oracle Net Services and Oracle Net
different machine
Oracle Database over a network
TCP/
IP
location transparency
does not
need to know the server’s physical location
Resolving Oracle Net Service Names
Local name resolution
TNSNAMES.ORA
Oracle Internet Directory
centralized naming service extends far beyond the Oracle environment
Lightweight Directory Access Protocol
Host naming
Domain Name Service
hostname into an IP address
Third-party naming services
external or third-party
Global Data Services
Oracle Net Manager
avoid the errors
Oracle Connection Pooling
middle-tier server
connection pooling
database resident connection pooling
Auto-Discovery and Agents
features that allowed it
Oracle Net Configuration Files
Windows and Unix
ORACLE_HOME\network\admin
TNS_ADMIN
TNSNAMES.ORA
LISTENER.ORA
SQLNET.ORA
LDAP.ORA
Starting Up the Database
STARTUP command
Starting the instance
INIT.ORA
SPFILE
need privilege SYSOPER or SYSDBA
Mounting the database
CONTROL_FILES
limited types of database administration
DBA
Opening the database
Shutting Down the Database
Closing the database
Dismounting the database
Shutting down the instance
Accessing a Database
Server Processes and Clients
Server process
Log Writer and Database Writer
Client process
Application Servers and Web Servers As Clients
Data dictionary information about the shared server
V$SHARED_SERVER_MONITOR
V$DISPATCHER
V$SHARED_SERVER
Database Resident Connection Pooling
Oracle Net and Establishing Network Connections
The Listener introduces the server to the client by letting each know the other’s
network address
The Listener steps out of the way and lets the client and server process communicate
directly
The Listener detects an incoming request and introduces the requesting client to
an Oracle server process
The client contacts the Listener over the network
The Shared Server/Multi-Threaded Server
(MTS) in Oracle7
shared server since Oracle9i
dedicated server