• admin@thetechmaster.in
  • |
  • +919676516545

admin@thetechmaster.in

+919676516545

Oracle Cloud Administration

Faculity Name : Raj

Experience : 9 Years

Course Duration : 25 days

Price : 25000 INR

Course Details

  • About Course
  • About Instructor
  • Course Content
  • Videos

Cloud has been the next generation technology for server hosting and much more. Oracle, with it's leadership and experience with Database technology move forward to build it's very own "Oracle Cloud" and offering many more services to it's customers.

TechMaster introduced first of it's kind Oracle Cloud course where in a candidate can learn and explore the Database as Service (DBaaS). With this, candidates can become cloud database administrators which is the future for Oracle DBA's and others which is also a highly paid job. 

Raj

Experience : 9 Years

Raj  is having 7 years experience as Oracle RAC & EXADATA  DBA and currently working in MNC as DMA.

He has been into training industry for more than 3 years now and handled  corporate and personal training batches. 50+ of his trained professionals were placed into MNC's in  India .

His training is purely real time oriented with lot of exposure to the internals as well as real time issues. His expertise helps a layman candidate to understand about Oracle Database Administration to the core.

Oracle Cloud Administration Course Content

Oracle Cloud Course Content

Getting Started with Database Cloud Service

  • About Oracle Database Cloud Service
  • About Database Cloud Service Database Deployments
  • Service Level
  • Metering Frequency
  • Oracle Database Software Release
  • Oracle Database Software Edition
  • Oracle Database Type
  • Computing Power
  • Database Storage
  • Automatic Backup Configuration
  • Before You Begin with Database Cloud Service
  • How to Begin with Database Cloud Service Subscriptions
  • About Database Cloud Service Roles and Users
  • Accessing the Oracle Database Cloud Service Console
  • Using the Database Cloud Service REST APIs
  • Typical Workflow for Using Database Cloud Service
  • About Database Deployments in Oracle Cloud Infrastructure

Managing the Database Cloud Service Life Cycle

  • Creating a Database Deployment
  • Creating a QuickStart Database Deployment
  • Standard Edition
  • Enterprise Edition
  • Extreme Performance
  • Creating a Customized Database Deployment
  • Creating a Database Deployment Using a Cloud Backup
  • Replacing the Database by Using the Oracle Database Cloud Service Console
  • Replacing the Database by Using ibkup Actions
  • Creating a Clone Database Deployment from a Snapshot
  • Creating a Hybrid DR Deployment
  • Viewing All Database Deployments
  • Viewing Detailed Information for a Database Deployment
  • Viewing Activities for Database Deployments in an Identity Domain
  • Stopping, Starting and Restarting a Database Deployment
  • Rebooting a Compute Node
  • Scaling a Database Deployment
  • Creating and Managing IP Reservations
  • Creating an IP Reservation
  • Using an IP Reservation when Creating a Database Deployment
  • Deleting an IP Reservation
  • Creating and Managing Snapshots of a Database Deployment
  • Deleting a Database Deployment
  • Tracking the Number of Database Deployments in an Account

 

Managing Network Access to Database Cloud Service

  • About Network Access to Database Cloud Service
  • Generating a Secure Shell (SSH) Public/Private Key Pair
  • Generating an SSH Key Pair on UNIX and UNIX-Like Platforms Using the sshkeygen
  • Utility
  • Generating an SSH Key Pair on Windows Using the PuTTYgen Program
  • Creating an SSH Tunnel to a Compute Node Port
  • Creating an SSH Tunnel Using the ssh Utility on Linux
  • Creating an SSH Tunnel Using the PuTTY Program on Windows
  • Enabling Access to a Compute Node Port
  • Enabling IPSec VPN Access to Database Cloud Service
  • Defining a Custom Host Name or Domain Name for Database Cloud Service
  • Using Network Encryption and Integrity

 

 

                                                                                                                            

