Creating and Configuring an Oracle Database for RPM Based

In the last post, we installed Oracle 19c Database Software by running RPM Package. Now, we are going to create and configure a Database with default Setting.Log in as root and run the below command to configure an Oracle Database instance. [root@oracle19c dbhome_1]# /etc/init.d/oracledb_ORCLCDB-19c configure Configuring Oracle Database ORCLCDB. [FATAL] [DBT-06103] The port (1,521) is […]

Read More

ORACLE 19C RPM BASED SOFTWARE INSTALLATION

Oracle 19c can be installed on Oracle Linux using an RPM. This article describes the RPM installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit.  The naming convention for RPM packages is name–version–release.architecture.rpm. Installing Oracle Database RPM Manually Login as Root and Download and install the Oracle Preinstallation RPM [root@oracle19c sw]# curl -o […]

Read More

Manual upgrading Oracle database 11gR2 to 19c

Manual upgrading Oracle database 11gR2 to 19c If you want to know how we upgrade an 11.2.0.4 database to 19.0.0.0.0 using DBUA, click here. This article explains how to upgrade 11.2.0.3 and above, and 12.1.0.1, 12.2.0.1, 18c to 19.0.0.0.0 manually. Manually upgrading to 19c There are many DBAs who don’t want to follow the recommended […]

Read More

Upgrade Database from Oracle 11gR2 to Oracle 19c

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 19c (19.2.0.0.0) on the same server. This upgrade process was done on Oracle Linux 7.6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything for you. You should be able to […]

Read More

Creating the Database 19c on- premise

After installing Oracle 19c home, now we are going to create to database on-premise. Run the DBCA after setting the Oracle Home. [oracle@oracle19c ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 [oracle@oracle19c ~]$ export PATH=$ORACLE_HOME/bin:$PATH [oracle@oracle19c ~]$ dbca Select Database type as Oracle Single Instance database. Provide the database name as SID. Use the default template. Check the enable archiving […]

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. [root@oracle19c ~]# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 [root@oracle19c ~]# chown -R oracle:oinstall /u01 [root@oracle19c ~]# chmod -R 775 /u01 [oracle@oracle19c ~]# ./runinstaller & Select a […]

Read More

New Features of Performance Tuning in Oracle Database 19c

The following are changes in Oracle Database Performance Tuning for Oracle Database Release 19c. Memoptimized Rowstore – Fast Ingest Automatic Database Diagnostic Monitor (ADDM) support for pluggable databases (PDBs) The following are changes in Oracle Database In-Memory for Oracle Database release 19. Database In-Memory wait on populate Big Data and performance enhancements for In-Memory external tables Hybrid partitioned […]

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 initialization parameters, data dictionary views & dynamic performance views in Oracle Database 19c

The following initialization parameters are new in Oracle Database Release 19c, Version 19.1: ADG_REDIRECT_DML DATA_GUARD_MAX_IO_TIME DATA_GUARD_MAX_LONGIO_TIME ENABLE_IMC_WITH_MIRA LOB_SIGNATURE_ENABLE MAX_DATAPUMP_PARALLEL_PER_JOB The following static data dictionary views are new in Oracle Database Release 19c, Version 19.1: ALL_TRIGGERS_AE, DBA_TRIGGERS_AE, and USER_TRIGGERS_AE DBA_PDB_SNAPSHOTFILE DBA_RAT_CAPTURE_SCHEMA_INFO DBA_REGISTRY_BACKPORTS The following dynamic performance views are new in Oracle Database Release 19c, Version 19.1: GV$AQ_PARTITION_STATS and V$AQ_PARTITION_STATS […]

Read More