Please enable JavaScript.
Coggle requires JavaScript to display documents.
Installing and Running Oracle, Referencias, Datos personales - Coggle…
Installing and Running Oracle
Installation
Oracle installation is user-friendly and consistent across operating systems.
It involves a few clicks and configuration questions.
Optimal Flexible Architecture (OFA)
OFA is a set of best practices for organizing directory structures and filenames.
It streamlines database administration and helps with managing multiple databases.
Supporting Multiple Oracle Versions
You can install and run multiple Oracle software versions on a single server.
Each version uses a different ORACLE_HOME variable for separation and compatibility.
Upgrading Oracle Database
Tools like Database Upgrade Assistant and rolling upgrades simplify the upgrade process.
Oracle Database 11g onwards allows upgrading from Oracle XE to other editions.
Planning the Database
Considerations include the database's purpose, data volume, hardware, access patterns, growth rates, redundancy, performance, and security requirements.
Adequate capacity planning prevents future performance issues.
Value of Estimating
Make initial estimates and document them.
Refine estimates as the database evolves based on real-world data and requirements.
Tools for Creating Databases
Use the graphical installer for user-friendly setups.
Use the graphical installer for user-friendly setups.
Oracle Net Services and Oracle Net
Oracle Net Services
Manages network connections between Oracle applications and databases.
Handles network protocols, client-server interactions, and connection maintenance.
Resolving Oracle Net Service Names
Oracle Net resolves service names into host and instance names.
Methods include local name resolution, Oracle Names service, LDAP directories, host naming, or third-party naming services.
Global Data Services
Introduced in Oracle Database 12c.
Allows multiple database instances to participate in a unified global service.
Enhances high availability and scalability.
Oracle Net Manager
A consistent configuration interface built using Java.
Helps avoid common errors in network configuration.
Oracle Connection Pooling
Middle-tier server implementations often employ connection pooling.
Manages a pool of database connections, reducing connection overhead.
Oracle in the Cloud
Oracle Database is available in various cloud deployment options.
Cloud setups may differ from on-premises installations, offering scalability and managed services.
Oracle and Transactions
Transactions
Units of work requested by clients.
Include data retrieval, insertion, updating, or deletion.
Clients can commit for permanent changes or roll back for undoing.
System Change Number (SCN)
Maintains transaction order and database integrity.
Tracks transaction timing and position.
Rollback Segments
Store "undo" information.
Crucial for rolling back transactions.
Fast Commits
Two methods for committing transactions:
Write all modified database blocks.
Record redo information for later reproduction.
Flashback
Offers data recovery and history analysis features.
Includes Flashback Database, Flashback Table, Flashback Drop, and Flashback Versions Query.
Capabilities expanded in newer Oracle Database versions.
Referencias
Greenwald, R., Stackowiak, R., & Stern, J. (2013). Oracle Essentials, Fifth Edition. O’Reilly Media.
Datos personales
Nombre: David Josué Centeno Araya,Carne:2020103578