Tag: #oratidbit

Happy Halloween!

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in October 2020. I hope you find these helpful to learn something new or to remind you of its existence and use.

#OraTidbit #AutonomousDB The default operation mode of Autonomous Database is Read/Write. If you select Read-Only mode users can only run queries. You can restrict access to only allow users with the RESTRICTED SESSION privilege to connect to the database. The ADMIN user has this privilege. You can use the restricted access mode to perform administrative tasks such as indexing, data loads, or other planned activities.

#OraTidbit #AutonomousDB Read-Only mode and restricted mode of operation are not supported with Autonomous JSON Database. Currently, these modes of operations are available only with Autonomous Data Warehouse (#ADW) and Autonomous Transaction Processing (#ATP).

#OraTidbit #OracleOnAzure #Azure Using #Blobfuse (virtual file system driver for Azure Blob storage on Linux), you can write Oracle database RMAN backups directly to Azure Blob storage.

#OraTidbit #OracleOnAzure #Azure Though Azure Site Recovery is designed for Business Continuity and Disaster Recovery (BCDR), you can use it to migrate Oracle Databases running on OEL 6.x from on-premises to Azure Cloud.

#OraTidbit #OracleOnAzure #Azure You may use Active Data Guard and Far Sync Instance to achieve zero data loss protection for Oracle databases on Azure. The Far Sync instance can be deployed in the same availability zone as the database instance to reduce the latency.

#OraTidbit #OracleCloud The Exadata Cloud Service compute nodes are each configured with at least one virtual machine (VM). You have root privilege for the Exadata compute node VMs, so you can load and run additional software on the Exadata compute nodes.

#OraTidbit #OracleCloud With Exadata Cloud Service, databases that use Oracle Database 12c, or later, are configured to use the CDB architecture.

#OraTidbit #AutonomousDB You can use Oracle Cloud Infrastructure Events to subscribe to and be notified of Autonomous Database events. The Oracle Cloud Infrastructure Events allow to create automation and to receive notifications based on state changes for resources.

#OraTidbit #AutonomousDB Autonomous Container Databases with Autonomous Data Guard is available on Oracle Autonomous Database on Dedicated Exadata Infrastructure. When the primary database becomes unavailable for any reason, the Autonomous Data Guard automatically converts the standby database to the primary database and, it begins servicing your applications.

#OraTidbit #OrclDB #db20c Oracle Automatic Storage Management Cluster File System (Oracle ACFS) automatic shrinking automatically shrinks an Oracle ACFS file system based on a policy providing there is enough free storage in the volume.

#OraTidbit #OracleCloud Cloud Guard is a cloud-native detect-and-respond solution that detects misconfigured resources and insecure activities at scale. Cloud Guard acts as a log and events aggregator that directly integrates with all major Oracle Cloud Infrastructure services (Compute, Networking, Storage, etc.), providing actionable results.

#OraTidbit #OracleCloud The OCI Designer Toolkit (OKIT) is a standalone/offline, OpenSource browser-based Drag-n-Drop design tool for OCI providing rapid design and prototyping of OCI based infrastructure. Once the design is complete Terraform / Ansible scripts can be generated that can then be executed to build what has been designed.

#OraTidbit #OracleCloud Security Zones let you be confident that your resources in Oracle Cloud Infrastructure, including Compute, Networking, Object Storage, and Database resources, comply with Oracle security principles.

#OraTidbit #OracleCloud Oracle Autonomous JSON Database is an Oracle Cloud service that is specialized for developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents. It performs all routine database maintenance tasks while the system is running, without human intervention.

#OraTidbit Oracle NoSQL Database provides SQL for Oracle NoSQL Database, which is an easy to use SQL-like language that supports read-only queries and data definition (DDL) statements.

#OraTidbit Oracle Audit Vault and Database Firewall monitors Oracle and non-Oracle database traffic to detect and block threats, as well as improves compliance reporting by consolidating audit data from databases, operating systems, directories, and other sources.

#OraTidbit Oracle Audit Vault and Database Firewall uses a sophisticated grammar analysis engine to inspect SQL statements before they reach the database and determines with high accuracy whether to allow, log, alert, substitute, or block the incoming SQL.

#OraTidbit #AutonomousDB When you perform the clone operation you can select a newer Oracle Database version for the target database. This allows you to use cloning to upgrade Autonomous Database.

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in September 2020. I hope you find these helpful to learn something new or to remind you of its existence and use.