Administering Database Cloud Service

  • Adding Temporary Storage to a Database Deployment
  • Adding an SSH Public Key
  • Updating the Cloud Tooling on Database Cloud Service
  • Updating the Cloud Tooling by Using the dbpatchm Subcommand
  • Updating the Cloud Tooling by Using the raccli Utility
  • Administering a Data Guard Configuration
  • Checking the Status of the Oracle Data Guard Configuration
  • Performing a Switchover Operation
  • Performing a Switchover Operation by Using the dbaascli Utility
  • Performing a Manual Failover Operation
  • Performing a Manual Failover Operation by Using the dbaascli Utility
  • Reinstating a Failed Primary Database
  • Reinstating a Failed Primary Database by Using the dbaascli Utility
  • Changing the SYS Password
  • Configuring Clients for Automatic Failover
  • Preparing 12.2 Database Deployments for Patching
  • Preparing 12.2 Database Deployments Hosting Single-Instance Databases for
  • Patching
  • Preparing 12.2 Database Deployments Hosting Oracle RAC Databases for
  • Patching
  • Upgrading Database deployments Hosting Single-Instance Databases to Oracle
  • Linux 6.6 with UEK3
  • Applying Linux OS Security Patches
  • Applying Linux OS Security Patches by Using the dbpatchmsm Utility
  • Manually Applying Linux OS Security Patches
  • Improving Block I/O Performance by Enabling Multi-Page Ring Support in the Linux OS
  • Maintaining the Manageability of Database Cloud Service
  • Administering Oracle REST Data Services (ORDS)
  • Adding a Signed SSL Certificate to Oracle REST Data Services
  • Stopping Oracle REST Data Services
  • Starting Oracle REST Data Services
  • Loading Data into the Oracle Database on Database Cloud Service
  • Tuning Oracle Database Performance on Database Cloud Service
  • Monitoring and Managing Oracle Database on Database Cloud Service
  • Managing the Log and Diagnostic Files on Database Cloud Service
  • Creating a Database using the Virtual Image Service Level
  • Creating a Database on a Virtual Image Database Deployment: Example

Accessing Database Cloud Service

  • Connecting to a Compute Node Through Secure Shell (SSH)
  • Connecting to a Compute Node Using the ssh Utility on UNIX and UNIX-Like
  • Platforms
  • Connecting to a Compute Node Using the PuTTY Program on Windows
  • Accessing Enterprise Manager Database Express 12c
  • Accessing Enterprise Manager 11g Database Control
  • Connecting Remotely to the Database by Using Oracle SQL Developer
  • Connecting Remotely to the Database by Using Oracle Net Services
  • Copying Files to or from a Database Cloud Service Database Deployment

Backing Up and Restoring Databases on Database Cloud Service

  • About Backing Up Database Deployments on Database Cloud Service
  • Viewing Backup Configuration Information
  • Creating an On-Demand Backup
  • Creating an On-Demand Backup by Using the bkup_api Utility
  • Creating an On-Demand Backup by Using the raccli Utility
  • Deleting a Backup
  • Updating the Password for Backing Up to the Storage Cloud
  • Updating the Password by Using the bkup_api Utility
  • Updating the Password by Using the raccli Utility
  • Customizing the Current Backup Configuration
  • Customizing the Current Backup Configuration on Database Deployments
  • Hosting Single-Instance Databases
  • Customizing the Current Backup Configuration on Database Deployments
  • Hosting Oracle RAC Databases
  • Changing the Backup Configuration to a Different Backup Destination
  • Changing the Backup Configuration on Database Deployments Hosting Single-
  • Instance Databases
  • Changing the Backup Configuration on Database Deployments Hosting Oracle
  • RAC Databases
  • Increasing Local Storage for Backups on Older Database Deployments
  • Disabling and Re-enabling Scheduled Backups
  • Restoring from the Most Recent Backup
  • Restoring from the Most Recent Backup by Using the dbaascli Utility
  • Restoring from the Most Recent Backup by Using the raccli Utility
  • Restoring from a Specific Backup
  • Restoring from a Specific Backup by Using the dbaascli Utility
  • Restoring to a Specific Point in Time
  • Restoring to a Specific Point in Time by Using the dbaascli Utility
  • Restoring to a Specific Point in Time by Using the raccli Utility
  • Recreating an Unrecoverable Database Deployment From a Backup to Cloud Storage

 

Patching Database Cloud Service

  • Viewing Available Patches
  • Viewing Available Patches by Using the dbpatchm Subcommand
  • Viewing Available Patches by Using the dbpatchmdg Utility
  • Checking Prerequisites Before Applying a Patch
  • Checking Patch Prerequisites by Using the dbpatchm Subcommand
  • Checking Patch Prerequisites by Using the dbpatchmdg Utility
  • Checking Patch Prerequisites by Using the raccli Utility
  • Applying a Patch
  • Applying a Patch by Using the dbpatchm Subcommand
  • Applying a Patch by Using the dbpatchmdg Utility
  • Applying a Patch by Using the raccli Utility
  • Rolling Back a Patch or Failed Patch
  • Rolling Back a Patch or Failed Patch by Using the dbpatchm Subcommand
  • Rolling Back a Patch or Failed Patch by Using the dbpatchmdg Utility
  • Applying a Patch to a Test Deployment
  • Patching a Hybrid DR Deployment
  • The dbpatchm.cfg Configuration File

 

 

 

 

Configuring Database Features, Database Options, and Companion

