Oracle Database Administration Fundamentals II
- Offered byXLNC
Oracle Database Administration Fundamentals II at XLNC Overview
Duration | 6 months |
Total fee | ₹1,999 |
Mode of learning | Online |
Credential | Certificate |
Oracle Database Administration Fundamentals II at XLNC Highlights
- Earn a certificate of completion from XLNC
Oracle Database Administration Fundamentals II at XLNC Course details
- For Solution developers, Database developers, Architects and IT Professionals
- Oracle Database Administration Fundamentals II is the third in a series of four courses covering Oracle Certification course #1Z0-032, and more
- This course teaches and demonstrates by example using thoroughly tested examples
- This course covers Oracle Net Services, Backup and Recovery including RMAN, Oracle Enterprise Manager, Transportable Tablespaces and SQL Loader
Oracle Database Administration Fundamentals II at XLNC Curriculum
Welcome
Welcome
Prerequisites for this course
About this course
Oracle net services on technet
Oracle backup and recovery on technet
Other applicable technet options
Introducing oracle net services
What is oracle net services?
Three basic configurations
Managing oracle database networks
Local versus centralized naming
Simple server configuration
Oracle shared servers or mts pt. 1
Oracle shared servers or mts pt. 2
Simple client configuration
Connection profiles
Introducing naming options pt. 1
Introducing naming options pt. 2
Oracle connection manager
Net configuration assistant
Net manager
Using oracle enterprise manager
Introducing backup/recovery options/utilities
Different backup and recovery options
Import and export
Cold backups (offline)
Hot tablespace backups (online)
Rman or recovery manager
Recovery
Standby databases
Physical standby databases
Logical standby databases
Replication
Replication by other means
What are transportable tablespaces?
What is sql loader?
Oracle net services architecture
Oracle net services architecture
Open systems interconnection (osi) model
Oracle osi model
Protocols
Net services communication
Dedicated and shared connections
Shared server processes and dispatchers
Configuring a simple connection
He listener configuration file
The tns names configuration file
The profile parameters file
Database configuration parameters pt. 1
Database configuration parameters pt. 2
Using the net configuration assistant pt. 1
Using the net configuration assistant pt. 2
The listener
What is the listener? pt. 1
What is the listener? pt. 2
Basic listener configuration
The listener control utility
Service registration
Listener queue size
Switching off listener logging and tracing
Timeouts
Multiple listeners pt. 1
Multiple listeners pt. 2
Connection load balancing and failover
The session data unit buffer (sdu)
Connection profile configuration