#OraTidbit #OracleCloud #AutonomousDB Sep 2020 #New: Refreshable clone of Autonomous DB. With a refreshable clone, the system creates a clone that can be easily updated with changes from the source database.

#OraTidbit #OracleLinux #Linux Spacewalk provides a set of tools for managing the Oracle Linux software life cycle. Spacewalk helps to automate a kickstart installation, system configuration, and maintenance tasks, which enables you to rapidly deploy proven and consistent software configurations for Oracle Linux systems.

#OraTidbit #db19c Automated Transaction Draining for Oracle Grid Infrastructure Upgrades provides automatic draining of transactions against the database instances one node at a time in a rolling fashion according to the database service configurations.

#OraTidbit #OracleCloud Oracle #DataSafe supports Oracle Databases on Compute instances in OCI by using an Oracle Data Safe private endpoint. The Compute instance and the Oracle Data Safe private endpoint reside on your private virtual cloud network (VCN), and the Oracle Data Safe service resides on the Oracle Data Safe VCN.

#OraTidbit #OracleCloud (Finally!) You can configure compute virtual machine (VM) instances to remain stopped after a maintenance event affects the underlying infrastructure, instead of being automatically rebooted. This lets you restart the instance on your own schedule.

#OraTidbit #OrclDB Oracle Database AutoUpgrade enables you to upgrade one or many databases without human intervention all with one command and with a single configuration file. AutoUpgrade runs the preupgrade tasks, performs automated fix-ups where needed, runs the database upgrade, and finishes by completing post-upgrade tasks.

#OraTidbit #OracleCloud Oracle Exadata Cloud@Customer uses virtual machine (VM) technology to separate the customer-managed and components managed by Oracle on each compute node. You have root privilege for the Oracle Exadata compute node VMs. You do not have administrative access to the physical compute node hardware, which Oracle administers.

#OraTidbit #OracleCloud Oracle Exadata Cloud@Customer uses Oracle Exadata Storage Servers for database storage. The storage is allocated to disk groups managed by Oracle ASM. You have full administrative access to the Oracle ASM disk groups, but Oracle administers the Oracle Exadata Storage Server hardware and software.

#OraTidbit Centrally managed users in #OrclDB provides a simpler integration with Microsoft Active Directory to allow centralized authentication and authorization of users. This integration enables organizations to use Active Directory to centrally manage users and roles in multiple Oracle databases with a single directory along with other Information Technology services.

#OraTidbit #OrclDB Zero-downtime Oracle Grid Infrastructure Patching enables patching of Oracle Grid Infrastructure without interrupting database operations. Patches are applied out-of-place and in a rolling fashion, with one node being patched at a time, while the database instances on the node remain operational.

#OraTidbit #OracleLinux The Oracle Cloud Infrastructure OS Management service allows you to manage updates and patches for the operating system environment on your Oracle Cloud Infrastructure instances. The OS Management service is an agent-based service.

#OraTidbit #OracleCloud Cloud Guard is a cloud-native service that helps customers monitor, identify, achieve, and maintain a strong security posture on Oracle Cloud. Use the service to examine your Oracle Cloud Infrastructure resources for security weakness related to configuration, and your Oracle Cloud Infrastructure operators and users for risky activities. Upon detection, Cloud Guard can suggest, assist, or take corrective actions, based on your configuration.

#OraTidbit #OracleCloud The Oracle Data Cloud platform is an enterprise-level, cloud-based tool that enables you to organize and categorize your consumer data from all sources, including your website, CRM database, and mobile apps, into a single hierarchical taxonomy.

#OraTidbit #OracleCloud Oracle Fusion Analytics Warehouse enables you to analyze your Oracle Applications Cloud data and generate visualizations and reports. This packaged service includes Oracle Analytics Cloud, extracts data from your Oracle Applications Cloud into an instance of Oracle Autonomous Data Warehouse.

#OraTidbit #OracleCloud Oracle Fusion Analytics Warehouse (FAW) formerly known as Oracle Analytics for Applications (OAX) is built on top of Oracle Analytics Cloud (OAC) and is powered by Oracle Autonomous Data Warehouse (ADW).

#OraTidbit #AutonomousDB You can select an Autonomous Database operation mode. The default mode is Read/Write. If you select Read-Only mode users can only run queries. In addition, for either mode, you can restrict access to only allow privileged users to connect to the database.

#OraTidbit #AutonomousDB Autonomous Database includes extensive, sophisticated audit capabilities to track, monitor, and record database actions. In addition to default auditing, you can configure Oracle Data Safe and configure Oracle Database Audit Policies.