Products

  • Using Oracle Real Application Clusters (RAC) in Database Cloud Service
  • Using Oracle Data Guard in Database Cloud Service
  • More About Oracle Data Guard
  • Using Oracle Real Application Clusters (RAC) and Oracle Data Guard Together in
  • Database Cloud Service
  • Using Oracle Multitenant in Database Cloud Service
  • Creating and Activating a Master Encryption Key for a PDB
  • Exporting and Importing a Master Encryption Key for a PDB
  • Using Oracle Database Vault in Database Cloud Service
  • Configuring and Enabling Oracle Database Vault
  • Disabling Oracle Database Vault
  • Using Oracle Application Express in Database Cloud Service
  • Accessing the Oracle Application Express Console
  • Upgrading from Oracle Application Express 4.2 or 5.0 to 5.1 for Oracle
  • Database 11g
  • Upgrading from Oracle Application Express 4.2 to 5.1 for Oracle Database 12c
  • Upgrading from Oracle Application Express 5.0 to 5.1 for Oracle Database 12c
  • Moving Oracle Application Express 5.1 from CDB$ROOT to PDBs
  • Using the Demos PDB
  • Using Oracle Enterprise Manager Cloud Control with Database Cloud Service
  • Using Oracle GoldenGate Cloud Service with Database Cloud Service
  • Manually Configuring a Deployment’s Database for Oracle GoldenGate Cloud
  • Service Replication

 

Migrating Oracle Databases to Database Cloud Service

  • Choosing a Migration Method
  • Migrating from Oracle Database 11g to Oracle Database 11g in the Cloud
  • Migrating from Oracle Database 11g to Oracle Database 12c in the Cloud
  • Migrating from Oracle Database 12c CDB to Oracle Database 12c in the Cloud
  • Migrating from Oracle Database 12c Non-CDB to Oracle Database 12c in the Cloud
  • Migration Methods
  • Data Pump Conventional Export/Import
  • Data Pump Conventional Export/Import: Example
  • Data Pump Full Transportable
  • Data Pump Full Transportable: Example
  • Data Pump Transportable Tablespace
  • Data Pump Transportable Tablespace: Example
  • Remote Cloning a PDB
  • Remote Cloning Non-CDB
  • RMAN Cross-Platform Transportable PDB
  • RMAN Cross-Platform Transportable Tablespace Backup Sets
  • RMAN Cross-Platform Transportable Tablespace Backup Sets: Example
  • RMAN Transportable Tablespace with Data Pump
  • RMAN Transportable Tablespace with Data Pump: Example
  • RMAN CONVERT Transportable Tablespace with Data Pump
  • RMAN CONVERT Transportable Tablespace with Data Pump: Example
  • SQL Developer and INSERT Statements to Migrate Selected Objects
  • SQL Developer and SQL*Loader to Migrate Selected Objects
  • Unplugging/Plugging a PDB
  • Unplugging/Plugging Non-CDB

Using Oracle DBaaS Monitor

  • About Oracle DBaaS Monitor
  • Accessing Oracle DBaaS Monitor
  • Filtering the Display on DBaaS Monitor Pages
  • Administering the Listener
  • Viewing Listener Status Information
  • Starting the Listener
  • Stopping the Listener
  • Verifying that the Listener Knows of a Service
  • Starting and Stopping the Database Instance
  • Starting the Database Instance
  • Stopping the Database Instance
  • Viewing and Modifying Initialization Parameters
  • Viewing User Account and Expiring Password Information
  • Viewing Tablespace and Segment Space Usage
  • Changing the TDE Keystore Password
  • Viewing Alert Log Entries and Checking for Errors
  • Viewing Real Time SQL Monitor
  • Administering Pluggable Databases
  • Cloning a Pluggable Database
  • Closing a Pluggable Database
  • Creating a Pluggable Database
  • Dropping a Pluggable Database
  • Opening a Pluggable Database
  • Plugging In a Pluggable Database
  • Unplugging a Pluggable Database

Troubleshooting Database Cloud Service

  • Problems Creating Deployments
    • I cannot create a deployment when I have many database deployments
    • I cannot create a deployment, even after waiting for an hour
    • I get a "SCRIPT execution errors" message when I try to create an deployment with backups to cloud storage
  • Problems Administering Deployments
    • I am required to change the password for the oracle user when I try to connect to a compute node
    • I get a Linux error 30, Read-only file system, when trying to connect to or work in my environment
    • I can’t use dbaascli to update my cloud tooling
  • Problems with Scaling
    • My scaling operation does not start 12-5
    • My deployment is too busy to allow scaling 12-5
    • After scaling the shape of my Data Guard configuration, I get an ORA-16792 warning when I check the status of the configuration
  • Problems with Patching and Rollback
    • I receive a message stating that the virtual machines are unhealthy
    • I receive a message stating that the instance is busy with another operation
    • I cannot apply a patch due to a lack of storage space
    • My attempt to roll back the January 2015 Patch Set Update (Jan 2015 PSU) fails
    • My attempt to roll back the April 2015 Patch Set Update (Apr 2015 PSU) fails
  • Problems with Backing Up and Restoring
    • There is not enough space for my backup
    • I receive a message stating that there was an unexpected error during the duplicate command (ORA messages)
    • I receive a message stating that there was an unexpected error during the duplicate command (RMAN messages)
    • A backup fails with an ORA-19914 and ORA-28361

