Release Upgrade from 18.3 to 18.5 by applying RU

Database 18c Patch As of the Release date (16-Jan-2019), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Then afterwards, it was available for on-premise as well. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information You must use the OPatch utility version 12.2.0.1.14 or later to apply this patch. Oracle […]

Read More

Oracle Database 18c New Features Book

Written by Oracle Certified Master Skant Gupta and Oracle Certified Master & Oracle ACED Joel Pérez describes the myriad new and enhanced capabilities available in the latest Oracle Database release. This book is meticulously planned for the audience keen to learn all about the amazing new features being offered by Oracle Database 18c. You must […]

Read More

Installing Oracle Database 18c with GitHub Repos

In this post, we can use GitHub reposirotry to fetch the repos and then be installing the Oracle Database 18c.  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. [root@ORA006 ~]# git version bash: git: command not found As GitHub is not […]

Read More

Accessing the Oracle 18c Database in Vagrant VM

In the previous post, we learned the installation of Vagrant and provisioning the Oracle 18c Database in Vagrant VM. Oracle Database 18c installation with Vagrant Now, in this post, we will show how to access Oracle 18c Database in Vagrant VM. First of all, we can check the status of VM. D:\shared\vagrant-boxes-master\vagrant-boxes-master\OracleDatabase\18.3.0>vagrant global-status id name […]

Read More

Oracle Database 18c installation with Vagrant

A vagrant is a tool for building and managing virtual machine environments in a single workflow. With an easy-to-use workflow and focus on automation, Vagrant lowers development environment setup time, increases production parity, and makes the “works on my machine” excuse a relic of the past. It provides easy to configure, reproducible, and portable work […]

Read More

Finally, the wait is over!! Now Oracle 18c is Available for on-Premise

Oracle Database 18c was released for on-premise as well. Oracle Database 18c, the latest generation of the world’s most popular database, is now available in Oracle Cloud and on Oracle Exadata. It provides businesses of all sizes with access to the world’s fastest, most scalable and reliable database technology for secure and cost-effective deployment of […]

Read More

Export and Import Database link in Oracle 18c

In this post, we will export and import the database link with data pump in Oracle 18c. In next post, we will demonstrate to prevent the passwords of database link using keystores. First, we created the user for testing purpose. [oracle@18c OPatch]$ sqlplus system/sys@pdb18c2 SQL*Plus: Release 18.0.0.0.0 – Production on Wed May 30 10:12:42 2018 […]

Read More

Creating Schema-Only Accounts in Oracle 18c

In this post, we will create a schema-only user or we can say that user with no authentication, this feature introduced in Oracle 18c. Sometimes developers want to create a user which contain data only but not allowed to log in. [oracle@18c ~]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 – Production on Wed May […]

Read More

ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks

You may get this error while creating a tablespace in your environment. SQL> create tablespace test extent management local datafile size 40 G uniform size 256 K; create tablespace test extent management local datafile size 40 G uniform size 256 K * ERROR at line 1: ORA-01144: File size (5242880 blocks) exceeds maximum of 4194303 […]

Read More

Physical Standby Database: Redo Apply Architecture

In the previous article, we have seen basics about the architecture of Oracle Dataguard. Oracle Dataguard Architecture Oracle Data Guard works on physical standby and logical standby sites. Physical Standby: When primary database generates redo entries, those redo are transferred to standby database and then redo is applied to standby database. Logical Standby: When primary […]

Read More