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

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

Oracle Database 18c Client Released

Oracle Database 18c Client 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 […]

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

Upgrade Grid Infrastructure to 18.2 by applying RU

Database 18c Patch As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information You must […]

Read More

Patching (or Updating) home and database to 18.2 from base release by applying RU

Database 18c Patch As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information […]

Read More