Oracle Database 18c Technical Architecture

This interactive diagram shows the Oracle Database 18c technical architecture. An Oracle Database consists of at least one database instance and one database. The database instance handles memory and processes. The database consists of physical files called data files, and can be a non-container database or a multitenant container database. An Oracle Database also uses […]

Read More

Installing Oracle 18c Data Guard on Cloud

This article shows how to create Oracle 18c Data Guard in Oracle Database Cloud Service database deployment with simple steps. Create a New Instance of Oracle Data Guard Cloud Service Log in to your Oracle Cloud services account, go to the Oracle Database Cloud Service page, and create a new service:- For Instance Name enter DG18. – […]

Read More

Converting Normal Disk Groups to Flex Disk Groups in Oracle 18c

In this post, You can convert a conventional disk group ie created before Oracle ASM 18c to an Oracle ASM flex disk group without using the restrictive mount (MOUNTED RESTRICTED) option. Migrating (converting) to a flex disk group can be performed for a NORMAL or HIGH redundancy disk group with the CONVERT REDUNDANCY TO FLEX […]

Read More

New look of ASMCA in Oracle 18c

Oracle ASM Configuration Assistant (ASMCA) supports installing and configuring Oracle ASM instances, disk groups, volumes, and Oracle Automatic Storage Management Cluster File System (Oracle ACFS). In addition, you can use the ASMCA command-line interface as a non-GUI utility. In Oracle 18c database, ASMCA comes up with new GUI interface which looks cool and easy to […]

Read More

Upgrading Oracle Grid Infrastructure 11gR2 to 18c

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 18c (18.0.0.0) on the same server. This upgrade process was done on Linux 7 (x86_64). Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 18.0.0.0 to 11.2.0.4 later one. If you want […]

Read More

Manual upgrading Oracle database 11gR2 to 18c

Manual upgrading Oracle database 11gR2 to 18c If you want to know how we upgrade an 11.2.0.4 database to 18.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 to 18.0.0.0.0 manually. Manually upgrading to 18c There are many DBAs who don’t want to follow the recommended way of an upgrade […]

Read More

Tablespaces Info for upgrading to 18c

To help you keep track of your tablespace allocations, the following AUTOEXTEND tablespaces are expected to successfully EXTEND during the upgrade process.

Minimum tablespace sizes for upgrade are estimates. Only Solution is to extend the tablespace.

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the […]

Read More

First Look of OEM 18c

In this article, we will try to find the new things with Oracle OEM 18c. I already installed Oracle OEM18c. After deploying the agent, we log in with sys user. First thing, we can able to see Forward Listener in Oracle 18c, which can explain in later posts. After that, we can see more parameter […]

Read More

Installing Oracle 18c Database on Cloud in 3-clicks

This article shows how to create Oracle 18c database in Oracle Database Cloud Service database deployment with simple steps. Create a New Instance of Oracle Database Cloud Service Log in to your Oracle Cloud services account, go to the Oracle Database Cloud Service page, and create a new service:- For Instance Name enter Cloud18c. – From the Software Release list, […]

Read More

Apply Patch on Oracle 18c Database

In this post, we are going to apply bug fix patch for testing in Oracle 18c Database. First of all, we can download latest opatch utility from support. Doc ID 274526.1 -> How To Download And Install The Latest OPatch (6880880) Version. Check the version from new OPatch utility.

Now we are going to […]

Read More