OracleNotes

Blog

  • Oracle Tidbits – November 2020 #OraTidbit

    Oracle Tidbits – November 2020 #OraTidbit

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

    #OraTidbit #SQLcl Oracle SQLcl (SQL Developer Command-Line) is a Java-based command-line interface for Oracle Database. Using SQLcl, you can interactively or batch execute SQL and PL/SQL statements. SQLcl provides inline editing, statement completion, command recall, and supports existing SQL*Plus scripts.
    #OraTidbit #Liquibase is an open-source database-independent library for tracking, managing, and applying database schema changes. With the Liquibase feature in SQLcl, you can generate and execute single object changelogs.
    #OraTidbit #SQLDev There are two options for working with databases other than Oracle in SQL Developer: Creating database connections so that you can view schema objects and data. Migrating these databases to Oracle to take advantage of the full range of Oracle Database features and capabilities.
    #OraTidbit #SQLDev The SQL Developer unit testing feature provides a framework for testing PL/SQL objects, such as functions and procedures, and monitoring such objects’ results over time. You create tests, and for each, you provide information about what is to be tested and what result is expected.
    #OraTidbit Users of #AutonomousDB can subscribe to events and get notified. An event could be a resource lifecycle state change or a system event impacting a resource. Example events are DatabaseDownBegin, DatabaseDownEnd, MaintenanceBegin, MaintenanceEnd, DatabaseConnection.
    #OraTidbit #OracleCloud Zero Downtime Migration lets you quickly and smoothly move your Oracle databases from on-premises environments and Oracle Cloud Infrastructure Classic to the Oracle Cloud without incurring significant downtime.
    #OraTidbit #AutonomousLinux #Linux Every system running Autonomous Linux is patched automatically. This helps keep systems secure and compliant, eliminating the risk of unpatched systems. Ksplice technology allows patching for kernel and key userspace libraries without restarting or scheduled downtime.
    #OraTidbit #AutonomousLinux #Linux Oracle Autonomous Linux automatically tunes memory management, network algorithms, and disk I/O based on workload, so applications run at higher performance and better reliability.
    #OraTidbit #AutonomousDB #Azure You can use Shared Access Signatures (SAS) URL in any DBMS_CLOUD procedure that takes a URL to access files in Azure Blob Storage, without the need to create a credential. (New Feature)
    #OraTidbit #AutonomousDB #AWS You can use a presigned URL in any DBMS_CLOUD procedure that takes a URL to access files in Amazon Simple Storage Service, without the need to create a credential. (New Feature)
    #OraTidbit #VirtualBox Oracle VM VirtualBox supports importing of cloud instances from an Oracle Cloud Infrastructure service. When you import a cloud instance, Oracle VM VirtualBox creates and registers a new VM automatically on the localhost.
    #OraTidbit #DB20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in new password files are case-sensitive.
    #OraTidbit #DB20c MAX_IDLE_BLOCKER_TIME sets the number of minutes that a session holding needed resources can be idle before it is a candidate for termination. Unlike MAX_IDLE_TIME, MAX_IDLE_BLOCKER_TIME terminates resources only when they are needed.
    #OraTidbit #DB20c Oracle ASM Flex Disk Group supports Cloning a PDB in one CDB to a new PDB in a different CDB. Previously point-in-time database clones could only clone a pluggable database (PDB) in a multitenant container database (CDB) to a new PDB in the same CDB.
    #OraTidbit Oracle Database AutoUpgrade enables you to upgrade one or many Oracle Database instances at the command-line using a single command and a single configuration file. AutoUpgrade runs the pre-upgrade tasks, performs automated fix-ups where needed, runs the database upgrade, and finishes by completing post-upgrade tasks.

  • Oracle Tidbits – October 2020 #OraTidbit

    Oracle Tidbits – October 2020 #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.