31-08-2016, 12:11 PM
1451719442-Oracle.pdf (Size: 226.9 KB / Downloads: 10)
Oracle Database Architecture Overview
• Oracle ASM Architecture Overview
• Process Architecture
• Memory structures
• Logical and physical storage structures
• ASM storage components
Installing your Oracle Software
• Tasks of an Oracle Database Administrator
• Tools Used to Administer an Oracle Database
• Installation: System Requirements
• Oracle Universal Installer (OUI)
• Installing Oracle Grid Infrastructure
• Installing Oracle Database Software
• Silent Install
Creating an Oracle Database
• Planning the Database
• Using the DBCA to Create a Database
• Password Management
• Creating a Database Design Template
• Using the DBCA to Delete a Database
Managing the Oracle Database Instance
• Start and stop the Oracle database and components
• Use Oracle Enterprise Manager
Access a database with SQLPlus
• Modify database installation parameters
• Describe the stages of database startup
• Describe database shutdown options
• View the alert log
• Access dynamic performance views
Manage the ASM Instance
• Set up initialization parameter files for ASM instance
• Start up and shut down ASM instances
• Administer ASM disk groups
Configuring the Oracle Network Environment
• Use Enterprise Manager to create and configure the Listener
• Enable Oracle Restart to monitor the listener
• Use tnsping to test Oracle Net connectivity
• Identify when to use shared servers and when to use dedicated servers
Managing Database Storage Structures
• Storage Structures
• How Table Data Is Stored
• Anatomy of a Database Block
• Space Management in Tablespaces
• Tablespaces in the Preconfigured Database
• Actions with Tablespaces
• Oracle Managed Files (OMF)