Active Session History

The error related to the memory_target parameter during Oracle Database upgrades is due to insufficient size of /dev/shm, which must be at least 1.125GB. To resolve the issue, adjust the /etc/fstab entry, remount /dev/shm, and restart the database. In Docker, increase size with ‘–shm-size=2.00gb’.

23ai Database : Starting and Stopping Oracle Database Free

You can perform a direct upgrade to the new release from the following

DML Redirection lets a standby database in an Oracle Data Guard setup handle DML operations (INSERT, UPDATE, DELETE) aimed at it.

Oracle Database 23ai includes several new features for Oracle Real Application Clusters (RAC) that are not supported in Standard Edition 2 (SE2):

Cluster Domain consists of a single Domain Services Cluster (DSC) and one or more Member Clusters. DSC provides many services which can be utilized by Member Clusters.

To install Oracle Database, first ensure prerequisites are met by running either the yum or dnf command to install the oracle-database-preinstall package. Once the prerequisites are completed, execute the installation using the runInstaller command from the ORACLE_HOME folder.

To change a hostname in Oracle Linux 9, use nmcli to set the new hostname, then reboot and verify the change. Alternatively, the hostnamectl utility can also be used for this task.

In ORACLE 23ai Database, BIGFILE is the default for most tablespaces, excluding TEMP. Verification shows