Tag: #db19c

Posted on

Oracle Database 19c – The best Oracle database release to be on now!

Recently Oracle announced that the extended support fee for the Oracle database 19c will be waived for the first two years.

I wanted to take a moment to document the best MOS notes that help customers to upgrade their older version of Oracle databases to the 19c long-term version.

11.2.0.4 and 19c are similar releases before a major architecture change (PDB architecture was introduced in 12.1 and traditional architecture deprecated. In 23c traditional architecture is unsupported). You can see in the chart above that 11.2.0.4 had four years of waived extended support, 2 years of extended support, 2 years of market-driven support, and now has upgrade support from CSS (Customer Success Services, which used to be known as ACS). I think it is only prudent for customers to jump on 19c and stay there for a while – 19c is a good database release to be on.

19c Database Upgrade – Self-Guided Assistance with Best Practices (Doc ID 1919.2)

This is the best MOS note for upgrade planning and learning about the 19c upgrade.

Oracle Database Patches to Consider for 19c (Doc ID 2781612.2)

Primary Note for Database Proactive Patch Program (Doc ID 888.1)

Oracle Database 19c Important Recommended One-off Patches (Doc ID 555.1)

The RU and MRPs will include only the patches that are standby-first and RAC-rolling enabled. There are many critical patches that may need to go on your databases. This note is an absolute must for all DBAs to review and apply.

And finally, check out the new features in Oracle Database 19c using the interactive & easy to search APEX tool – Oracle Database Features and Licensing.

None of upgrade learning and planning is complete without reading and watching Mike Dietrich’s Blog About Oracle Database Upgrades.

Oracle Database 19c Technical Architecture

Oracle Real Application Clusters 19c Technical Architecture

Posted on

Oracle TidBits – July 2020 #OraTidBit

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

#OrclDB #db20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in 20c password files are case-sensitive.
#OraTidbit #OrclDB Oracle Blockchain tables are append-only tables in which only insert operations are allowed. Deleting rows is either prohibited or restricted based on time.
#OraTidbit #OrclDB #db20c allows an expression when setting the value of an initialization parameter. This allows us to optimize the values set in initialization parameters when they depend on environmental characteristics, such as system configurations, run-time decisions, or the values of other parameters by using expressions.
#OraTidbit #AutonomousDB With Autonomous Data Guard, the standby database is created in the same region as the primary database. If the region has multiple Availability Domains, the standby database is provisioned in a different availability domain than the primary database.
#OraTidbit #AutonomousDB July 2020 Feature: You can create database links from an Autonomous Database to an Oracle Database Gateway to access Non-Oracle databases.
#OraTidbit #GoldenGate Oracle GoldenGate Monitor is a real-time, Web-based monitoring console that delivers an at-a-glance, graphical view of all of the Oracle GoldenGate instances and their associated databases within your enterprise.
#OraTidbit #OraleCloud #DataSafe is a unified control center for managing database security in the Oracle Cloud. Data Safe provides an integrated set of features enabling users to understand the sensitivity,
evaluate risks, mask, implement security controls, assess user security, monitor user activity, and address data security compliance requirements.
#OraTidbit #SE#db19c Oracle Database Standard Edition High Availability (available from 19.7) provides cluster-based failover for single-instance Standard Edition Oracle Databases using Oracle Clusterware.
#OraTidbit (from the Oracle database licensing doc) Oracle Automatic Storage Management (Oracle ASM) is free to use with all Oracle databases and Oracle ACFS file systems (including Oracle Standard Edition).
#OraTidbit Oracle Enterprise Data Quality (EDQ) provides a comprehensive data quality management environment that is used to understand, improve, protect, and govern data quality. EDQ facilitates best practice master data management, data integration, business intelligence, and data migration initiatives.
#OraTidbit #OracleCloud #DBaaS provisioning has two options. Fast provisioning includes the Preview Version (currently 20c) and uses Logical Volume Manager (not ASM) for storage. Standard provisioning uses Automatic Storage Management and includes versions 11.2 to 19c.
#OraTidbit #MachineLearning The OML4SQL API consists of Machine Learning extensions to Oracle SQL. The #MLPL/SQL packages are DBMS_DATA_MINING, DBMS_DATA_MINING_TRANSFORM, DBMS_PREDICTIVE_ANALYTICS.
#OraTidbit #AutonomousDB #OrclAPEX Autonomous Database 19c includes Oracle Application Express Release 20.1. If your Autonomous Database instance is Database 18c, to use APEX 20.1 you must upgrade to Oracle Database 19c. APEX is automatically upgraded to APEX 20.1.
#OraTidbit #db20c Oracle Data Pump supports adding, changing, and eliminating table compression. Oracle Database 20c introduces a new TRANSFORM parameter clause, INDEX_COMPRESSION_CLAUSE. This clause enables you to control whether index compression is performed during import.
#OraTidbit #db20c #AutonomousDB Starting with Oracle Database 20c, Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object-store.
#OraTidbit #MachineLearning #ML Oracle Machine Learning Notebooks is an Apache Zeppelin-based collaborative web-based interface that provides a development environment to create data mining notebooks where you can perform data exploration and visualizations, data preparation and machine learning.
#OraTidbit #MachineLearning #ML Oracle Machine Learning in the #AutonomousDB includes #OpenSource components Apache Zeppelin, Mockito, and JavaScript Extension Toolkit.
#OraTidbit #AutonomousDB You can configure Autonomous Database to authenticate and authorize Microsoft Active Directory users. The integration of Autonomous Database with Centrally Managed Users (CMU) provides integration with Microsoft Active Directory. CMU with Active Directory works by mapping Oracle database users and roles to Microsoft Active Directory users and groups.