Oracle Exadata,Oracle Cloud,Oracle-Exacloud,Oracle Rac 19c and Oracle dba

  PROVISIONING DATABASES :- In a traditional data center environment, administrators perform a number of tasks to complete the database provisioning process. These tasks would typically take days or even week s to complete. 1)     Identify and Allocate Compute & Storage Resources 2)     Install and Configure System Software 3)     Install and Configure Database Software 4)     Configure Oracle Grid Infrastructure 5)     Configure Oracle Real Application Clusters 6)     Install and Configure Monitoring . These tasks are all executed automatically with the Autonomous Database and any issues that might arise are either addressed  automatically or by Oracle’s(Oracle support team) Cloud Operations team . Provisioning an Autonomous Databases is an extremely simple process  where users provide a set of basic information to provision . Thanks Rajan Than

  AUTONOMOUS DATABASE SERVICES :- Database capabilities of the Oracle Database enable the AutonomousDatabase to be offered in two editions that are specifically tailored to a workload . Oracle Autonomous Data Warehouse (ADW) is tailored to Data Warehousing, Data Marts, Data Lakes, and Machine Learning workloads. Oracle Autonomous Transaction Processing (ATP) is tailored to On-Line Transaction Processing, Batch, reporting, IoT, application development, machine learning, and mixed workload environments. 1) Autonomous Data Warehouse 2) Autonomous Transaction Processing Thanks Rajan

  Oracle Autonomous Database - Oracle Autonomous Database combines the flexibility of cloud with the power of machine learning to deliver data management as a service. It’s built upon a foundation of technical innovations that have been developed by Oracle over the course of more than three decades, meeting the needs of thousands of enterprise customers worldwide. The foundation for Autonomous Database includes :-  1) Oracle Database Enterprise Edition 2)   Exadata Database Machine 3) Oracle Cloud Infrastructure 4)   Oracle’s Best Practices 5)   Oracle’s Knowledge Base 6)   Machine Learning Autonomous Database incorporates all of these technologies to deliver a database that is self-driving, self-securing, and self-repairing, allowing customers to focus energies on developing and delivering solutions that directly add value to their business. Each of these technologies provide powerful capabilities separately, but in combination these techno...

ExaCS -Customer v/s Oracle managed . Customers control and manage software that dire ctly affects their databases . u All Patches pre-staged (OS, GI, DB) u Patch what you want when you want on your schedule u Patching automated through cloud tooling u REST services make scheduling easy . Oracle manages underlying infras tructure u Proactive Hardware Fault Notification u Oracle Patches the following rolling u Servers(dom0) u Storage hardware and software u Networking u Firmware u Hypervisor 

Exadata Cloud Service(ExaCS) u Exadata Cloud Service is offered on Oracle Cloud Infrastructure,within OCI regions. u Exadata Cloud Service available in  quarter Rack, Half Rack or full Rack configurations. u Exadata rack in OCI includes DB nodes, storage nodes and InfiniBand switches. u The storage and compute nodes are connected via high bandwidth Infiniband network that provides RDMA based storage access to the compute nodes. u Exadata storage software runs on storage servers and offloads database SQL processing overheads. u Currently, a single VM per compute node is supported. It allows root access for customers while protecting hardware and network, DB nodes are virtualized using Xen based OVM. u Oracle Manages storage cells, switches, management or IB network while customer manages database compute nodes. u Exadata Cloud Service provides a control Plane, a Web-based self-service management interface for Exadata provisioning and  interactive access to servic...

Add ASM disks to exiting ASM disk group and monitoring Re balancing operation :- Extending and Existing DISK GROUP  :- ASM automatically re balances the disk group when disk are added By default the Alter disk group statement returns immediately after the disk have been added while the re balance operation continues to run asynchronously.you can query the V$ASM_OPERATION view to monitor the status of the re balance operation    You can optionally use the RE BALANCE clause to manually control the re balance process. In the POWER clause,you can specify a value from 0 to 11.A value of 0 disable re balancing for this statement.A value of 1 causes the re balance to take place with minimal resources allocated to it.whereas a value of 11 permits ASM to execute the re balance to the value of the ASM_POWER_LIMIT initialization parameter .    Dropping Disks from an existing DISK group : When a disk is dropped. The disk group is re balanced by moving all the file extents f...