Oracle Data Pump, Export, and Import The Data Pump Import DATA_OPTIONS parameter has a new CONTINUE_LOAD_ON_FORMAT_ERROR option. If Data Pump encounters a stream format error when loading table data, Data Pump attempts to skip forward to find the start of the next row and continue loading that data from that location. For security purposes, Data […]
Category: Oracle 18c
Installing Oracle Database Using RPM Packages in Oracle 18c
Starting with Oracle Database 18c, you can use the Oracle Preinstallation RPM and the rpm -ivh command to perform an RPM-based single-instance Oracle Database or Oracle Database Client installation. Note: An RPM-based Oracle Database installation is supported only on Oracle Linux systems. Use RPM packages to perform a single-instance, Oracle Database installation on Oracle Linux […]
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 […]
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. – […]
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 […]
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 […]
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 […]
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 […]
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. Tablespace Size Min Size For Upgrade ———- ———- ———– SYSAUX 490 MB 718 MB SYSTEM 750 MB 1194 MB TEMP 54 MB 150 MB UNDOTBS1 85 MB 446 MB Minimum tablespace sizes for […]
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 […]