Characteristics of a Newly Created Deployment

  • Characteristics Common Across Database Deployment Types
  • Data Security
  • Security of Data at Rest
  • Security of Data in Transit
  • Hybrid Columnar Compression (HCC)
  • Tablespace Encryption
  • Creating Encrypted Tablespaces
  • Managing Tablespace Encryption
  • Characteristics of a Single Instance Database Deployment
  • Linux User Accounts
  • Storage Volumes and File System Layout
  • Locations of Installed Software
  • Network Access
  • Oracle Database Characteristics
  • Location of Diagnostic and Log Files
  • Characteristics of a Single Instance with Data Guard Standby Database Deployment
  • Linux User Accounts
  • Storage Volumes and File System Layout
  • Network Access
  • Oracle Data Guard Configuration
  • Characteristics of a Database Clustering with RAC Database Deployment
  • Linux User Accounts
  • Storage Volumes and File System Layout
  • Network Access
  • Characteristics of a Database Clustering with RAC and Data Guard Standby
  • Database Deployment
  • Linux User Accounts
  • Storage Volumes and File System Layout
  • Network Access
  • Oracle Data Guard Configuration
  • Characteristics of an Oracle Database Cloud Service - Virtual Image Database
  • Deployment
  • Linux User Accounts
  • Storage Volumes and File System Layout
  • Location of Installed Software
  • Network Access

Oracle Cloud Pages for Administering Database Cloud Service

  • Services Page
  • Activity Page
  • SSH Access Page
  • IP Reservations Page
  • QuickStarts Page
  • Overview Page
  • Access Rules Page
  • Backup Page
  • Patching Page
  • Snapshots Page
  • Create Service: Service Page
  • Create Service: Service Details Page
  • Create Service: Confirmation Page

The oracle-dbcs-cli Utility

  • Downloading and Installing the oracle-dbcs-cli Utility
  • Running the oracle-dbcs-cli Utility
  • The Configuration File for oracle-dbcs-cli Subcommands
  • The Data File for the oracle-dbcs-cli create Subcommand

The dbaascli Utility

  • dbaascli database bounce
  • dbaascli database changepassword
  • dbaascli database start
  • dbaascli database status
  • dbaascli database stop
  • dbaascli dataguard failover
  • dbaascli dataguard reinstate
  • dbaascli dataguard status
  • dbaascli dataguard switchover
  • dbaascli dbpatchm apply
  • dbaascli dbpatchm clonedb
  • dbaascli dbpatchm list_patches
  • dbaascli dbpatchm list_tools
  • dbaascli dbpatchm prereq
  • dbaascli dbpatchm rollback
  • dbaascli dbpatchm switchback
  • dbaascli dbpatchm toolsinst
  • dbaascli dv off
  • dbaascli dv on
  • dbaascli gg setup
  • dbaascli gg status
  • dbaascli listener bounce
  • dbaascli listener start
  • dbaascli listener status
  • dbaascli listener stop
  • dbaascli netsec config
  • dbaascli netsec config encryption
  • dbaascli netsec config integrity
  • dbaascli netsec status
  • dbaascli orec duplicate
  • dbaascli orec keep list
  • dbaascli orec keep tag
  • dbaascli orec latest
  • dbaascli orec list
  • dbaascli orec pitr
  • dbaascli orec scn
  • dbaascli tde rotate masterkey
  • dbaascli tde status

 

The raccli Utility

  • raccli apply patch
  • raccli clean backup
  • raccli create backup
  • raccli create recovery
  • raccli describe job
  • raccli describe system
  • raccli failover dataguard
  • raccli list backup
  • raccli list backupconfig
  • raccli list jobs
  • raccli list recovery
  • raccli reinstate dataguard
  • raccli status dataguard
  • raccli switchover dataguard
  • raccli update backupconfig
  • raccli update databasepassword
  • raccli update netsec
  • raccli update rdk
  • raccli update tde

The dbpatchmdg Utility

  • Running the dbpatchmdg Utility
  • dbpatchmdg apply_async
  • dbpatchmdg precheck_async
  • dbpatchmdg rollback_async

For Quick Contact Please Call Us : +919676516545

Batch Timings

Course Features

  • Live Instructor Led Course
  • Real Time oriented training
  • Guidance on Resume preparation
  • Mock Interviews
  • Training on latest version
  • Guidance on certification
  • Coverage of extended topics
  • Lower price