Oracle Data Guard Switchover in Oracle Cloud Infrastructure (OCI)

To  view how to configure Data Guard in OCI please check  Configuring Data Guard in Oracle Cloud Infrastructure (OCI) Assumptions: Oracle Data Guard is configured in OCI and it is up, running and synchronized. You can check the dgmgrl configuration before starting switchover by login to the server using Public IP. You can see SKANTORC_iad19m […]

Read More

Installation of Oracle RAC on Oracle Cloud Infrastructure(OCI)

In this post, we will see the creation of Oracle RAC on Oracle Cloud Infrastructure (OCI) After login to your OCI account, Click on the Menu and choose Bare Metal, VM, Exadata option under Database category. First, you need to select the compartment name and then click on “Create DB System” As shown in the […]

Read More

Installing Oracle Database 19c with GitHub Repos

In this post, we can use GitHub repository to fetch the repos and then be installing the Oracle Database 19c.  GitHub must be installed for this feature prerequisite. In your VM or Bare Metal, check the status and version of GitHub if it is installed.

As GitHub is not configured, we use YUM to install it with […]

Read More

Installing Oracle 19c Binary on OEL 7.6

In this post, we are installing Oracle 19c binaries on OEL 7.6. First, we need to download the software then unzip it on oracle home and start runInstaller from the software location.

Select a “Set Up Software Only” and click next. Select on “Single instance database installation” and click on next. Select on “Enterprise […]

Read More

New Features of RAC & ASM in Oracle 19c

These are the new features for Oracle Automatic Storage Management 19c. SRVCTL command enhancements Flushing the password file metadata Automatic block corruption recovery with the CONTENT.CHECK disk group attribute New and updated ASMCMD commands The password option with the ASMCMD pwcreate command is now optional. The new ASMCMD setsparseparent command sets the parent for a sparse child file. The new ASMCMD mvfile command moves a […]

Read More

New Features of Data Guard in Oracle Database 19c

These are the changes in Oracle Data Guard Concepts and Administration for Oracle Database Release 19c. The process of flashing back a physical standby to a point in time that was captured on the primary is simplified by automatically replicating restore points from primary to the standby. When flashback or point-in-time recovery is performed on the primary […]

Read More

New Features of Security in Oracle Database 19c

The following are changes in the Oracle Security for Oracle Database Release 19c. Signature-Based Security for LOB LocatorsStarting with this release, you can configure signature-based security for large object (LOB) locators. Default User Accounts Now Schema OnlyUsing the schema only account feature from Oracle Database release 18c, most of the Oracle Database supplied schemas (users) now have […]

Read More

New Features of Backup & Recovery in Oracle Database 19c

The following are changes in the Oracle Database Backup and Recovery for Oracle Database Release 19c. Recovery catalog support for PDBs You can connect to a recovery catalog when the target database is a pluggable database (PDB). Automatic deletion of flashback logs Flashback logs that are beyond the retention period are automatically deleted. Automatically deleting flashback logs […]

Read More

New Features in Oracle Database 19c

Oracle Database supplied user accounts are now schema only accounts Most of the Oracle Database supplied user accounts, except SYS and sample schemas are now schema only accounts, that is, these accounts are created without passwords. This prevents malicious users from logging into these accounts. You can assign passwords to these accounts whenever you want them to be authenticated. […]

Read More

New Features in Oracle Multitenant 19c

Enhancements to database-managed PDB snapshots When the initialization parameter CLONEDB is TRUE, database-managed snapshots create sparse copies of the data files of the source PDB. Starting in Oracle Database 19c, you can create database-managed snapshot clone PDBs from a source PDB that is open read/write. In previous releases, the source PDB needed to remain read-only and unchanging for […]

Read More