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.

As GitHub is not configured, we use YUM to install it with […]

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.

Next step uses […]

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.

Now, we connected to the new user and created one dummy table with some […]

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.

Now creating the user without password.

Create a dummy table for testing. […]

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

CDB Fleets in Oracle 18c

A lead CDB is the central location for monitoring and managing the CDBs in the fleet. A CDB fleet provides the database infrastructure for scalability and centralized management of many CDBs. Designate one CDB in the fleet to be the lead CDB by setting its LEAD_CDB database property to TRUE. The other CDBs in the […]

Read More