Please enable JavaScript.
Coggle requires JavaScript to display documents.
Installing and running Oracle - Coggle Diagram
Installing and running Oracle
Oracle installation
Portable on operating systems
Process
Starts by checking that there is enough space
Run the network wizard and the database configuration wizard
If errors occur, they are recorded in a file that provides some commands to fix the problem.
Installation includes the configuration and initialization of services
Nomenclature
Optimal Flexible Architecture
Directory structures for installation procedures
Filenames
Avoid mistakes
Standard for managing multiple oracle versions
Supporting Multiple Oracle Versions on a Machine
A different ORACLE_HOME variable is declared for each version
Upgrading an Oracle Database
Database update wizard
Support for incremental upgrades
Continuous updating without bringing down the database
Creating a Database
Planning the Database
Ask yourself what it will be used for and how much data the database will contain.
The Value of Estimating
Estimate with margins when planning the database, as the database grows, you can plan for changes that occur in your database.
Tools for Creating Databases
There are two ways to create an Oracle database
Graphic installation
Scripted installation
Oracle Net Services y Oracle Net
Oracle net services: connection to the database from a network.
Easy transfer of the physical database
Resolving Oracle Net Service Names
Local name resolution
Oracle Naming Service
Oracle Internet Directory or other LDAP directories
Host nomenclature
Global Data Services
Several instances can participate in the same global service
Oracle Net Manager
Prevents errors in the database files
Oracle Connection Pooling
Intermediate level server
Accepts client requests and connects to database server
Auto-Discovery and Agents
Automatic database discovery
Starting Up the Database
Oracle services are started on windows
On Unix and Linux you issue the STARTUP command from SQL * Plus or Enterprise manager
Automatic processes at startup
Start of the instance
Assembly of the database
Opening the database
Shutting Down the Database
Close the database
Disassembly of the database
Close the instance
Accessing a Database
Server Processes and Clients
SQL*Plus process acting as client
Can be run on the same computer as the instance or on another one
Server process or shadow process
Provides connection to the oracle instance
The server connects to the shared memory for the SGA
Application Servers and Web Servers As Clients
In multilevel computation the client process is an intermediate level
Oracle Net and Establishing Network Connections
Oracle Net Listener listener listens for incoming requests by one or several instances
The Shared Server/Multi-Threaded Server
Each process on the server only serves one client
Shared servers cause oracle to share a set of processes to a larger group of users.
Database Resident Connection Pooling
Oracle in the Cloud
To use Oracle Database Cloud you only need to request the cloud service from your browser.
Oracle at Work
Oracle and Transactions
Transaction: request from a customer to retrieve, insert, update or delete data
DML: data manipulation language
Ensure the integrity
Logical and complete transactions: Composed of INSERT, UPDATE and DELETE
Flashback
Tell oracle to return at a specific time the results of a SQL query